P_PURCHASEORDERITEMPAI_05

P_PurchaseOrderItemPAI_04 | view: PPOITEMPAI5 | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrderItemConcat null
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
PurchaseContractItem FK Item number of principal purchase agreement
PurchaseContract FK Number of principal purchase agreement
Column Name Description
Column Name Description
RUNNING_TOTAL Consumed quantity for a contract
RUNNING_PERCENTAGE Contract consumption in percentage
ConsumedQty Contract consumption in percentage
AVG_PO_AMT Average PO amount
Column Name Description
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
CONT_LEN Days for which contaract is valid for
CONT_DAYS_LEFT Days left for contract to expiry
PODATE_MONTH Calendar Month NUM2
PODATE_WEEKDAY Week Day NUM1
PODATE_WEEK Calendar Week NUM2
PO_ITEMS_NUM Number for PO items
DAYS_INTERVAL Days interval between two PO
AVG_PO_DAYS Average Purchase order days
DAYS2GO_QUANT Days left for contract to expiry
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCHASEORDERITEMPAI_05.COMPANYCODE == T001.BUKRS
  • P_PURCHASEORDERITEMPAI_05.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_PURCHASEORDERITEMPAI_05.MANDT == TCURC.MANDT
  • P_PURCHASEORDERITEMPAI_05.DOCUMENTCURRENCY == TCURC.WAERS
Plant
  • Plant
  • Client
  • P_PURCHASEORDERITEMPAI_05.PLANT == T001W.WERKS
  • P_PURCHASEORDERITEMPAI_05.MANDT == T001W.MANDT