P_OverduePO2

Overdue PO 2 | view: PMMOVERDUEPO2 | 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
PurchaseOrderQty Purchase Order Quantity
OpenPurchaseOrderQuantity null
GoodsReceiptQuantity null
Column Name Description
ScheduleLineDeliveryDate null
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_OVERDUEPO2.MANDT == T001.MANDT
  • P_OVERDUEPO2.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_OVERDUEPO2.MANDT == TCURC.MANDT
  • P_OVERDUEPO2.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_OVERDUEPO2.MANDT == MARA.MANDT
  • P_OVERDUEPO2.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_OVERDUEPO2.MANDT == T023.MANDT
  • P_OVERDUEPO2.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_OVERDUEPO2.MANDT == T001W.MANDT
  • P_OVERDUEPO2.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_OVERDUEPO2.MANDT == T163.MANDT
  • P_OVERDUEPO2.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_OVERDUEPO2.MANDT == T006.MANDT
  • P_OVERDUEPO2.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • Purchasing Document Category
  • Client
  • P_OVERDUEPO2.PURCHASEORDERTYPE == T161.BSART
  • P_OVERDUEPO2.PURCHASEORDERCATEGORY == T161.BSTYP
  • P_OVERDUEPO2.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_OVERDUEPO2.MANDT == T024.MANDT
  • P_OVERDUEPO2.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_OVERDUEPO2.MANDT == T024E.MANDT
  • P_OVERDUEPO2.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_OVERDUEPO2.MANDT == LFA1.MANDT
  • P_OVERDUEPO2.SUPPLIER == LFA1.LIFNR