C_TrdgContrPrcFixationDetails

Consumption Query for Trading Contract Price Fixation Det | view: CTCPRCFIXDET | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Column Name Description
TrdgContrPrcgAspectSrceLotID Source Lot ID
Column Name Description
💲 Condition Unit (Currency or Percentage) (ACMPrcgCndnCumltvBasisCrcy):
ACMPrcgCndnCumltvBasisPrice Condition amount or percentage where no scale exists
Column Name Description
Column Name Description
MaturityKeyDate Maturity Key Date
Column Name Description
Column Name Description Domain name
PricingConditionTerm CPE Term - Number in Formula
ACMPrcgCndnFuturePrice CPE Term - Fixed Rate (up to 14 decimals)
ACMPrcgCndnBasisPrc CPE Term - Fixed Rate (up to 14 decimals)
ACMPrcgCndnFlatPrice Total Amount
ACMPrcgCndnTotalNonHedgePrice Total Amount
ACMPrcgCndnFutureRate CPE Term - Fixed Exchange Rate for Currency Conversion
ACMPrcgCndnBasisRate CPE Term - Fixed Exchange Rate for Currency Conversion
ACMDerivativeContrSpecsTxt Description of Derivative Contract Specification TEXT40
ACMMarketIdentifierCodeTxt Market Identifier Code Description TEXT40
DerivativeContractMaturityCode null
ACMPrcgCndnNonHedgeFlatPrice CPE Term - Fixed Rate (up to 14 decimals)
ACMPrcgCndnBasisFixedRate CPE - Price Unit of Fixed Rate CPE_PRUN
ACMPrcgCndnFutureFixedRateQty CPE - Price Unit of Fixed Rate CPE_PRUN
ACMPrcgCndnNonHedgePriceUnit CPE - Price Unit of Fixed Rate CPE_PRUN
ACMNmbrOfSecondaryBasis null
ACMPrcgCndnNonHedgeBsFXValue CPE Term - Fixed Exchange Rate for Currency Conversion
Master Data Relations Join Conditions
Foreign key for UoM of fix term rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • Client
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFIXEDRATEBASISUOM == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNNONHEDGEQTYUNIT == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFIXEDRATEFUTUREUOM == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.MANDT == T006.MANDT
Foreign key for UoM of fix term rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • Client
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFIXEDRATEBASISUOM == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNNONHEDGEQTYUNIT == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFIXEDRATEFUTUREUOM == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.MANDT == T006.MANDT
Foreign key for currency of fix term rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • Client
  • C_TRDGCONTRPRCFIXATIONDETAILS.PRCGCONDITIONTERMFIXEDRATECRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFUTURETERMCRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNNONHEDGETERMCRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.MANDT == TCURC.MANDT
Foreign key for UoM of fix term rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • CPE - Unit of Measure of Fixed Rate
  • Client
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFIXEDRATEBASISUOM == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNNONHEDGEQTYUNIT == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFIXEDRATEFUTUREUOM == T006.MSEHI
  • C_TRDGCONTRPRCFIXATIONDETAILS.MANDT == T006.MANDT
Foreign key for currency of fix term rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • Client
  • C_TRDGCONTRPRCFIXATIONDETAILS.PRCGCONDITIONTERMFIXEDRATECRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFUTURETERMCRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNNONHEDGETERMCRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.MANDT == TCURC.MANDT
Foreign key for currency of fix term rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • Client
  • C_TRDGCONTRPRCFIXATIONDETAILS.PRCGCONDITIONTERMFIXEDRATECRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNFUTURETERMCRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.ACMPRCGCNDNNONHEDGETERMCRCY == TCURC.WAERS
  • C_TRDGCONTRPRCFIXATIONDETAILS.MANDT == TCURC.MANDT