P_Vlogp_Dendrun_Na_2

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_Vlogp_Dendrun_Na_2.
-- 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: PVLOGPDENDNA2
-- 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, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime

CREATE VIEW P_Vlogp_Dendrun_Na_2 AS
SELECT
  vlogp.PricingKey AS PricingKey,
  vlogp.Version AS Version,
  vlogp.PricingDocumentItem AS PricingDocumentItem,
  vlogp.ConditionType AS ConditionType,
  vlogp.SubConditionType AS SubConditionType,
  vlogp.ValuationDate1 AS valuationDate,
  vlogp.SnapshotDate0 AS SnapshotDate0,
  vlogp.SnapshotDate1 AS SnapshotDate1,
  vlogp.ConsumptionType AS DataSelectionType,
  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,
  dendrun_from.EndOfDaySnapshotDateTime AS EndOfDayTimestampFrom,
  dendrun_to.EndOfDaySnapshotDateTime AS EndOfDayTimestampTo,
  dendrun_from.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  vlogp.MaximumVersion AS MaximumVersion,
  vlogp.PreviousVersion AS PreviousVersion,
  vlogp.PreviousSubConditionType AS PreviousSubConditionType,
  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.SourceDocumentShortNumber AS SourceDocumentShortNumber,
  vlogp.SourceDocument AS SourceDocument,
  vlogp.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  vlogp.OrignRefDocumentShortNumber AS OrignRefDocumentShortNumber,
  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.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
  vlogp.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber,
  vlogp.ConditionRate AS ConditionRate,
  vlogp.ConditionCurrency AS ConditionCurrency,
  vlogp.ConditionQuantity AS ConditionQuantity,
  vlogp.ConditionQuantityUnit AS ConditionQuantityUnit,
  vlogp.OldConditionTermrate AS OldConditionTermrate,
  vlogp.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  vlogp.ConditionTermValue AS ConditionTermValue,
  vlogp.OldConditionTermValue AS OldConditionTermValue,
  vlogp.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  vlogp.ConditionTermRateMktCurrency AS ConditionTermRateMktCurrency,
  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.MaturitySelectionRoutine AS MaturitySelectionRoutine,
  vlogp.DCSPeriodType AS DCSPeriodType,
  vlogp.CmmdtyLtstEvaluationKeyDate AS CmmdtyLtstEvaluationKeyDate,
  vlogp.DerivativeContrSpecification AS DerivativeContrSpecification,
  vlogp.MarketIdentifierCode AS MarketIdentifierCode,
  vlogp.MaturityKeyDate AS MaturityKeyDate,
  vlogp.CommodityContractMaturityCode AS CommodityContractMaturityCode,
  vlogp.BasisType AS BasisType,
  vlogp.BasisID AS BasisID,
  case when (vlogp.MTMAdjustmentType = ' ' or vlogp.MTMAdjustmentType = '20') and vlogp.MTMConditionGroupCategory = '2' then case when orth.NewMarketNormQuotationGroup is not null then orth.NewMarketNormQuotationGroup else vlogp.QuotationGroup end else case when vlogp.MTMAdjustmentType = '01' and vlogp.PricingStatus = '01' and FixedSpread.SpreadHasFixationDate = ' ' and FixedSpread.FixedSpreadRate is not null then '' else vlogp.QuotationGroup end end as QuotationGroup AS QuotationGroupendendasQuotationGroup,
  vlogp.PricingStatus AS PricingStatus,
  vlogp.ConditionTermRateFixation AS ConditionTermRateFixation,
  vlogp.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  vlogp.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  vlogp.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  vlogp.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  vlogp.FixedExchRateDate AS FixedExchRateDate,
  vlogp.CommodityUnit AS CommodityUnit,
  vlogp.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  vlogp.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  vlogp.MTMConditionGroup AS MTMConditionGroup,
  vlogp.MTMCalculationGroup AS MTMCalculationGroup,
  vlogp.MTMAdjustmentType AS MTMAdjustmentType,
  vlogp.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  vlogp.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  PrevVersionCommodityQuantity,
  PreviousVersionQuantitySign,
  PrevVersCndnTermRateCurrency,
  PrevVersionConditionTermValue,
  ImplicitFixationIsRelevant,
  ConditionTermFactorNumerator,
  ConditionTermFactorDenominator,
  ComparImplicitFixationIsRlvt,
  ComparCndnTermFactorNumerator,
  ComparCndnTrmFctrDenominator,
  ComparMinCndnTermLimitRate,
  ComparMaxCndnTermLimitRate,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrVolumeUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  ContrPriceExposureIsExecuted,
  CmmdtyForwardIndexTiming,
  FixedFactorFrom,
  FixedFactorTo,
  QuotationUnitOfMeasure,
  FixedCalculationType,
  TermToDocFixedFactorFrom,
  TermToDocFixedFactorTo,
  MarketToTermExchangeRateType,
  CndnToStstcExchangeRateType,
  ConditionToDocExchangeRateType,
  DocToStstcExchangeRateType,
  ExchangeRateType,
  QuotationCurrency,
  SkipReportingIndicatorIsSet,
  vlogp.PriceSettingMethod AS PriceSettingMethod,
  vlogp.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  vlogp.ValidToDateTime AS ValidToDateTime,
  vlogp.PricingProcedure AS PricingProcedure,
  vlogp.ValuationDate1 AS FXvaluationDate,
  'SUM' AS QuotationGroupCalculationRule,
  vlogp.PricingConditionTerm AS PricingConditionTerm
FROM P_Versionedlogisticdocument_2
RIGHT OUTER JOIN I_DayEndRun AS dendrun_from ON /* join condition not captured in parsed metadata */
RIGHT OUTER JOIN I_DayEndRun AS dendrun_to ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Versionedlogisticdocument_2
;