I_MstrProjPurOrdItem

Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
InvoicedAmount null
PurchaseOrderAmount null
Column Name Description
📏 Base Unit of Measure (BaseUnit):
TotalQuantity Purchase Order Quantity
OpenQuantity null
InvoicedQuantity null
Quantity null
Column Name Description
DocumentDate Purchase Order Date
DeliveryDate Item delivery date
Column Name Description
IsCompletelyDelivered "Delivery Completed" Indicator Show values
Column Name Description Domain name
PurchaseOrderItemText Short Text TEXT40
PurchaseRequisition Purchase Requisition Number BANFN
MasterProject Commercial Project ID /CPD/MP_ID
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
WBSElementInternalID WBS Element PS_S4_PSPNR
ProjectNetwork Order Number AUFNR
ProjectNetworkDescription Description TEXT40
NetworkActivity Activity Number VORNR
NetworkActivityDescription Operation short text TEXT40
NetworkActivityInternalID null
ProjectNetworkInternalID null
ServicePerformer Service Performer BU_PARTNER
MaterialName Short Text TEXT40
NetPriceQuantity Price Unit DEC5
PurchaseOrderStatus null
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MSTRPROJPURORDITEM.MANDT == T006.MANDT
  • I_MSTRPROJPURORDITEM.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • I_MSTRPROJPURORDITEM.MANDT == TCURC.MANDT
  • I_MSTRPROJPURORDITEM.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_MSTRPROJPURORDITEM.MANDT == MARA.MANDT
  • I_MSTRPROJPURORDITEM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_MSTRPROJPURORDITEM.MANDT == T023.MANDT
  • I_MSTRPROJPURORDITEM.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_MSTRPROJPURORDITEM.MANDT == T006.MANDT
  • I_MSTRPROJPURORDITEM.ORDERPRICEUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_MSTRPROJPURORDITEM.MANDT == T001W.MANDT
  • I_MSTRPROJPURORDITEM.PLANT == T001W.WERKS
Purchase Order Type
  • Purchase Order Type
  • Client
  • ?
  • I_MSTRPROJPURORDITEM.PURCHASEORDERTYPE == T161.BSART
  • I_MSTRPROJPURORDITEM.MANDT == T161.MANDT
  • I_MSTRPROJPURORDITEM.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_MSTRPROJPURORDITEM.MANDT == T024.MANDT
  • I_MSTRPROJPURORDITEM.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_MSTRPROJPURORDITEM.MANDT == T024E.MANDT
  • I_MSTRPROJPURORDITEM.PURCHASINGORGANIZATION == T024E.EKORG
Release Indicator
  • Release Indicator
  • Client
  • I_MSTRPROJPURORDITEM.RELEASECODE == T161S.FRGKZ
  • I_MSTRPROJPURORDITEM.MANDT == T161S.MANDT
Supplier
  • Supplier
  • Client
  • I_MSTRPROJPURORDITEM.SUPPLIER == LFA1.LIFNR
  • I_MSTRPROJPURORDITEM.MANDT == LFA1.MANDT