/dmbe/c_PricingItem_Display

Pricing Item Display Consumption View | view: /DMBE/IPRCITMDSP | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: /DMBE/TM_DETACT, /DMBE/TM_DEALHDR, /DMBE/TM_LOCACT, /DMBE/TM_PRDACT, /DMBE/TM_ACCOUNT, /DMBE/TM_ACCO_TX, TBACC_BAS_ID, TBACC_BAS_ID_T, TBACC_BAS_TYPE, TBACC_BAS_TYPE_T, BUT000, T685A, T683S, CPEC_ROUTINE, CPEC_CONVERSION, TBAC_PHYSCOMMT, TBAC_DCST, /DMBE/TM_EVENTS, CPEC_QUOTRULE, /DMBE/TM_QUOTR_T, CPEC_QUOTRULE_T, TBAC_DCS_KD, TBAC_DCS_KDT, TBAC_MICT, CPEC_PERIODDET_T, /DMBE/TM_PERIOD, TW56T, /DMBE/TM_QUOTRUL, CPEC_QUOTRULE, CPEC_QUOTRULE_T, CPEC_ROUTINE_T, CPEC_REFDATERT_T, CPEC_REFDATEROUT, TCURT, /DMBE/TM_DC_CONF, TCURW, TCURX, /DMBE/TM_PRCHACT, /DMBE/TM_PRCDACT, /DMBE/TM_PRDTP, /DMBE/TM_PRDTP_T, /DMBE/TM_STATUS, T006, T006A, ADRP, USR21, T685, T006, T006A, /DMBE/TM_COMB, TBAC_DCS_LOF, TBAC_DCS_CTY, /DMBE/TP_PRC_CAT, /DMBE/TP_PRC_PRO, /DMBE/TM_CURCPRC
Column Name Description
pricingItemUuid UUID in X form (binary)
Column Name Description
💲 Premium/Discount Currency (surchargeCurrency):
surchargeRate Premium/Discount
fxSurchargeRate Premium/Discount
💲 Amount Currency (amountCurrency):
amount Monetary Value Amount
fxAmount Monetary Value Amount
💲 CPE - Currency for Fixed Term (fixedTermCurrency):
fixedTermRate CPE Term - Fixed Rate
fxFixedTermRate CPE Term - Fixed Rate
Column Name Description
📏 Quantity From Unit of Measure (quantityFromUom):
quantityFrom Quantity From
fxQuantityFrom Quantity From
conversionQuantityFrom Quantity From
📏 Quantity To Unit of Measure (quantityToUom):
quantityTo Quantity To
fxQuantityTo Quantity To
conversionQuantityTo Quantity To
Column Name Description
deemedStartDate Deemed Date
deemedEndDate Deemed End Date
fxDeemedStartDate Deemed Date
fxDeemedEndDate Deemed End Date
Column Name Description
isDcs Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
isBasis Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
fixedPeriod Fixed Period Show values
baseDate Base Date Show values
provisionPricing Provisional Pricing Show values
maturityType Maturity Type Show values
estimatedBasisId Estimated Basis ID Show values
termType Term Type Show values
pricingTermType Term Type Show values
dealDetailEfpPricingCategory Pricing Category for Exchange Futures for Physicals Show values
detailCalcPricingMethod Pricing Method Show values
pricingCategory Pricing Category Show values
priceType Price Type Show values
combinationRoutineRelevancy Combination Routine Relevancy Show values
fxFixedPeriod Fixed Period Show values
fxProvisionPricing Provisional Pricing Show values
fxBaseDate Base Date Show values
fxRateEnabled FX Rate Enabled Show values
uomConversionEnabled Conversion factor UoM is enabled Show values
headerTransactionType Transaction Type Show values
transactiontype Transaction Type Show values
Column Name Description Domain name
pricingUuid UUID in X form (binary) SYSUUID
dealUuid UUID in X form (binary) SYSUUID
itemIndex Index CPE_RULE
itemIndexDescr null
percentage Percentage /DMBE/DM_PRICING_PERCENTAGE
event Event CPE_ROUTINE
eventDescr Description TEXT40
offsetRoutine Offset Routine CPE_ROUTINE
offsetRoutineDescr Description TEXT40
offsetRoutineQtt null
offsetRoutineUom Time Unit of Measure Routine CPE_ROUTINE
offsetRoutineUomDescr Description TEXT40
offsetRoutineQttBefore Time Units Before DEC3
offsetRoutineQttAfter Time Units After DEC3
closedDaysRoutine Closed Days Routine CPE_ROUTINE
closedDaysRoutineDescr Description TEXT40
surchargeCurrencyDescr Long Text TEXT40
surchargeUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
heelPercent Heel Percent /DMBE/DM_HEEL_PERCENT
provisionPricingKey Provision Pricing Key /DMBE/DM_PROVISION_KEY
provisionPricingReference Provision Pricing Reference /DMBE/DM_PROVISION_REFERENCE
quantityFromUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
quantityToUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
amountCurrencyDescr Long Text TEXT40
perQuantity Per Quantity KPEIN
perQuantityUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
termGroup CPE Term - Term Group CHAR1
termNO CPE Term - Number in Formula NUMC5
maturityTypeDescr Short Text for Fixed Values DDTEXT
maturityKeyDate Contract Month /DMBE/DM_MATURITY_KEYDATE
maturityKeyDateDescr Maturity Description TEXT40
itemMaturityKeyDateDescr Maturity Description TEXT40
basisId Basis ID TBAC_BASIS_ID
basisIdDescr Basis ID Description TBAC_BASIS_ID_TEXT
basisType Basis Type TBAC_BASIS_TYPE
basisTypeDescr Basis Type Description TBAC_BASIS_TYPE_TEXT
fixedTermCurrencyDescr Long Text TEXT40
fixedTermUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
maturityRoutine Nearby Maturity CPE_ROUTINE
maturityRoutineDescr Description TEXT40
periodDeterminationRule Period Determination Rule CPE_RULE
periodDeterminationRuleDescr Description TEXT40
createdBy User Name SYCHAR12
createdByDescr Full Name of Person TEXT80
createdAt UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
changedBy User Name SYCHAR12
changedByDescr Full Name of Person TEXT80
changedAt UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
deleted Deleted Indicator ABAP_BOOL
pricingHeaderConditionType Condition Type KSCHL
fxEvent Event CPE_ROUTINE
fxEventDescr Description TEXT40
fxOffsetRoutine Offset Routine CPE_ROUTINE
fxOffsetRoutineDescr Description TEXT40
fxOffsetRoutineQtt Offset N Value /DMBE/EM_OFFSET_ROUTINE_QTT
fxOffsetRoutineUom Time Unit of Measure Routine CPE_ROUTINE
fxOffsetRoutineUomDescr Description TEXT40
fxOffsetRoutineQttBefore Time Units Before DEC3
fxOffsetRoutineQttAfter Time Units After DEC3
fxClosedDaysRoutine Closed Days Routine CPE_ROUTINE
fxClosedDaysRoutineDescr Description TEXT40
fxSurchargeCurrencyDescr Long Text TEXT40
fxSurchargeUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
fxProvisionPricingKey Provision Pricing Key /DMBE/DM_PROVISION_KEY
fxProvisionPricingReference Provision Pricing Reference /DMBE/DM_PROVISION_REFERENCE
fxHeelPercent Heel Percent /DMBE/DM_HEEL_PERCENT
fxQuantityFromUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
fxQuantityToUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
fxAmountCurrencyDescr Long Text TEXT40
fxPerQuantity Per Quantity KPEIN
fxPerQuantityUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
fxPeriodDeterminationRule Period Determination Rule CPE_RULE
fxPeriodDeterminationRuleDescr Description TEXT40
fxFixedTermCurrencyDescr Long Text TEXT40
fxFixedTermUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
exchangeRateType Exchange Rate Type KURST
exchangeRateTypeDescription Exchange rate type usage TEXT40
conversionUomFromDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
conversionUomToDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
validFrom CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP
buyingCompany Buying Company I/C BUKRS
sellingCompany Selling Company I/C BUKRS
dealBlocked null
Master Data Relations Join Conditions
Derivative Contract Specification ID /DMBE/C_PRICINGITEM_DISPLAY.MANDT == TBAC_DCS.CLIENT
Quotation Currency
  • Client
  • Quotation Currency
  • /DMBE/C_PRICINGITEM_DISPLAY.MANDT == TCURC.MANDT
  • /DMBE/C_PRICINGITEM_DISPLAY.DCSQUOTATIONCURRENCY == TCURC.WAERS
Derivative Contract Specification Unit of Measure
  • Client
  • Derivative Contract Specification Unit of Measure
  • /DMBE/C_PRICINGITEM_DISPLAY.MANDT == T006.MANDT
  • /DMBE/C_PRICINGITEM_DISPLAY.DCSUOM == T006.MSEHI
Deal Type
  • Client
  • Deal Type
Product Type
  • Client
  • Product Type
Other Relations | to Master Data Relations ↑ Join Conditions
Internal Company
  • Client
  • Internal Company