C_QuantityContractCnsmpn

Quantity Contract Consumption | view: CMMQTYCONTRCNSM | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
AccountAssignmentNumber Sequential Number of Account Assignment
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
Column Name Description
💲 Display Currency (DisplayCurrency):
TargetAmount Target Amount
RelOrdLvlContractTargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
PredictedConsumptionAmount Release Net Amount
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Quantity
ReleaseOrderItemOrderQuantity Release Order Quantity
Column Name Description
ValidityEndDate End of Validity Period
ContractExpiryPredictedDate Predicted Contract Expiry Date
Column Name Description
Column Name Description Domain name
PurchaseOrderItemUniqueID null
FormattedPurchaseContractItem Purchase Contract Item ID
SupplierName Name of Supplier TEXT80
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurgDocItemCategoryName Text for Item Category TEXT20
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
PlantName Plant Name TEXT30
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
CreatedByUser User of person who created a purchasing document USNAM
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
ContractConsumptionInPct null
ContrCnsmpnByReleaseOrderInPct null
PredictiveConsumptionInPct null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T001.MANDT
  • C_QUANTITYCONTRACTCNSMPN.COMPANYCODE == T001.BUKRS
Cost Center
  • Cost Center
  • ?
  • Client
  • ?
  • C_QUANTITYCONTRACTCNSMPN.COSTCENTER == CSKS.KOSTL
  • C_QUANTITYCONTRACTCNSMPN.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_QUANTITYCONTRACTCNSMPN.MANDT == CSKS.MANDT
  • C_QUANTITYCONTRACTCNSMPN.[column in domain "DATBI"] == CSKS.DATBI
Material Number
  • Client
  • Material Number
  • C_QUANTITYCONTRACTCNSMPN.MANDT == MARA.MANDT
  • C_QUANTITYCONTRACTCNSMPN.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T023.MANDT
  • C_QUANTITYCONTRACTCNSMPN.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_QUANTITYCONTRACTCNSMPN.ORDERQUANTITYUNIT == T006.MSEHI
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_QUANTITYCONTRACTCNSMPN.PLANT == T001W.WERKS
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • ?
  • C_QUANTITYCONTRACTCNSMPN.PURCHASECONTRACTTYPE == T161.BSART
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T161.MANDT
  • C_QUANTITYCONTRACTCNSMPN.[column in domain "BSTYP"] == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T163.MANDT
  • C_QUANTITYCONTRACTCNSMPN.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T024.MANDT
  • C_QUANTITYCONTRACTCNSMPN.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_QUANTITYCONTRACTCNSMPN.PURCHASINGORGANIZATION == T024E.EKORG
  • C_QUANTITYCONTRACTCNSMPN.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_QUANTITYCONTRACTCNSMPN.SUPPLIER == LFA1.LIFNR
  • C_QUANTITYCONTRACTCNSMPN.MANDT == LFA1.MANDT