P_PurchaseOrderQuantity

Purchase Order Quantity | view: PMMPURORDQTY | 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 (Currency):
NetAmount Net Order Value in PO Currency
NetPriceAmount null
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
SuplrEvalCritraDelivCompleted Delivery Completed Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
Column Name Description Domain name
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
NetPriceQuantity Price Unit DEC5
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURCHASEORDERQUANTITY.MANDT == T001.MANDT
  • P_PURCHASEORDERQUANTITY.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PURCHASEORDERQUANTITY.MANDT == TCURC.MANDT
  • P_PURCHASEORDERQUANTITY.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PURCHASEORDERQUANTITY.MANDT == MARA.MANDT
  • P_PURCHASEORDERQUANTITY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURCHASEORDERQUANTITY.MANDT == T023.MANDT
  • P_PURCHASEORDERQUANTITY.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • P_PURCHASEORDERQUANTITY.PLANT == T001W.WERKS
  • P_PURCHASEORDERQUANTITY.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURCHASEORDERQUANTITY.MANDT == T006.MANDT
  • P_PURCHASEORDERQUANTITY.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • Client
  • ?
  • P_PURCHASEORDERQUANTITY.PURCHASEORDERTYPE == T161.BSART
  • P_PURCHASEORDERQUANTITY.MANDT == T161.MANDT
  • P_PURCHASEORDERQUANTITY.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEORDERQUANTITY.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEORDERQUANTITY.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCHASEORDERQUANTITY.MANDT == T024E.MANDT
  • P_PURCHASEORDERQUANTITY.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_PURCHASEORDERQUANTITY.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEORDERQUANTITY.MANDT == LFA1.MANDT