P_CntrlPurOrderItemMonitor

Monitor Central Purchase Order Item | view: PMMCPOIMONI | Extraction: Not supported | Component: Central Purchase Order

Tables used: MMPUR_EXT_EKKO, MMPUR_EXT_EKBE, MMPUR_EXT_EKPO, MMPUR_EXT_EKET

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (8)
📅 Dates (3)
☰ Categorical (1)
Other (13)
🔗 Relations (15)

Column Name	Description
PurchaseOrder	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchasing Document
ExtSourceSystem	Connected System ID

Column Name	Description
💲 null (DisplayCurrency):
InvoiceReceiptAmount	Invoice Value

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity
GoodsReceiptQty	null
StillToBeDeliveredQuantity	null
InvoiceReceiptQty	Data element for Invoice Receipt Qty
StillToInvoiceQuantity	null
ScheduleLineOrderQuantity	null
RoughGoodsReceiptQty	null
ScheduleLineOpenQty	Next Delivery Quantity

Column Name	Description
PurchaseOrderDate	Purchase Order Date
CreationDate	Creation Date of Purchasing Document
ScheduleLineDeliveryDate	Next Delivery Date

Column Name	Description
IsReturnsItem	Returns Item	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
NetPriceAmount	null
NetPriceQuantity	Price Unit	DEC5
NumberOfOpenItems	Number of Overdue Items
ScheduleLine	null
DeliveryStatus	Next Delivery Status
PlannedDeliveryDuration	null

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`P_CNTRLPURORDERITEMMONITOR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `P_CNTRLPURORDERITEMMONITOR.MANDT == T163K.MANDT`
Company Code Client Company Code	`P_CNTRLPURORDERITEMMONITOR.MANDT == T001.MANDT` `P_CNTRLPURORDERITEMMONITOR.COMPANYCODE == T001.BUKRS`
Currency Key Currency Key Client	`P_CNTRLPURORDERITEMMONITOR.DOCUMENTCURRENCY == TCURC.WAERS` `P_CNTRLPURORDERITEMMONITOR.MANDT == TCURC.MANDT`
Material Number Client Material Number	`P_CNTRLPURORDERITEMMONITOR.MANDT == MARA.MANDT` `P_CNTRLPURORDERITEMMONITOR.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`P_CNTRLPURORDERITEMMONITOR.MATERIALGROUP == T023.MATKL` `P_CNTRLPURORDERITEMMONITOR.MANDT == T023.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`P_CNTRLPURORDERITEMMONITOR.ORDERPRICEUNIT == T006.MSEHI` `P_CNTRLPURORDERITEMMONITOR.MANDT == T006.MANDT`
Plant Plant Client	`P_CNTRLPURORDERITEMMONITOR.PLANT == T001W.WERKS` `P_CNTRLPURORDERITEMMONITOR.MANDT == T001W.MANDT`
Item category in purchasing document Client Item category in purchasing document	`P_CNTRLPURORDERITEMMONITOR.MANDT == T163.MANDT` `P_CNTRLPURORDERITEMMONITOR.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`P_CNTRLPURORDERITEMMONITOR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI` `P_CNTRLPURORDERITEMMONITOR.MANDT == T006.MANDT`
Purchasing Document Type ? Purchasing Document Type Client	`P_CNTRLPURORDERITEMMONITOR.[column in domain "BSTYP"] == T161.BSTYP` `P_CNTRLPURORDERITEMMONITOR.PURCHASEORDERTYPE == T161.BSART` `P_CNTRLPURORDERITEMMONITOR.MANDT == T161.MANDT`
Purchasing Group Client Purchasing Group	`P_CNTRLPURORDERITEMMONITOR.MANDT == T024.MANDT` `P_CNTRLPURORDERITEMMONITOR.PURCHASINGGROUP == T024.EKGRP`
Purchasing Organization Client Purchasing Organization	`P_CNTRLPURORDERITEMMONITOR.MANDT == T024E.MANDT` `P_CNTRLPURORDERITEMMONITOR.PURCHASINGORGANIZATION == T024E.EKORG`
Storage Location Plant Client Storage Location	`P_CNTRLPURORDERITEMMONITOR.PLANT == T001L.WERKS` `P_CNTRLPURORDERITEMMONITOR.MANDT == T001L.MANDT` `P_CNTRLPURORDERITEMMONITOR.STORAGELOCATION == T001L.LGORT`
Supplier Client Supplier	`P_CNTRLPURORDERITEMMONITOR.MANDT == LFA1.MANDT` `P_CNTRLPURORDERITEMMONITOR.SUPPLIER == LFA1.LIFNR`