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_Sum.
-- 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: PCMMPNLBPSUM
-- 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_Sum AS
SELECT
source.PricingKey AS PricingKey,
source.Version AS Version,
cast (source.PricingDocumentItem as cds_source_document_item) AS PricingDocumentItem,
cast (source.ConditionType as kscha) AS ConditionType,
source.SubConditionType AS SubConditionType,
source.VersStockRecordUUID AS VersStockRecordUUID,
case when MarketPriceBroughtFwdVal <> 0 then cast (source.MarketPriceBroughtFwdVal as abap.dec (31, 8)) else cast (source.ContPriceBroughtFwdVal as abap.dec (31, 8)) end as MarketPriceBroughtFwdVal AS dec318endasMarketPriceBroughtFwdVal,
cast ( cast (source.SpreadBroughtForwardVal as abap.dec (31, 8)) as cds_spread_bf_value) AS SpreadBroughtForwardVal,
cast ( cast (source.DocToStstcFXBroughtFwdVal as abap.dec (31, 8)) as cds_doc_to_stat_fx_bf_value) AS DocToStstcFXBroughtFwdVal,
cast ( cast (MktValAdjmtFXBroughtFwdVal as abap.dec (31, 8)) as cds_mav_fx_bf_value) AS MktValAdjmtFXBroughtFwdVal,
source.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
cast (source.MarketConditionTermRate as cds_market_termrate) AS MarketConditionTermRate,
cast (source.ComparMktConditionTermRate as cds_comp_market_termrate) AS ComparMktConditionTermRate,
cast (source.ContrSpreadCndnTermRate as cds_contract_spread_rate) AS ContrSpreadCndnTermRate,
cast (source.ComparContrSpreadCndnTermRate as cds_comp_contract_spread_rate) AS ComparContrSpreadCndnTermRate,
cast (source.FixedMktSpreadcndntermrate as cds_fix_market_spread_termrate) AS FixedMktSpreadCndnTermRate,
cast (source.FloatingMktSpreadCndnTermRate as cds_flt_market_spread_termrate) AS FloatingMktSpreadCndnTermRate,
source.SpreadCurrency AS SpreadCurrency,
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 ( cast (source.MktMarketToStstcExchRate as abap.dec (31, 8)) as cds_mark_to_stat_fx_value) AS MktMarketToStstcExchRate,
cast ( source.ComparMktMarketToStstcExchRate as cds_comp_mkt_mkt_to_stat_rate) AS ComparMktMarketToStstcExchRate,
cast ( cast (ContractMktToDocExchRate as abap.dec (20, 8)) as cds_comp_ctr_mark_to_doc_rate) AS ContractMktToDocExchRate,
cast ( cast (MktAdjmtValueCndnTermValue as abap.dec (31, 8)) as cds_mav_term_value) AS MktAdjmtValueCndnTermValue,
cast ( cast (MktAdjmtValDocToStstcExchRate as abap.dec (20, 8)) as cds_ctr_mark_to_doc_exchrate) AS MktAdjmtValDocToStstcExchRate,
cast (source.ComparContrCndnTermRate as cds_contract_termrate ) AS ComparContrCndnTermRate,
source.EvaluationDate AS EvaluationDate,
source.ComparativeEvaluationDate AS ComparativeEvaluationDate,
cast (source.MarketDCS as cds_mkt_dcsid) AS MarketDCS,
cast (source.MktMarketIdentifierCode as cds_mkt_mic) AS MktMarketIdentifierCode,
cast (source.MktDrvtvContrMaturityCode as cds_mkt_contract_code) AS MktDrvtvContrMaturityCode,
cast ( cast (source.MktMaturityKeyDate as abap.dats) as cds_mkt_keydate) AS MktMaturityKeyDate,
cast (source.MarketBasisType as cds_mkt_basis_type) AS MarketBasisType,
cast (source.MarketBasisID as cds_mkt_basis_id) AS MarketBasisID,
source.HasError AS HasError,
source.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 PhysicalCommodity,
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,
source.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
source.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
source.ReferenceDocument AS ReferenceDocument,
source.ReferenceDocumentItem AS ReferenceDocumentItem,
source.ReferenceDocBusObjType AS ReferenceDocBusObjType,
source.DeliveryDate AS DeliveryDate,
source.ExpectedPaymentDate AS ExpectedPaymentDate,
source.StatisticsCurrency AS StatisticsCurrency,
source.DocumentCurrency AS DocumentCurrency,
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,
source.ConditionTermRate 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,
cast (source.ExchrateMaturityDate as cmm_maturity_date) AS ExchRateMaturityDate,
source.FixedExchRateDate AS FixedExchRateDate,
source.QuotationKeyType AS QuotationKeyType,
source.QuotationDateList AS QuotationDateList,
source.QuotationPeriodStartDate AS QuotationPeriodStartDate,
source.QuotationPeriodEndDate AS QuotationPeriodEndDate,
cast (source.ComparativeMarketDCS as cds_comp_mkt_dcsid) AS ComparativeMarketDCS,
cast (source.ComparMktMarketIdentifierCode as cds_comp_mkt_mic) AS ComparMktMarketIdentifierCode,
cast (source.ComparMktMaturityKeyDate as cds_comp_mkt_keydate) AS ComparMktMaturityKeyDate,
cast (source.ComparMktDrvtvContrCode as cds_comp_mkt_contract_code) AS ComparMktDrvtvContrCode,
cast (source.ComparMarketBasisID as cds_comp_mkt_basis_id) AS ComparMarketBasisID,
cast (source.ComparMarketBasisType as cds_comp_mkt_basis_type) AS ComparMarketBasisType,
cast (source.ComparMktQuotationPriceType as cds_comp_mkt_quotation_prctype) AS ComparMktQuotationPriceType,
cast (source.QuotationPeriodReferenceDate as cmm_vlogp_reference_date) AS QuotationPeriodReferenceDate,
cast (source.ComparQtanPeriodReferenceDate as cds_comp_quotation_ref_date) 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 (' ' as cmm_event_cat) AS PnLEventCategory,
cast (' ' as cmm_event) 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,
PriceSettingMethod,
PriceSettingMethodStatus,
ValidToDateTime,
PricingProcedure,
PricingConditionTerm,
CmmdtyRootDocExternalNumber,
CmmdtyDocumentExternalNumber
FROM P_CmmdtyBegPosPnL_Calc
;