P_CmmdtyPrcFixationOptionSales

Column Name Description
SalesDocument Sales Document
SalesDocumentItem Sales 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
📏 CPE Price Fixation Limit Quantity UoM (limit_quantity_uom):
limit_quantity CPE Price Fixation Limit Quantity
📏 CPE Price Fixation Limit Quantity UoM (limit_quantity_uom_out):
limit_quantity_out CPE Price Fixation Limit Quantity
📏 CPE Quantity UoM for Price Fixation (TrmFixationOptnNonFixedQtyUnit):
CndnTrmFixationOptnNonFixedQty CPE Quantity for Price Fixation
Column Name Description
DocumentDate Date on which the record was created
Column Name Description
PrcgCndnTermFixationOptnStatus Status of Price Fixation Option Show values
SDDocumentCategory SD Document Category Show values
quotkey_terminput Quotation Key Type in Document UI (all values) Show values
quotkey_quotrule Quotation Key Type in Document UI (all values) Show values
Column Name Description Domain name
ConditionTermRateQuantity CPE Term - Price Unit CPE_PRUN
Plant Plant (Own or External) WERKS
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName null
termconvout_guid CPE Term - GUID for Conversion Result SYSUUID
Master Data Relations Join Conditions
Sold-to Party
  • Sold-to Party
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONSALES.CUSTOMER == KNA1.KUNNR
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == KNA1.MANDT
Derivative Contract Specification ID P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == TBAC_DCS.CLIENT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == TVKOV.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.SALESORGANIZATION == TVKOV.VKORG
  • P_CMMDTYPRCFIXATIONOPTIONSALES.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == TVTA.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.DIVISION == TVTA.SPART
  • P_CMMDTYPRCFIXATIONOPTIONSALES.SALESORGANIZATION == TVTA.VKORG
  • P_CMMDTYPRCFIXATIONOPTIONSALES.DISTRIBUTIONCHANNEL == TVTA.VTWEG
CPE Price Fixation Limit Quantity UoM
  • Client
  • CPE Price Fixation Limit Quantity UoM
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == T006.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.LIMIT_QUANTITY_UOM == T006.MSEHI
CPE Price Fixation Limit Routine
  • Client
  • CPE Price Fixation Limit Routine
  • ?
  • ?
  • ?
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == CPEC_ROUTINE.CLIENT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.LIMIT_ROUTINE == CPEC_ROUTINE.CPE_ROUTINE
  • P_CMMDTYPRCFIXATIONOPTIONSALES.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
  • P_CMMDTYPRCFIXATIONOPTIONSALES.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • P_CMMDTYPRCFIXATIONOPTIONSALES.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
Material: order item
  • Material Number
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MATERIAL == MARA.MATNR
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == MARA.MANDT
CPE - Currency to Be Converted During Conversion ('from')
  • Client
  • CPE - Currency to Be Converted During Conversion ('from')
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == TCURC.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.PRCGCNDNTERMCNVRSNSOURCECRCY == TCURC.WAERS
CPE - Currency to Be Converted to During Conversion ('to')
  • Client
  • CPE - Currency to Be Converted to During Conversion ('to')
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == TCURC.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.PRCGCNDNTERMCNVRSNTARGETCRCY == TCURC.WAERS
Sales organization in order header
  • Client
  • Sales Organization
  • P_CMMDTYPRCFIXATIONOPTIONSALES.MANDT == TVKO.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONSALES.SALESORGANIZATION == TVKO.VKORG