I_QuantityContractPrediction

I_QuantityContractPrediction | view: IQTYCONPREDICT | TRAN | Extraction: Not supported | Component: Reporting
Tables used: /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, QTY_CON_PAI, EKKO, EKPO, T001W, LFA1
Column Name Description
PurchaseContract Purchasing Document Number
PurchaseContractItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
ContractNetPriceAmount Net Price in Purchasing Document (in Document Currency)
TargetAmount Target Value for Outline Agreement in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
CreationDate Creation Date of Purchasing Document
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
ContractExpiryPredictedDate Predicted Contract Expiry Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
PurchasingContractDeletionCode Deletion Indicator in Purchasing Document ELOEK
PredictedDaysToContrExpiry null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_QUANTITYCONTRACTPREDICTION.COMPANYCODE == T001.BUKRS
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_QUANTITYCONTRACTPREDICTION.DOCUMENTCURRENCY == TCURC.WAERS
  • I_QUANTITYCONTRACTPREDICTION.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • I_QUANTITYCONTRACTPREDICTION.MATERIAL == MARA.MATNR
  • I_QUANTITYCONTRACTPREDICTION.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_QUANTITYCONTRACTPREDICTION.MATERIALGROUP == T023.MATKL
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_QUANTITYCONTRACTPREDICTION.ORDERQUANTITYUNIT == T006.MSEHI
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T001W.MANDT
  • I_QUANTITYCONTRACTPREDICTION.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • I_QUANTITYCONTRACTPREDICTION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_QUANTITYCONTRACTPREDICTION.PURCHASECONTRACTTYPE == T161.BSART
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • I_QUANTITYCONTRACTPREDICTION.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_QUANTITYCONTRACTPREDICTION.PURCHASINGGROUP == T024.EKGRP
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_QUANTITYCONTRACTPREDICTION.PURCHASINGORGANIZATION == T024E.EKORG
  • I_QUANTITYCONTRACTPREDICTION.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • I_QUANTITYCONTRACTPREDICTION.SUPPLIER == LFA1.LIFNR
  • I_QUANTITYCONTRACTPREDICTION.MANDT == LFA1.MANDT