C_PrelimBillingDueListItem

Billing Due List Items | view: CPREBILLDUELIST | TRAN | Extraction: Not supported | Component: Billing
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
Column Name Description Domain name
SoldToPartyCityName City TEXT40
SoldToPartyName Name 1 NAME
SoldToPartyAdditionalName Name 2 NAME
CustomerProject Customer Project ID /CPD/SS_CP_ID
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
CreationDateTime Creation Date and Time TZNTSTMPL
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TVFK.MANDT
  • C_PRELIMBILLINGDUELISTITEM.BILLINGDOCUMENTTYPE == TVFK.FKART
Destination Country/Region
  • Destination Country/Region
  • Client
  • C_PRELIMBILLINGDUELISTITEM.DESTINATIONCOUNTRY == T005.LAND1
  • C_PRELIMBILLINGDUELISTITEM.MANDT == T005.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_PRELIMBILLINGDUELISTITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • C_PRELIMBILLINGDUELISTITEM.DIVISION == TSPA.SPART
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TSPA.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_PRELIMBILLINGDUELISTITEM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TVFS.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_PRELIMBILLINGDUELISTITEM.SALESORGANIZATION == TVKO.VKORG
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TVST.MANDT
  • C_PRELIMBILLINGDUELISTITEM.SHIPPINGPOINT == TVST.VSTEL
Sold-to Party
  • Client
  • Sold-to Party
  • C_PRELIMBILLINGDUELISTITEM.MANDT == KNA1.MANDT
  • C_PRELIMBILLINGDUELISTITEM.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • SD Document Currency
  • Client
  • C_PRELIMBILLINGDUELISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PRELIMBILLINGDUELISTITEM.MANDT == TCURC.MANDT