C_BillingDocItemBasicDEX_1

Data Extraction for Billing Doc Item Basic | view: CSDBILDOCITMBDX1 | TRAN | Extraction: Full or Incremental | Component: Sales Analytics
Tables used: VBRP, VBRK, T001, TKA02, TVKO
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of Billing item in Document Currency
GrossAmount Gross Value of the Billing Item in Document Currency
TaxAmount Tax Amount in Document Currency
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
EligibleAmountForCashDiscount Amount eligible for cash discount in document currency
CreditRelatedPrice Item credit price
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity Actual billed quantity
📏 Base Unit of Measure (BaseUnit):
BillingQuantityInBaseUnit Billing quantity in stock keeping unit
MRPRequiredQuantityInBaseUnit Required quantity for mat.management in stockkeeping units
PricingScaleQuantityInBaseUnit Scale Quantity in base unit of measure
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross weight
ItemNetWeight Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
BillingDocumentDate Billing Date
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
FixedValueDate Fixed Value Date
PriceDetnExchangeRateDate Translation date
Column Name Description
SalesDocumentItemType Item Type Show values
ReturnItemProcessingType Returns item Show values
BillingDocumentCategory Billing Category Show values
SDDocumentCategory SD Document Category Show values
BillingDocumentIsTemporary Boolean Variable (X = True, - = False, Space = Unknown) Show values
BillingDocumentIsCancelled Billing document is canceled Show values
BillingPlanRule Rule in billing plan/invoice plan Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
StatisticalValueControl Statistical Values Show values
AccountingExchangeRateIsSet Exchange Rate Setting Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SalesSDDocumentCategory SD Document Category Show values
ItemIsRelevantForCredit ID: Item with active credit function / relevant for credit 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
Column Name Description Domain name
SalesDocumentItemCategory Sales document item category PSTYV
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
BillingDocumentItemText Short text for sales order item TEXT40
BillingToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
BillingToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
BillingPlanItem Item for billing plan/invoice plan/payment cards FPLTR
CustomerPriceGroup Customer Price Group KONDA
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
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
StatisticsExchangeRate Exchange rate for statistics (Exch.rate at time of creation) KURRF_NOT_CONVERTED
ContractAccount Contract Account Number CORR_VKONT_KK
CustomerPaymentTerms Terms of payment key ZTERM
PaymentReference Payment Reference CHAR30
AdditionalValueDays Additional Value Days TAGE2
PayerParty Payer KUNNR
CompanyCode Company Code BUKRS
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
CostCenter Cost Center KOSTL
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SalesDistrict Sales District BZIRK
CustomerGroup Customer Group KDGRP
SoldToParty Sold-to Party KUNNR
Country Destination Country/Region LAND1
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVV3.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVV4.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVV5.MANDT
Material Group 1
  • Client
  • Material Group 1
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVM1.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVM2.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVM3.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVM4.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVM5.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T006.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Plant
  • Material Number
  • Product Number
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == MCHA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.BATCH == MCHA.CHARG
  • C_BILLINGDOCITEMBASICDEX_1.PLANT == MCHA.WERKS
  • C_BILLINGDOCITEMBASICDEX_1.MATERIAL == MCHA.MATNR
  • C_BILLINGDOCITEMBASICDEX_1.PRODUCT == MCHA.MATNR
Sales unit
  • Client
  • Sales unit
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T006.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.BILLINGQUANTITYUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • C_BILLINGDOCITEMBASICDEX_1.BILLTOPARTYCOUNTRY == T005.LAND1
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T005.MANDT
Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • Region of Sales Order
  • C_BILLINGDOCITEMBASICDEX_1.BILLTOPARTYCOUNTRY == T005S.LAND1
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T005S.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.BILLTOPARTYREGION == T005S.BLAND
Business Area
  • Client
  • Business Area
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TGSB.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TKA01.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • Statistics currency
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TCURC.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.CURRENCY == TCURC.WAERS
  • C_BILLINGDOCITEMBASICDEX_1.SALESORGANIZATIONCURRENCY == TCURC.WAERS
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVKT.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Division
  • Client
  • Division
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TSPA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TCURV.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.EXCHANGERATETYPE == TCURV.KURST
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T009.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.FISCALYEARVARIANT == T009.PERIV
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TINC.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TINCV.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.INCOTERMSVERSION == TINCV.INCOV
Volume unit
  • Client
  • Volume unit
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T006.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T006.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ITEMWEIGHTUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • Product Number
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == MARA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.MATERIAL == MARA.MATNR
  • C_BILLINGDOCITEMBASICDEX_1.PRODUCT == MARA.MATNR
Commission Group
  • Client
  • Commission Group
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVPR.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.MATERIALCOMMISSIONGROUP == TVPR.PROVG
Material Group
  • Client
  • Material Group
  • Product Group
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T023.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.MATERIALGROUP == T023.MATKL
  • C_BILLINGDOCITEMBASICDEX_1.PRODUCTGROUP == T023.MATKL
Order Number
  • Client
  • Order Number
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == AUFK.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ORDERID == AUFK.AUFNR
Division for order header
  • Client
  • Division for order header
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TSPA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ORGANIZATIONDIVISION == TSPA.SPART
Material Entered
  • Client
  • Material Entered
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == MARA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • ?
  • Client
  • Payment Method
  • C_BILLINGDOCITEMBASICDEX_1.[column in domain "LAND1"] == T042Z.LAND1
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T042Z.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.PAYMENTMETHOD == T042Z.ZLSCH
Plant
  • Client
  • Plant
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T001W.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.PLANT == T001W.WERKS
Price List Type
  • Client
  • Price List Type
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T189.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.PRICELISTTYPE == T189.PLTYP
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == MARA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.PRICINGREFERENCEMATERIAL == MARA.MATNR
Product Number
  • Client
  • Material Number
  • Product Number
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == MARA.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.MATERIAL == MARA.MATNR
  • C_BILLINGDOCITEMBASICDEX_1.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Material Group
  • Product Group
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T023.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.MATERIALGROUP == T023.MATKL
  • C_BILLINGDOCITEMBASICDEX_1.PRODUCTGROUP == T023.MATKL
Sales group
  • Client
  • Sales group
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVKGR.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.SALESGROUP == TVKGR.VKGRP
Sales office
  • Client
  • Sales office
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVBUR.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.SALESOFFICE == TVBUR.VKBUR
Statistics currency
  • Client
  • Currency Key
  • Statistics currency
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TCURC.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.CURRENCY == TCURC.WAERS
  • C_BILLINGDOCITEMBASICDEX_1.SALESORGANIZATIONCURRENCY == TCURC.WAERS
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVAU.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.SDDOCUMENTREASON == TVAU.AUGRU
Pricing Procedure in Pricing
  • Client
  • ?
  • ?
  • Pricing Procedure in Pricing
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T683.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.[column in domain "KVEWE"] == T683.KVEWE
  • C_BILLINGDOCITEMBASICDEX_1.[column in domain "KAPPL"] == T683.KAPPL
  • C_BILLINGDOCITEMBASICDEX_1.SDPRICINGPROCEDURE == T683.KALSM
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVSB.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TVST.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.SHIPPINGPOINT == TVST.VSTEL
Statistics Currency
  • Client
  • Statistics Currency
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == TCURC.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.STATISTICSCURRENCY == TCURC.WAERS
Storage location
  • Client
  • Storage location
  • Plant
  • C_BILLINGDOCITEMBASICDEX_1.MANDT == T001L.MANDT
  • C_BILLINGDOCITEMBASICDEX_1.STORAGELOCATION == T001L.LGORT
  • C_BILLINGDOCITEMBASICDEX_1.PLANT == T001L.WERKS