P_POItemInvoicePrice

PO Item for Invoice Price | view: PPOITMINVPRC | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
IsReturnsItem Returns Item Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
ProductType Product Type Group CHAR2
NetPriceQuantity Price Unit DEC5
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_POITEMINVOICEPRICE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_POITEMINVOICEPRICE.MANDT == T163K.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_POITEMINVOICEPRICE.BASEUNIT == T006.MSEHI
  • P_POITEMINVOICEPRICE.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • P_POITEMINVOICEPRICE.COMPANYCODE == T001.BUKRS
  • P_POITEMINVOICEPRICE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_POITEMINVOICEPRICE.DOCUMENTCURRENCY == TCURC.WAERS
  • P_POITEMINVOICEPRICE.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_POITEMINVOICEPRICE.MATERIAL == MARA.MATNR
  • P_POITEMINVOICEPRICE.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_POITEMINVOICEPRICE.MANDT == T023.MANDT
  • P_POITEMINVOICEPRICE.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • P_POITEMINVOICEPRICE.MANDT == T006.MANDT
  • P_POITEMINVOICEPRICE.ORDERPRICEUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • P_POITEMINVOICEPRICE.PLANT == T001W.WERKS
  • P_POITEMINVOICEPRICE.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_POITEMINVOICEPRICE.MANDT == T006.MANDT
  • P_POITEMINVOICEPRICE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • ?
  • Purchase Order Type
  • Client
  • P_POITEMINVOICEPRICE.[column in domain "BSTYP"] == T161.BSTYP
  • P_POITEMINVOICEPRICE.PURCHASEORDERTYPE == T161.BSART
  • P_POITEMINVOICEPRICE.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_POITEMINVOICEPRICE.PURCHASINGGROUP == T024.EKGRP
  • P_POITEMINVOICEPRICE.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_POITEMINVOICEPRICE.MANDT == T024E.MANDT
  • P_POITEMINVOICEPRICE.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_POITEMINVOICEPRICE.SUPPLIER == LFA1.LIFNR
  • P_POITEMINVOICEPRICE.MANDT == LFA1.MANDT