I_Mppurchaseorderitemhistory

Master Project Puchase Order history | view: IMPPOHIST | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Tables used: EKKOEKPORBKPRBKPBRBDRSEGRSEGEKBEEKBEHESSRESLLT163BESLHTVBST
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem null
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
💲 Currency Key (Currency):
InvoiceAmtInCoCodeCrcy null
PurOrdAmountInCompanyCodeCrcy null
Column Name Description
📏 Purchase Order Unit of Measure (DeliveryQuantityUnit):
Quantity null
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
PurchaseOrderStatus Invoice document status Show values
Column Name Description Domain name
MaterialDocumentYear Material Document Year GJAHR
OrderStatusText Status Description TEXT20
InvoiceReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == TCURC.MANDT
  • I_MPPURCHASEORDERITEMHISTORY.CURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T006.MANDT
  • I_MPPURCHASEORDERITEMHISTORY.DELIVERYQUANTITYUNIT == T006.MSEHI
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_MPPURCHASEORDERITEMHISTORY.GOODSMOVEMENTTYPE == T156.BWART
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T156.MANDT
Material Number
  • Client
  • Material Number
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == MARA.MANDT
  • I_MPPURCHASEORDERITEMHISTORY.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • I_MPPURCHASEORDERITEMHISTORY.PLANT == T001W.WERKS
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T001W.MANDT
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • I_MPPURCHASEORDERITEMHISTORY.PURCHASEORDERHISTCATEGORY == T163B.BEWTP
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T163B.MANDT
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • I_MPPURCHASEORDERITEMHISTORY.[column in domain "BSTYP"] == T161.BSTYP
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T161.MANDT
  • I_MPPURCHASEORDERITEMHISTORY.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T024.MANDT
  • I_MPPURCHASEORDERITEMHISTORY.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_MPPURCHASEORDERITEMHISTORY.MANDT == T024E.MANDT
  • I_MPPURCHASEORDERITEMHISTORY.PURCHASINGORGANIZATION == T024E.EKORG