What is I_CmmdtyPnLFinValuesCube in SAP S/4HANA?

I_CmmdtyPnLFinValuesCube is a composite CDS view in SAP S/4HANA. Derivative PnL - Cube It contains 66 fields.

Which tables does I_CmmdtyPnLFinValuesCube read from?

I_CmmdtyPnLFinValuesCube reads data from: I_CmmdtyPnLFinValues.

What VDM layer is I_CmmdtyPnLFinValuesCube?

I_CmmdtyPnLFinValuesCube is classified as a Composite view that combines data from multiple basic views.

I_CmmdtyPnLFinValuesCube

DDL: I_CMMDTYPNLFINVALUESCUBE SQL: IDRVTVPNLCUBE Type: view COMPOSITE

66 Fields 1 Data Sources

Derivative PnL - Cube

I_CmmdtyPnLFinValuesCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_CmmdtyPnLFinValuesCube is a Composite CDS View (Cube) that provides data about "Derivative PnL - Cube" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyPnLFinValues) and exposes 66 fields with key fields CompanyCode, CommodityPriceExposure, CommodityExposureCategory, CommodityPriceSubExposure, CommodityPriceExposureVersion.

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 P/L Reporting of commodity derivatives.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-CMM-RSK
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Financial Operations for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CmmdtyPnLFinValues	I_CmmdtyPnLFinValues	from

Parameters (4)

Name	Type	Default
P_EvaluationDate	cds_evaluation_date
P_EndOfDaySnapshotToDate	cds_evaluation_date_comp
P_DisplayView	cds_view_uom
P_DisplayCurrency	cds_view_currency

Annotations (12)

Name	Value	Level
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	IDRVTVPNLCUBE	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
AbapCatalog.preserveKey	true	view
EndUserText.label	Derivative PnL - Cube	view

Fields (66)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	PnL	CompanyCode	Receiver Company Code
KEY	CommodityPriceExposure	PnL	CommodityPriceExposure	Commodity Price Exposure ID
KEY	CommodityExposureCategory	PnL	CommodityExposureCategory	Exposure Category
KEY	CommodityPriceSubExposure	PnL	CommodityPriceSubExposure	Hash key
KEY	CommodityPriceExposureVersion	PnL	CommodityPriceExposureVersion	Version of a Commodity Price Exposure
	ValidityStartDateTime	PnL	ValidityStartDateTime	Valid-From Timestamp of Commodity Derivative
	ValidityEndDateTime	PnL	ValidityEndDateTime	Valid-To Timestamp of Commodity Derivative
	ValidityStartDate	PnL	ValidityStartDate	Valid-From Date of Exposure
	ValidityStartTime	PnL	ValidityStartTime	Valid-From Time of Commodity Derivative
	ValidityEndDate	PnL	ValidityEndDate	Valid-To Date of Commodity Derivative
	ValidityEndTime	PnL	ValidityEndTime	Valid-To Time of Commodity Derivative
	MaximumVersion	PnL	MaximumVersion	Highest Version Number
	RiskAnalyzerVersionUUID	PnL	RiskAnalyzerVersionUUID	CMM_VFIND Version GUID
	ExposureDueDate	PnL	ExposureDueDate	Date on which the exposure is due and expires
	ReportingDate	PnL	ReportingDate	Reporting Date
	Commodity	PnL	Commodity	Commodity Code
	CashFlowDirection	PnL	CashFlowDirection	Transaction Flow Direction
	TreasuryPositionLongShortCode	PnL	TreasuryPositionLongShortCode	Indicates whether it is a long or a short position
	DerivativeContrSpecification	PnL	DerivativeContrSpecification	Derivative Contract Specification ID
	MarketIdentifierCode	PnL	MarketIdentifierCode	Market Identifier Code
	TimeToMaturity	PnL	TimeToMaturity	Time to Maturity
	CmmdtyForwardIndexTiming	PnL	CmmdtyForwardIndexTiming	Timing/Periodicity of Commodity Forward Indexes
	MaturityKeyDate	PnL	MaturityKeyDate	Maturity Key Date
	DerivativeContractMaturityCode	PnL	DerivativeContractMaturityCode	Contract Maturity Code
	FinancialInstrProductCategory	PnL	FinancialInstrProductCategory	Product Category
	FinancialAssetsMgmtProductType	PnL	FinancialAssetsMgmtProductType	Product Type
	FinInstrTransactionCategory	PnL	FinInstrTransactionCategory	Transaction Category
	FinancialInstrumentProductType	PnL	FinancialInstrumentProductType	Financial Transaction Type
	FinancialInstrActivityCategory	PnL	FinancialInstrActivityCategory	Transaction Activity Category
	FinancialObject	PnL	FinancialObject	Financial Object Number
	PnLEventCategory	PnL	PnLEventCategory	Profit and Loss Event Category
	PnLEventType	PnL	PnLEventType	Profit and Loss Event Type
	TermStartDate	PnL	TermStartDate	Term Start
	TermEndDate	PnL	TermEndDate	Term End
	DeliveryDate	PnL	DeliveryDate	Delivery Date of a Commodity Derivative
	NumberOfCommodityContracts			Number of Contracts
	TreasuryPositionAccount	PnL	TreasuryPositionAccount	Futures Account for Listed Options and Futures
	DerivativeContract	PnL	DerivativeContract	Contract for Listed Options and Futures
	OptionStrikePrice			Option Strike Price
	OptionStrikeCurrency	PnL	OptionStrikeCurrency	Currency Unit of the Rate
	OptionPutCallCode	PnL	OptionPutCallCode	Put/Call Indicator
	OptionExerciseType	PnL	OptionExerciseType	Exercise Type (American or European)
	EvaluationDate	PnL	EvaluationDate	Evaluation Date
	FinInstrExternalReference	PnL	FinInstrExternalReference	External Reference
	DisplayView	PnL	DisplayView	View Variant
	DisplayCurrency	PnL	DisplayCurrency	Display Currency
	HasError	PnL	HasError	Error Flag for Data Record of Commodity Risk Analytics
	HasErrorDescription	PnL	HasErrorDescription	Error Description
	ExternalKeyFigureValue	PnL	ExternalKeyFigureValue	External Key figures
	PnLValue	PnL	PnLValue	PnLValue
	PnLCalculationRelevantValue	PnL	PnLCalculationRelevantValue	PnLCalculationRelevantValue
	PnLCalculationRelevantQuantity	PnL	PnLCalculationRelevantQuantity	PnLRelevantTermQty
	PnLRelevantComparativeTermVal	PnL	PnLRelevantComparativeTermVal	PnLRelevantCamparativeTermValue
	PnLRelevantComparativeTermQty	PnL	PnLRelevantComparativeTermQty	PnLRelevantTermQty
	PnLRelevantTermValue	PnL	PnLRelevantTermValue	PnLRelevantCamparativeTermValue
	PnLRelevantTermQuantity	PnL	PnLRelevantTermQuantity	PnLRelevantTermQty
	Currency	PnL	Currency	Statistics Currency in Evaluation
	CommodityPriceExposureUnit	PnL	CommodityPriceExposureUnit	Unit of Measure for the Commodity
	_CompanyCode	PnL	_CompanyCode
	_DerivativeContrSpecification	PnL	_DerivativeContrSpecification
	_FinAssetsMgmtProductType	PnL	_FinAssetsMgmtProductType
	_MarketIdentifierCode	PnL	_MarketIdentifierCode
	_PhysicalCommodity	PnL	_PhysicalCommodity
	_UnitOfMeasure	PnL	_UnitOfMeasure
	_PnLEventCategory	PnL	_PnLEventCategory
	_PnLEventType	PnL	_PnLEventType

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_CmmdtyPnLFinValuesCube.
-- 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: IDRVTVPNLCUBE
-- Parameters: P_EvaluationDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_DisplayView : cds_view_uom, P_DisplayCurrency : cds_view_currency

CREATE VIEW I_CmmdtyPnLFinValuesCube AS
SELECT
  PnL.CompanyCode AS CompanyCode,
  PnL.CommodityPriceExposure AS CommodityPriceExposure,
  PnL.CommodityExposureCategory AS CommodityExposureCategory,
  PnL.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  PnL.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  PnL.ValidityStartDateTime AS ValidityStartDateTime,
  PnL.ValidityEndDateTime AS ValidityEndDateTime,
  PnL.ValidityStartDate AS ValidityStartDate,
  PnL.ValidityStartTime AS ValidityStartTime,
  PnL.ValidityEndDate AS ValidityEndDate,
  PnL.ValidityEndTime AS ValidityEndTime,
  PnL.MaximumVersion AS MaximumVersion,
  PnL.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  PnL.ExposureDueDate AS ExposureDueDate,
  PnL.ReportingDate AS ReportingDate,
  PnL.Commodity AS Commodity,
  PnL.CashFlowDirection AS CashFlowDirection,
  PnL.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  PnL.DerivativeContrSpecification AS DerivativeContrSpecification,
  PnL.MarketIdentifierCode AS MarketIdentifierCode,
  PnL.TimeToMaturity AS TimeToMaturity,
  PnL.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  PnL.MaturityKeyDate AS MaturityKeyDate,
  PnL.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  PnL.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  PnL.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  PnL.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  PnL.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  PnL.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  PnL.FinancialObject AS FinancialObject,
  PnL.PnLEventCategory AS PnLEventCategory,
  PnL.PnLEventType AS PnLEventType,
  PnL.TermStartDate AS TermStartDate,
  PnL.TermEndDate AS TermEndDate,
  PnL.DeliveryDate AS DeliveryDate,
  cast( PnL.NumberOfCommodityContracts as cmm_contracts_number) AS NumberOfCommodityContracts,
  PnL.TreasuryPositionAccount AS TreasuryPositionAccount,
  PnL.DerivativeContract AS DerivativeContract,
  cast( PnL.OptionStrikePrice as cmm_option_strike_price) AS OptionStrikePrice,
  PnL.OptionStrikeCurrency AS OptionStrikeCurrency,
  PnL.OptionPutCallCode AS OptionPutCallCode,
  PnL.OptionExerciseType AS OptionExerciseType,
  PnL.EvaluationDate AS EvaluationDate,
  PnL.FinInstrExternalReference AS FinInstrExternalReference,
  PnL.DisplayView AS DisplayView,
  PnL.DisplayCurrency AS DisplayCurrency,
  PnL.HasError AS HasError,
  PnL.HasErrorDescription AS HasErrorDescription,
  PnL.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  PnL.PnLValue AS PnLValue,
  PnL.PnLCalculationRelevantValue AS PnLCalculationRelevantValue,
  PnL.PnLCalculationRelevantQuantity AS PnLCalculationRelevantQuantity,
  PnL.PnLRelevantComparativeTermVal AS PnLRelevantComparativeTermVal,
  PnL.PnLRelevantComparativeTermQty AS PnLRelevantComparativeTermQty,
  PnL.PnLRelevantTermValue AS PnLRelevantTermValue,
  PnL.PnLRelevantTermQuantity AS PnLRelevantTermQuantity,
  PnL.Currency AS Currency,
  PnL.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  PnL._CompanyCode AS _CompanyCode,
  PnL._DerivativeContrSpecification AS _DerivativeContrSpecification,
  PnL._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
  PnL._MarketIdentifierCode AS _MarketIdentifierCode,
  PnL._PhysicalCommodity AS _PhysicalCommodity,
  PnL._UnitOfMeasure AS _UnitOfMeasure,
  PnL._PnLEventCategory AS _PnLEventCategory,
  PnL._PnLEventType AS _PnLEventType
FROM I_CmmdtyPnLFinValues
;

Depth:

I_CmmdtyPnLFinValuesCube view

I_CmmdtyPnLFinValues view

C_CmmdtyPnLFinValueQuery view