A_BillingDocument

Billing Document Header | view: ASDBILLINGDOC | TRAN | Extraction: Not supported | Component: Billing
Tables used: VBRK
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 null
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
ExchangeRateDate Translation date
BillingDocumentListDate Billing date for the invoice list
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
BillingDocumentIsCancelled Billing document is canceled Show values
ManualInvoiceMaintIsRelevant Manual Invoice Maintenance Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
AccountingExchangeRateIsSet Exchange Rate Setting Show values
AcctgExchangeRateIsIndrctQtan Accounting exchange rate quotation is indirect Show values
IsRelevantForAccrual Is relevant for accrual Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallBillingStatus SD Billing Status Show values
AccountingPostingStatus Posting Status of Billing Document Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
BillingIssueType Billing Issue Type Show values
InvoiceListStatus Invoice list status of billing document Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
InvoiceClearingStatus Clearing Status of Billing Document Show values
Column Name Description Domain name
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LogicalSystem Logical system LOGSYS
ForeignTrade Number of foreign trade data in MM and SD documents EXNUM
IsExportDelivery Export indicator EXPKZ
BillingDocCombinationCriteria Combination criteria in the billing document CHAR40
TaxDepartureCountry Tax Departure Country/Region LAND1
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number 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
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ContractAccount Contract Account Number CORR_VKONT_KK
CustomerPaymentTerms Terms of payment key ZTERM
PaymentReference Payment Reference CHAR30
AdditionalValueDays Additional Value Days TAGE2
SEPAMandate Unique Reference to Mandate for each Payee ID035
FiscalYear Fiscal Year GJAHR
AccountingDocument Document Number of an Accounting Document BELNR
AbsltAccountingExchangeRate Absolute exchange rate for FI postings KURRF_ABS
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment Number ZUONR
InternalFinancialDocument Financial doc. processing: Internal financial doc. number LCNUM
PurchaseOrderByCustomer Customer Reference BSTKD
SalesDocumentCondition Number of the Document Condition KNUMV
Master Data Relations Join Conditions
Invoice List Type
  • Client
  • Invoice List Type
  • A_BILLINGDOCUMENT.MANDT == TVFK.MANDT
  • A_BILLINGDOCUMENT.BILLINGDOCUMENTLISTTYPE == TVFK.FKART
Billing Type
  • Billing Type
  • Client
  • A_BILLINGDOCUMENT.BILLINGDOCUMENTTYPE == TVFK.FKART
  • A_BILLINGDOCUMENT.MANDT == TVFK.MANDT
City Code
  • City Code
  • Client
  • Destination Country/Region
  • Region (State, Province, County)
  • A_BILLINGDOCUMENT.CITYCODE == T005G.CITYC
  • A_BILLINGDOCUMENT.MANDT == T005G.MANDT
  • A_BILLINGDOCUMENT.COUNTRY == T005G.LAND1
  • A_BILLINGDOCUMENT.REGION == T005G.REGIO
Company Code
  • Client
  • Company Code
  • A_BILLINGDOCUMENT.MANDT == T001.MANDT
  • A_BILLINGDOCUMENT.COMPANYCODE == T001.BUKRS
Destination Country/Region
  • Client
  • Destination Country/Region
  • A_BILLINGDOCUMENT.MANDT == T005.MANDT
  • A_BILLINGDOCUMENT.COUNTRY == T005.LAND1
County Code
  • Client
  • County Code
  • Destination Country/Region
  • Region (State, Province, County)
  • A_BILLINGDOCUMENT.MANDT == T005E.MANDT
  • A_BILLINGDOCUMENT.COUNTY == T005E.COUNC
  • A_BILLINGDOCUMENT.COUNTRY == T005E.LAND1
  • A_BILLINGDOCUMENT.REGION == T005E.REGIO
Credit control area
  • Client
  • Credit control area
  • A_BILLINGDOCUMENT.MANDT == T014.MANDT
  • A_BILLINGDOCUMENT.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • A_BILLINGDOCUMENT.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • A_BILLINGDOCUMENT.MANDT == TVKT.MANDT
Customer Group
  • Client
  • Customer Group
  • A_BILLINGDOCUMENT.MANDT == T151.MANDT
  • A_BILLINGDOCUMENT.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Client
  • Customer Price Group
  • A_BILLINGDOCUMENT.MANDT == T188.MANDT
  • A_BILLINGDOCUMENT.CUSTOMERPRICEGROUP == T188.KONDA
Agreement (various conditions grouped together)
  • Client
  • Agreement (various conditions grouped together)
  • A_BILLINGDOCUMENT.MANDT == KONA.MANDT
  • A_BILLINGDOCUMENT.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
Distribution Channel
  • Distribution Channel
  • Client
  • A_BILLINGDOCUMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • A_BILLINGDOCUMENT.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • A_BILLINGDOCUMENT.MANDT == TSPA.MANDT
  • A_BILLINGDOCUMENT.DIVISION == TSPA.SPART
Dunning Area
  • Client
  • Company Code
  • Dunning Area
  • A_BILLINGDOCUMENT.MANDT == T047M.MANDT
  • A_BILLINGDOCUMENT.COMPANYCODE == T047M.BUKRS
  • A_BILLINGDOCUMENT.DUNNINGAREA == T047M.MABER
Dunning Block
  • Client
  • Dunning Block
  • A_BILLINGDOCUMENT.MANDT == T040S.MANDT
  • A_BILLINGDOCUMENT.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • A_BILLINGDOCUMENT.MANDT == T040.MANDT
  • A_BILLINGDOCUMENT.DUNNINGKEY == T040.MSCHL
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • A_BILLINGDOCUMENT.EXCHANGERATETYPE == TCURV.KURST
  • A_BILLINGDOCUMENT.MANDT == TCURV.MANDT
Hierarchy type for pricing
  • Client
  • Hierarchy type for pricing
  • A_BILLINGDOCUMENT.MANDT == THIT.MANDT
  • A_BILLINGDOCUMENT.HIERARCHYTYPEPRICING == THIT.HITYP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_BILLINGDOCUMENT.MANDT == TINC.MANDT
  • A_BILLINGDOCUMENT.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • A_BILLINGDOCUMENT.MANDT == TINCV.MANDT
  • A_BILLINGDOCUMENT.INCOTERMSVERSION == TINCV.INCOV
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • A_BILLINGDOCUMENT.MANDT == T880.MANDT
  • A_BILLINGDOCUMENT.PARTNERCOMPANY == T880.RCOMP
Payer
  • Payer
  • Client
  • A_BILLINGDOCUMENT.PAYERPARTY == KNA1.KUNNR
  • A_BILLINGDOCUMENT.MANDT == KNA1.MANDT
Payment Method
  • Client
  • Destination Country/Region
  • Payment Method
  • A_BILLINGDOCUMENT.MANDT == T042Z.MANDT
  • A_BILLINGDOCUMENT.COUNTRY == T042Z.LAND1
  • A_BILLINGDOCUMENT.PAYMENTMETHOD == T042Z.ZLSCH
Price List Type
  • Client
  • Price List Type
  • A_BILLINGDOCUMENT.MANDT == T189.MANDT
  • A_BILLINGDOCUMENT.PRICELISTTYPE == T189.PLTYP
Region (State, Province, County)
  • Client
  • Destination Country/Region
  • Region (State, Province, County)
  • A_BILLINGDOCUMENT.MANDT == T005S.MANDT
  • A_BILLINGDOCUMENT.COUNTRY == T005S.LAND1
  • A_BILLINGDOCUMENT.REGION == T005S.BLAND
Sales District
  • Sales District
  • Client
  • A_BILLINGDOCUMENT.SALESDISTRICT == T171.BZIRK
  • A_BILLINGDOCUMENT.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • A_BILLINGDOCUMENT.SALESORGANIZATION == TVKO.VKORG
  • A_BILLINGDOCUMENT.MANDT == TVKO.MANDT
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • ?
  • Client
  • A_BILLINGDOCUMENT.SDPRICINGPROCEDURE == T683.KALSM
  • A_BILLINGDOCUMENT.[column in domain "KAPPL"] == T683.KAPPL
  • A_BILLINGDOCUMENT.[column in domain "KVEWE"] == T683.KVEWE
  • A_BILLINGDOCUMENT.MANDT == T683.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • A_BILLINGDOCUMENT.SHIPPINGCONDITION == TVSB.VSBED
  • A_BILLINGDOCUMENT.MANDT == TVSB.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • A_BILLINGDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • A_BILLINGDOCUMENT.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • A_BILLINGDOCUMENT.MANDT == TCURC.MANDT
  • A_BILLINGDOCUMENT.STATISTICSCURRENCY == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • A_BILLINGDOCUMENT.MANDT == TCURC.MANDT
  • A_BILLINGDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS