What is I_ContrBPPnLValueCube in SAP S/4HANA?

I_ContrBPPnLValueCube is a composite CDS view in SAP S/4HANA. ACM Contract BP PnL Values - Cube It contains 137 fields.

Which tables does I_ContrBPPnLValueCube read from?

I_ContrBPPnLValueCube reads data from: I_Cmmdtybppnlvalue_Cube, I_ContrPrcAttribLogSync.

What VDM layer is I_ContrBPPnLValueCube?

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

I_ContrBPPnLValueCube

DDL: I_CONTRBPPNLVALUECUBE SQL: IACMBPPNLVALCUBE Type: view COMPOSITE

137 Fields 2 Data Sources 3 Associations

ACM Contract BP PnL Values - Cube

I_ContrBPPnLValueCube (Composite)

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

Sales

I_ContrBPPnLValueCube is a Composite CDS View (Cube) that provides data about "ACM Contract BP PnL Values - Cube" in SAP S/4HANA. It reads from 2 data sources (I_Cmmdtybppnlvalue_Cube, I_ContrPrcAttribLogSync) and exposes 137 fields. It has 3 associations to related views.

SAP API Hub

State	C1
Line of Business	Sales
Application Component	LO-AGR
Capabilities	Data Provider for Analytical Queries
Package	Sales 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 (2)

Source	Alias	Join Type
I_Cmmdtybppnlvalue_Cube	I_Cmmdtybppnlvalue_Cube	from
I_ContrPrcAttribLogSync	LogSync	left_outer

Parameters (1)

Name	Type	Default
P_Language	spras

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_ContrVersionedLogPrcDoc	_vlogp	`cube.PricingKey = _vlogp.PricingKey and cube.Version = _vlogp.Version and cube.PricingDocumentItem = _vlogp.PricingDocumentItem and cube.ConditionType = _vlogp.ConditionType and cube.SubConditionType = _vlogp.SubConditionType and cube.CompanyCode = _vlogp.CompanyCode and cube.Plant = _vlogp.Plant and cube.Material = _vlogp.Material`
[1..1]	I_CompanyCode	_Companycode	`cube.CompanyCode = _Companycode.CompanyCode`
[0..1]	I_Product	_Material	`$projection.Material = _Material.Product`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IACMBPPNLVALCUBE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
Analytics.dataCategory	#CUBE	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	ACM Contract BP PnL Values - Cube	view
ObjectModel.supportedCapabilities	#ANALYTICAL_PROVIDER	view

Fields (137)

Field	Source Table	Source Field	Description
EvaluationDate	cube	EvaluationDate	Snapshot End Date
ComparativeEvaluationDate	cube	ComparativeEvaluationDate	Snapshot Start Date
CompanyCode	cube	CompanyCode	Receiver Company Code
_Companycode		_Companycode
ProfitCenter	cube	ProfitCenter	Profit Center
Plant	cube	Plant	Valuation Area
_Plant	cube	_Plant
Commodity	cube	Commodity	Commodity Code
_Commodity	cube	_Commodity
MTMCalculationGroup	cube	MTMCalculationGroup	MtM Calculation Group
_MTMCalculationGroup	cube	_MTMCalculationGroup
PnLEventGroup	cube	PnLEventGroup	Profit and Loss Event Group
MTMAdjustmentType	cube	MTMAdjustmentType	Type of adjustment for the MtM or TPL calculation
_MTMAdjustmentType	cube	_MTMAdjustmentType
OriginReferenceDocument	cube	OriginReferenceDocument	Root Document
OriginReferenceDocumentItem	cube	OriginReferenceDocumentItem	Origin Reference Document Item
OriginReferenceDocBusObjType	cube	OriginReferenceDocBusObjType	Root Document (BOR) Object Type
_OriginReferenceDocBusObjType	cube	_OriginReferenceDocBusObjType
SourceDocument	cube	SourceDocument	Document
SourceDocumentItem	cube	SourceDocumentItem	Condition item number
SourceDocumentBusObjType	cube	SourceDocumentBusObjType	Document (BOR) Object Type
_SourceDocumentBusObjType	cube	_SourceDocumentBusObjType
ConditionTermRateFixation	cube	ConditionTermRateFixation	CPE Term - Number in Formula
ConditionType	cube	ConditionType	Condition type
MarketDCS	cube	MarketDCS	Market Derivative Contract Specification ID
_MarketDCS	cube	_MarketDCS
MktMarketIdentifierCode	cube	MktMarketIdentifierCode	Market Market Identifier Code
_MktMarketIdentifierCode	cube	_MktMarketIdentifierCode
MktDrvtvContrMaturityCode	cube	MktDrvtvContrMaturityCode	Market Contract Maturity Code
MktMaturityKeyDate	cube	MktMaturityKeyDate	Market Maturity Key Date
MarketBasisType	cube	MarketBasisType	Market Basis Type
MarketBasisID	cube	MarketBasisID	Market Basis ID
_BasisID	cube	_BasisID
MktQuotationPriceType	cube	MktQuotationPriceType	Market Type of Price Quotation
MTMDataSourceType	cube	MTMDataSourceType	Type of Data Record
_MTMDataSourceType	cube	_MTMDataSourceType
ComparativeMarketDCS	cube	ComparativeMarketDCS	Comparative Market Derivative Contract Specification ID
_ComparativeMarketDCS	cube	_ComparativeMarketDCS
ComparMktMarketIdentifierCode	cube	ComparMktMarketIdentifierCode	Comparative Market Market Identifier Code
_ComparMktMarketIdentifierCode	cube	_ComparMktMarketIdentifierCode
ComparMktMaturityKeyDate	cube	ComparMktMaturityKeyDate	Market Maturity Key Date
ComparMktDrvtvContrCode	cube	ComparMktDrvtvContrCode	Comparative Market Contract Maturity Code
ComparMarketBasisID	cube	ComparMarketBasisID	Comparative Market Basis ID
ComparMarketBasisType	cube	ComparMarketBasisType	Comparative Market Basis Type
ComparMktQuotationPriceType	cube	ComparMktQuotationPriceType	Comparative Market Type of Price Quotation
PricingStatus	cube	PricingStatus	Future/Basis Price Fixation Status
_PricingStatus	cube	_PricingStatus
SubConditionType	cube	SubConditionType	The key of a sub-condition type
HasError	cube	HasError	Flag: Error occured
SystemMessageNumber	cube	SystemMessageNumber	System Message Number
_CmmdtyMtmMessage	cube	_CmmdtyMtmMessage
CommodityUnit	cube	CommodityUnit	Unit of Measure for Commodity
_CommodityUnit	cube	_CommodityUnit
ConditionTermRateQuantityUnit	cube	ConditionTermRateQuantityUnit	CPE Term - Unit of Measure
_ConditionTermRateQuantityUnit	cube	_ConditionTermRateQuantityUnit
StatisticsCurrency	cube	StatisticsCurrency	Statistics Currency
_StatisticsCurrency	cube	_StatisticsCurrency
PnLValue	cube	PnLValue	PnLValue
MktPricePnLValue	cube	MktPricePnLValue	PnL Market Price
SpreadPnLValue	cube	SpreadPnLValue	PnL Spread Value
DocToStstcFXPnLValue	cube	DocToStstcFXPnLValue	PnL Document to Statistics FX
MktToStstcFXPnLValue	cube	MktToStstcFXPnLValue	PnL Market to Statistics FX
MktValAdjmtFXBroughtFwdVal	cube	MktValAdjmtFXBroughtFwdVal	Document to Statistics FX Brought Forward Value
CommodityQuantityInTermUnit	cube	CommodityQuantityInTermUnit	Commodity Quantity in Price Unit
ComparCmmdtyQuantityInTermUnit	cube	ComparCmmdtyQuantityInTermUnit	Comparative Contract Commodity Qty in Term Unit of Measure
PnLCalculationRelevantQuantity	cube	PnLCalculationRelevantQuantity	PnLRelevantTermQty
MarketConditionTermRate	cube	MarketConditionTermRate	Market Term Rate
ComparMktConditionTermRate	cube	ComparMktConditionTermRate	Comparative Market Term Rate
PnLCalculationRelevantValue	cube	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	cube	ContractConditionTermRate	Comparative Contract Condition Term Rate
ComparContrCndnTermRate	cube	ComparContrCndnTermRate	Contract Condition Term Rate
MktMarketToDocExchRate	cube	MktMarketToDocExchRate	Market Exchange Rate: Market to Document Currency
ComparMktMarketToDocExchRate	cube	ComparMktMarketToDocExchRate	Comparative Market Exchange Rate: Market to Document Curr.
ContractMktToDocExchRate	cube	ContractMktToDocExchRate	Comparative Contract Exchange Rate: Market to Document Curr.
MktDocToStstcExchRate	cube	MktDocToStstcExchRate	Market Exchange Rate: Document to Statistics Currency
ComparMktDocToStstcExchRate	cube	ComparMktDocToStstcExchRate	Comparative Market Exch. Rate: Document to Statistics Curr.
MktMarketToStstcExchRate	cube	MktMarketToStstcExchRate	Market Exchange Rate: Market to Statistics Currency
ComparMktMarketToStstcExchRate	cube	ComparMktMarketToStstcExchRate	Comparative Market Exch. Rate: Market to Statistics Curr.
MktAdjmtValDocToStstcExchRate	cube	MktAdjmtValDocToStstcExchRate	Contract Exchange Rate: Market to Document Currency
MktAdjmtValueCndnTermValue	cube	MktAdjmtValueCndnTermValue	Market Adjustment Value Term Value
ConditionTermFactor	cube	ConditionTermFactor	CPE condition type term factor
ComparConditionTermFactor	cube	ComparConditionTermFactor	Comparative CPE condition type term factor
SalesOrganization	cube	SalesOrganization	Sales Organization
DistributionChannel	cube	DistributionChannel	Distribution Channel
Division	cube	Division	Internal Division ID
Creditor	cube	Creditor	Account Number of Supplier
_Creditor	cube	_Creditor
SoldToParty	cube	SoldToParty	Customer Number
_SoldToParty	cube	_SoldToParty
Material	cube	Material	Material Number
_Material		_Material
StorageLocation	cube	StorageLocation	Storage Location
_StorageLocation	cube	_StorageLocation
Batch	cube	Batch	Batch Number
IncotermsClassification	cube	IncotermsClassification	Incoterms (Part 1)
_IncotermsClassification	cube	_IncotermsClassification
IncotermsTransferLocation	cube	IncotermsTransferLocation	Incoterms (Part 2)
ConditionApplication	cube	ConditionApplication	Application
ReferenceDocument	cube	ReferenceDocument	Predecessor Document
ReferenceDocumentItem	cube	ReferenceDocumentItem	Reference Document Item
ReferenceDocBusObjType	cube	ReferenceDocBusObjType	Ref (BOR) Object Type
_ReferenceDocBusObjType	cube	_ReferenceDocBusObjType
DeliveryDate	cube	DeliveryDate	Delivery Date
ExpectedPaymentDate	cube	ExpectedPaymentDate	Payment Date
DocumentCurrency	cube	DocumentCurrency	SD Document Currency
_DocumentCurrency	cube	_DocumentCurrency
ConditionTermRateCurrency	cube	ConditionTermRateCurrency	CPE Term - Currency
_ConditionTermRateCurrency	cube	_ConditionTermRateCurrency
SpreadCurrency			CPE Term - Currency
_SpreadCurrency
BusinessArea	cube	BusinessArea	Business Area
PurchasingOrganization	cube	PurchasingOrganization	Purchasing Organization
MaterialGroup	cube	MaterialGroup	Material Group
IsIntercompanyTransfer	cube	IsIntercompanyTransfer	Intercompany Transfer
ExchRateMaturityDate	cube	ExchRateMaturityDate	Maturity Date
FixedExchRateDate	cube	FixedExchRateDate	Date when forward FX rate is frozen
QuotationPeriodReferenceDate	cube	QuotationPeriodReferenceDate	Reference Date
ComparQtanPeriodReferenceDate	cube	ComparQtanPeriodReferenceDate	Comparative Valuation Reference Date
QuotationPeriodStartDate	cube	QuotationPeriodStartDate	Start Date of Quotation Period
QuotationPeriodEndDate	cube	QuotationPeriodEndDate	End Date of Quotation Period
QuotationGroup	cube	QuotationGroup	Quotation Group (Technical Key Field)
QuotationGroupCalculationRule	cube	QuotationGroupCalculationRule	Quotation Group Operation
CndnTermRateFixationDate	cube	CndnTermRateFixationDate	Rate Fixation Date
CndnTermRateFixationTime	cube	CndnTermRateFixationTime	Rate Fixation Time
CndnTermExchRateFixationDate	cube	CndnTermExchRateFixationDate	FX Fixation Date
CndnTermExchRateFixationTime	cube	CndnTermExchRateFixationTime	FX Fixation Time
MTMConditionGroupCategoryName			Short Text for Fixed Values
MTMConditionGroup	cube	MTMConditionGroup	MtM Condition Group
_MTMConditionGroup	cube	_MTMConditionGroup
MTMCalcGrpMarketPriceCondition	cube	MTMCalcGrpMarketPriceCondition	Market Price Condition within a calculation group
PriceIsRealized	cube	PriceIsRealized	Indicates that the MtM value is realized
PricingKey	cube	PricingKey	A key required to access versioned pricing data
Version	cube	Version	Version of an MtM Valuation Record

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_ContrBPPnLValueCube.
-- 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: IACMBPPNLVALCUBE
-- Parameters: P_Language : spras

CREATE VIEW I_ContrBPPnLValueCube AS
SELECT
  cube.EvaluationDate AS EvaluationDate,
  cube.ComparativeEvaluationDate AS ComparativeEvaluationDate,
  cube.CompanyCode AS CompanyCode,
  cube.ProfitCenter AS ProfitCenter,
  cube.Plant AS Plant,
  cube._Plant AS _Plant,
  cube.Commodity AS Commodity,
  cube._Commodity AS _Commodity,
  cube.MTMCalculationGroup AS MTMCalculationGroup,
  cube._MTMCalculationGroup AS _MTMCalculationGroup,
  cube.PnLEventGroup AS PnLEventGroup,
  cube.MTMAdjustmentType AS MTMAdjustmentType,
  cube._MTMAdjustmentType AS _MTMAdjustmentType,
  cube.OriginReferenceDocument AS OriginReferenceDocument,
  cube.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  cube.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  cube._OriginReferenceDocBusObjType AS _OriginReferenceDocBusObjType,
  cube.SourceDocument AS SourceDocument,
  cube.SourceDocumentItem AS SourceDocumentItem,
  cube.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  cube._SourceDocumentBusObjType AS _SourceDocumentBusObjType,
  cube.ConditionTermRateFixation AS ConditionTermRateFixation,
  cube.ConditionType AS ConditionType,
  cube.MarketDCS AS MarketDCS,
  cube._MarketDCS AS _MarketDCS,
  cube.MktMarketIdentifierCode AS MktMarketIdentifierCode,
  cube._MktMarketIdentifierCode AS _MktMarketIdentifierCode,
  cube.MktDrvtvContrMaturityCode AS MktDrvtvContrMaturityCode,
  cube.MktMaturityKeyDate AS MktMaturityKeyDate,
  cube.MarketBasisType AS MarketBasisType,
  cube.MarketBasisID AS MarketBasisID,
  cube._BasisID AS _BasisID,
  cube.MktQuotationPriceType AS MktQuotationPriceType,
  cube.MTMDataSourceType AS MTMDataSourceType,
  cube._MTMDataSourceType AS _MTMDataSourceType,
  cube.ComparativeMarketDCS AS ComparativeMarketDCS,
  cube._ComparativeMarketDCS AS _ComparativeMarketDCS,
  cube.ComparMktMarketIdentifierCode AS ComparMktMarketIdentifierCode,
  cube._ComparMktMarketIdentifierCode AS _ComparMktMarketIdentifierCode,
  cube.ComparMktMaturityKeyDate AS ComparMktMaturityKeyDate,
  cube.ComparMktDrvtvContrCode AS ComparMktDrvtvContrCode,
  cube.ComparMarketBasisID AS ComparMarketBasisID,
  cube.ComparMarketBasisType AS ComparMarketBasisType,
  cube.ComparMktQuotationPriceType AS ComparMktQuotationPriceType,
  cube.PricingStatus AS PricingStatus,
  cube._PricingStatus AS _PricingStatus,
  cube.SubConditionType AS SubConditionType,
  cube.HasError AS HasError,
  cube.SystemMessageNumber AS SystemMessageNumber,
  cube._CmmdtyMtmMessage AS _CmmdtyMtmMessage,
  cube.CommodityUnit AS CommodityUnit,
  cube._CommodityUnit AS _CommodityUnit,
  cube.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  cube._ConditionTermRateQuantityUnit AS _ConditionTermRateQuantityUnit,
  cube.StatisticsCurrency AS StatisticsCurrency,
  cube._StatisticsCurrency AS _StatisticsCurrency,
  cube.PnLValue AS PnLValue,
  cube.MktPricePnLValue AS MktPricePnLValue,
  cube.SpreadPnLValue AS SpreadPnLValue,
  cube.DocToStstcFXPnLValue AS DocToStstcFXPnLValue,
  cube.MktToStstcFXPnLValue AS MktToStstcFXPnLValue,
  cube.MktValAdjmtFXBroughtFwdVal AS MktValAdjmtFXBroughtFwdVal,
  cube.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  cube.ComparCmmdtyQuantityInTermUnit AS ComparCmmdtyQuantityInTermUnit,
  cube.PnLCalculationRelevantQuantity AS PnLCalculationRelevantQuantity,
  cube.MarketConditionTermRate AS MarketConditionTermRate,
  cube.ComparMktConditionTermRate AS ComparMktConditionTermRate,
  cube.PnLCalculationRelevantValue AS PnLCalculationRelevantValue,
  cube.ContractConditionTermRate AS ContractConditionTermRate,
  cube.ComparContrCndnTermRate AS ComparContrCndnTermRate,
  cube.MktMarketToDocExchRate AS MktMarketToDocExchRate,
  cube.ComparMktMarketToDocExchRate AS ComparMktMarketToDocExchRate,
  cube.ContractMktToDocExchRate AS ContractMktToDocExchRate,
  cube.MktDocToStstcExchRate AS MktDocToStstcExchRate,
  cube.ComparMktDocToStstcExchRate AS ComparMktDocToStstcExchRate,
  cube.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
  cube.ComparMktMarketToStstcExchRate AS ComparMktMarketToStstcExchRate,
  cube.MktAdjmtValDocToStstcExchRate AS MktAdjmtValDocToStstcExchRate,
  cube.MktAdjmtValueCndnTermValue AS MktAdjmtValueCndnTermValue,
  cube.ConditionTermFactor AS ConditionTermFactor,
  cube.ComparConditionTermFactor AS ComparConditionTermFactor,
  cube.SalesOrganization AS SalesOrganization,
  cube.DistributionChannel AS DistributionChannel,
  cube.Division AS Division,
  cube.Creditor AS Creditor,
  cube._Creditor AS _Creditor,
  cube.SoldToParty AS SoldToParty,
  cube._SoldToParty AS _SoldToParty,
  cube.Material AS Material,
  cube.StorageLocation AS StorageLocation,
  cube._StorageLocation AS _StorageLocation,
  cube.Batch AS Batch,
  cube.IncotermsClassification AS IncotermsClassification,
  cube._IncotermsClassification AS _IncotermsClassification,
  cube.IncotermsTransferLocation AS IncotermsTransferLocation,
  cube.ConditionApplication AS ConditionApplication,
  cube.ReferenceDocument AS ReferenceDocument,
  cube.ReferenceDocumentItem AS ReferenceDocumentItem,
  cube.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  cube._ReferenceDocBusObjType AS _ReferenceDocBusObjType,
  cube.DeliveryDate AS DeliveryDate,
  cube.ExpectedPaymentDate AS ExpectedPaymentDate,
  cube.DocumentCurrency AS DocumentCurrency,
  cube._DocumentCurrency AS _DocumentCurrency,
  cube.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  cube._ConditionTermRateCurrency AS _ConditionTermRateCurrency,
  cube.BusinessArea AS BusinessArea,
  cube.PurchasingOrganization AS PurchasingOrganization,
  cube.MaterialGroup AS MaterialGroup,
  cube.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  cube.ExchRateMaturityDate AS ExchRateMaturityDate,
  cube.FixedExchRateDate AS FixedExchRateDate,
  cube.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  cube.ComparQtanPeriodReferenceDate AS ComparQtanPeriodReferenceDate,
  cube.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  cube.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  cube.QuotationGroup AS QuotationGroup,
  cube.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  cube.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  cube.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  cube.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  cube.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  cube._MTMConditionGroupCategory._MtmConditionGroupCategoryT[1:Language = :P_Language].MTMConditionGroupCategoryName AS MTMConditionGroupCategoryName,
  cube.MTMConditionGroup AS MTMConditionGroup,
  cube._MTMConditionGroup AS _MTMConditionGroup,
  cube.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  cube.PriceIsRealized AS PriceIsRealized,
  cube.PricingKey AS PricingKey,
  cube.Version AS Version
FROM I_Cmmdtybppnlvalue_Cube
LEFT OUTER JOIN I_ContrPrcAttribLogSync AS LogSync ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS _vlogp ON cube.PricingKey = _vlogp.PricingKey AND cube.Version = _vlogp.Version AND cube.PricingDocumentItem = _vlogp.PricingDocumentItem AND cube.ConditionType = _vlogp.ConditionType AND cube.SubConditionType = _vlogp.SubConditionType AND cube.CompanyCode = _vlogp.CompanyCode AND cube.Plant = _vlogp.Plant AND cube.Material = _vlogp.Material  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _Companycode ON cube.CompanyCode = _Companycode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [0..1]
;

Depth:

I_ContrBPPnLValueCube view

I_Cmmdtybppnlvalue_Cube view
I_ContrPrcAttribLogSync view

C_CmmdtyBegPosPnLValueQry view