P_CmmdtyPrcFixationOptionPurg

Column Name Description
PurchasingDocument Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
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 Purchasing Document Date
Column Name Description
PrcgCndnTermFixationOptnStatus Status of Price Fixation Option Show values
PurchasingDocumentCategory Purchasing 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
LastChangeDateTime Change Time Stamp TZNTSTMPL
CreatedByUser User of person who created a purchasing document USNAM
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName null
termconvout_guid CPE Term - GUID for Conversion Result SYSUUID
Master Data Relations Join Conditions
Vendor's account number
  • Vendor's account number
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONPURG.ACTIVESUPPLIER == LFA1.LIFNR
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == LFA1.MANDT
Company Code
  • Company Code
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONPURG.COMPANYCODE == T001.BUKRS
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == T001.MANDT
Derivative Contract Specification ID P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == TBAC_DCS.CLIENT
CPE Price Fixation Limit Quantity UoM
  • Client
  • CPE Price Fixation Limit Quantity UoM
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == T006.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONPURG.LIMIT_QUANTITY_UOM == T006.MSEHI
CPE Price Fixation Limit Routine
  • ?
  • ?
  • ?
  • CPE Price Fixation Limit Routine
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONPURG.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
  • P_CMMDTYPRCFIXATIONOPTIONPURG.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • P_CMMDTYPRCFIXATIONOPTIONPURG.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • P_CMMDTYPRCFIXATIONOPTIONPURG.LIMIT_ROUTINE == CPEC_ROUTINE.CPE_ROUTINE
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == CPEC_ROUTINE.CLIENT
Material Number
  • Client
  • Material Number
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == MARA.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == T001W.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONPURG.PLANT == T001W.WERKS
CPE - Currency to Be Converted During Conversion ('from')
  • CPE - Currency to Be Converted During Conversion ('from')
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONPURG.PRCGCNDNTERMCNVRSNSOURCECRCY == TCURC.WAERS
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == TCURC.MANDT
CPE - Currency to Be Converted to During Conversion ('to')
  • Client
  • CPE - Currency to Be Converted to During Conversion ('to')
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == TCURC.MANDT
  • P_CMMDTYPRCFIXATIONOPTIONPURG.PRCGCNDNTERMCNVRSNTARGETCRCY == TCURC.WAERS
Purchasing Group
  • Purchasing Group
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONPURG.PURCHASINGGROUP == T024.EKGRP
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_CMMDTYPRCFIXATIONOPTIONPURG.PURCHASINGORGANIZATION == T024E.EKORG
  • P_CMMDTYPRCFIXATIONOPTIONPURG.MANDT == T024E.MANDT