C_BillgDocRedacted

Redacted Billing Document | view: CBDREDACTED | Extraction: Not supported | Component: Billing
Tables used: VBRK, VBPA, VBPA, TVFK, TVFKT, CVI_CUST_CT_LINK, BUT0ID, BUT000, CVI_CUST_LINK, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
BillingDocument Billing Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalTaxAmount Tax Amount in Document Currency
TotalNetAmount Net Value in Document Currency
TotalGrossAmount Total Amount
Column Name Description
Column Name Description
BillingDocumentDate Billing Date
Column Name Description
OverallBillingStatus SD Billing Status Show values
BillingIssueType Billing Issue Type Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
Column Name Description Domain name
BillingDocumentTypeName Description TEXT40
PayerParty Identification Number CHAR60
BillToParty Identification Number CHAR60
SoldToParty Identification Number CHAR60
CustomerPaymentTerms Terms of payment key ZTERM
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
DocumentReferenceID Reference Document Number XBLNR1_CASE_SENSITIVE
AssignmentReference Assignment Number ZUONR
AccountingDocument Journal Entry Number BELNR
FiscalYear Fiscal Year GJAHR
TaxDepartureCountry Tax Departure Country/Region LAND1
CustomerTaxClassification1 Tax Classification 1 for Customer TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_BILLGDOCREDACTED.MANDT == TVFK.MANDT
  • C_BILLGDOCREDACTED.BILLINGDOCUMENTTYPE == TVFK.FKART
City Code
  • Client
  • Region (State, Province, County)
  • City Code
  • Destination Country/Region
  • C_BILLGDOCREDACTED.MANDT == T005G.MANDT
  • C_BILLGDOCREDACTED.REGION == T005G.REGIO
  • C_BILLGDOCREDACTED.CITYCODE == T005G.CITYC
  • C_BILLGDOCREDACTED.COUNTRY == T005G.LAND1
Company Code
  • Client
  • Company Code
  • C_BILLGDOCREDACTED.MANDT == T001.MANDT
  • C_BILLGDOCREDACTED.COMPANYCODE == T001.BUKRS
Destination Country/Region
  • Client
  • Destination Country/Region
  • C_BILLGDOCREDACTED.MANDT == T005.MANDT
  • C_BILLGDOCREDACTED.COUNTRY == T005.LAND1
County Code
  • County Code
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • C_BILLGDOCREDACTED.COUNTY == T005E.COUNC
  • C_BILLGDOCREDACTED.MANDT == T005E.MANDT
  • C_BILLGDOCREDACTED.REGION == T005E.REGIO
  • C_BILLGDOCREDACTED.COUNTRY == T005E.LAND1
Distribution Channel
  • Client
  • Distribution Channel
  • C_BILLGDOCREDACTED.MANDT == TVTW.MANDT
  • C_BILLGDOCREDACTED.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_BILLGDOCREDACTED.MANDT == TSPA.MANDT
  • C_BILLGDOCREDACTED.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_BILLGDOCREDACTED.MANDT == TINC.MANDT
  • C_BILLGDOCREDACTED.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_BILLGDOCREDACTED.INCOTERMSVERSION == TINCV.INCOV
  • C_BILLGDOCREDACTED.MANDT == TINCV.MANDT
Payment Method
  • Client
  • Payment Method
  • Destination Country/Region
  • C_BILLGDOCREDACTED.MANDT == T042Z.MANDT
  • C_BILLGDOCREDACTED.PAYMENTMETHOD == T042Z.ZLSCH
  • C_BILLGDOCREDACTED.COUNTRY == T042Z.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • C_BILLGDOCREDACTED.MANDT == T005S.MANDT
  • C_BILLGDOCREDACTED.REGION == T005S.BLAND
  • C_BILLGDOCREDACTED.COUNTRY == T005S.LAND1
Sales Organization
  • Client
  • Sales Organization
  • C_BILLGDOCREDACTED.MANDT == TVKO.MANDT
  • C_BILLGDOCREDACTED.SALESORGANIZATION == TVKO.VKORG
SD Document Currency
  • Client
  • SD Document Currency
  • C_BILLGDOCREDACTED.MANDT == TCURC.MANDT
  • C_BILLGDOCREDACTED.TRANSACTIONCURRENCY == TCURC.WAERS