C_SalesSchedgAgrmtItemQry

Sales Scheduling Agreement Item - Query | view: CSDSCHEDGAGRMTIQ | Extraction: Not supported | Component: Sales Analytics

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

🔑 Keys (3)
💰 Amounts
∑ Quantities (3)
📅 Dates (3)
☰ Categorical (1)
Other (10)
🔗 Relations (26)

Column Name	Description
SalesSchedulingAgreement FK	Sales Scheduling Agreement
SalesSchedulingAgreementItem	Sales Scheduling Agreement Item
SchedulingAgreementReleaseType	Release type	Show values

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
CumulativeDeliveredQuantity	Cumulative qty for delivery/MAIS in base unit of measure
CumulativeIssuedQuantity	GI Posted Cumulative Delivered Quantity
📏 Sales unit (OrderQuantityUnit):
CumulativeReceiptQuantity	Cumulative Quantity Received by Customer

Column Name	Description
LastChangeDate	Last Changed On
CreationDate	Date on which the record was created
CreationTime	Time at Which Record Was Created

Column Name	Description
SchedulingAgreementReleaseType	Release type	Show values

Column Name	Description	Domain name
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
CreationDateYear	Year of Creation	NUM4
CreationDateYearQuarter	Year/Quarter of Creation	NUM5
CreationDateYearMonth	Year/Month of Creation	NUM6
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
CustomerFiscalYear	Customer Fiscal Year	GJAHR

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

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