I_CmmdtyMTMFinValuesCube
Derivative MTM - Cube
I_CmmdtyMTMFinValuesCube (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.
Financial Operations
I_CmmdtyMTMFinValuesCube is a Composite CDS View (Cube) that provides data about "Derivative MTM - Cube" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyMTMFinValues) and exposes 67 fields. It has 1 association to related views. Part of development package FTR_COMMODITY_CDS.
SAP Help Documentation
| Category | CDS Views for Commodity Management |
|---|---|
| Data Category | Cube |
| Status | Released |
Purpose
This CDS view helps to retrieve data relevant for the Mark-to-Market Reporting of commodity derivatives.
This CDS view helps to retrieve data relevant for the Mark-to-Market Reporting of commodity derivatives.
SAP API Hub
| Category | Composite |
|---|---|
| State | C1 |
| Line of Business | Financial Operations |
| Application Component | FIN-FSCM-CMM-RSK |
| Capabilities | Data Source in SQL Select,Data Provider for Analytical Queries,Data Source for Defining CDS Entities |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Not Released |
| Package | Financial Operations for SAP S/4HANA Cloud Public Edition |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CmmdtyMTMFinValues | I_CmmdtyMTMFinValues | from |
Parameters (4)
| Name | Type | Default |
|---|---|---|
| P_DisplayView | cds_view_uom | |
| P_EvaluationDate | cds_evaluation_date | |
| P_EndOfDaySnapshotToDate | cds_evaluation_date_comp | |
| P_MTMDataSelectionType | cmm_vlogp_consumptiontype |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_CmmdtyMtmMessage | _CmmdtyMtmMessage | $projection.SystemMessageNumber = _CmmdtyMtmMessage.SystemMessageNumber |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| Analytics.dataCategory | #CUBE | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | IDRVTVMTMCUBE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| EndUserText.label | Derivative MTM - Cube | view |
Fields (67)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| CompanyCode | CompanyCode | Receiver Company Code | ||
| CommodityPriceExposure | CommodityPriceExposure | Commodity Price Exposure ID | ||
| CommodityExposureCategory | CommodityExposureCategory | Exposure Category | ||
| CommodityPriceExposureVersion | CommodityPriceExposureVersion | Version of a Commodity Price Exposure | ||
| CommodityPriceSubExposure | CommodityPriceSubExposure | Hash key | ||
| ValidityStartDateTime | ValidityStartDateTime | Valid-From Timestamp of Commodity Derivative | ||
| ValidityEndDateTime | ValidityEndDateTime | Valid-To Timestamp of Commodity Derivative | ||
| ValidityStartDate | ValidityStartDate | Valid-From Date of Exposure | ||
| ValidityStartTime | ValidityStartTime | Valid-From Time of Commodity Derivative | ||
| ValidityEndDate | ValidityEndDate | Valid-To Date of Commodity Derivative | ||
| ValidityEndTime | ValidityEndTime | Valid-To Time of Commodity Derivative | ||
| MaximumVersion | MaximumVersion | Highest Version Number | ||
| RiskAnalyzerVersionUUID | RiskAnalyzerVersionUUID | CMM_VFIND Version GUID | ||
| ExposureDueDate | ExposureDueDate | Date on which the exposure is due and expires | ||
| ReportingDate | ReportingDate | Reporting Date | ||
| Commodity | Commodity | Commodity Code | ||
| CashFlowDirection | CashFlowDirection | Transaction Flow Direction | ||
| TreasuryPositionLongShortCode | TreasuryPositionLongShortCode | Indicates whether it is a long or a short position | ||
| DerivativeContrSpecification | DerivativeContrSpecification | Derivative Contract Specification ID | ||
| MarketIdentifierCode | MarketIdentifierCode | Market Identifier Code | ||
| TimeToMaturity | TimeToMaturity | Time to Maturity | ||
| CmmdtyForwardIndexTiming | CmmdtyForwardIndexTiming | Timing/Periodicity of Commodity Forward Indexes | ||
| MaturityKeyDate | MaturityKeyDate | Maturity Key Date | ||
| DerivativeContractMaturityCode | DerivativeContractMaturityCode | Contract Maturity Code | ||
| FinancialInstrProductCategory | FinancialInstrProductCategory | Product Category | ||
| FinancialAssetsMgmtProductType | FinancialAssetsMgmtProductType | Product Type | ||
| FinInstrTransactionCategory | FinInstrTransactionCategory | Transaction Category | ||
| FinancialInstrumentProductType | FinancialInstrumentProductType | Financial Transaction Type | ||
| FinancialInstrActivityCategory | FinancialInstrActivityCategory | Transaction Activity Category | ||
| FinancialObject | FinancialObject | Financial Object Number | ||
| PnLEventType | PnLEventType | Profit and Loss Event Type | ||
| TermStartDate | TermStartDate | Term Start | ||
| TermEndDate | TermEndDate | Term End | ||
| DeliveryDate | DeliveryDate | Delivery Date of a Commodity Derivative (OBSOLETE) | ||
| NumberOfCommodityContracts | Number of Contracts | |||
| CommodityPriceExposureQuantity | CommodityPriceExposureQuantity | Quantity (OBSOLETE) | ||
| CommodityPriceExposureUnit | CommodityPriceExposureUnit | Unit of Measure for the Commodity | ||
| TreasuryPositionAccount | TreasuryPositionAccount | Futures Account for Listed Options and Futures | ||
| DerivativeContract | DerivativeContract | Contract for Listed Options and Futures | ||
| OptionStrikePrice | Option Strike Price | |||
| OptionStrikeCurrency | OptionStrikeCurrency | Currency Unit of the Rate | ||
| OptionPutCallCode | OptionPutCallCode | Put/Call Indicator | ||
| OptionExerciseType | OptionExerciseType | Exercise Type (American or European) | ||
| EvaluationDate | EvaluationDate | Evaluation Date | ||
| MTMDataSelectionType | MTMDataSelectionType | VLOGP Data Selection Type | ||
| FinInstrExternalReference | FinInstrExternalReference | External Reference | ||
| DisplayView | DisplayView | View Variant | ||
| HasError | HasError | Error Flag for Data Record of Commodity Risk Analytics | ||
| ExternalKeyFigureValue | ExternalKeyFigureValue | External Key figures | ||
| OptionDeltaFactorKeyFigure | OptionDeltaFactorKeyFigure | Option Delta Factor | ||
| OptionDeltaFactor | OptionDeltaFactor | Option Delta Factor Value | ||
| RiskAnalyzerKeyFigureName | RiskAnalyzerKeyFigureName | Risk Analyzer Keyfigure Name | ||
| RiskAnalyzerKeyFigInQtanCrcy | RiskAnalyzerKeyFigInQtanCrcy | Value in Quotation Currency | ||
| QuotationCurrency | QuotationCurrency | Evaluation in Quotation Currency | ||
| RiskAnalyzerKeyFigInPaytCrcy | RiskAnalyzerKeyFigInPaytCrcy | Value in Payment Currency | ||
| PaymentCurrency | PaymentCurrency | Evaluation in Payment Currency | ||
| RiskAnalyzerKeyFigInStstcCrcy | RiskAnalyzerKeyFigInStstcCrcy | Value in Statistics Currency | ||
| StatisticsCurrency | StatisticsCurrency | Statistics Currency in Evaluation | ||
| HasErrorDescription | HasErrorDescription | Error Description | ||
| SystemMessageNumber | SystemMessageNumber | Message Number | ||
| _CompanyCode | _CompanyCode | |||
| _DerivativeContrSpecification | _DerivativeContrSpecification | |||
| _FinAssetsMgmtProductType | _FinAssetsMgmtProductType | |||
| _MarketIdentifierCode | _MarketIdentifierCode | |||
| _PhysicalCommodity | _PhysicalCommodity | |||
| _CmmdtyMtmMessage | _CmmdtyMtmMessage | |||
| _UnitOfMeasure | _UnitOfMeasure |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_CmmdtyMTMFinValuesCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IDRVTVMTMCUBE
-- Parameters: P_DisplayView : cds_view_uom, P_EvaluationDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cmm_vlogp_consumptiontype
CREATE VIEW I_CmmdtyMTMFinValuesCube AS
SELECT
CompanyCode,
CommodityPriceExposure,
CommodityExposureCategory,
CommodityPriceExposureVersion,
CommodityPriceSubExposure,
ValidityStartDateTime,
ValidityEndDateTime,
ValidityStartDate,
ValidityStartTime,
ValidityEndDate,
ValidityEndTime,
MaximumVersion,
RiskAnalyzerVersionUUID,
ExposureDueDate,
ReportingDate,
Commodity,
CashFlowDirection,
TreasuryPositionLongShortCode,
DerivativeContrSpecification,
MarketIdentifierCode,
TimeToMaturity,
CmmdtyForwardIndexTiming,
MaturityKeyDate,
DerivativeContractMaturityCode,
FinancialInstrProductCategory,
FinancialAssetsMgmtProductType,
FinInstrTransactionCategory,
FinancialInstrumentProductType,
FinancialInstrActivityCategory,
FinancialObject,
PnLEventType,
TermStartDate,
TermEndDate,
DeliveryDate,
cast( NumberOfCommodityContracts as cmm_contracts_number) AS NumberOfCommodityContracts,
CommodityPriceExposureQuantity,
CommodityPriceExposureUnit,
TreasuryPositionAccount,
DerivativeContract,
cast( OptionStrikePrice as cmm_option_strike_price) AS OptionStrikePrice,
OptionStrikeCurrency,
OptionPutCallCode,
OptionExerciseType,
EvaluationDate,
MTMDataSelectionType,
FinInstrExternalReference,
DisplayView,
HasError,
ExternalKeyFigureValue,
OptionDeltaFactorKeyFigure,
OptionDeltaFactor,
RiskAnalyzerKeyFigureName,
RiskAnalyzerKeyFigInQtanCrcy,
QuotationCurrency,
RiskAnalyzerKeyFigInPaytCrcy,
PaymentCurrency,
RiskAnalyzerKeyFigInStstcCrcy,
StatisticsCurrency,
HasErrorDescription,
SystemMessageNumber
FROM I_CmmdtyMTMFinValues
LEFT OUTER JOIN I_CmmdtyMtmMessage AS _CmmdtyMtmMessage ON SystemMessageNumber = _CmmdtyMtmMessage.SystemMessageNumber -- association [0..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA