I_CmmdtyPnLFinValues

DDL: I_CMMDTYPNLFINVALUES SQL: ICMMDTYPNLFIN Type: view COMPOSITE Package: FTR_COMMODITY_CDS
66 Fields 1 Data Sources 1 Associations

Derivative PnL Interface Layer

I_CmmdtyPnLFinValues is a Composite CDS View that provides data about "Derivative PnL Interface Layer" in SAP S/4HANA. It reads from 1 data source (P_CmmdtyPnLFinValue) and exposes 66 fields with key fields CompanyCode, CommodityPriceExposure, CommodityExposureCategory, CommodityPriceSubExposure, CommodityPriceExposureVersion. It has 1 association to related views. Part of development package FTR_COMMODITY_CDS.

Data Sources (1)

SourceAliasJoin Type
P_CmmdtyPnLFinValue P_CmmdtyPnLFinValue from

Parameters (4)

NameTypeDefault
P_EvaluationDate cds_evaluation_date
P_EndOfDaySnapshotToDate cds_evaluation_date_comp
P_DisplayView cds_view_uom
P_DisplayCurrency cds_view_currency

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_FinancialInstrCharacteristic _Extension $projection.CompanyCode = _Extension.CompanyCode and $projection.CommodityPriceExposure = _Extension.CommodityPriceExposure and $projection.CommodityPriceSubExposure = _Extension.CommodityPriceSubExposure and $projection.CommodityExposureCategory = _Extension.CommodityExposureCategory and $projection.CommodityPriceExposureVersion = _Extension.CommodityPriceExposureVersion

Annotations (10)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICMMDTYPNLFIN view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Derivative PnL Interface Layer view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode PnL CompanyCode Receiver Company Code
KEY CommodityPriceExposure PnL CommodityPriceExposure Exposure ID
KEY CommodityExposureCategory PnL CommodityExposureCategory
KEY CommodityPriceSubExposure PnL CommodityPriceSubExposure
KEY CommodityPriceExposureVersion PnL CommodityPriceExposureVersion Exposure Version
ValidityStartDateTime PnL ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime PnL ValidityEndDateTime Valid To Timestamp
ValidityStartDate PnL ValidityStartDate Validity Start Date
ValidityStartTime PnL ValidityStartTime Valid From Time
ValidityEndDate PnL ValidityEndDate ValidTo
ValidityEndTime PnL ValidityEndTime Valid To Time
MaximumVersion PnL MaximumVersion Highest Version
RiskAnalyzerVersionUUID PnL RiskAnalyzerVersionUUID Version GUID
ExposureDueDate PnL ExposureDueDate
ReportingDate PnL ReportingDate
Commodity PnL Commodity Commodity Code
CashFlowDirection PnL CashFlowDirection
TreasuryPositionLongShortCode PnL TreasuryPositionLongShortCode
DerivativeContrSpecification PnL DerivativeContrSpecification DCS ID
MarketIdentifierCode PnL MarketIdentifierCode MIC
TimeToMaturity PnL TimeToMaturity Time to Maturity
CmmdtyForwardIndexTiming PnL CmmdtyForwardIndexTiming
MaturityKeyDate PnL MaturityKeyDate Maturity Key Date
DerivativeContractMaturityCode PnL DerivativeContractMaturityCode Contr. Maturity Code
FinancialInstrProductCategory PnL FinancialInstrProductCategory
FinancialAssetsMgmtProductType PnL FinancialAssetsMgmtProductType
FinInstrTransactionCategory PnL FinInstrTransactionCategory
FinancialInstrumentProductType PnL FinancialInstrumentProductType
FinancialInstrActivityCategory PnL FinancialInstrActivityCategory
FinancialObject PnL FinancialObject
PnLEventCategory PnL PnLEventCategory
PnLEventType PnL PnLEventType
TermStartDate PnL TermStartDate
TermEndDate PnL TermEndDate
DeliveryDate PnL DeliveryDate Delivery Date
NumberOfCommodityContracts PnL NumberOfCommodityContracts
TreasuryPositionAccount PnL TreasuryPositionAccount
DerivativeContract PnL DerivativeContract
OptionStrikePrice PnL OptionStrikePrice
OptionStrikeCurrency PnL OptionStrikeCurrency
OptionPutCallCode PnL OptionPutCallCode
OptionExerciseType PnL OptionExerciseType
EvaluationDate PnL EvaluationDate
FinInstrExternalReference PnL FinInstrExternalReference
DisplayView PnL DisplayView
DisplayCurrency PnL DisplayCurrency Display Currency
HasError PnL HasError TRUE
HasErrorDescription PnL HasErrorDescription
PnLValue PnL PnLValue
PnLCalculationRelevantValue PnL PnLCalculationRelevantValue
PnLCalculationRelevantQuantity PnL PnLCalculationRelevantQuantity
PnLRelevantComparativeTermVal PnL PnLRelevantComparativeTermVal
PnLRelevantComparativeTermQty PnL PnLRelevantComparativeTermQty
PnLRelevantTermValue PnL PnLRelevantTermValue
PnLRelevantTermQuantity PnL PnLRelevantTermQuantity
Currency PnL Currency Valuation Crcy
CommodityPriceExposureUnit PnL CommodityPriceExposureUnit
ExternalKeyFigureValue PnL ExternalKeyFigureValue
_CompanyCode PnL _CompanyCode
_DerivativeContrSpecification PnL _DerivativeContrSpecification
_FinAssetsMgmtProductType PnL _FinAssetsMgmtProductType
_MarketIdentifierCode PnL _MarketIdentifierCode
_PhysicalCommodity PnL _PhysicalCommodity
_PnLEventType PnL _PnLEventType
_PnLEventCategory PnL _PnLEventCategory
_UnitOfMeasure PnL _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_CmmdtyPnLFinValues.
-- 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: ICMMDTYPNLFIN
-- 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_CmmdtyPnLFinValues 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,
  PnL.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  PnL.TreasuryPositionAccount AS TreasuryPositionAccount,
  PnL.DerivativeContract AS DerivativeContract,
  PnL.OptionStrikePrice 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.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.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  PnL._CompanyCode AS _CompanyCode,
  PnL._DerivativeContrSpecification AS _DerivativeContrSpecification,
  PnL._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
  PnL._MarketIdentifierCode AS _MarketIdentifierCode,
  PnL._PhysicalCommodity AS _PhysicalCommodity,
  PnL._PnLEventType AS _PnLEventType,
  PnL._PnLEventCategory AS _PnLEventCategory,
  PnL._UnitOfMeasure AS _UnitOfMeasure
FROM P_CmmdtyPnLFinValue
LEFT OUTER JOIN E_FinancialInstrCharacteristic AS _Extension ON CompanyCode = _Extension.CompanyCode AND CommodityPriceExposure = _Extension.CommodityPriceExposure AND CommodityPriceSubExposure = _Extension.CommodityPriceSubExposure AND CommodityExposureCategory = _Extension.CommodityExposureCategory AND CommodityPriceExposureVersion = _Extension.CommodityPriceExposureVersion  -- association [1..1]
;

Learn More