I_MPProcurement

Column Name Description
MasterProject Commercial Project ID
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
Column Name Description
💲 Currency Key (DocumentCurrency):
InvoicedAmount null
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
PurchaseOrderAmount Master Project Delivered Amount
OpenAmountInDisplayCrcy null
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
TotalQuantity Purchase Order Quantity
OpenQuantity null
InvoicedQuantity null
OrderedQuantity Quantity ordered against this purchase requisition
RequestedQuantity Purchase requisition quantity
Quantity Master Project Delivered Quantity
Column Name Description
DocumentDate Purchase Order Date
DeliveryDate Item delivery date
Column Name Description
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
ControllingObjectExternalID null
ControllingObjectDescription WBS Element Name TEXT40
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
NetworkActivity Activity Number VORNR
NetworkActivityDescription Operation short text TEXT40
ProjectNetwork Order Number AUFNR
ProjectNetworkDescription Description TEXT40
NetPriceQuantity Price Unit DEC5
ProcessingStatus null
PurReqnNetAmount null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MPPROCUREMENT.BASEUNIT == T006.MSEHI
  • I_MPPROCUREMENT.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • I_MPPROCUREMENT.DOCUMENTCURRENCY == TCURC.WAERS
  • I_MPPROCUREMENT.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • I_MPPROCUREMENT.MANDT == MARA.MANDT
  • I_MPPROCUREMENT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_MPPROCUREMENT.MANDT == T023.MANDT
  • I_MPPROCUREMENT.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • I_MPPROCUREMENT.ORDERPRICEUNIT == T006.MSEHI
  • I_MPPROCUREMENT.MANDT == T006.MANDT
Release Indicator
  • Release Indicator
  • Client
  • I_MPPROCUREMENT.RELEASECODE == T161S.FRGKZ
  • I_MPPROCUREMENT.MANDT == T161S.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • I_MPPROCUREMENT.SUPPLIER == LFA1.LIFNR
  • I_MPPROCUREMENT.MANDT == LFA1.MANDT