C_BillingDocument_F0797

Billing Document | view: CBDOCF0797 | Extraction: Not supported | Component: Billing
Tables used: VBRK, VBFS, ADCP, ADRC, ADR6, ADR2, TVFK, TVFKT, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK
Column Name Description
BillingDocument Billing Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value in Document Currency
TaxAmount Tax Amount in Document Currency
TotalGrossAmount Total Amount
Column Name Description
Column Name Description
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
CreationDate Date on which the record was created
CreationTime Entry time
Column Name Description
OverallBillingStatus Billing Document Status Show values
BillingIssueType Billing Issue Type Show values
BillingDocumentIsCancelled Billing document is canceled Show values
SDDocumentCategory SD Document Category Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
IsRelevantForAccrual Is relevant for accrual Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
ManualInvoiceMaintIsRelevant Manual Invoice Maintenance Show values
AccountingExchangeRateIsSet Exchange Rate Setting Show values
AcctgExchangeRateIsIndrctQtan Accounting exchange rate quotation is indirect Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
BillingDocumentIsTemporary IsDraft Indicator Show values
InvoiceClearingStatus Clearing Status of Billing Document Show values
SystemMessageType Message Type Show values
Column Name Description Domain name
BillingDocumentTypeName Description TEXT40
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry Number BELNR
DocumentReferenceID Reference Document Number XBLNR1_CASE_SENSITIVE
PurchaseOrderByCustomer Customer Reference BSTKD
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
AssignmentReference Assignment Number ZUONR
AbsltAccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
PricingDocument Number of the Document Condition KNUMV
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
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
UxFcTexts UI Field Control Byte INT1
UxAcPost UI Field Control Byte INT1
UxAcCancel UI Field Control Byte INT1
SoldToPartyName Name 1 NAME
SoldToPartyAdditionalName Name 2 NAME
PayerPartyName Name 1 NAME
PayerPartyAdditionalName Name 2 NAME
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
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
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • C_BILLINGDOCUMENT_F0797.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_BILLINGDOCUMENT_F0797.MANDT == TVFK.MANDT
City Code
  • City Code
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • C_BILLINGDOCUMENT_F0797.CITYCODE == T005G.CITYC
  • C_BILLINGDOCUMENT_F0797.COUNTRY == T005G.LAND1
  • C_BILLINGDOCUMENT_F0797.MANDT == T005G.MANDT
  • C_BILLINGDOCUMENT_F0797.REGION == T005G.REGIO
Company Code
  • Client
  • Company Code
  • C_BILLINGDOCUMENT_F0797.MANDT == T001.MANDT
  • C_BILLINGDOCUMENT_F0797.COMPANYCODE == T001.BUKRS
Destination Country/Region
  • Destination Country/Region
  • Client
  • C_BILLINGDOCUMENT_F0797.COUNTRY == T005.LAND1
  • C_BILLINGDOCUMENT_F0797.MANDT == T005.MANDT
County Code
  • County Code
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • C_BILLINGDOCUMENT_F0797.COUNTY == T005E.COUNC
  • C_BILLINGDOCUMENT_F0797.COUNTRY == T005E.LAND1
  • C_BILLINGDOCUMENT_F0797.MANDT == T005E.MANDT
  • C_BILLINGDOCUMENT_F0797.REGION == T005E.REGIO
Currency Key
  • Client
  • Currency Key
  • C_BILLINGDOCUMENT_F0797.MANDT == TCURC.MANDT
  • C_BILLINGDOCUMENT_F0797.CURRENCY == TCURC.WAERS
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_BILLINGDOCUMENT_F0797.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_BILLINGDOCUMENT_F0797.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_BILLINGDOCUMENT_F0797.CUSTOMERGROUP == T151.KDGRP
  • C_BILLINGDOCUMENT_F0797.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • C_BILLINGDOCUMENT_F0797.CUSTOMERPRICEGROUP == T188.KONDA
  • C_BILLINGDOCUMENT_F0797.MANDT == T188.MANDT
Agreement (various conditions grouped together)
  • Agreement (various conditions grouped together)
  • Client
  • C_BILLINGDOCUMENT_F0797.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • C_BILLINGDOCUMENT_F0797.MANDT == KONA.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_BILLINGDOCUMENT_F0797.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_BILLINGDOCUMENT_F0797.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • C_BILLINGDOCUMENT_F0797.MANDT == TSPA.MANDT
  • C_BILLINGDOCUMENT_F0797.DIVISION == TSPA.SPART
Dunning Area
  • Dunning Area
  • Client
  • Company Code
  • C_BILLINGDOCUMENT_F0797.DUNNINGAREA == T047M.MABER
  • C_BILLINGDOCUMENT_F0797.MANDT == T047M.MANDT
  • C_BILLINGDOCUMENT_F0797.COMPANYCODE == T047M.BUKRS
Dunning Block
  • Client
  • Dunning Block
  • C_BILLINGDOCUMENT_F0797.MANDT == T040S.MANDT
  • C_BILLINGDOCUMENT_F0797.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Dunning Key
  • Client
  • C_BILLINGDOCUMENT_F0797.DUNNINGKEY == T040.MSCHL
  • C_BILLINGDOCUMENT_F0797.MANDT == T040.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_BILLINGDOCUMENT_F0797.MANDT == TINC.MANDT
  • C_BILLINGDOCUMENT_F0797.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • C_BILLINGDOCUMENT_F0797.MANDT == TINCV.MANDT
  • C_BILLINGDOCUMENT_F0797.INCOTERMSVERSION == TINCV.INCOV
Invoice List Type
  • Invoice List Type
  • Client
  • C_BILLINGDOCUMENT_F0797.INVOICELISTTYPE == TVFK.FKART
  • C_BILLINGDOCUMENT_F0797.MANDT == TVFK.MANDT
Payer
  • Payer
  • Client
  • C_BILLINGDOCUMENT_F0797.PAYERPARTY == KNA1.KUNNR
  • C_BILLINGDOCUMENT_F0797.MANDT == KNA1.MANDT
Payment Method
  • Destination Country/Region
  • Payment Method
  • Client
  • C_BILLINGDOCUMENT_F0797.COUNTRY == T042Z.LAND1
  • C_BILLINGDOCUMENT_F0797.PAYMENTMETHOD == T042Z.ZLSCH
  • C_BILLINGDOCUMENT_F0797.MANDT == T042Z.MANDT
Price List Type
  • Price List Type
  • Client
  • C_BILLINGDOCUMENT_F0797.PRICELISTTYPE == T189.PLTYP
  • C_BILLINGDOCUMENT_F0797.MANDT == T189.MANDT
Region (State, Province, County)
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • C_BILLINGDOCUMENT_F0797.COUNTRY == T005S.LAND1
  • C_BILLINGDOCUMENT_F0797.MANDT == T005S.MANDT
  • C_BILLINGDOCUMENT_F0797.REGION == T005S.BLAND
Sales District
  • Sales District
  • Client
  • C_BILLINGDOCUMENT_F0797.SALESDISTRICT == T171.BZIRK
  • C_BILLINGDOCUMENT_F0797.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_BILLINGDOCUMENT_F0797.SALESORGANIZATION == TVKO.VKORG
  • C_BILLINGDOCUMENT_F0797.MANDT == TVKO.MANDT
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • Client
  • ?
  • C_BILLINGDOCUMENT_F0797.SDPRICINGPROCEDURE == T683.KALSM
  • C_BILLINGDOCUMENT_F0797.[column in domain "KVEWE"] == T683.KVEWE
  • C_BILLINGDOCUMENT_F0797.MANDT == T683.MANDT
  • C_BILLINGDOCUMENT_F0797.[column in domain "KAPPL"] == T683.KAPPL
Shipping Conditions
  • Shipping Conditions
  • Client
  • C_BILLINGDOCUMENT_F0797.SHIPPINGCONDITION == TVSB.VSBED
  • C_BILLINGDOCUMENT_F0797.MANDT == TVSB.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_BILLINGDOCUMENT_F0797.SOLDTOPARTY == KNA1.KUNNR
  • C_BILLINGDOCUMENT_F0797.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_BILLINGDOCUMENT_F0797.MANDT == TCURC.MANDT
  • C_BILLINGDOCUMENT_F0797.TRANSACTIONCURRENCY == TCURC.WAERS