P_CntralPurOrderItm

Central Purchase Order item Monitor | view: PCNTRLPURORDITM | Extraction: Not supported | Component: Central Purchase Order
Tables used: MMPUR_EXT_EKKO, MMPUR_EXT_EKPO
Column Name Description
PurchaseOrder Purchasing Document Number
PurchaseOrderItem Item Number of Purchasing Document
ExtSourceSystem Connected System ID
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
NetPriceAmount Net Price
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
TargetQuantity Target Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsReturnsItem Returns Item Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
Column Name Description Domain name
PurchaseOrderItemText Short Text TEXT40
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
CreatedByUser User of person who created a purchasing document USNAM
ServicePerformer Service Performer BU_PARTNER
ProductType Product Type Group CHAR2
PurchaseRequisition Purchase Requisition Number BANFN
NumberOfPurchaseOrderItems Number of PO Items INT4
ReturnItems 2 Byte Signed Integer INT2
NetPriceQuantity Price Unit DEC5
IsGRIROpenItem null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_CNTRALPURORDERITM.MANDT == T163K.MANDT
  • P_CNTRALPURORDERITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Client
  • Company Code
  • P_CNTRALPURORDERITM.MANDT == T001.MANDT
  • P_CNTRALPURORDERITM.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_CNTRALPURORDERITM.MANDT == TCURC.MANDT
  • P_CNTRALPURORDERITM.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_CNTRALPURORDERITM.MANDT == MARA.MANDT
  • P_CNTRALPURORDERITM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_CNTRALPURORDERITM.MANDT == T023.MANDT
  • P_CNTRALPURORDERITM.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_CNTRALPURORDERITM.ORDERPRICEUNIT == T006.MSEHI
  • P_CNTRALPURORDERITM.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_CNTRALPURORDERITM.MANDT == T001W.MANDT
  • P_CNTRALPURORDERITM.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_CNTRALPURORDERITM.MANDT == T163.MANDT
  • P_CNTRALPURORDERITM.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_CNTRALPURORDERITM.MANDT == T006.MANDT
  • P_CNTRALPURORDERITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • P_CNTRALPURORDERITM.PURCHASEORDERTYPE == T161.BSART
  • P_CNTRALPURORDERITM.MANDT == T161.MANDT
  • P_CNTRALPURORDERITM.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_CNTRALPURORDERITM.PURCHASINGGROUP == T024.EKGRP
  • P_CNTRALPURORDERITM.MANDT == T024.MANDT
Purchasing Organization
  • Client
  • Purchasing Organization
  • P_CNTRALPURORDERITM.MANDT == T024E.MANDT
  • P_CNTRALPURORDERITM.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Plant
  • Storage Location
  • P_CNTRALPURORDERITM.MANDT == T001L.MANDT
  • P_CNTRALPURORDERITM.PLANT == T001L.WERKS
  • P_CNTRALPURORDERITM.STORAGELOCATION == T001L.LGORT
Supplier
  • Client
  • Supplier
  • P_CNTRALPURORDERITM.MANDT == LFA1.MANDT
  • P_CNTRALPURORDERITM.SUPPLIER == LFA1.LIFNR