C_SalesDocumentItemDEX_1

Data Extraction for Sales Document Item | view: CSDSLSDOCITMDX1 | TRAN | Extraction: Full or Incremental | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, T001, TKA02, TVKO
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
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
OutlineAgreementTargetAmount Target Value for Outline Agreement in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
TargetDelivQtyInOrderQtyUnit Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
RequestedDeliveryDate Requested Delivery Date
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
BillingDocumentDate Billing Date
Column Name Description
SDDocumentCategory SD Document Category Show values
IsReturnsItem Returns Item Show values
HdrOrderProbabilityInPercent Sales probability Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
StatisticalValueControl Statistical Values Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
CompletionRule Completion Rule for Quotation / Contract Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
Column Name Description Domain name
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ShipToParty Ship-to Party KUNNR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
TargetToBaseQuantityDnmntr Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
TargetToBaseQuantityNmrtr Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
NetPriceQuantity Condition Pricing Unit KPEIN
Plant Plant (Own or External) WERKS
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVV5.MANDT
Material Group 1
  • Material Group 1
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVM3.MANDT
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SALESDOCUMENTITEMDEX_1.BASEUNIT == T006.MSEHI
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Material Number
  • Product Number
  • Plant (Own or External)
  • Client
  • C_SALESDOCUMENTITEMDEX_1.BATCH == MCHA.CHARG
  • C_SALESDOCUMENTITEMDEX_1.MATERIAL == MCHA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.PRODUCT == MCHA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.PLANT == MCHA.WERKS
  • C_SALESDOCUMENTITEMDEX_1.MANDT == MCHA.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SALESDOCUMENTITEMDEX_1.BILLINGCOMPANYCODE == T001.BUKRS
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • C_SALESDOCUMENTITEMDEX_1.BUSINESSAREA == TGSB.GSBER
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_SALESDOCUMENTITEMDEX_1.CONTROLLINGAREA == TKA01.KOKRS
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TKA01.MANDT
Currency Key
  • Client
  • Currency Key
  • Statistics currency
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TCURC.MANDT
  • C_SALESDOCUMENTITEMDEX_1.CURRENCY == TCURC.WAERS
  • C_SALESDOCUMENTITEMDEX_1.SALESORGANIZATIONCURRENCY == TCURC.WAERS
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_SALESDOCUMENTITEMDEX_1.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SALESDOCUMENTITEMDEX_1.CUSTOMERGROUP == T151.KDGRP
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SALESDOCUMENTITEMDEX_1.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_SALESDOCUMENTITEMDEX_1.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESDOCUMENTITEMDEX_1.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVKOV.MANDT
  • C_SALESDOCUMENTITEMDEX_1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Division
  • Client
  • C_SALESDOCUMENTITEMDEX_1.DIVISION == TSPA.SPART
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TSPA.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • C_SALESDOCUMENTITEMDEX_1.EXCHANGERATETYPE == TCURV.KURST
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TCURV.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T009.MANDT
  • C_SALESDOCUMENTITEMDEX_1.FISCALYEARVARIANT == T009.PERIV
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SALESDOCUMENTITEMDEX_1.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESDOCUMENTITEMDEX_1.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SALESDOCUMENTITEMDEX_1.INCOTERMSVERSION == TINCV.INCOV
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TINCV.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_SALESDOCUMENTITEMDEX_1.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T148.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ITEMVOLUMEUNIT == T006.MSEHI
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ITEMWEIGHTUNIT == T006.MSEHI
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T006.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • C_SALESDOCUMENTITEMDEX_1.MATERIAL == MARA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.PRODUCT == MARA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • Product Group
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T023.MANDT
  • C_SALESDOCUMENTITEMDEX_1.MATERIALGROUP == T023.MATKL
  • C_SALESDOCUMENTITEMDEX_1.PRODUCTGROUP == T023.MATKL
Reason for material substitution
  • Reason for material substitution
  • Client
  • C_SALESDOCUMENTITEMDEX_1.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVSU.MANDT
Condition Unit
  • Condition Unit
  • Client
  • C_SALESDOCUMENTITEMDEX_1.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T006.MANDT
Order Number
  • Order Number
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ORDERID == AUFK.AUFNR
  • C_SALESDOCUMENTITEMDEX_1.MANDT == AUFK.MANDT
Sales unit
  • Client
  • Sales unit
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T006.MANDT
  • C_SALESDOCUMENTITEMDEX_1.ORDERQUANTITYUNIT == T006.MSEHI
Material Entered
  • Material Entered
  • Client
  • C_SALESDOCUMENTITEMDEX_1.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.MANDT == MARA.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • C_SALESDOCUMENTITEMDEX_1.MATERIAL == MARA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.PRODUCT == MARA.MATNR
  • C_SALESDOCUMENTITEMDEX_1.MANDT == MARA.MANDT
Product Group
  • Client
  • Material Group
  • Product Group
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T023.MANDT
  • C_SALESDOCUMENTITEMDEX_1.MATERIALGROUP == T023.MATKL
  • C_SALESDOCUMENTITEMDEX_1.PRODUCTGROUP == T023.MATKL
Route
  • Client
  • Route
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVRO.MANDT
  • C_SALESDOCUMENTITEMDEX_1.ROUTE == TVRO.ROUTE
Sales District
  • Sales District
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SALESDISTRICT == T171.BZIRK
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVAG.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SALESOFFICE == TVBVK.VKBUR
  • C_SALESDOCUMENTITEMDEX_1.SALESGROUP == TVBVK.VKGRP
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SALESORGANIZATION == TVKO.VKORG
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVKO.MANDT
Statistics currency
  • Client
  • Currency Key
  • Statistics currency
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TCURC.MANDT
  • C_SALESDOCUMENTITEMDEX_1.CURRENCY == TCURC.WAERS
  • C_SALESDOCUMENTITEMDEX_1.SALESORGANIZATIONCURRENCY == TCURC.WAERS
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SDDOCUMENTREASON == TVAU.AUGRU
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVAU.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SHIPPINGCONDITION == TVSB.VSBED
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SHIPPINGPOINT == TVST.VSTEL
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SHIPPINGTYPE == T173.VSART
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T173.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESDOCUMENTITEMDEX_1.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESDOCUMENTITEMDEX_1.MANDT == KNA1.MANDT
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • C_SALESDOCUMENTITEMDEX_1.PLANT == T001L.WERKS
  • C_SALESDOCUMENTITEMDEX_1.STORAGELOCATION == T001L.LGORT
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T001L.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • C_SALESDOCUMENTITEMDEX_1.TARGETQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTITEMDEX_1.MANDT == T006.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_SALESDOCUMENTITEMDEX_1.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESDOCUMENTITEMDEX_1.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESDOCUMENTITEMDEX_1.DIVISION == TVKBZ.SPART
  • C_SALESDOCUMENTITEMDEX_1.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESDOCUMENTITEMDEX_1.MANDT == TVKBZ.MANDT
  • C_SALESDOCUMENTITEMDEX_1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG