P_PurchaseOrderItemDateRange

Purchage Order Item for Date Range | view: PMMPOITMDR | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
PurchaseOrderItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
CreatedByUser User of person who created a purchasing document USNAM
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURCHASEORDERITEMDATERANGE.MANDT == T001.MANDT
  • P_PURCHASEORDERITEMDATERANGE.COMPANYCODE == T001.BUKRS
Customer
  • Client
  • Customer
  • P_PURCHASEORDERITEMDATERANGE.MANDT == KNA1.MANDT
  • P_PURCHASEORDERITEMDATERANGE.CUSTOMER == KNA1.KUNNR
Material Number
  • Client
  • Material Number
  • P_PURCHASEORDERITEMDATERANGE.MANDT == MARA.MANDT
  • P_PURCHASEORDERITEMDATERANGE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURCHASEORDERITEMDATERANGE.MANDT == T023.MANDT
  • P_PURCHASEORDERITEMDATERANGE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURCHASEORDERITEMDATERANGE.MANDT == T001W.MANDT
  • P_PURCHASEORDERITEMDATERANGE.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCHASEORDERITEMDATERANGE.MANDT == T024.MANDT
  • P_PURCHASEORDERITEMDATERANGE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEORDERITEMDATERANGE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEORDERITEMDATERANGE.MANDT == T024E.MANDT
Storage Location
  • Client
  • Plant
  • Storage Location
  • P_PURCHASEORDERITEMDATERANGE.MANDT == T001L.MANDT
  • P_PURCHASEORDERITEMDATERANGE.PLANT == T001L.WERKS
  • P_PURCHASEORDERITEMDATERANGE.STORAGELOCATION == T001L.LGORT
Supplier
  • Client
  • Supplier
  • P_PURCHASEORDERITEMDATERANGE.MANDT == LFA1.MANDT
  • P_PURCHASEORDERITEMDATERANGE.SUPPLIER == LFA1.LIFNR