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_ElevationBaseData.
-- 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: PELEBASEDATA
-- Parameters: P_consumption_type : cmm_vlogp_consumptiontype, P_valuation_date0 : cmm_eval_keydate, P_valuation_date1 : cmm_eval_keydate, P_FX_valuation_date : cmm_eval_keydate, P_snapshot_date0 : cmm_dend_cutdate, P_snapshot_date1 : cmm_dend_cutdate
CREATE VIEW P_ElevationBaseData AS
SELECT
TermData.PricingKey AS PricingKey,
TermData.Version AS Version,
TermData.PricingDocumentItem AS PricingDocumentItem,
TermData.ConditionType AS ConditionType,
TermData.SubConditionType AS SubConditionType,
TermData.VersStockRecordUUID AS VersStockRecordUUID,
TermData.ValuationDate AS ValuationDate,
TermData.Scenario AS Scenario,
TermData.SnapshotDate0 AS SnapshotDate0,
TermData.SnapshotDate1 AS SnapshotDate1,
TermData.DataSelectionType AS DataSelectionType,
TermData.MTMDataSourceType AS MTMDataSourceType,
TermData.ValidityStartDate AS ValidityStartDate,
TermData.ValidityStartDateTime AS ValidityStartDateTime,
TermData.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
TermData.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
TermData.EndOfDayTimestampFrom AS EndOfDayTimestampFrom,
TermData.EndOfDayTimestampTo AS EndOfDayTimestampTo,
TermData.MaximumVersion AS MaximumVersion,
TermData.PreviousVersion AS PreviousVersion,
TermData.PreviousSubConditionType AS PreviousSubConditionType,
TermData.CompanyCode AS CompanyCode,
TermData.SalesOrganization AS SalesOrganization,
TermData.DistributionChannel AS DistributionChannel,
TermData.Division AS Division,
TermData.Creditor AS Creditor,
TermData.SoldToParty AS SoldToParty,
TermData.Material AS Material,
TermData.PhysicalCommodity AS PhysicalCommodity,
TermData.Plant AS Plant,
TermData.StorageLocation AS StorageLocation,
TermData.Batch AS Batch,
TermData.GoodsMovementType AS GoodsMovementType,
TermData.IncotermsClassification AS IncotermsClassification,
TermData.IncotermsTransferLocation AS IncotermsTransferLocation,
TermData.ConditionApplication AS ConditionApplication,
TermData.SourceDocument AS SourceDocument,
TermData.SourceDocumentItem AS SourceDocumentItem,
TermData.SourceDocumentBusObjType AS SourceDocumentBusObjType,
TermData.OriginReferenceDocument AS OriginReferenceDocument,
TermData.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
TermData.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
TermData.ReferenceDocument AS ReferenceDocument,
TermData.ReferenceDocumentItem AS ReferenceDocumentItem,
TermData.ReferenceDocBusObjType AS ReferenceDocBusObjType,
TermData.DeliveryDate AS DeliveryDate,
TermData.DeliveryYear AS DeliveryYear,
TermData.DeliveryMonth AS DeliveryMonth,
TermData.ExpectedPaymentDate AS ExpectedPaymentDate,
TermData.StatisticsCurrency AS StatisticsCurrency,
TermData.DocumentCurrency AS DocumentCurrency,
TermData.ProfitCenter AS ProfitCenter,
TermData.BusinessArea AS BusinessArea,
TermData.PurchasingOrganization AS PurchasingOrganization,
TermData.MaterialGroup AS MaterialGroup,
TermData.IsIntercompanyTransfer AS IsIntercompanyTransfer,
cast( TermData.ConditionTermRate as abap.fltp ) AS ConditionTermRate,
TermData.MarketToDocExchrate AS MarketToDocExchrate,
TermData.MarketToDocFrozenExchrate AS MarketToDocFrozenExchrate,
TermData.MarketToDocExchrateDate AS MarketToDocExchrateDate,
TermData.ConditionTermRateCurrency AS ConditionTermRateCurrency,
TermData.ConditionTermRateQuantity AS ConditionTermRateQuantity,
TermData.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
TermData.ConditionTermValueInStstcCrcy AS ConditionTermValueInStstcCrcy,
TermData.ConditionTermValueInDocCrcy AS ConditionTermValueInDocCrcy,
TermData.DocToStatisticalExchRate AS DocToStatisticalExchRate,
TermData.DocToStatisticalExchRateDate AS DocToStatisticalExchRateDate,
TermData.ConditionTermValueCurrency AS ConditionTermValueCurrency,
TermData.SystemMessageNumber AS SystemMessageNumber,
substring(TermData.SystemMessageNumber,1,1) AS SystemMessageNumberSub,
TermData.HasError AS HasError,
TermData.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
TermData.BasisID AS BasisID,
TermData.BasisType AS BasisType,
TermData.DerivativeContrSpecification AS DerivativeContrSpecification,
TermData.MarketIdentifierCode AS MarketIdentifierCode,
TermData.MaturityKeyDate AS MaturityKeyDate,
TermData.QuotationPriceType AS QuotationPriceType,
TermData.MarketCurrency AS MarketCurrency,
TermData.OldestQuotationDate AS OldestQuotationDate,
TermData.CommodityQuantity AS CommodityQuantity,
TermData.CommodityQuantityInBaseUnit AS CommodityQuantityInBaseUnit,
TermData.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
case when ConvFactorCommUnit.QuantityNumerator is not null and ConvFactorCommUnit.QuantityNumerator is not initial and ConvFactorTermUnit.QuantityDenominator is not null and ConvFactorTermUnit.QuantityDenominator is not initial then ( ( cast(ConvFactorTermUnit.QuantityNumerator as abap.fltp) / cast(ConvFactorTermUnit.QuantityDenominator as abap.fltp) ) * ( cast(ConvFactorCommUnit.QuantityDenominator as abap.fltp) / cast(ConvFactorCommUnit.QuantityNumerator as abap.fltp) ) ) when ConvFacCommUnit006.SIUnitCnvrsnRateNumerator is not null and ConvFacCommUnit006.SIUnitCnvrsnRateNumerator is not initial and ConvFactTermUnit006.SIUnitCnvrsnRateDenominator is not null and ConvFactTermUnit006.SIUnitCnvrsnRateDenominator is not initial then ( ( cast(ConvFactTermUnit006.SIUnitCnvrsnRateNumerator as abap.fltp) / cast(ConvFactTermUnit006.SIUnitCnvrsnRateDenominator as abap.fltp) ) * ( cast(ConvFacCommUnit006.SIUnitCnvrsnRateDenominator as abap.fltp) / cast(ConvFacCommUnit006.SIUnitCnvrsnRateNumerator as abap.fltp) ) ) else cast( 0 as abap.fltp) end as CommodityQtyPerCondTermQty AS fltpendasCommodityQtyPerCondTermQty,
case when TermData.CommodityUnit is initial or TermData.CommodityUnit is null then PhysCmmdtyUnit.CommodityUnit else TermData.CommodityUnit end as CommodityUnit AS CommodityUnitendasCommodityUnit,
TermData.MaterialBaseUnit AS MaterialBaseUnit,
TermData.MTMConditionGroupCategory AS MTMConditionGroupCategory,
TermData.MTMConditionGroup AS MTMConditionGroup,
TermData.MTMCalculationGroup AS MTMCalculationGroup,
TermData.MTMAdjustmentType AS MTMAdjustmentType,
TermData.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
TermData.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
TermData.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
TermData.ConditionTermRateFixation AS ConditionTermRateFixation,
TermData.PricingStatus AS PricingStatus,
TermData.CndnTermRateFixationDate AS CndnTermRateFixationDate,
TermData.CndnTermRateFixationTime AS CndnTermRateFixationTime,
TermData.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
TermData.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
TermData.FixedExchRateDate AS FixedExchRateDate,
TermData.ExchRateMaturityDate AS ExchRateMaturityDate,
TermData.BsMktRefDrvtvContrMaturityCode AS BsMktRefDrvtvContrMaturityCode,
TermData.BasisMarketRefRate AS BasisMarketRefRate,
TermData.BasisMarketRefRateCurrency AS BasisMarketRefRateCurrency,
TermData.BasisMarketRefKeyDate AS BasisMarketRefKeyDate,
TermData.BasisMarketRefAdjustmentSpread AS BasisMarketRefAdjustmentSpread,
TermData.pnldatatype AS pnldatatype,
TermData.PrevVersionCommodityQuantity AS PrevVersionCommodityQuantity,
TermData.PreviousVersionQuantitySign AS PreviousVersionQuantitySign,
TermData.PrevVersCndnTermRateCurrency AS PrevVersCndnTermRateCurrency,
TermData.PrevVersionConditionTermValue AS PrevVersionConditionTermValue,
TermData.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
TermData.ConditionTermFactorNumerator AS ConditionTermFactorNumerator,
TermData.ConditionTermFactorDenominator AS ConditionTermFactorDenominator,
TermData.ComparCndnTermFactorNumerator AS ComparCndnTermFactorNumerator,
TermData.ComparCndnTrmFctrDenominator AS ComparCndnTrmFctrDenominator,
TermData.ComparMinCndnTermLimitRate AS ComparMinCndnTermLimitRate,
TermData.ComparMaxCndnTermLimitRate AS ComparMaxCndnTermLimitRate,
TermData.ComparImplicitFixationIsRlvt AS ComparImplicitFixationIsRlvt,
case when TermData.ConditionTermRateCurrency = TermData.StatisticsCurrency then TermData.ConditionTermRate else case when TermData.ConditionTermRateCurrency = TermData.DocumentCurrency then TermData.ConditionTermRate else ( cast( TermData.ConditionTermRate as abap.fltp ) * cast( TermData.MarketToDocExchrate as abap.fltp ) ) end end as EConditionTermRateInDoc AS fltpendendasEConditionTermRateInDoc,
TermData.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
TermData.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
TermData.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
TermData.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
TermData.PricedContractQuantity AS PricedContractQuantity,
TermData.UnpricedContractQuantity AS UnpricedContractQuantity,
TermData.TodayPricedQuantity AS TodayPricedQuantity,
TermData.PricedContractQuantityInMass AS PricedContractQuantityInMass,
TermData.UnpricedContractQuantityInMass AS UnpricedContractQuantityInMass,
TermData.TodayPricedQuantityInMass AS TodayPricedQuantityInMass,
TermData.PricedContractQuantityInVol AS PricedContractQuantityInVol,
TermData.UnpricedContractQuantityInVol AS UnpricedContractQuantityInVol,
TermData.TodayPricedQuantityInVol AS TodayPricedQuantityInVol,
TermData.ContrPriceExposureIsExecuted AS ContrPriceExposureIsExecuted,
TermData.PricedDays AS PricedDays,
TermData.UnpricedDays AS UnpricedDays,
TermData.TodayDays AS TodayDays
FROM P_CMM_CPE_TERM_VALUE
;