P_Cmmdtybppnlvalue

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 P_Cmmdtybppnlvalue.
-- 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: PCMMBPPNLVALUE
-- Parameters: P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate

CREATE VIEW P_Cmmdtybppnlvalue AS
SELECT
  source.PricingKey AS PricingKey,
  source.Version AS Version,
  PricingDocumentItem,
  source.ConditionType AS ConditionType,
  source.SubConditionType AS SubConditionType,
  source.VersStockRecordUUID AS VersStockRecordUUID,
  cast ( cast (source.BeginningPosBroughtForwardVal as abap.curr(15,2)) as cmm_cds_pnl_value) AS OverviewPnLValue,
  cast ( cast (source.BeginningPosBroughtForwardVal as abap.curr(15,2)) as cmm_cds_pnl_value) AS PnLValue,
  cast (source.MarketPriceBroughtFwdVal as cds_mkt_price_value) AS MktPricePnLValue,
  cast (source.SpreadBroughtForwardVal as cds_spread_value) AS SpreadPnLValue,
  cast (source.DocToStstcFXBroughtFwdVal as cds_doc_to_stat_fx_value) AS DocToStstcFXPnLValue,
  cast (source.MktToStstcFXBroughtFwdVal as cds_mark_to_stat_fx_value) AS MktToStstcFXPnLValue,
  cast (source.MktValAdjmtFXBroughtFwdVal as cds_mav_fx_bf_value) AS MktValAdjmtFXBroughtFwdVal,
  cast (source.CommodityQuantityInTermUnit as cds_cmmdtyqty_in_termuom) AS CommodityQuantityInTermUnit,
  cast ( cast (source.MarketConditionTermRate as abap.dec(31,8)) as cds_market_termrate ) AS MarketConditionTermRate,
  source.ComparMktConditionTermRate AS ComparMktConditionTermRate,
  source.ContrSpreadCndnTermRate AS ContrSpreadCndnTermRate,
  source.ComparContrSpreadCndnTermRate AS ComparContrSpreadCndnTermRate,
  source.FixedMktSpreadCndnTermRate AS FixedMktSpreadCndnTermRate,
  source.FloatingMktSpreadCndnTermRate AS FloatingMktSpreadCndnTermRate,
  source.SpreadCurrency AS SpreadCurrency,
  source.ComparContrCndnTermRate AS ComparContrCndnTermRate,
  cast (source.MktDocToStstcExchRate as cds_mkt_doc_to_stat_exchrate) AS MktDocToStstcExchRate,
  cast (source.ComparMktDocToStstcExchRate as cds_comp_mkt_doc_to_stat_rate) AS ComparMktDocToStstcExchRate,
  cast (source.MktMarketToDocExchRate as cds_mkt_mark_to_doc_exchrate) AS MktMarketToDocExchRate,
  cast (source.ComparMktMarketToDocExchRate as cds_comp_mkt_mark_to_doc_rate) AS ComparMktMarketToDocExchRate,
  cast (source.CommodityQuantityInTermUnit as cds_comp_ctr_quan_comm) AS ComparCmmdtyQuantityInTermUnit,
  cast (cast (source.CommodityQuantityInTermUnit as abap.quan (17, 3))as cmm_cds_calcrelqty) AS PnLCalculationRelevantQuantity,
  cast (cast ((source.MarketConditionTermRate - source.ComparMktConditionTermRate) as abap.dec (31, 8)) as cds_calcrelval_df34) AS PnLCalculationRelevantValue,
  cast (cast (source.MktMarketToStstcExchRate as abap.dec(20,8)) as cds_mkt_mkt_to_stat_exchrate) AS MktMarketToStstcExchRate,
  cast (source.ComparMktMarketToStstcExchRate as cds_comp_mkt_mkt_to_stat_rate) AS ComparMktMarketToStstcExchRate,
  cast ( source.EvaluationDate as cmm_snapshot_end) AS EvaluationDate,
  cast ( source.ComparativeEvaluationDate as cmm_snapshot_start) AS ComparativeEvaluationDate,
  source.ContractMktToDocExchRate AS ContractMktToDocExchRate,
  source.MktAdjmtValDocToStstcExchRate AS MktAdjmtValDocToStstcExchRate,
  source.MktAdjmtValueCndnTermValue AS MktAdjmtValueCndnTermValue,
  source.MarketDCS AS MarketDCS,
  source.MktMarketIdentifierCode AS MktMarketIdentifierCode,
  source.MktDrvtvContrMaturityCode AS MktDrvtvContrMaturityCode,
  source.MktMaturityKeyDate AS MktMaturityKeyDate,
  source.MarketBasisType AS MarketBasisType,
  source.MarketBasisID AS MarketBasisID,
  source.MktQuotationPriceType AS MktQuotationPriceType,
  cast (source.HasError as cmm_error_occured) AS HasError,
  cast (source.SystemMessageNumber as cds_systemmessagenumber) AS SystemMessageNumber,
  source.MTMDataSourceType AS MTMDataSourceType,
  source.ValidityStartDate AS ValidityStartDate,
  source.ValidityStartDateTime AS ValidityStartDateTime,
  source.ValidityEndDate AS ValidityEndDate,
  source.ValidityEndDateTime AS ValidityEndDateTime,
  source.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  source.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  source.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  source.CompanyCode AS CompanyCode,
  source.SalesOrganization AS SalesOrganization,
  source.DistributionChannel AS DistributionChannel,
  source.Division AS Division,
  source.Creditor AS Creditor,
  source.SoldToParty AS SoldToParty,
  source.Material AS Material,
  source.PhysicalCommodity AS Commodity,
  source.Plant AS Plant,
  source.StorageLocation AS StorageLocation,
  source.Batch AS Batch,
  source.IncotermsClassification AS IncotermsClassification,
  source.IncotermsTransferLocation AS IncotermsTransferLocation,
  source.ConditionApplication AS ConditionApplication,
  source.SourceDocument AS SourceDocument,
  source.SourceDocumentItem AS SourceDocumentItem,
  source.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  source.OriginReferenceDocument AS OriginReferenceDocument,
  cast (source.OriginReferenceDocumentItem as cds_origin_document_item) AS OriginReferenceDocumentItem,
  source.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  source.ReferenceDocument AS ReferenceDocument,
  cast (source.ReferenceDocumentItem as cds_ref_document_item) AS ReferenceDocumentItem,
  source.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  source.DeliveryDate AS DeliveryDate,
  source.ExpectedPaymentDate AS ExpectedPaymentDate,
  source.StatisticsCurrency AS StatisticsCurrency,
  source.DocumentCurrency AS DocumentCurrency,
  _CompanyCode.ControllingArea AS ControllingArea,
  source.ProfitCenter AS ProfitCenter,
  source.BusinessArea AS BusinessArea,
  source.PurchasingOrganization AS PurchasingOrganization,
  source.MaterialGroup AS MaterialGroup,
  source.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  source.ConditionCalculationType AS ConditionCalculationType,
  source.ConditionRate AS ConditionRate,
  source.ConditionCurrency AS ConditionCurrency,
  source.ConditionQuantity AS ConditionQuantity,
  source.ConditionQuantityUnit AS ConditionQuantityUnit,
  cast ( cast (source.ConditionTermRate as abap.dec(31,8)) as cds_market_termrate ) AS ConditionTermRate,
  source.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  source.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  source.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  source.ConditionTermValue AS ConditionTermValue,
  source.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  source.ConditionTermName AS ConditionTermName,
  source.ConditionTermStatus AS ConditionTermStatus,
  source.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  source.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
  source.ConditionTermRateNmrtr AS ConditionTermRateNmrtr,
  source.ConditionTermRateDnmntr AS ConditionTermRateDnmntr,
  source.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  source.MaturitySelectionType AS MaturitySelectionType,
  source.ExchRateMaturityDate AS ExchRateMaturityDate,
  source.FixedExchRateDate AS FixedExchRateDate,
  source.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  source.QuotationKeyType AS QuotationKeyType,
  source.QuotationDateList AS QuotationDateList,
  source.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  source.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  source.ComparativeMarketDCS AS ComparativeMarketDCS,
  source.ComparMktMarketIdentifierCode AS ComparMktMarketIdentifierCode,
  source.ComparMktMaturityKeyDate AS ComparMktMaturityKeyDate,
  source.ComparMktDrvtvContrCode AS ComparMktDrvtvContrCode,
  source.ComparMarketBasisID AS ComparMarketBasisID,
  source.ComparMarketBasisType AS ComparMarketBasisType,
  source.ComparMktQuotationPriceType AS ComparMktQuotationPriceType,
  source.ComparQtanPeriodReferenceDate AS ComparQtanPeriodReferenceDate,
  source.QuotationGroup AS QuotationGroup,
  source.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  source.ConditionTermRateFixation AS ConditionTermRateFixation,
  source.PricingStatus AS PricingStatus,
  source.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  source.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  source.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  source.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  source.CommodityQuantity AS CommodityQuantity,
  source.CommodityUnit AS CommodityUnit,
  source.QuantitySign AS QuantitySign,
  source.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  source.MTMConditionGroup AS MTMConditionGroup,
  source.MTMCalculationGroup AS MTMCalculationGroup,
  source.MTMAdjustmentType AS MTMAdjustmentType,
  source.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  source.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  source.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  source.PriceIsRealized AS PriceIsRealized,
  cast ( '10' as cmm_event_group ) AS PnLEventGroup,
  pnleventtype.PnLEventCategory AS PnLEventCategory,
  source.PnLEventType AS PnLEventType,
  source.ComparImplicitFixation AS ComparImplicitFixation,
  source.ImplicitFixation AS ImplicitFixation,
  source.ConditionTermFactor AS ConditionTermFactor,
  source.ComparConditionTermFactor AS ComparConditionTermFactor,
  source.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  source.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  source.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  source.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  source.PriceSettingMethod AS PriceSettingMethod,
  source.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  source.ValidToDateTime AS ValidToDateTime,
  source.PricingProcedure AS PricingProcedure,
  source.PricingConditionTerm AS PricingConditionTerm,
  source.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
  source.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber
FROM P_CmmdtyBegPosPnLValue_Sum
LEFT OUTER JOIN I_PnLEventType AS pnleventtype ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PnLEventType AS _PnLEventType ON PnLEventType = _PnLEventType.PnLEventType  -- association [1..1]
LEFT OUTER JOIN I_PnLEventCategory AS _PnLEventCategory ON PnLEventCategory = _PnLEventCategory.PnLEventCategory  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyMtmMessage AS _CmmdtyMtmMessage ON SystemMessageNumber = _CmmdtyMtmMessage.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionTermRateQuantityUnit ON ConditionTermRateQuantityUnit = _ConditionTermRateQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionTermRateCurrency ON ConditionTermRateCurrency = _ConditionTermRateCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityUnit ON CommodityUnit = _CommodityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_MtmDataSourceType AS _MTMDataSourceType ON MTMDataSourceType = _MTMDataSourceType.MTMDataSourceType  -- association [0..1]
LEFT OUTER JOIN I_MtmConditionGroup AS _MTMConditionGroup ON MTMConditionGroup = _MTMConditionGroup.MTMConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_Mtmconditiongroupcategory AS _MTMConditionGroupCategory ON MTMConditionGroupCategory = _MTMConditionGroupCategory.MTMConditionGroupCategory  -- association [0..1]
LEFT OUTER JOIN I_MtmAdjustmentType AS _MTMAdjustmentType ON MTMAdjustmentType = _MTMAdjustmentType.MTMAdjustmentType  -- association [0..1]
LEFT OUTER JOIN I_MtmCalculationGroup AS _MTMCalculationGroup ON MTMCalculationGroup = _MTMCalculationGroup.MTMCalculationGroup  -- association [0..1]
LEFT OUTER JOIN I_Cmmdty AS _Commodity ON Commodity = _Commodity.Commodity  -- association [0..1]
LEFT OUTER JOIN I_BasisID AS _BasisID ON MarketBasisID = _BasisID.BasisID  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _SourceDocumentBusObjType ON SourceDocumentBusObjType = _SourceDocumentBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _ReferenceDocBusObjType ON ReferenceDocBusObjType = _ReferenceDocBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _OriginReferenceDocBusObjType ON OriginReferenceDocBusObjType = _OriginReferenceDocBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_PricingStatus AS _PricingStatus ON PricingStatus = _PricingStatus.PricingStatus  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Creditor ON Creditor = _Creditor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON _CompanyCode.ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _CompanyCode.ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _MarketDCS ON MarketDCS = _MarketDCS.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MktMarketIdentifierCode ON MktMarketIdentifierCode = _MktMarketIdentifierCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _ComparativeMarketDCS ON ComparativeMarketDCS = _ComparativeMarketDCS.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _ComparMktMarketIdentifierCode ON ComparMktMarketIdentifierCode = _ComparMktMarketIdentifierCode.MarketIdentifierCode  -- association [0..1]
;