C_Cmmdtynapnlvalue_Query

Commodity NA PnL Value | view: CCMMNAPNLVALUE | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: CMM_TPL_EVENTST100
Column Name Description
PricingKey A key required to access versioned pricing data
Column Name Description
💲 Statistics Currency (StatisticsCurrency):
PnLValue PnLValue
SpreadPnLValue PnL Spreads Value
Column Name Description
📏 Price UoM (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit Commodity Quantity in Price Unit
ComparCmmdtyQuantityInTermUnit Comparative Contract Commodity Qty in Term Unit of Measure
PnLCalculationRelevantQuantity PnLRelevantTermQty
📏 CPE Term - Unit of Measure (MarketPriceQuantityUnit):
PnLCalcRelevantMarketQuantity PnL Calculation Relevant Market Rate Quantity
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
Column Name Description
EvaluationDate Snapshot End Date
ComparativeEvaluationDate Snapshot Start Date
QuotationPeriodReferenceDate Reference Date
ContractMaturityKeyDate Contract Maturity Key Date
MktMaturityKeyDate Market Maturity Key Date
ValidityStartDate Valid-From Date
ValidityStartDateTime Valid-From Time
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
ExchRateMaturityDate Maturity Date
FixedExchRateDate Date when forward FX rate is frozen
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
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
MTMAdjustmentType Type of adjustment for the MtM or TPL calculation Show values
PriceIsRealized Indicates that the MtM value is realized 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
PnLEventType Profit and Loss Event Type CMM_EVENT
PnLElementaryEventType Profit and Loss Elementary Event Type CMM_EVENT
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocumentItem Origin Reference Document Item
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
SourceDocument Document CMM_MTM_OBJID
SourceDocumentItem Source Document Item
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
ConditionTermRateFixation Fixation ID
ConditionType Condition Type KSCHL
ContractConditionType Contract Price Condition Type KSCHL
ContractDCS Contractual Derivative Contract Specification ID TBA_DCSID
ContractMarketIdentifierCode Contract Market Identifier Code TBA_MIC
ContrDrvtvContrMaturityCode Contractual Contract Maturity Code TBA_CONTRACT_CODE
ContractBasisType Contract Basis Type TBAC_BASIS_TYPE
ContractBasisID Contract Basis ID TBAC_BASIS_ID
ContractQuotationPriceType Contract Type of Price Quotation VVSKURSART
MarketDCS Comparative Market Derivative Contract Specification ID TBA_DCSID
MktMarketIdentifierCode Comparative Market Market Identifier Code TBA_MIC
MktDrvtvContrMaturityCode Comparative Market Contract Maturity Code TBA_CONTRACT_CODE
MarketBasisType Comparative Market Basis Type TBAC_BASIS_TYPE
MarketBasisID Comparative Market Basis ID TBAC_BASIS_ID
MktQuotationPriceType Comparative Market Type of Price Quotation VVSKURSART
SubConditionType The key of a sub-condition type CMM_VLOGP_SUBKEY
SystemMessageNumber System Message Number
ContractConditionTermRate Contract Condition Term Rate
ComparContrCndnTermRate Comparative Contract Condition Term Rate
ConditionTermFactor CPE condition type term factor
ComparConditionTermFactor Comparative CPE condition type term factor
MarketConditionTermRate Market Term Rate
ContrSpreadCndnTermRate Contract Spread Term Rate
FixedMktSpreadCndnTermRate Fixed Market Spread Term Rate
FloatingMktSpreadCndnTermRate Floating Market Spread Term Rate
ContractMktToDocExchRate Contract Exchange Rate: Market to Document Currency
ComparContrMktToDocExchRate Comparative Contract Exchange Rate: Market to Document Curr.
ContrDocToStstcExchRate Contract Exchange Rate: Document to Statistics Currency
ComparContrDocToStstcExchRate Comparative Contr. Exch. Rate: Document to Statistics Curr.
MktMarketToDocExchRate Market Exchange Rate: Market to Document Currency
MktDocToStstcExchRate Market Exchange Rate: Document to Statistics Currency
MktMarketToStstcExchRate Market Exchange Rate: Market to Statistics Currency
CalcRelContrConditionTermRate Calculation Relevant Contract Condition Term Rate
CalcRelComparContrCndnTermRate CalculationRelevant Comparative Contract Condition Term Rate
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
ReferenceDocument 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
MTMConditionGroupCategoryName Short Text for Fixed Values DDTEXT
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
MTMCalcGrpMarketPriceCondition Market Price Condition within a calculation group KSCHL
SystemMessageText Message Text NATXT
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