I_PrelimBillingDocument

Preliminary Billing Document | view: ISDPREBILDOC | ATTR | Extraction: Not supported | Component: Billing
Tables used: VBRK
Column Name Description
PrelimBillingDocument Preliminary 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
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
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
BillingIssueType Billing Issue Type Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
PrelimBillingDocumentStatus Preliminary Billing Document Status Show values
BillgProcDocApprovalStatus Document Approval Status Show values
Column Name Description Domain name
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
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
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment Number ZUONR
PurchaseOrderByCustomer Customer Reference BSTKD
PricingDocument Number of the Document Condition KNUMV
PrelimBillgDocApprovalReason Approval Request Reason ID SD_APM_APPROVAL_REASON
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • I_PRELIMBILLINGDOCUMENT.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PRELIMBILLINGDOCUMENT.MANDT == TVFK.MANDT
City Code
  • City Code
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • I_PRELIMBILLINGDOCUMENT.CITYCODE == T005G.CITYC
  • I_PRELIMBILLINGDOCUMENT.MANDT == T005G.MANDT
  • I_PRELIMBILLINGDOCUMENT.REGION == T005G.REGIO
  • I_PRELIMBILLINGDOCUMENT.COUNTRY == T005G.LAND1
Company Code
  • Client
  • Company Code
  • I_PRELIMBILLINGDOCUMENT.MANDT == T001.MANDT
  • I_PRELIMBILLINGDOCUMENT.COMPANYCODE == T001.BUKRS
Destination Country/Region
  • Client
  • Destination Country/Region
  • I_PRELIMBILLINGDOCUMENT.MANDT == T005.MANDT
  • I_PRELIMBILLINGDOCUMENT.COUNTRY == T005.LAND1
County Code
  • County Code
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • I_PRELIMBILLINGDOCUMENT.COUNTY == T005E.COUNC
  • I_PRELIMBILLINGDOCUMENT.MANDT == T005E.MANDT
  • I_PRELIMBILLINGDOCUMENT.REGION == T005E.REGIO
  • I_PRELIMBILLINGDOCUMENT.COUNTRY == T005E.LAND1
Credit control area
  • Credit control area
  • Client
  • I_PRELIMBILLINGDOCUMENT.CREDITCONTROLAREA == T014.KKBER
  • I_PRELIMBILLINGDOCUMENT.MANDT == T014.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_PRELIMBILLINGDOCUMENT.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_PRELIMBILLINGDOCUMENT.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • I_PRELIMBILLINGDOCUMENT.CUSTOMERGROUP == T151.KDGRP
  • I_PRELIMBILLINGDOCUMENT.MANDT == T151.MANDT
Customer Price Group
  • Client
  • Customer Price Group
  • I_PRELIMBILLINGDOCUMENT.MANDT == T188.MANDT
  • I_PRELIMBILLINGDOCUMENT.CUSTOMERPRICEGROUP == T188.KONDA
Agreement (various conditions grouped together)
  • Client
  • Agreement (various conditions grouped together)
  • I_PRELIMBILLINGDOCUMENT.MANDT == KONA.MANDT
  • I_PRELIMBILLINGDOCUMENT.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
Distribution Channel
  • Client
  • Distribution Channel
  • I_PRELIMBILLINGDOCUMENT.MANDT == TVTW.MANDT
  • I_PRELIMBILLINGDOCUMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_PRELIMBILLINGDOCUMENT.MANDT == TSPA.MANDT
  • I_PRELIMBILLINGDOCUMENT.DIVISION == TSPA.SPART
Dunning Area
  • Dunning Area
  • Client
  • Company Code
  • I_PRELIMBILLINGDOCUMENT.DUNNINGAREA == T047M.MABER
  • I_PRELIMBILLINGDOCUMENT.MANDT == T047M.MANDT
  • I_PRELIMBILLINGDOCUMENT.COMPANYCODE == T047M.BUKRS
Dunning Block
  • Dunning Block
  • Client
  • I_PRELIMBILLINGDOCUMENT.DUNNINGBLOCKINGREASON == T040S.MANSP
  • I_PRELIMBILLINGDOCUMENT.MANDT == T040S.MANDT
Dunning Key
  • Client
  • Dunning Key
  • I_PRELIMBILLINGDOCUMENT.MANDT == T040.MANDT
  • I_PRELIMBILLINGDOCUMENT.DUNNINGKEY == T040.MSCHL
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • I_PRELIMBILLINGDOCUMENT.MANDT == TCURV.MANDT
  • I_PRELIMBILLINGDOCUMENT.EXCHANGERATETYPE == TCURV.KURST
Hierarchy type for pricing
  • Client
  • Hierarchy type for pricing
  • I_PRELIMBILLINGDOCUMENT.MANDT == THIT.MANDT
  • I_PRELIMBILLINGDOCUMENT.HIERARCHYTYPEPRICING == THIT.HITYP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_PRELIMBILLINGDOCUMENT.MANDT == TINC.MANDT
  • I_PRELIMBILLINGDOCUMENT.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • I_PRELIMBILLINGDOCUMENT.MANDT == TINCV.MANDT
  • I_PRELIMBILLINGDOCUMENT.INCOTERMSVERSION == TINCV.INCOV
Invoice List Type
  • Client
  • Invoice List Type
  • I_PRELIMBILLINGDOCUMENT.MANDT == TVFK.MANDT
  • I_PRELIMBILLINGDOCUMENT.INVOICELISTTYPE == TVFK.FKART
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_PRELIMBILLINGDOCUMENT.MANDT == T880.MANDT
  • I_PRELIMBILLINGDOCUMENT.PARTNERCOMPANY == T880.RCOMP
Payer
  • Payer
  • Client
  • I_PRELIMBILLINGDOCUMENT.PAYERPARTY == KNA1.KUNNR
  • I_PRELIMBILLINGDOCUMENT.MANDT == KNA1.MANDT
Payment Method
  • Client
  • Destination Country/Region
  • Payment Method
  • I_PRELIMBILLINGDOCUMENT.MANDT == T042Z.MANDT
  • I_PRELIMBILLINGDOCUMENT.COUNTRY == T042Z.LAND1
  • I_PRELIMBILLINGDOCUMENT.PAYMENTMETHOD == T042Z.ZLSCH
Price List Type
  • Client
  • Price List Type
  • I_PRELIMBILLINGDOCUMENT.MANDT == T189.MANDT
  • I_PRELIMBILLINGDOCUMENT.PRICELISTTYPE == T189.PLTYP
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • I_PRELIMBILLINGDOCUMENT.MANDT == T005S.MANDT
  • I_PRELIMBILLINGDOCUMENT.REGION == T005S.BLAND
  • I_PRELIMBILLINGDOCUMENT.COUNTRY == T005S.LAND1
Sales District
  • Sales District
  • Client
  • I_PRELIMBILLINGDOCUMENT.SALESDISTRICT == T171.BZIRK
  • I_PRELIMBILLINGDOCUMENT.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_PRELIMBILLINGDOCUMENT.SALESORGANIZATION == TVKO.VKORG
  • I_PRELIMBILLINGDOCUMENT.MANDT == TVKO.MANDT
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • Client
  • ?
  • I_PRELIMBILLINGDOCUMENT.SDPRICINGPROCEDURE == T683.KALSM
  • I_PRELIMBILLINGDOCUMENT.[column in domain "KAPPL"] == T683.KAPPL
  • I_PRELIMBILLINGDOCUMENT.MANDT == T683.MANDT
  • I_PRELIMBILLINGDOCUMENT.[column in domain "KVEWE"] == T683.KVEWE
Shipping Conditions
  • Shipping Conditions
  • Client
  • I_PRELIMBILLINGDOCUMENT.SHIPPINGCONDITION == TVSB.VSBED
  • I_PRELIMBILLINGDOCUMENT.MANDT == TVSB.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_PRELIMBILLINGDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • I_PRELIMBILLINGDOCUMENT.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • I_PRELIMBILLINGDOCUMENT.MANDT == TCURC.MANDT
  • I_PRELIMBILLINGDOCUMENT.STATISTICSCURRENCY == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • I_PRELIMBILLINGDOCUMENT.MANDT == TCURC.MANDT
  • I_PRELIMBILLINGDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS