C_BillingDueListItem_F0798

Billing Due List Item | view: CBDLIF0798 | TRAN | Extraction: Not supported | Component: Billing

Tables used: VBRK, VBRP, VBFS, VBKD, VEDA, VBAK, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, ADCP, ADRC, ADR6, ADRP, ADR2, ADCP, ADRC, VKDFS, BUT000, KNA1, CVI_CUST_LINK

🔑 Keys (7)
💰 Amounts (1)
∑ Quantities
📅 Dates (2)
☰ Categorical (5)
Other (17)
🔗 Relations (9)

Column Name	Description
BillingDocumentCategory	Billing Category	Show values
BillingDocumentType FK	Billing Type
BillingDocumentDate	Billing Date
SalesOrganization FK	Sales Organization
SoldToParty FK	Sold-to Party
DestinationCountry FK	Destination Country/Region
ReferenceSDDocument	Sales and Distribution Document Number

Column Name	Description
💲 SD Document Currency (TransactionCurrency):
NetAmount	Net Value in Document Currency

Column Name	Description

Column Name	Description
BillingDocumentDate	Billing Date
CreationDate	Date on which the record was created

Column Name	Description
BillingDocumentCategory	Billing Category	Show values
ReferenceSDDocumentCategory	SD Document Category	Show values
OverallProofOfDeliveryStatus	POD Status on Header Level	Show values
HasError	Issue	Show values
SystemMessageType	Message Type	Show values

Column Name	Description	Domain name
SoldToPartyCityName	City	TEXT40
SoldToPartyName	Name 1	NAME
SoldToPartyAdditionalName	Name 2	NAME
CustomerProject	Commercial Project ID	/CPD/MP_ID
SystemMessageIdentification	Message identification	ARBGB
SystemMessageNumber	System Message Number	MSGNR
SystemMessageVariable1	Message variable 01	CHAR50
SystemMessageVariable2	Message variable 02	CHAR50
SystemMessageVariable3	Message variable 03	CHAR50
SystemMessageVariable4	Message variable 04	CHAR50
SystemMessageText	Issue Details (Text)	CHAR256
BillgDocReqRefLgclSyst	Logical system containing source document of BDR	LOGSYS
BillingDocRequestReference	Source document on which a billing document request is based	VBELN
ReferenceSDDocumentType	Sales and Distribution Document Type	VBART
BusinessSolutionOrder	Solution Order	CRM_OBJECT_ID
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
CreationDateTime	Creation Date and Time	TZNTSTMPL

Master Data Relations	Join Conditions
Billing Type Billing Type Client	`C_BILLINGDUELISTITEM_F0798.BILLINGDOCUMENTTYPE == TVFK.FKART` `C_BILLINGDUELISTITEM_F0798.MANDT == TVFK.MANDT`
Destination Country/Region Destination Country/Region Client	`C_BILLINGDUELISTITEM_F0798.DESTINATIONCOUNTRY == T005.LAND1` `C_BILLINGDUELISTITEM_F0798.MANDT == T005.MANDT`
Distribution Channel Client Distribution Channel	`C_BILLINGDUELISTITEM_F0798.MANDT == TVTW.MANDT` `C_BILLINGDUELISTITEM_F0798.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Division Client	`C_BILLINGDUELISTITEM_F0798.DIVISION == TSPA.SPART` `C_BILLINGDUELISTITEM_F0798.MANDT == TSPA.MANDT`
Billing Block in SD Document Billing Block in SD Document Client	`C_BILLINGDUELISTITEM_F0798.HEADERBILLINGBLOCKREASON == TVFS.FAKSP` `C_BILLINGDUELISTITEM_F0798.MANDT == TVFS.MANDT`
Sales Organization Sales Organization Client	`C_BILLINGDUELISTITEM_F0798.SALESORGANIZATION == TVKO.VKORG` `C_BILLINGDUELISTITEM_F0798.MANDT == TVKO.MANDT`
Shipping Point / Receiving Point Shipping Point / Receiving Point Client	`C_BILLINGDUELISTITEM_F0798.SHIPPINGPOINT == TVST.VSTEL` `C_BILLINGDUELISTITEM_F0798.MANDT == TVST.MANDT`
Sold-to Party Sold-to Party Client	`C_BILLINGDUELISTITEM_F0798.SOLDTOPARTY == KNA1.KUNNR` `C_BILLINGDUELISTITEM_F0798.MANDT == KNA1.MANDT`
SD Document Currency SD Document Currency Client	`C_BILLINGDUELISTITEM_F0798.TRANSACTIONCURRENCY == TCURC.WAERS` `C_BILLINGDUELISTITEM_F0798.MANDT == TCURC.MANDT`