P_PurContractItemConsumption

Purchase Contract Item Consumption | view: PMMCONTRCNSMPN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseContract FK Number of principal purchase agreement
PurchaseContractItem FK Item number of principal purchase agreement
ReleaseOrder FK Purchasing Document Number
ReleaseOrderItem FK Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseContractTargetAmount Target Value for Header Area per Distribution
💲 null (DisplayCurrency):
ReleaseOrderItemNetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
ReleaseOrderItemOrderQuantity null
Column Name Description
ReleaseOrderDate Release Order Date
Column Name Description
PurchaseContractClassification Contract Type Show values
Column Name Description Domain name
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
CalendarYear Calendar Year NUM4
NumberOfReleasedOrders Number of Release Order Items INT4
Master Data Relations Join Conditions
Company Code (Due to Currency)
  • Company Code
  • Client
  • P_PURCONTRACTITEMCONSUMPTION.COMPANYCODE == T001.BUKRS
  • P_PURCONTRACTITEMCONSUMPTION.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_PURCONTRACTITEMCONSUMPTION.MANDT == TCURC.MANDT
  • P_PURCONTRACTITEMCONSUMPTION.DOCUMENTCURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURCONTRACTITEMCONSUMPTION.MANDT == T006.MANDT
  • P_PURCONTRACTITEMCONSUMPTION.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_PURCONTRACTITEMCONSUMPTION.MANDT == T001W.MANDT
  • P_PURCONTRACTITEMCONSUMPTION.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCONTRACTITEMCONSUMPTION.PURCHASINGGROUP == T024.EKGRP
  • P_PURCONTRACTITEMCONSUMPTION.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCONTRACTITEMCONSUMPTION.MANDT == T024E.MANDT
  • P_PURCONTRACTITEMCONSUMPTION.PURCHASINGORGANIZATION == T024E.EKORG