I_PurContrItmCnsmpnPrediction

Purchase Contract Item Consumption Prediction | view: IPCCNSMPREDICT | TRAN | Extraction: Not supported | Component: Reporting
Tables used: EKKOEKPOQTY_CON_PAI
Column Name Description
PurchaseContract Purchasing Document Number
PurchaseContractItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Outline Agreement in Document Currency
Column Name Description
Column Name Description
ContractExpiryPredictedDate Predicted Contract Expiry Date
Column Name Description
Column Name Description Domain name
PurchaseContractItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
PredictedDaysToContrExpiry null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == T001.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == TCURC.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.DOCUMENTCURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == T023.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == T001W.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == T024.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == T024E.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.PURCHASINGORGANIZATION == T024E.EKORG
Vendor's account number
  • Client
  • Vendor's account number
  • I_PURCONTRITMCNSMPNPREDICTION.MANDT == LFA1.MANDT
  • I_PURCONTRITMCNSMPNPREDICTION.SUPPLIER == LFA1.LIFNR