C_MstrProjPurOrdItem

Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
ControllingObjectExternalID Master Project Structure Element
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
InvoicedAmount Invoiced Amount
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
PurchaseOrderAmount Master Project Delivered Amount
OpenAmountInDisplayCrcy Open Amount in Display Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
TotalQuantity Purchase Order Quantity
OpenQuantity Open Quantity
InvoicedQuantity null
Quantity Master Project Delivered Quantity
Column Name Description
DocumentDate Purchase Order Date
DeliveryDate Item delivery date
Column Name Description
Column Name Description Domain name
OrderItem Item Number of Purchase Order EBELP
PurchaseOrderItemText Short Text TEXT40
MasterProject Commercial Project ID /CPD/MP_ID
MasterProjectName Project Name /CPD/SHORT_TEXT
ControllingObjectDescription WBS Element Name TEXT40
ServicePerformer Service Performer BU_PARTNER
BusinessPartnerName Business Partner Name
MaterialName Material Description TEXT40
NetPriceQuantity Price Unit DEC5
PurchasingReleaseIndicatorDesc Description of release indicator TEXT30
SupplierName Name 1 NAME
MaterialGroupName Product Group Description TEXT20
PurchaseOrderStatus Purchase Order Status
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_MSTRPROJPURORDITEM.BASEUNIT == T006.MSEHI
  • C_MSTRPROJPURORDITEM.MANDT == T006.MANDT
Currency Key
  • Client
  • Currency Key
  • C_MSTRPROJPURORDITEM.MANDT == TCURC.MANDT
  • C_MSTRPROJPURORDITEM.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_MSTRPROJPURORDITEM.MANDT == MARA.MANDT
  • C_MSTRPROJPURORDITEM.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_MSTRPROJPURORDITEM.MATERIALGROUP == T023.MATKL
  • C_MSTRPROJPURORDITEM.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_MSTRPROJPURORDITEM.ORDERPRICEUNIT == T006.MSEHI
  • C_MSTRPROJPURORDITEM.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • C_MSTRPROJPURORDITEM.MANDT == T001W.MANDT
  • C_MSTRPROJPURORDITEM.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • C_MSTRPROJPURORDITEM.PURCHASINGGROUP == T024.EKGRP
  • C_MSTRPROJPURORDITEM.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_MSTRPROJPURORDITEM.MANDT == T024E.MANDT
  • C_MSTRPROJPURORDITEM.PURCHASINGORGANIZATION == T024E.EKORG
Release Indicator
  • Client
  • Release Indicator
  • C_MSTRPROJPURORDITEM.MANDT == T161S.MANDT
  • C_MSTRPROJPURORDITEM.RELEASECODE == T161S.FRGKZ
Supplier
  • Supplier
  • Client
  • C_MSTRPROJPURORDITEM.SUPPLIER == LFA1.LIFNR
  • C_MSTRPROJPURORDITEM.MANDT == LFA1.MANDT