I_BillingDueListItem

Billing Due List Item | view: IBILLDUELISTITEM | TRAN | Extraction: Not supported | Component: Billing
Tables used: VKDFS
Column Name Description
BillingDocumentCategory Billing Category Show values
BillingDocumentType FK Billing Type
BillingDocumentDate Billing Date
SalesOrganization FK Sales Organization
Customer FK Customer Number
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
CreationTime Entry time
Column Name Description
BillingDocumentCategory Billing Category Show values
ReferenceSDDocumentCategory SD Document Category Show values
AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person) Show values
OverallProofOfDeliveryStatus POD Status on Header Level Show values
Column Name Description Domain name
ReferenceSDDocumentType Sales and Distribution Document Type VBART
AddressID Address ADRNR
SortCriterion Sort Criterion CHAR20
BillgDocReqRefLgclSyst Logical system containing source document of BDR LOGSYS
BillingDocRequestReference Source document on which a billing document request is based VBELN
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Person Number
  • Client
  • I_BILLINGDUELISTITEM.[column in domain "AD_NATION"] == ADRP.NATION
  • I_BILLINGDUELISTITEM.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_BILLINGDUELISTITEM.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_BILLINGDUELISTITEM.MANDT == ADRP.CLIENT
Billing Type
  • Billing Type
  • Client
  • I_BILLINGDUELISTITEM.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_BILLINGDUELISTITEM.MANDT == TVFK.MANDT
Customer Number
  • Customer Number
  • Client
  • I_BILLINGDUELISTITEM.CUSTOMER == KNA1.KUNNR
  • I_BILLINGDUELISTITEM.MANDT == KNA1.MANDT
Destination Country/Region
  • Destination Country/Region
  • Client
  • I_BILLINGDUELISTITEM.DESTINATIONCOUNTRY == T005.LAND1
  • I_BILLINGDUELISTITEM.MANDT == T005.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_BILLINGDUELISTITEM.MANDT == TVTW.MANDT
  • I_BILLINGDUELISTITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • I_BILLINGDUELISTITEM.DIVISION == TSPA.SPART
  • I_BILLINGDUELISTITEM.MANDT == TSPA.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_BILLINGDUELISTITEM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_BILLINGDUELISTITEM.MANDT == TVFS.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_BILLINGDUELISTITEM.MANDT == TVKO.MANDT
  • I_BILLINGDUELISTITEM.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_BILLINGDUELISTITEM.MANDT == TVST.MANDT
  • I_BILLINGDUELISTITEM.SHIPPINGPOINT == TVST.VSTEL
SD Document Currency
  • SD Document Currency
  • Client
  • I_BILLINGDUELISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_BILLINGDUELISTITEM.MANDT == TCURC.MANDT