P_PurOrdItemHistCrcyCnvrsn

Purchase Order Item History Currency Conversion | view: PMMPOIHISTCRCY | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKBZ, EKBZH, EKBE, EKBEH, ADCP, ADRC, T001, TKA02, T005, T163B, LFA1
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
PurchaseOrderNetAmount null
GoodsReceiptAmountInDspCrcy null
InvoiceAmtInDisplayCurrency null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SupplierCountry Country/Region Key LAND1
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PURORDITEMHISTCRCYCNVRSN.CURRENCY == TCURC.WAERS
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PURORDITEMHISTCRCYCNVRSN.CURRENCY == TCURC.WAERS
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.MATERIAL == MARA.MATNR
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.MATERIALGROUP == T023.MATKL
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == T001W.MANDT
  • P_PURORDITEMHISTCRCYCNVRSN.PLANT == T001W.WERKS
Purchase Order Type
  • ?
  • Purchase Order Type
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURORDITEMHISTCRCYCNVRSN.PURCHASEORDERTYPE == T161.BSART
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.PURCHASINGGROUP == T024.EKGRP
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURORDITEMHISTCRCYCNVRSN.SUPPLIER == LFA1.LIFNR
  • P_PURORDITEMHISTCRCYCNVRSN.MANDT == LFA1.MANDT