C_RequirementTrckgSchedAgrmt

Scheduling Agreement by Req. Tracking | view: CREQTRACKSA | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKKO, EKPO, T161T, T163, T163Y, USR21

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical
Other (14)
🔗 Relations (16)

Column Name	Description
SchedulingAgreement FK	Purchasing Document Number
SchedulingAgreementItem	Item Number of Purchasing Document

Column Name	Description
💲 Currency Key (DocumentCurrency):
TargetAmount	Target Value for Header Area per Distribution
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)

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

Column Name	Description
ValidityEndDate	End of Validity Period
ValidityStartDate	Start of Validity Period
SchedAgrmtCumQtyReconcileDate	Reconciliation date for agreed cumulative quantity

Column Name	Description

Column Name	Description	Domain name
FormattedPurchasingDocItem	null
DueDateCriticality	null
PurContrValidityStatusName	Contract Status
PurchasingDocumentCategory	Purchasing Document Category
PaymentTerms	Terms of Payment Key
RequirementTracking	Requirement Tracking Number
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
PurgDocItemCategoryName	Text for Item Category
PurchasingText	Short Text	TEXT40
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Name of Purchasing Category
NetPriceQuantity	Price Unit
FirmTradeOffZoneBindMRP	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
FirmTradeOffZoneBindMRPText	MRP Procedure Name	DDTEXT

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T163K.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Company Code Client Company Code	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T001.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.COMPANYCODE == T001.BUKRS`
Currency Key Client Currency Key	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == TCURC.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.DOCUMENTCURRENCY == TCURC.WAERS`
Incoterms (Part 1) Client Incoterms (Part 1)	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == TINC.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.INCOTERMSCLASSIFICATION == TINC.INCO1`
Material Number Client Material Number	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == MARA.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T023.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_REQUIREMENTTRCKGSCHEDAGRMT.ORDERPRICEUNIT == T006.MSEHI` `C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T006.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T006.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.ORDERQUANTITYUNIT == T006.MSEHI`
Plant Client Plant	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T001W.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T163.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Document Type Purchasing Document Category Client Purchasing Document Type	`C_REQUIREMENTTRCKGSCHEDAGRMT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T161.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.PURCHASINGDOCUMENTTYPE == T161.BSART`
Purchasing Group Client Purchasing Group	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T024.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T024E.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.PURCHASINGORGANIZATION == T024E.EKORG`
Storage Location Client Plant Storage Location	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == T001L.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.PLANT == T001L.WERKS` `C_REQUIREMENTTRCKGSCHEDAGRMT.STORAGELOCATION == T001L.LGORT`
Supplier Client Supplier	`C_REQUIREMENTTRCKGSCHEDAGRMT.MANDT == LFA1.MANDT` `C_REQUIREMENTTRCKGSCHEDAGRMT.SUPPLIER == LFA1.LIFNR`