I_BillingDocumentBasic

Billing Document Basic | view: ISDBILLDOCBASIC | ATTR | 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
TotalTaxAmount Tax Amount in Document Currency
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
InvoiceListBillingDate 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
BillingDocumentIsTemporary IsDraft Indicator 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
IsRelevantForAccrual Is relevant for accrual Show values
BillgDocReqRefSDDocCategory SD document category of BDR source document 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
OverallBillingDocReqStatus Billing Document Request Status 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
OverallDocumentBillingStatus Order-Related Billing Status (All Items) Show values
PrelimBillingDocumentStatus Preliminary Billing Document Status Show values
InvoiceClearingStatus Clearing Status of Billing Document Show values
BillgProcDocApprovalStatus Document Approval Status Show values
Column Name Description Domain name
ProposedBillingDocumentType Proposed billing type for an order-related billing document FKART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LogicalSystem Logical system LOGSYS
BillingDocCombinationCriteria Combination criteria in the billing document CHAR40
NmbrOfPages Number of pages of invoice J_1ANOPG
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
PlantSupplier Supplier Number of Plant LIFNR
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
FiscalPeriod Posting period POPER
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment Number ZUONR
InternalFinancialDocument Financial doc. processing: Internal financial doc. number LCNUM
BillingDocRequestReference Source document on which a billing document request is based VBELN
BillgDocReqRefLgclSyst Logical system containing source document of BDR LOGSYS
PurchaseOrderByCustomer Customer Reference BSTKD
PricingDocument Number of the Document Condition KNUMV
BillgProcDocApprovalReason Approval Request Reason ID SD_APM_APPROVAL_REASON
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • I_BILLINGDOCUMENTBASIC.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_BILLINGDOCUMENTBASIC.MANDT == TVFK.MANDT
City Code
  • Destination Country/Region
  • City Code
  • Client
  • Region (State, Province, County)
  • I_BILLINGDOCUMENTBASIC.COUNTRY == T005G.LAND1
  • I_BILLINGDOCUMENTBASIC.CITYCODE == T005G.CITYC
  • I_BILLINGDOCUMENTBASIC.MANDT == T005G.MANDT
  • I_BILLINGDOCUMENTBASIC.REGION == T005G.REGIO
Company Code
  • Company Code
  • Client
  • I_BILLINGDOCUMENTBASIC.COMPANYCODE == T001.BUKRS
  • I_BILLINGDOCUMENTBASIC.MANDT == T001.MANDT
Destination Country/Region
  • Destination Country/Region
  • Client
  • I_BILLINGDOCUMENTBASIC.COUNTRY == T005.LAND1
  • I_BILLINGDOCUMENTBASIC.MANDT == T005.MANDT
County Code
  • Destination Country/Region
  • County Code
  • Client
  • Region (State, Province, County)
  • I_BILLINGDOCUMENTBASIC.COUNTRY == T005E.LAND1
  • I_BILLINGDOCUMENTBASIC.COUNTY == T005E.COUNC
  • I_BILLINGDOCUMENTBASIC.MANDT == T005E.MANDT
  • I_BILLINGDOCUMENTBASIC.REGION == T005E.REGIO
Credit control area
  • Client
  • Credit control area
  • I_BILLINGDOCUMENTBASIC.MANDT == T014.MANDT
  • I_BILLINGDOCUMENTBASIC.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_BILLINGDOCUMENTBASIC.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_BILLINGDOCUMENTBASIC.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • I_BILLINGDOCUMENTBASIC.CUSTOMERGROUP == T151.KDGRP
  • I_BILLINGDOCUMENTBASIC.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • I_BILLINGDOCUMENTBASIC.CUSTOMERPRICEGROUP == T188.KONDA
  • I_BILLINGDOCUMENTBASIC.MANDT == T188.MANDT
Agreement (various conditions grouped together)
  • Agreement (various conditions grouped together)
  • Client
  • I_BILLINGDOCUMENTBASIC.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • I_BILLINGDOCUMENTBASIC.MANDT == KONA.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_BILLINGDOCUMENTBASIC.MANDT == TVTW.MANDT
  • I_BILLINGDOCUMENTBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • I_BILLINGDOCUMENTBASIC.DIVISION == TSPA.SPART
  • I_BILLINGDOCUMENTBASIC.MANDT == TSPA.MANDT
Dunning Area
  • Company Code
  • Dunning Area
  • Client
  • I_BILLINGDOCUMENTBASIC.COMPANYCODE == T047M.BUKRS
  • I_BILLINGDOCUMENTBASIC.DUNNINGAREA == T047M.MABER
  • I_BILLINGDOCUMENTBASIC.MANDT == T047M.MANDT
Dunning Block
  • Client
  • Dunning Block
  • I_BILLINGDOCUMENTBASIC.MANDT == T040S.MANDT
  • I_BILLINGDOCUMENTBASIC.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Dunning Key
  • Client
  • I_BILLINGDOCUMENTBASIC.DUNNINGKEY == T040.MSCHL
  • I_BILLINGDOCUMENTBASIC.MANDT == T040.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_BILLINGDOCUMENTBASIC.EXCHANGERATETYPE == TCURV.KURST
  • I_BILLINGDOCUMENTBASIC.MANDT == TCURV.MANDT
Hierarchy type for pricing
  • Hierarchy type for pricing
  • Client
  • I_BILLINGDOCUMENTBASIC.HIERARCHYTYPEPRICING == THIT.HITYP
  • I_BILLINGDOCUMENTBASIC.MANDT == THIT.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_BILLINGDOCUMENTBASIC.MANDT == TINC.MANDT
  • I_BILLINGDOCUMENTBASIC.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • I_BILLINGDOCUMENTBASIC.INCOTERMSVERSION == TINCV.INCOV
  • I_BILLINGDOCUMENTBASIC.MANDT == TINCV.MANDT
Invoice List Type
  • Invoice List Type
  • Client
  • I_BILLINGDOCUMENTBASIC.INVOICELISTTYPE == TVFK.FKART
  • I_BILLINGDOCUMENTBASIC.MANDT == TVFK.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_BILLINGDOCUMENTBASIC.PARTNERCOMPANY == T880.RCOMP
  • I_BILLINGDOCUMENTBASIC.MANDT == T880.MANDT
Payer
  • Payer
  • Client
  • I_BILLINGDOCUMENTBASIC.PAYERPARTY == KNA1.KUNNR
  • I_BILLINGDOCUMENTBASIC.MANDT == KNA1.MANDT
Payment Method
  • Destination Country/Region
  • Payment Method
  • Client
  • I_BILLINGDOCUMENTBASIC.COUNTRY == T042Z.LAND1
  • I_BILLINGDOCUMENTBASIC.PAYMENTMETHOD == T042Z.ZLSCH
  • I_BILLINGDOCUMENTBASIC.MANDT == T042Z.MANDT
Price List Type
  • Price List Type
  • Client
  • I_BILLINGDOCUMENTBASIC.PRICELISTTYPE == T189.PLTYP
  • I_BILLINGDOCUMENTBASIC.MANDT == T189.MANDT
Region (State, Province, County)
  • Destination Country/Region
  • Client
  • Region (State, Province, County)
  • I_BILLINGDOCUMENTBASIC.COUNTRY == T005S.LAND1
  • I_BILLINGDOCUMENTBASIC.MANDT == T005S.MANDT
  • I_BILLINGDOCUMENTBASIC.REGION == T005S.BLAND
Sales District
  • Sales District
  • Client
  • I_BILLINGDOCUMENTBASIC.SALESDISTRICT == T171.BZIRK
  • I_BILLINGDOCUMENTBASIC.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_BILLINGDOCUMENTBASIC.MANDT == TVKO.MANDT
  • I_BILLINGDOCUMENTBASIC.SALESORGANIZATION == TVKO.VKORG
Pricing Procedure in Pricing
  • ?
  • Pricing Procedure in Pricing
  • ?
  • Client
  • I_BILLINGDOCUMENTBASIC.[column in domain "KVEWE"] == T683.KVEWE
  • I_BILLINGDOCUMENTBASIC.SDPRICINGPROCEDURE == T683.KALSM
  • I_BILLINGDOCUMENTBASIC.[column in domain "KAPPL"] == T683.KAPPL
  • I_BILLINGDOCUMENTBASIC.MANDT == T683.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • I_BILLINGDOCUMENTBASIC.SHIPPINGCONDITION == TVSB.VSBED
  • I_BILLINGDOCUMENTBASIC.MANDT == TVSB.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • I_BILLINGDOCUMENTBASIC.MANDT == KNA1.MANDT
  • I_BILLINGDOCUMENTBASIC.SOLDTOPARTY == KNA1.KUNNR
Statistics Currency
  • Statistics Currency
  • Client
  • I_BILLINGDOCUMENTBASIC.STATISTICSCURRENCY == TCURC.WAERS
  • I_BILLINGDOCUMENTBASIC.MANDT == TCURC.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_BILLINGDOCUMENTBASIC.MANDT == TCURC.MANDT
  • I_BILLINGDOCUMENTBASIC.TRANSACTIONCURRENCY == TCURC.WAERS