I_CmmdtyBeginPosPnLValCube

PnL value for Beginning Position - Cube | view: ICMMBPPNLVALC | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: T001, TKA02, CMM_TPL_EVENTS
Column Name Description
PricingKey A key required to access versioned pricing data
LogisticsDocumentVersion Version of an MtM Valuation Record
PricingDocumentItem Source Document Item
ConditionType Condition Type
SubConditionType The key of a sub-condition type
Column Name Description
💲 Statistics Currency (StatisticsCurrency):
PnLValue PnLValue
💲 CPE Term - Currency (ConditionTermRateCurrency):
ConditionRateAmount Condition Amount or Percentage
💲 CPE Term - Currency (ConditionTermValueCurrency):
ConditionTermValue CPE Term - Value
Column Name Description
📏 CPE Term - Unit of Measure (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit Commodity Quantity in Price Unit
ComparCmmdtyQuantityInTermUnit Comparative Contract Commodity Qty in Term Unit of Measure
PnLCalculationRelevantQuantity PnLRelevantTermQty
📏 Mass Unit of Measure (CmmdtyPriceExpsrMassUnit):
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
📏 QuantityVolume UoM (CmmdtyPriceExpsrVolumeUnit):
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Open Commodity Quantity
Column Name Description
EvaluationDate Snapshot End Date
ComparativeEvaluationDate Snapshot Start Date
MktMaturityKeyDate Market Maturity Key Date
ComparMktMaturityKeyDate Market Maturity Key Date
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
ExchRateMaturityDate Maturity Date
FixedExchRateDate Date when forward FX rate is frozen
QuotationPeriodReferenceDate Reference Date
ComparQtanPeriodReferenceDate Comparative Valuation Reference Date
QuotationPeriodStartDate Start Date of Quotation Period
QuotationPeriodEndDate End Date of Quotation Period
CndnTermRateFixationDate Rate Fixation Date
CndnTermRateFixationTime Rate Fixation Time
CndnTermExchRateFixationDate FX Fixation Date
CndnTermExchRateFixationTime FX Fixation Time
Column Name Description
PnLEventGroup Profit and Loss Event Group Show values
MTMAdjustmentType Type of adjustment for the MtM or TPL calculation Show values
MTMDataSourceType Type of Data Record Show values
PricingStatus Future/Basis Price Fixation Status Show values
HasError Flag: Error occured Show values
IsIntercompanyTransfer Intercompany Transfer Show values
QuotationGroupCalculationRule Quotation Group Operation Show values
PriceIsRealized Indicates that the MtM value is realized Show values
QuotationKeyType Quotation Key Type in Document UI (all values) Show values
MTMConditionGroupCategory Categorization of Condition Group Show values
ConditionTermRateIsFixed Indicates that the term is fixed Show values
ConditionTermExchRateIsFixed Indicates that the term is fixed Show values
ConditionCalculationTypeShort Calculation Type for Condition Show values
ConditionTermRateIsRounded Indicates whether the term rate is rounded Show values
ConditionTermExtensionUsage CPE Extension Usage Show values
MaturitySelectionType Maturity Selection Type Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
ProfitCenter Profit Center PRCTR
Plant Plant WERKS
Commodity Commodity TBA_STOEFFCHEN
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
OrignRefDocumentShortNumber Root Document CMM_DOCUMENT_CHAR10
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocumentItem Origin Reference Document Item
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
SourceDocumentShortNumber Document CMM_DOCUMENT_CHAR10
SourceDocument Document CMM_MTM_OBJID
SourceDocumentItem Condition item number NUM6
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
ConditionTermRateFixation CPE Term - Number in Formula NUMC5
MarketDCS Market Derivative Contract Specification ID TBA_DCSID
MktMarketIdentifierCode Market Market Identifier Code TBA_MIC
MktDrvtvContrMaturityCode Market Contract Maturity Code TBA_CONTRACT_CODE
MarketBasisType Market Basis Type TBAC_BASIS_TYPE
MarketBasisID Market Basis ID TBAC_BASIS_ID
MktQuotationPriceType Market Type of Price Quotation VVSKURSART
ComparativeMarketDCS Comparative Market Derivative Contract Specification ID TBA_DCSID
ComparMktMarketIdentifierCode Comparative Market Market Identifier Code TBA_MIC
ComparMktDrvtvContrCode Comparative Market Contract Maturity Code TBA_CONTRACT_CODE
ComparMarketBasisID Comparative Market Basis ID TBAC_BASIS_ID
ComparMarketBasisType Comparative Market Basis Type TBAC_BASIS_TYPE
ComparMktQuotationPriceType Comparative Market Type of Price Quotation VVSKURSART
SystemMessageNumber System Message Number
MktPricePnLValue PnL Market Price
SpreadPnLValue PnL Spread Value
DocToStstcFXPnLValue PnL Document to Statistics FX
MktToStstcFXPnLValue PnL Market to Statistics FX
MktValAdjmtFXBroughtFwdVal Document to Statistics FX Brought Forward Value
MarketConditionTermRate Market Term Rate
ComparMktConditionTermRate Comparative Market Term Rate
PnLCalculationRelevantValue PnLCalculationRelevantValue
ContrSpreadCndnTermRate Contract Spread Term Rate
ComparContrSpreadCndnTermRate Comparative Contract Spread Term Rate
FixedMktSpreadCndnTermRate Fixed Market Spread Term Rate
FloatingMktSpreadCndnTermRate Floating Market Spread Term Rate
ContractConditionTermRate Comparative Contract Condition Term Rate
ComparContrCndnTermRate Contract Condition Term Rate
MktMarketToDocExchRate Market Exchange Rate: Market to Document Currency
ComparMktMarketToDocExchRate Comparative Market Exchange Rate: Market to Document Curr.
ContractMktToDocExchRate Comparative Contract Exchange Rate: Market to Document Curr.
MktDocToStstcExchRate Market Exchange Rate: Document to Statistics Currency
ComparMktDocToStstcExchRate Comparative Market Exch. Rate: Document to Statistics Curr.
MktMarketToStstcExchRate Market Exchange Rate: Market to Statistics Currency
ComparMktMarketToStstcExchRate Comparative Market Exch. Rate: Market to Statistics Curr.
MktAdjmtValDocToStstcExchRate Contract Exchange Rate: Market to Document Currency
MktAdjmtValueCndnTermValue Market Adjustment Value Term Value
ConditionTermFactor CPE condition type term factor
ComparConditionTermFactor Comparative CPE condition type term factor
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
Creditor Account Number of Supplier LIFNR
SoldToParty Customer Number KUNNR
Material Material Number MATNR
StorageLocation Storage location LGORT
Batch Batch Number CHARG
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
ReferenceDocumentLongNumber Predecessor Document CMM_MTM_OBJID
ReferenceDocumentItem Reference Document Item
ReferenceDocBusObjType Ref (BOR) Object Type OJ_NAME
BusinessArea Business Area GSBER
PurchasingOrganization Purchasing organization EKORG
MaterialGroup Material Group MATKL
QuotationGroup Quotation Group (Technical Key Field) CHAR40
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
MTMCalcGrpMarketPriceCondition Market Price Condition within a calculation group KSCHL
CmmdtyEndOfDayBusinessEntyKey Key of an Business Entity End-of-day snapshot:Char format
ConditionQuantity Condition Pricing Unit KPEIN
ConditionTermRateQuantity CPE Term - Price Unit CPE_PRUN
ConditionTermName Description TEXT40
ConditionTermStatus CPE Term - Status CPE_TERMSTATUS
RoundingDecimalPlaces Decimals of Calculated Term/Formula Rate INT1
ConditionTermRateNmrtr Rate factor numerator
ConditionTermRateDnmntr Rate factor denominator
PnLEventType Profit and Loss Event Type CMM_EVENT
ConditionTermRate Market Term Rate
MarketToTermExchangeRateType Exch. Rate Type for Conversion from Market to Term Currency KURST
CndnToStstcExchangeRateType Exch. Rate Type for Conv. from Condition to Document Crcy KURST
ConditionToDocExchangeRateType Exch Rate Type for Conv. from Document to Statistics Crcy KURST
DocToStstcExchangeRateType Exch. Rate Type for Conv. from Condition to Stat. Crcy KURST
PriceSettingMethod Price Setting Method CPE_PSMETHOD
PriceSettingMethodStatus Price Setting Method Status CPE_PSMSTATUS
ValidToDateTime Valid-To Timestamp TZNTSTMPS
PricingProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
PricingConditionTerm CPE Term - Number in Formula NUMC5
Master Data Relations Join Conditions
Profit and Loss Event Category
  • Profit and Loss Event Category
  • Client