C_SchedgAgrmtItmHistory

Scheduling Agreement Item History | view: CMMSCAGTITEMHIST | TRAN | Extraction: Not supported | Component: Reporting

Tables used: SCAL_TT_DATE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKET, EKBE, EKBEH, EKKO, EKPO, T161T, USR21

🔑 Keys (8)
💰 Amounts (7)
∑ Quantities (2)
📅 Dates (4)
☰ Categorical (1)
Other (12)
🔗 Relations (13)

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
TargetAmountInDisplayCurrency	Scheduling Agreement Target Amount
SchedulingAgreementSpend	Scheduling Agreement Released Amount
ScheduleLineExpectedSpend	Expected Spend of Scheduling Agreement
GoodsReceiptAmountInDspCrcy	Goods Receipt Amount
InvoiceAmtInDisplayCurrency	Invoice Amount
WeightedNetPrice	null

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity	Target Quantity
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
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
ProductType	Product Type Group	CHAR2
ScheduleLineOrderQuantity	Target Quantity of Scheduling Agreement Items	DEC
GoodsReceiptQuantity	Goods Receipt Quantity of Scheduling Agreement Items	DEC
AverageTargetQuantity	null
NumberOfItems	null
NumberOfScheduleLines	null

Master Data Relations	Join Conditions
Company Code Client Company Code	`C_SCHEDGAGRMTITMHISTORY.MANDT == T001.MANDT` `C_SCHEDGAGRMTITMHISTORY.COMPANYCODE == T001.BUKRS`
Currency Key Client Currency Key	`C_SCHEDGAGRMTITMHISTORY.MANDT == TCURC.MANDT` `C_SCHEDGAGRMTITMHISTORY.DOCUMENTCURRENCY == TCURC.WAERS`
Material Number Client Material Number	`C_SCHEDGAGRMTITMHISTORY.MANDT == MARA.MANDT` `C_SCHEDGAGRMTITMHISTORY.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_SCHEDGAGRMTITMHISTORY.MANDT == T023.MANDT` `C_SCHEDGAGRMTITMHISTORY.MATERIALGROUP == T023.MATKL`
Material type Client Material type	`C_SCHEDGAGRMTITMHISTORY.MANDT == T134.MANDT` `C_SCHEDGAGRMTITMHISTORY.MATERIALTYPE == T134.MTART`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_SCHEDGAGRMTITMHISTORY.MANDT == T006.MANDT` `C_SCHEDGAGRMTITMHISTORY.ORDERQUANTITYUNIT == T006.MSEHI`
Plant Client Plant	`C_SCHEDGAGRMTITMHISTORY.MANDT == T001W.MANDT` `C_SCHEDGAGRMTITMHISTORY.PLANT == T001W.WERKS`
Purchasing Document Type Client Purchasing Document Type ?	`C_SCHEDGAGRMTITMHISTORY.MANDT == T161.MANDT` `C_SCHEDGAGRMTITMHISTORY.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_SCHEDGAGRMTITMHISTORY.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Client Purchasing Group	`C_SCHEDGAGRMTITMHISTORY.MANDT == T024.MANDT` `C_SCHEDGAGRMTITMHISTORY.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`C_SCHEDGAGRMTITMHISTORY.MANDT == T024E.MANDT` `C_SCHEDGAGRMTITMHISTORY.PURCHASINGORGANIZATION == T024E.EKORG`
Storage Location Storage Location Client Plant	`C_SCHEDGAGRMTITMHISTORY.STORAGELOCATION == T001L.LGORT` `C_SCHEDGAGRMTITMHISTORY.MANDT == T001L.MANDT` `C_SCHEDGAGRMTITMHISTORY.PLANT == T001L.WERKS`
Supplier Client Supplier	`C_SCHEDGAGRMTITMHISTORY.MANDT == LFA1.MANDT` `C_SCHEDGAGRMTITMHISTORY.SUPPLIER == LFA1.LIFNR`