C_RequirementTrackingPurOrd

Purchase Orders by Requirement Tracking | view: CREQTRACKPO | TRAN | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Purchase Order Value
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
GoodsReceiptAmountInDspCrcy Data element for goods receipt
StillToBeDeliveredValue Value to be Delivered
InvoicedAmountInDspCurrency Invoice Value
StillToInvoiceValue Value to be Invoiced
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Order Quantity
OpenPurchaseOrderQuantity Next Scheduled Delivery Quantity
GoodsReceiptQty Data element for goods receipt quantity
StillToBeDeliveredQuantity Quantity to be Delivered
InvoiceReceiptQty Data element for Invoice Receipt Qty
StillToInvoiceQuantity Quantity to be Invoiced
Column Name Description
PurchaseOrderDate Purchase Order Date
ScheduleLineDeliveryDate Schedule line delivery date
CreationDate Creation Date of Purchasing Document
Column Name Description
Column Name Description Domain name
FormattedPurchaseOrderItem null
RequirementTracking Requirement Tracking Number
PurchasingText Short Text TEXT40
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category
PurchasingDocumentType Purchasing Document Type
PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentTypeName Short Description of Purchasing Document Type
PurgDocExternalItemCategory Item Category in Purchasing Document
PurgDocItemCategoryName Text for Item Category
CreatedByUser User of person who created a purchasing document USNAM
UserDescription User Description
DueDateCriticality null
PurchasingIsBlockedForSupplier Supplier Blocked status
NetPriceQuantity Net Price Quantity
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_REQUIREMENTTRACKINGPURORD.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • C_REQUIREMENTTRACKINGPURORD.COMPANYCODE == T001.BUKRS
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_REQUIREMENTTRACKINGPURORD.DOCUMENTCURRENCY == TCURC.WAERS
  • C_REQUIREMENTTRACKINGPURORD.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • C_REQUIREMENTTRACKINGPURORD.MATERIAL == MARA.MATNR
  • C_REQUIREMENTTRACKINGPURORD.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_REQUIREMENTTRACKINGPURORD.MATERIALGROUP == T023.MATKL
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_REQUIREMENTTRACKINGPURORD.ORDERPRICEUNIT == T006.MSEHI
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_REQUIREMENTTRACKINGPURORD.PLANT == T001W.WERKS
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T001W.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T163.MANDT
  • C_REQUIREMENTTRACKINGPURORD.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_REQUIREMENTTRACKINGPURORD.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_REQUIREMENTTRACKINGPURORD.PURCHASINGGROUP == T024.EKGRP
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_REQUIREMENTTRACKINGPURORD.PURCHASINGORGANIZATION == T024E.EKORG
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T024E.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • C_REQUIREMENTTRACKINGPURORD.PLANT == T001L.WERKS
  • C_REQUIREMENTTRACKINGPURORD.STORAGELOCATION == T001L.LGORT
  • C_REQUIREMENTTRACKINGPURORD.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • C_REQUIREMENTTRACKINGPURORD.SUPPLIER == LFA1.LIFNR
  • C_REQUIREMENTTRACKINGPURORD.MANDT == LFA1.MANDT