P_CmmdtyBegPosPnLValue_Ext

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

CREATE VIEW P_CmmdtyBegPosPnLValue_Ext AS
SELECT
  aggregate.PricingKey AS PricingKey,
  aggregate.Version AS Version,
  aggregate.PricingDocumentItem AS PricingDocumentItem,
  aggregate.ConditionType AS ConditionType,
  aggregate.SubConditionType AS SubConditionType,
  aggregate.VersStockRecordUUID AS VersStockRecordUUID,
  aggregate.EvaluationDate AS EvaluationDate,
  aggregate.ComparativeEvaluationDate AS ComparativeEvaluationDate,
  aggregate.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  aggregate.ComparQtanPeriodReferenceDate AS ComparQtanPeriodReferenceDate,
  aggregate.SpreadCurrency AS SpreadCurrency,
  aggregate.CtrConditionTermRateIsFixed AS CtrConditionTermRateIsFixed,
  aggregate.CtrCondTermExchRateIsFixed AS CtrCondTermExchRateIsFixed,
  aggregate.ComparImplicitFixation AS ComparImplicitFixation,
  aggregate.ImplicitFixation AS ImplicitFixation,
  case when vlogp.ConditionTermRateCurrency = vlogp.StatisticsCurrency then 1 else cast (( cast (aggregate.MktMarketToDocExchRate as abap.dec(18,8)) * cast (aggregate.MktDocToStstcExchRate as abap.dec(18,8))) as abap.dec(20,8)) end as MktMarketToStstcExchRate AS dec208endasMktMarketToStstcExchRate,
  aggregate.MarketDCS AS MarketDCS,
  aggregate.MktMarketIdentifierCode AS MktMarketIdentifierCode,
  aggregate.MktDrvtvContrMaturityCode AS MktDrvtvContrMaturityCode,
  aggregate.MktMaturityKeyDate AS MktMaturityKeyDate,
  aggregate.MarketBasisType AS MarketBasisType,
  aggregate.MarketBasisID AS MarketBasisID,
  aggregate.MktQuotationPriceType AS MktQuotationPriceType,
  aggregate.HasError AS HasError,
  cast (substring(aggregate.SystemMessageNumber, 2, 3) as cds_systemmessagenumber ) AS SystemMessageNumber,
  vlogp.MTMDataSourceType AS MTMDataSourceType,
  vlogp.ValidityStartDate AS ValidityStartDate,
  vlogp.ValidityStartDateTime AS ValidityStartDateTime,
  vlogp.ValidityEndDate AS ValidityEndDate,
  vlogp.ValidityEndDateTime AS ValidityEndDateTime,
  vlogp.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  vlogp.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  vlogp.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  vlogp.MaximumVersion AS MaximumVersion,
  vlogp.PreviousVersion AS PreviousVersion,
  vlogp.PrevVersionSubConditionType AS PrevVersionSubConditionType,
  vlogp.CompanyCode AS CompanyCode,
  vlogp.SalesOrganization AS SalesOrganization,
  vlogp.DistributionChannel AS DistributionChannel,
  vlogp.Division AS Division,
  vlogp.Creditor AS Creditor,
  vlogp.SoldToParty AS SoldToParty,
  vlogp.Material AS Material,
  vlogp.PhysicalCommodity AS PhysicalCommodity,
  vlogp.Plant AS Plant,
  vlogp.StorageLocation AS StorageLocation,
  vlogp.Batch AS Batch,
  vlogp.IncotermsClassification AS IncotermsClassification,
  vlogp.IncotermsTransferLocation AS IncotermsTransferLocation,
  vlogp.ConditionApplication AS ConditionApplication,
  vlogp.SourceDocument AS SourceDocument,
  cast (vlogp.PricingDocumentItem as cds_source_document_item) AS SourceDocumentItem,
  vlogp.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  vlogp.OriginReferenceDocument AS OriginReferenceDocument,
  vlogp.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  vlogp.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  vlogp.ReferenceDocument AS ReferenceDocument,
  vlogp.ReferenceDocumentItem AS ReferenceDocumentItem,
  vlogp.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  vlogp.DeliveryDate AS DeliveryDate,
  vlogp.ExpectedPaymentDate AS ExpectedPaymentDate,
  vlogp.StatisticsCurrency AS StatisticsCurrency,
  vlogp.DocumentCurrency AS DocumentCurrency,
  vlogp.ProfitCenter AS ProfitCenter,
  vlogp.BusinessArea AS BusinessArea,
  vlogp.PurchasingOrganization AS PurchasingOrganization,
  vlogp.MaterialGroup AS MaterialGroup,
  vlogp.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  vlogp.ConditionCalculationType AS ConditionCalculationType,
  vlogp.ConditionRate AS ConditionRate,
  vlogp.ConditionCurrency AS ConditionCurrency,
  vlogp.ConditionQuantity AS ConditionQuantity,
  vlogp.ConditionQuantityUnit AS ConditionQuantityUnit,
  vlogp.ConditionTermRate AS ConditionTermRate,
  vlogp.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  vlogp.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  vlogp.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  vlogp.ConditionTermValue AS ConditionTermValue,
  vlogp.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  vlogp.ConditionTermName AS ConditionTermName,
  vlogp.ConditionTermStatus AS ConditionTermStatus,
  vlogp.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  vlogp.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
  vlogp.ConditionTermRateNmrtr AS ConditionTermRateNmrtr,
  vlogp.ConditionTermRateDnmntr AS ConditionTermRateDnmntr,
  vlogp.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  vlogp.MaturitySelectionType AS MaturitySelectionType,
  vlogp.ExchRateMaturityDate AS ExchRateMaturityDate,
  vlogp.FixedExchRateDate AS FixedExchRateDate,
  vlogp.QuotationKeyType AS QuotationKeyType,
  vlogp.QuotationDateList AS QuotationDateList,
  vlogp.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  vlogp.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  vlogp.DerivativeContrSpecification AS ComparativeMarketDCS,
  vlogp.MarketIdentifierCode AS ComparMktMarketIdentifierCode,
  vlogp.MaturityKeyDate AS ComparMktMaturityKeyDate,
  vlogp.DerivativeContractMaturityCode AS ComparMktDrvtvContrCode,
  vlogp.BasisID AS ComparMarketBasisID,
  vlogp.BasisType AS ComparMarketBasisType,
  vlogp.QuotationPriceType AS ComparMktQuotationPriceType,
  vlogp.QuotationGroup AS QuotationGroup,
  vlogp.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  vlogp.ConditionTermRateFixation AS ConditionTermRateFixation,
  vlogp.PricingStatus AS PricingStatus,
  vlogp.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  vlogp.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  vlogp.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  vlogp.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  vlogp.CommodityQuantity AS CommodityQuantity,
  vlogp.CommodityUnit AS CommodityUnit,
  vlogp.QuantitySign AS QuantitySign,
  vlogp.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  vlogp.MTMConditionGroup AS MTMConditionGroup,
  vlogp.MTMCalculationGroup AS MTMCalculationGroup,
  vlogp.MTMAdjustmentType AS MTMAdjustmentType,
  vlogp.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  vlogp.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  vlogp.PriceIsRealized AS PriceIsRealized,
  vlogp.PnLEventType AS PnLEventType,
  vlogp.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant
FROM P_CmmdtyBegPosPnLValue_Aggr
;