I_SlsDocSchedLineAnalytics

Sales Document Schedule Line Analytics | view: ISDSCHEDLINENANA | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, KNA1, TVKO
Column Name Description
SalesDocument Sales Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OpenSlsOrdersForDelivNetAmount Open Sales Orders for Deliveries Net Amt in Trans. Crcy
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OpnSlsOrdrsForDelivQuantity Open Confirmed Sales Orders for Deliveries Quantity in BU
Column Name Description
GoodsIssueDate Goods Issue Date
DeliveryDate Schedule line date
CreationDate Date on which the record was created
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProfitCenter Profit Center PRCTR
SoldToPartyName Name of Sold-to Party TEXT80
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVV4.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVV5.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Material Group 1
  • Material Group 1
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.BASEUNIT == T006.MSEHI
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == T006.MANDT
Batch Number
  • ?
  • Batch Number
  • Material Number
  • Product Number
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.[column in domain "WERKS_D"] == MCHA.WERKS
  • I_SLSDOCSCHEDLINEANALYTICS.BATCH == MCHA.CHARG
  • I_SLSDOCSCHEDLINEANALYTICS.MATERIAL == MCHA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.PRODUCT == MCHA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == MCHA.MANDT
Customer Group
  • Customer Group
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.CUSTOMERGROUP == T151.KDGRP
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == T151.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_SLSDOCSCHEDLINEANALYTICS.SALESORGANIZATION == TVKOV.VKORG
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVKOV.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.MATERIAL == MARA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.PRODUCT == MARA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • Product Group
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == T023.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.MATERIALGROUP == T023.MATKL
  • I_SLSDOCSCHEDLINEANALYTICS.PRODUCTGROUP == T023.MATKL
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • I_SLSDOCSCHEDLINEANALYTICS.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SLSDOCSCHEDLINEANALYTICS.SALESORGANIZATION == TVTA.VKORG
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVTA.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material Entered
  • Material Entered
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == MARA.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.MATERIAL == MARA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.PRODUCT == MARA.MATNR
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == MARA.MANDT
Product Group
  • Client
  • Material Group
  • Product Group
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == T023.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.MATERIALGROUP == T023.MATKL
  • I_SLSDOCSCHEDLINEANALYTICS.PRODUCTGROUP == T023.MATKL
Product hierarchy: order item
  • Product hierarchy
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == T179.MANDT
Sales District
  • Sales District
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.SALESDISTRICT == T171.BZIRK
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == T171.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.SALESDOCUMENTTYPE == TVAK.AUART
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • I_SLSDOCSCHEDLINEANALYTICS.SALESOFFICE == TVBVK.VKBUR
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVBVK.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.SALESORGANIZATION == TVKO.VKORG
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.SHIPPINGPOINT == TVST.VSTEL
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVST.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.SOLDTOPARTY == KNA1.KUNNR
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == KNA1.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_SLSDOCSCHEDLINEANALYTICS.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TKUKL.MANDT
Statistics currency
  • Client
  • Statistics currency
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TCURC.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.STATISTICSCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • I_SLSDOCSCHEDLINEANALYTICS.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SLSDOCSCHEDLINEANALYTICS.SALESOFFICE == TVKBZ.VKBUR
  • I_SLSDOCSCHEDLINEANALYTICS.SALESORGANIZATION == TVKBZ.VKORG
  • I_SLSDOCSCHEDLINEANALYTICS.MANDT == TVKBZ.MANDT
  • I_SLSDOCSCHEDLINEANALYTICS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG