I_SlsSchedgAgrmtIncgSchdLn

Sales Scheduling Agreement Incoming Schedule Line | view: ISDSAINCGSCHDLN | Extraction: Not supported | Component: Sales Analytics

Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK

🔑 Keys (5)
💰 Amounts
∑ Quantities (1)
📅 Dates (1)
☰ Categorical (2)
Other (10)
🔗 Relations (24)

Column Name	Description
SalesSchedulingAgreement	Sales Scheduling Agreement
SalesSchedulingAgreementItem	Sales Scheduling Agreement Item
ScheduleLine	Schedule Line Number
IntDeliveryScheduleNumber	Internal delivery schedule number
SchedulingAgreementReleaseType	Release Type	Show values

Column Name	Description

Column Name	Description
📏 Sales unit (OrderQuantityUnit):
ScheduleLineOrderQuantity	Order Quantity in Sales Units

Column Name	Description
RequestedDeliveryDate	Requested Delivery Date

Column Name	Description
SchedulingAgreementReleaseType	Release Type	Show values
SalesDelivDateCategory	Delivery Date Type (Day, Week, Month, Interval)	Show values

Column Name	Description	Domain name
CreationDateYear	Year of Creation	NUM4
CreationDateYearQuarter	Year/Quarter of Creation	NUM5
CreationDateYearMonth	Year/Month of Creation	NUM6
CreationDateYearWeek	Year Week	NUM6
SalesSchedgAgrmtPeriodName	Time Period for Sales Scheduling Agreement Analysis	CHAR8
ShipToParty	Ship-to Party	KUNNR
BillToParty	Bill-to Party	KUNNR
PayerParty	Payer	KUNNR
MaterialByCustomer	Material Number Used by Customer	IDNEX
Plant	Plant (Own or External)	WERKS

Master Data Relations	Join Conditions
Customer Group 1 Customer Group 1 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVV1.MANDT`
Customer Group 2 Customer Group 2 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVV2.MANDT`
Customer Group 3 Customer Group 3 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVV3.MANDT`
Customer Group 4 Customer Group 4 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVV4.MANDT`
Customer Group 5 Customer Group 5 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVV5.MANDT`
Material Group 1 Material Group 1 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVM1.MANDT`
Material Group 2 Client Material Group 2	`I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVM2.MANDT` `I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2`
Material Group 3 Material Group 3 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVM3.MANDT`
Material Group 4 Material Group 4 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVM4.MANDT`
Material Group 5 Material Group 5 Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVM5.MANDT`
Company Code to Be Billed Company Code to Be Billed Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.BILLINGCOMPANYCODE == T001.BUKRS` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == T001.MANDT`
Customer Group Customer Group Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.CUSTOMERGROUP == T151.KDGRP` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == T151.MANDT`
Distribution channel in order header Sales Organization Distribution Channel Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESORGANIZATION == TVKOV.VKORG` `I_SLSSCHEDGAGRMTINCGSCHDLN.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVKOV.MANDT`
Division Client Division Organization Division	`I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TSPA.MANDT` `I_SLSSCHEDGAGRMTINCGSCHDLN.DIVISION == TSPA.SPART` `I_SLSSCHEDGAGRMTINCGSCHDLN.ORGANIZATIONDIVISION == TSPA.SPART`
Sales unit Client Sales unit	`I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == T006.MANDT` `I_SLSSCHEDGAGRMTINCGSCHDLN.ORDERQUANTITYUNIT == T006.MSEHI`
Division in order header Sales Organization Distribution Channel Client Division Organization Division	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESORGANIZATION == TVTA.VKORG` `I_SLSSCHEDGAGRMTINCGSCHDLN.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVTA.MANDT` `I_SLSSCHEDGAGRMTINCGSCHDLN.DIVISION == TVTA.SPART` `I_SLSSCHEDGAGRMTINCGSCHDLN.ORGANIZATIONDIVISION == TVTA.SPART`
Material: order item Product Number Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.PRODUCT == MARA.MATNR` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == MARA.MANDT`
Product Group Product Group Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.PRODUCTGROUP == T023.MATKL` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == T023.MANDT`
Sales District Sales District Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESDISTRICT == T171.BZIRK` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == T171.MANDT`
Sales group Sales office Sales group Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESOFFICE == TVBVK.VKBUR` `I_SLSSCHEDGAGRMTINCGSCHDLN.SALESGROUP == TVBVK.VKGRP` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVBVK.MANDT`
Sales organization in order header Sales Organization Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESORGANIZATION == TVKO.VKORG` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVKO.MANDT`
Order type in order header Sales Scheduling Agreement Type Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESSCHEDGAGRMTTYPE == TVAK.AUART` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVAK.MANDT`
Sold-to Party Sold-to Party Client	`I_SLSSCHEDGAGRMTINCGSCHDLN.SOLDTOPARTY == KNA1.KUNNR` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == KNA1.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Sales Organization Distribution Channel Sales office Client Division Organization Division	`I_SLSSCHEDGAGRMTINCGSCHDLN.SALESORGANIZATION == TVKBZ.VKORG` `I_SLSSCHEDGAGRMTINCGSCHDLN.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `I_SLSSCHEDGAGRMTINCGSCHDLN.SALESOFFICE == TVKBZ.VKBUR` `I_SLSSCHEDGAGRMTINCGSCHDLN.MANDT == TVKBZ.MANDT` `I_SLSSCHEDGAGRMTINCGSCHDLN.DIVISION == TVKBZ.SPART` `I_SLSSCHEDGAGRMTINCGSCHDLN.ORGANIZATIONDIVISION == TVKBZ.SPART`