P_OverduePO3

Overdue PO with Return Items | view: POVRDUEPO3 | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKET, MMPUR_ANA_CONF
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
Column Name Description
OpenPurchaseOrderNetAmount null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
OpenPurchaseOrderQuantity null
GoodsReceiptQuantity Quantity of goods received
Column Name Description
ScheduleLineDeliveryDate Item delivery date
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
PurchaseOrderItemText Short Text TEXT40
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_OVERDUEPO3.MANDT == T001.MANDT
  • P_OVERDUEPO3.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_OVERDUEPO3.MANDT == TCURC.MANDT
  • P_OVERDUEPO3.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • P_OVERDUEPO3.MATERIAL == MARA.MATNR
  • P_OVERDUEPO3.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_OVERDUEPO3.MANDT == T023.MANDT
  • P_OVERDUEPO3.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_OVERDUEPO3.MANDT == T001W.MANDT
  • P_OVERDUEPO3.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_OVERDUEPO3.MANDT == T163.MANDT
  • P_OVERDUEPO3.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_OVERDUEPO3.MANDT == T006.MANDT
  • P_OVERDUEPO3.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchasing Document Category
  • Client
  • Purchase Order Type
  • P_OVERDUEPO3.PURCHASEORDERCATEGORY == T161.BSTYP
  • P_OVERDUEPO3.MANDT == T161.MANDT
  • P_OVERDUEPO3.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • P_OVERDUEPO3.MANDT == T024.MANDT
  • P_OVERDUEPO3.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_OVERDUEPO3.MANDT == T024E.MANDT
  • P_OVERDUEPO3.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_OVERDUEPO3.SUPPLIER == LFA1.LIFNR
  • P_OVERDUEPO3.MANDT == LFA1.MANDT