C_SalesDocumentSchedLineDEX

Data Extraction for Sales Document Schedule Lines | view: CSDSDOCSCHEDLNDX | TRAN | Extraction: Full or Incremental | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, T001, TKA02
Column Name Description
SalesDocument Sales Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetPriceAmount Net Price
Column Name Description
📏 Sales unit (OrderQuantityUnit):
CorrectedQtyInOrderQtyUnit Corrected quantity in sales unit
ConfdOrderQtyByMatlAvailCheck Confirmed Quantity
ScheduleLineOrderQuantity Order Quantity in Sales Units
📏 Base Unit of Measure (BaseUnit):
MRPRequiredQuantityInBaseUnit Required quantity for mat.management in stockkeeping units
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
PricingDate Date for Pricing and Exchange Rate
ProductAvailabilityDate Material Staging/Availability Date
DeliveryDate Schedule line date
RequestedDeliveryDate Requested Delivery Date
ServicesRenderedDate Date on which services are rendered
ConfdSchedLineReqdDelivDate Schedule line date
ConfirmedDeliveryDate Schedule line date
LoadingDate Loading Date
TransportationPlanningDate Transportation Planning Date
GoodsIssueDate Goods Issue Date
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
BillingDocumentDate Billing Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
Column Name Description Domain name
NetPriceQuantity Condition Pricing Unit KPEIN
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
IsConfirmedDelivSchedLine null
IsRequestedDelivSchedLine null
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
ShipToParty Ship-to Party KUNNR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
Plant Plant (Own or External) WERKS
IncotermsTransferLocation Incoterms (Part 2) INCO2
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVV5.MANDT
Material Group 1
  • Client
  • Material Group 1
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVM1.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Material Group 2
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.BASEUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T006.MANDT
Batch Number
  • Product Number
  • Material Number
  • Plant (Own or External)
  • Batch Number
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PRODUCT == MCHA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX.MATERIAL == MCHA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX.PLANT == MCHA.WERKS
  • C_SALESDOCUMENTSCHEDLINEDEX.BATCH == MCHA.CHARG
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == MCHA.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.BILLINGCOMPANYCODE == T001.BUKRS
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T001.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.CUSTOMERGROUP == T151.KDGRP
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T151.MANDT
Schedule Line Blocked for Delivery
  • Schedule Line Blocked for Delivery
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.DELIVBLOCKREASONFORSCHEDLINE == TVLS.LIFSP
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVLS.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVKOV.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TSPA.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.EXCHANGERATETYPE == TCURV.KURST
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TCURV.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.FISCALYEARVARIANT == T009.PERIV
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T009.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.INCOTERMSVERSION == TINCV.INCOV
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TINCV.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T006.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ITEMWEIGHTUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T006.MANDT
Material: order item
  • Product Number
  • Material Number
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PRODUCT == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX.MATERIAL == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == MARA.MANDT
Material Group
  • Product Group
  • Material Group
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PRODUCTGROUP == T023.MATKL
  • C_SALESDOCUMENTSCHEDLINEDEX.MATERIALGROUP == T023.MATKL
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T023.MANDT
Reason for material substitution
  • Client
  • Reason for material substitution
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVSU.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
Condition Unit
  • Condition Unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T006.MANDT
Material Entered
  • Client
  • Material Entered
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == MARA.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Material: order item
  • Product Number
  • Material Number
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PRODUCT == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX.MATERIAL == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Material Group
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PRODUCTGROUP == T023.MATKL
  • C_SALESDOCUMENTSCHEDLINEDEX.MATERIALGROUP == T023.MATKL
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T023.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PRODUCTHIERARCHYNODE == T179.PRODH
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T179.MANDT
Route
  • Route
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.ROUTE == TVRO.ROUTE
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVRO.MANDT
Sales District
  • Sales District
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESDISTRICT == T171.BZIRK
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVAG.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVAK.MANDT
Sales group
  • Sales group
  • Sales office
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESGROUP == TVBVK.VKGRP
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESOFFICE == TVBVK.VKBUR
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESORGANIZATION == TVKO.VKORG
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVKO.MANDT
Schedule line category
  • Schedule line category
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SCHEDULELINECATEGORY == TVEP.ETTYP
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVEP.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SDDOCUMENTREASON == TVAU.AUGRU
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVAU.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SHIPPINGPOINT == TVST.VSTEL
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVST.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TCURC.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.STATISTICSCURRENCY == TCURC.WAERS
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.PLANT == T001L.WERKS
  • C_SALESDOCUMENTSCHEDLINEDEX.STORAGELOCATION == T001L.LGORT
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T001L.MANDT
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == T006.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • SD Document Currency
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Sales office
  • Client
  • Division
  • Distribution Channel
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESDOCUMENTSCHEDLINEDEX.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESDOCUMENTSCHEDLINEDEX.MANDT == TVKBZ.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX.DIVISION == TVKBZ.SPART
  • C_SALESDOCUMENTSCHEDLINEDEX.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG