C_ValueContractCnsmpn

Value Contract Consumption | view: CMMVALCONTRCNSM | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseContract Purchasing Contract Header
Column Name Description
PurchaseContractTargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
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
ContractConsumptionRatio null
ContractConsumptionInPct null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_VALUECONTRACTCNSMPN.COMPANYCODE == T001.BUKRS
  • C_VALUECONTRACTCNSMPN.MANDT == T001.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • ?
  • C_VALUECONTRACTCNSMPN.PURCHASECONTRACTTYPE == T161.BSART
  • C_VALUECONTRACTCNSMPN.MANDT == T161.MANDT
  • C_VALUECONTRACTCNSMPN.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • C_VALUECONTRACTCNSMPN.PURCHASINGGROUP == T024.EKGRP
  • C_VALUECONTRACTCNSMPN.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_VALUECONTRACTCNSMPN.PURCHASINGORGANIZATION == T024E.EKORG
  • C_VALUECONTRACTCNSMPN.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • C_VALUECONTRACTCNSMPN.MANDT == LFA1.MANDT
  • C_VALUECONTRACTCNSMPN.SUPPLIER == LFA1.LIFNR