C_SalesDocumentSchedLineDEX_1

Data Extraction for Sales Document Schedule Lines | view: CSDSDOCSCHDLNDX1 | 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_1.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVV5.MANDT
Material Group 1
  • Material Group 1
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVM2.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.BASEUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T006.MANDT
Batch Number
  • Material Number
  • Product Number
  • Plant (Own or External)
  • Batch Number
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MATERIAL == MCHA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PRODUCT == MCHA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PLANT == MCHA.WERKS
  • C_SALESDOCUMENTSCHEDLINEDEX_1.BATCH == MCHA.CHARG
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == MCHA.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.BILLINGCOMPANYCODE == T001.BUKRS
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T001.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.CUSTOMERGROUP == T151.KDGRP
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T151.MANDT
Schedule Line Blocked for Delivery
  • Schedule Line Blocked for Delivery
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.DELIVBLOCKREASONFORSCHEDLINE == TVLS.LIFSP
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVLS.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESDOCUMENTSCHEDLINEDEX_1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVKOV.MANDT
Division
  • Division
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.DIVISION == TSPA.SPART
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TSPA.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.EXCHANGERATETYPE == TCURV.KURST
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TCURV.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.FISCALYEARVARIANT == T009.PERIV
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T009.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.INCOTERMSVERSION == TINCV.INCOV
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TINCV.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ITEMVOLUMEUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ITEMWEIGHTUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T006.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MATERIAL == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PRODUCT == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • Product Group
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T023.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MATERIALGROUP == T023.MATKL
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PRODUCTGROUP == T023.MATKL
Reason for material substitution
  • Reason for material substitution
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVSU.MANDT
Condition Unit
  • Condition Unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T006.MANDT
Material Entered
  • Client
  • Material Entered
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == MARA.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Material: order item
  • Material Number
  • Product Number
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MATERIAL == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PRODUCT == MARA.MATNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == MARA.MANDT
Product Group
  • Client
  • Material Group
  • Product Group
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T023.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MATERIALGROUP == T023.MATKL
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PRODUCTGROUP == T023.MATKL
Product hierarchy: order item
  • Product hierarchy
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PRODUCTHIERARCHYNODE == T179.PRODH
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T179.MANDT
Route
  • Client
  • Route
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVRO.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.ROUTE == TVRO.ROUTE
Sales District
  • Sales District
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESDISTRICT == T171.BZIRK
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVAG.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVBVK.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESOFFICE == TVBVK.VKBUR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESORGANIZATION == TVKO.VKORG
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVKO.MANDT
Schedule line category
  • Schedule line category
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SCHEDULELINECATEGORY == TVEP.ETTYP
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVEP.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SDDOCUMENTREASON == TVAU.AUGRU
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVAU.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SHIPPINGPOINT == TVST.VSTEL
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVST.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TCURC.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.STATISTICSCURRENCY == TCURC.WAERS
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.PLANT == T001L.WERKS
  • C_SALESDOCUMENTSCHEDLINEDEX_1.STORAGELOCATION == T001L.LGORT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T001L.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • C_SALESDOCUMENTSCHEDLINEDEX_1.TARGETQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == T006.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TCURC.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Division
  • Distribution Channel
  • Client
  • Sales office
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESDOCUMENTSCHEDLINEDEX_1.DIVISION == TVKBZ.SPART
  • C_SALESDOCUMENTSCHEDLINEDEX_1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SALESDOCUMENTSCHEDLINEDEX_1.MANDT == TVKBZ.MANDT
  • C_SALESDOCUMENTSCHEDLINEDEX_1.SALESOFFICE == TVKBZ.VKBUR