I_CmmdtyPriceFixationOption

Column Name Description
SourceDocument Reference document number
SourceDocumentItem Source Document Item
ConditionType CPE: Condition Type for Commodity Pricing
PricingConditionTerm CPE Term - Number in Formula
Column Name Description
💲 CPE Term - Currency (ConditionTermRateCurrency):
ConditionTermRate CPE Term - Rate in Term Currency
Column Name Description
📏 CPE Term - UoM for Calculated Commodity Quantity (CalcdPrcgCndnTermQuantityUnit):
CalcdPrcgConditionTermQuantity CPE Term - Calculated Commodity Quantity
CndnTermFixationOptionLimitQty CPE Price Fixation Limit Quantity
📏 CPE Quantity UoM for Price Fixation (TrmFixationOptnNonFixedQtyUnit):
CndnTrmFixationOptnNonFixedQty CPE Quantity for Price Fixation
Column Name Description
DocumentDate Purchasing Document Date
Column Name Description
PrcgCndnTermFixationOptnStatus Status of Price Fixation Option Show values
Column Name Description Domain name
ConditionTermRateQuantity CPE Term - Price Unit CPE_PRUN
BusinessObjectType Object Type OJ_NAME
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
LastChangeDateTime Change Time Stamp TZNTSTMPL
CreatedByUser User of person who created a purchasing document USNAM
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
ConditionApplication Application KAPPL
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName null
CurrencyConversionIsAllowed null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_CMMDTYPRICEFIXATIONOPTION.COMPANYCODE == T001.BUKRS
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == T001.MANDT
Material Number
  • Material Number
  • Client
  • I_CMMDTYPRICEFIXATIONOPTION.MATERIAL == MARA.MATNR
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • I_CMMDTYPRICEFIXATIONOPTION.PLANT == T001W.WERKS
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == T001W.MANDT
CPE - Currency to Be Converted During Conversion ('from')
  • CPE - Currency to Be Converted During Conversion ('from')
  • Client
  • I_CMMDTYPRICEFIXATIONOPTION.PRCGCNDNTERMCNVRSNSOURCECRCY == TCURC.WAERS
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == TCURC.MANDT
CPE - Currency to Be Converted to During Conversion ('to')
  • Client
  • CPE - Currency to Be Converted to During Conversion ('to')
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == TCURC.MANDT
  • I_CMMDTYPRICEFIXATIONOPTION.PRCGCNDNTERMCNVRSNTARGETCRCY == TCURC.WAERS
Purchasing Group
  • Purchasing Group
  • Client
  • I_CMMDTYPRICEFIXATIONOPTION.PURCHASINGGROUP == T024.EKGRP
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_CMMDTYPRICEFIXATIONOPTION.PURCHASINGORGANIZATION == T024E.EKORG
  • I_CMMDTYPRICEFIXATIONOPTION.MANDT == T024E.MANDT