C_RequirementTrackingPurCtr

Purchase Contracts by Requirement Tracking | view: CREQTRACKCTR | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKO, EKPO, T001W, T163Y, T16FE, LFA1, USR21

🔑 Keys (2)
💰 Amounts (3)
∑ Quantities (2)
📅 Dates (4)
☰ Categorical (1)
Other (15)
🔗 Relations (17)

Column Name	Description
PurchaseContract FK	Purchasing Contract Header
PurchaseContractItem	Item Number of Purchasing Contract

Column Name	Description
💲 Currency Key (DocumentCurrency):
ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)
TargetAmount	Target Value for Outline Agreement in Document Currency
PurchaseContractTargetAmount	null

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

Column Name	Description
ReleaseOrderDate	Release Order Date
ValidityEndDate	Date Validity Ends
CreationDate	Creation Date of Purchasing Document
ValidityStartDate	Date for Beginning of Validity

Column Name	Description
PurContrValidityStatusName	Contract Status	Show values

Column Name	Description	Domain name
FormattedPurchaseContractItem	null
NetPriceQuantity	Price Unit	DEC5
DueDateCriticality	null
PurchaseContractValidityStatus	Validity Status
ReleaseCodeName	Release Status	TEXT30
CreatedByUser	User of person who created a purchasing document	USNAM
UserDescription	User Description
PurchasingDocumentCategory	Purchasing Document Category
PurgDocExternalItemCategory	Item Category in Purchasing Document
PurgDocItemCategoryName	Text for Item Category
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Name of Purchasing Category
PurchasingText	Short Text	TEXT40
RequirementTracking	Requirement Tracking Number
PurchasingIsBlockedForSupplier	Supplier Blocked status

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_REQUIREMENTTRACKINGPURCTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T163K.MANDT`
Company Code Company Code Client	`C_REQUIREMENTTRACKINGPURCTR.COMPANYCODE == T001.BUKRS` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T001.MANDT`
Currency Key Client Currency Key	`C_REQUIREMENTTRACKINGPURCTR.MANDT == TCURC.MANDT` `C_REQUIREMENTTRACKINGPURCTR.DOCUMENTCURRENCY == TCURC.WAERS`
Material Number Client Material Number	`C_REQUIREMENTTRACKINGPURCTR.MANDT == MARA.MANDT` `C_REQUIREMENTTRACKINGPURCTR.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_REQUIREMENTTRACKINGPURCTR.MANDT == T023.MANDT` `C_REQUIREMENTTRACKINGPURCTR.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_REQUIREMENTTRACKINGPURCTR.ORDERPRICEUNIT == T006.MSEHI` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_REQUIREMENTTRACKINGPURCTR.ORDERQUANTITYUNIT == T006.MSEHI` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T006.MANDT`
Plant Plant Client	`C_REQUIREMENTTRACKINGPURCTR.PLANT == T001W.WERKS` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T001W.MANDT`
Item category in purchasing document Client Item category in purchasing document	`C_REQUIREMENTTRACKINGPURCTR.MANDT == T163.MANDT` `C_REQUIREMENTTRACKINGPURCTR.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Document Type Client Purchasing Document Type Purchasing Document Category	`C_REQUIREMENTTRACKINGPURCTR.MANDT == T161.MANDT` `C_REQUIREMENTTRACKINGPURCTR.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_REQUIREMENTTRACKINGPURCTR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP`
Purchasing Group Purchasing Group Client	`C_REQUIREMENTTRACKINGPURCTR.PURCHASINGGROUP == T024.EKGRP` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`C_REQUIREMENTTRACKINGPURCTR.PURCHASINGINFORECORD == EINA.INFNR` `C_REQUIREMENTTRACKINGPURCTR.MANDT == EINA.MANDT`
Purchasing organization Client Purchasing organization	`C_REQUIREMENTTRACKINGPURCTR.MANDT == T024E.MANDT` `C_REQUIREMENTTRACKINGPURCTR.PURCHASINGORGANIZATION == T024E.EKORG`
Storage Location Plant Client Storage Location	`C_REQUIREMENTTRACKINGPURCTR.PLANT == T001L.WERKS` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T001L.MANDT` `C_REQUIREMENTTRACKINGPURCTR.STORAGELOCATION == T001L.LGORT`
Supplier Supplier Client	`C_REQUIREMENTTRACKINGPURCTR.SUPPLIER == LFA1.LIFNR` `C_REQUIREMENTTRACKINGPURCTR.MANDT == LFA1.MANDT`
Tax on sales/purchases code ? Client Tax on sales/purchases code	`C_REQUIREMENTTRACKINGPURCTR.[column in domain "KALSM_D"] == T007A.KALSM` `C_REQUIREMENTTRACKINGPURCTR.MANDT == T007A.MANDT` `C_REQUIREMENTTRACKINGPURCTR.TAXCODE == T007A.MWSKZ`