P_PriceFixReviewdata

Pricing Fixation Data Review | view: PPRCFIXREDAT | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: CPED_TERMINPUT, /ACCGO/T_CAKITM, WBHK, /ACCGO/T_PR_ASP, CPED_FORMDOC, CPED_KNUMVTOGUID, WBHI, WBHD, CPED_TERMGRPOUT, CPED_TERMINPUT, WBHD, CPED_TERMCONVIN, /ACCGO/T_CONDTYP, TBAC_DCST, TBAC_MICT, T685T, /ACCGO/T_CPE_BRI, /ACCGO/T_CONDMAP, TBAC_DCS_LOF
Column Name Description
Column Name Description
💲 Condition Unit (Currency or Percentage) (ACMPrcgCndnCumltvBasisCrcy):
ACMPrcgCndnCumltvBasisPrice Condition amount or percentage where no scale exists
Column Name Description
termcommquan CPE Term - Total Commodity Quantity for Calculating Term
Column Name Description
KEYDATE Maturity Key Date
Column Name Description
Column Name Description Domain name
SourceLotId Source Lot ID /ACCGO/D_PRICINGLOT_ID
termno CPE Term - Number in Formula NUMC5
TradingContractNumber Trading Contract TKONN
TradingContractItem Item Number of Trading Contract TPOSN
FutureFx CPE Term - Fixed Exchange Rate for Currency Conversion CPE_CONVFACTOR
futureprice CPE Term - Fixed Rate (up to 14 decimals) CPE_INTERNAL_VALUE
total_price_doc_curr Total Amount /ACCGO/CPE_D_TOTAL_PRICE
DerivativeContrSpecsTxt Description of Derivative Contract Specification TEXT40
MarketIdentifierCodeTxt Market Identifier Code Description TEXT40
PrcgConditionTermFixedRateQty CPE - Price Unit of Fixed Rate CPE_PRUN
PSMGUID PSM GUID SYSUUID_22
CommodityProductSymbol Derivative Contract Specification: Product Symbol TBA_DCS_SYMBL
CmmdtyMaturityMonthYear null
DerivativeContractMaturityCode null
BasisFx CPE Term - Fixed Exchange Rate for Currency Conversion CPE_CONVFACTOR
basisprice CPE Term - Fixed Rate (up to 14 decimals) CPE_INTERNAL_VALUE
PriceUnitBasisFixedRate CPE - Price Unit of Fixed Rate CPE_PRUN
NonHedgeableBasisFx CPE Term - Fixed Exchange Rate for Currency Conversion CPE_CONVFACTOR
NonHedgeablePrice CPE Term - Fixed Rate (up to 14 decimals) CPE_INTERNAL_VALUE
NonHedgeablePriceUnit CPE - Price Unit of Fixed Rate CPE_PRUN
TotalPriceNF Total Amount /ACCGO/CPE_D_TOTAL_PRICE
ACMNmbrOfSecondaryBasis null
ACMPrcgCndnCumltvBasisUnit Condition Pricing Unit KPEIN
PricingApproach Pricing Approach /ACCGO/CPE_D_PRICING_APPROACH
Master Data Relations Join Conditions
Check Material
  • Material Number
  • Client
  • P_PRICEFIXREVIEWDATA.CONTRACTMATERIAL == MARA.MATNR
  • P_PRICEFIXREVIEWDATA.MANDT == MARA.MANDT
Foreign key for UoM of fix term rate
  • Client
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • P_PRICEFIXREVIEWDATA.MANDT == T006.MANDT
  • P_PRICEFIXREVIEWDATA.NONHEDGEABLEUNITOFMEASURE == T006.MSEHI
  • P_PRICEFIXREVIEWDATA.FIXEDRATEBASISUNITOFMEASURE == T006.MSEHI
  • P_PRICEFIXREVIEWDATA.FIXEDRATEFUTUREUNITOFMEASURE == T006.MSEHI
Foreign key for UoM of fix term rate
  • Client
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • P_PRICEFIXREVIEWDATA.MANDT == T006.MANDT
  • P_PRICEFIXREVIEWDATA.NONHEDGEABLEUNITOFMEASURE == T006.MSEHI
  • P_PRICEFIXREVIEWDATA.FIXEDRATEBASISUNITOFMEASURE == T006.MSEHI
  • P_PRICEFIXREVIEWDATA.FIXEDRATEFUTUREUNITOFMEASURE == T006.MSEHI
Foreign key for currency of fix term rate
  • Client
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • P_PRICEFIXREVIEWDATA.MANDT == TCURC.MANDT
  • P_PRICEFIXREVIEWDATA.NONHEDGEABLETERMCURRENCY == TCURC.WAERS
  • P_PRICEFIXREVIEWDATA.PRCGCNDNFUTURETERMCURRENY == TCURC.WAERS
  • P_PRICEFIXREVIEWDATA.PRCGCNDNBASISTERMCURRENCY == TCURC.WAERS
Foreign key for UoM of fix term rate
  • Client
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • P_PRICEFIXREVIEWDATA.MANDT == T006.MANDT
  • P_PRICEFIXREVIEWDATA.NONHEDGEABLEUNITOFMEASURE == T006.MSEHI
  • P_PRICEFIXREVIEWDATA.FIXEDRATEBASISUNITOFMEASURE == T006.MSEHI
  • P_PRICEFIXREVIEWDATA.FIXEDRATEFUTUREUNITOFMEASURE == T006.MSEHI
Foreign key for currency of fix term rate
  • Client
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • P_PRICEFIXREVIEWDATA.MANDT == TCURC.MANDT
  • P_PRICEFIXREVIEWDATA.NONHEDGEABLETERMCURRENCY == TCURC.WAERS
  • P_PRICEFIXREVIEWDATA.PRCGCNDNFUTURETERMCURRENY == TCURC.WAERS
  • P_PRICEFIXREVIEWDATA.PRCGCNDNBASISTERMCURRENCY == TCURC.WAERS
Foreign key for currency of fix term rate
  • Client
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • P_PRICEFIXREVIEWDATA.MANDT == TCURC.MANDT
  • P_PRICEFIXREVIEWDATA.NONHEDGEABLETERMCURRENCY == TCURC.WAERS
  • P_PRICEFIXREVIEWDATA.PRCGCNDNFUTURETERMCURRENY == TCURC.WAERS
  • P_PRICEFIXREVIEWDATA.PRCGCNDNBASISTERMCURRENCY == TCURC.WAERS