C_SchedgAgrmtItmCnsmpn

Scheduling Agreement Item Consumption | view: CSCHAGTITMCNSM | Extraction: Not supported | Component: Reporting

Column Name	Description
SchedulingAgreement FK	Scheduling Agreement
SchedulingAgreementItem	Scheduling Agreement Item
ScheduleLine	Delivery Schedule Line Counter
AccountAssignmentNumber	Sequential Number of Account Assignment
PurchaseOrderTransactionType	Transaction/event type, purchase order history	Show values
MaterialDocument	Number of Material Document
MaterialDocumentItem	Item in Material Document
MaterialDocumentYear	Material Document Year

Column Name	Description
💲 Display Currency (DisplayCurrency):
AverageTargetAmount	null
SchedulingAgreementSpend	Scheduling Agreement Released Amount
ScheduleLineExpectedSpend	Expected Spend of Scheduling Agreement
WeightedNetPrice	null
GoodsReceiptAmountInDspCrcy	Goods Receipt Amount
InvoiceAmtInDisplayCurrency	Invoice Amount
TargetAmountInDisplayCurrency	Scheduling Agreement Target Amount

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantityInBaseUnit	Target Quantity

Column Name	Description
ValidityStartDate	Start of Validity Period
ValidityEndDate	End of Validity Period
PurchasingDocumentOrderDate	Purchasing Document Date
ScheduleLineDeliveryDate	Item delivery date

Column Name	Description
PurchaseOrderTransactionType	Transaction/event type, purchase order history	Show values

Column Name	Description	Domain name
SupplierName	Name of Supplier	TEXT80
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PurchasingGroupName	Purchasing Group Name	TEXT18
PlantName	Plant Name	TEXT30
MaterialGroupName	Product Group Description	TEXT20
MaterialName	Material Description	TEXT40
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Name of Purchasing Category	/SRMSMC/MEDIUM_NAME
CalendarWeek	Calendar Week	NUM2
CalendarMonth	Calendar Month	NUM2
CalendarQuarter	Calendar Quarter	NUM1
CalendarYear	Calendar Year	NUM4
ScheduleLineOrderQuantity	Target Quantity of Scheduling Agreement Items	DEC
GoodsReceiptQuantity	Goods Receipt Quantity of Scheduling Agreement Items	DEC
TargetQuantity	null
AverageTargetQuantity	null
TargetAmount	null
NumberOfItems	null
NumberOfScheduleLines	null
SchedgAgrmtCnsmpnRatio	null
SchedgAgrmtCnsmpnInPct	null

Master Data Relations	Join Conditions
Company Code Company Code Client	`C_SCHEDGAGRMTITMCNSMPN.COMPANYCODE == T001.BUKRS` `C_SCHEDGAGRMTITMCNSMPN.MANDT == T001.MANDT`
Material Number Client Material Number	`C_SCHEDGAGRMTITMCNSMPN.MANDT == MARA.MANDT` `C_SCHEDGAGRMTITMCNSMPN.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`C_SCHEDGAGRMTITMCNSMPN.MATERIALGROUP == T023.MATKL` `C_SCHEDGAGRMTITMCNSMPN.MANDT == T023.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_SCHEDGAGRMTITMCNSMPN.ORDERQUANTITYUNIT == T006.MSEHI` `C_SCHEDGAGRMTITMCNSMPN.MANDT == T006.MANDT`
Plant Plant Client	`C_SCHEDGAGRMTITMCNSMPN.PLANT == T001W.WERKS` `C_SCHEDGAGRMTITMCNSMPN.MANDT == T001W.MANDT`
Purchasing Group Client Purchasing Group	`C_SCHEDGAGRMTITMCNSMPN.MANDT == T024.MANDT` `C_SCHEDGAGRMTITMCNSMPN.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Purchasing organization Client	`C_SCHEDGAGRMTITMCNSMPN.PURCHASINGORGANIZATION == T024E.EKORG` `C_SCHEDGAGRMTITMCNSMPN.MANDT == T024E.MANDT`
Storage Location Storage Location Plant Client	`C_SCHEDGAGRMTITMCNSMPN.STORAGELOCATION == T001L.LGORT` `C_SCHEDGAGRMTITMCNSMPN.PLANT == T001L.WERKS` `C_SCHEDGAGRMTITMCNSMPN.MANDT == T001L.MANDT`
Supplier Client Supplier	`C_SCHEDGAGRMTITMCNSMPN.MANDT == LFA1.MANDT` `C_SCHEDGAGRMTITMCNSMPN.SUPPLIER == LFA1.LIFNR`