C_SlsSchedgAgrmtIncgSchdLn

Sales Scheduling Agreements - Product Demand | view: CSDSAINCGSCHDLN | Extraction: Not supported | Component: Sales Analytics

Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBEP, VBPA, MARA, TVV1, TVV1T, TVV2, TVV2T, TVV3, TVV3T, TVV4, TVV4T, TVV5, TVV5T, TVM1, TVM1T, TVM2, TVM2T, TVM3, TVM3T, TVM4, TVM4T, TVM5, TVM5T, CVI_CUST_CT_LINK, BUT000, KNA1, T151, T151T, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, T001W, T023T, T023, MAKT, T171, T171T, TVAK, TVAKT, TVKGR, TVGRT, TVBUR, TVKBT, TVKO, TVKOT, CVI_VEND_LINK

🔑 Keys (5)
💰 Amounts
∑ Quantities (1)
📅 Dates (1)
☰ Categorical (2)
Other (32)
🔗 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
SalesDelivDateCategoryName	Short Text for Fixed Values	DDTEXT
SalesSchedgAgrmtPeriodName	Time Period for Sales Scheduling Agreement Analysis	CHAR8
SalesDocumentTypeName	Sales Document Type Description	TEXT20
SalesOrganizationName	Sales Organization Description	TEXT20
DistributionChannelName	Distribution Channel Description	TEXT20
SalesOfficeName	Sales Office Description	TEXT20
SalesGroupName	Sales Group Description	TEXT20
SoldToPartyName	Name of Customer	TEXT80
CustomerGroupName	Name	TEXT20
ShipToParty	Ship-to Party	KUNNR
ShipToPartyName	Name of Customer	TEXT80
BillToParty	Bill-to Party	KUNNR
BillToPartyName	Name of Customer	TEXT80
PayerParty	Payer	KUNNR
PayerPartyName	Name of Customer	TEXT80
AdditionalCustomerGroup1Name	Description	TEXT20
AdditionalCustomerGroup2Name	Description	TEXT20
AdditionalCustomerGroup3Name	Description	TEXT20
AdditionalCustomerGroup4Name	Description	TEXT20
AdditionalCustomerGroup5Name	Description	TEXT20
ProductName	Product Description	TEXT40
ProductGroupName	Product Group Description	TEXT20
MaterialByCustomer	Material Number Used by Customer	IDNEX
DivisionName	Division Description	TEXT20
Plant	Plant (Own or External)	WERKS
PlantName	Plant Name	TEXT30
AdditionalMaterialGroup1Name	Description	TEXT40
AdditionalMaterialGroup2Name	Description	TEXT40
AdditionalMaterialGroup3Name	Description	TEXT40
AdditionalMaterialGroup4Name	Description	TEXT40
AdditionalMaterialGroup5Name	Description	TEXT40
SalesDistrictName	Name of the district	TEXT20

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

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