P_Vlogp_ReportingDate_YrMnth

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_ReportingDate_YrMnth.
-- 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.
-- Parameters: P_consumption_type : cmm_vlogp_consumptiontype, P_DisplayView : cds_view_uom, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate

CREATE VIEW P_Vlogp_ReportingDate_YrMnth AS
SELECT
  vlogp.PricingKey AS PricingKey,
  vlogp.Version AS Version,
  vlogp.PricingDocumentItem AS PricingDocumentItem,
  vlogp.ConditionType AS ConditionType,
  vlogp.SubConditionType AS SubConditionType,
  vlogp.EvaluationDate AS EvaluationDate,
  vlogp.QuotationPeriodDate AS QuotationPeriodDate,
  vlogp.SubstitutePriceQuotationDate AS SubstitutePriceQuotationDate,
  vlogp.EndOfDaySnapshotFromDate AS EndOfDaySnapshotFromDate,
  vlogp.EndOfDaySnapshotToDate AS EndOfDaySnapshotToDate,
  vlogp.MTMDataSelectionType AS MTMDataSelectionType,
  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.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
  vlogp.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
  vlogp.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  vlogp.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  vlogp.MaximumVersion AS MaximumVersion,
  vlogp.PreviousVersion AS PreviousVersion,
  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,
  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.ConditionTermRate AS ConditionTermRate,
  vlogp.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  vlogp.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  vlogp.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  vlogp.ConditionTermValue AS ConditionTermValue,
  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.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  vlogp.MaturitySelectionType AS MaturitySelectionType,
  vlogp.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  vlogp.CommodityCurve AS CommodityCurve,
  vlogp.QuotationDateList AS QuotationDateList,
  vlogp.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  vlogp.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  vlogp.DerivativeContrSpecification AS DerivativeContrSpecification,
  vlogp.MarketIdentifierCode AS MarketIdentifierCode,
  vlogp.MaturityKeyDate AS MaturityKeyDate,
  vlogp.BasisType AS BasisType,
  vlogp.BasisID AS BasisID,
  vlogp.QuotationGroup AS QuotationGroup,
  vlogp.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  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.ExchRateMaturityDate AS ExchRateMaturityDate,
  vlogp.MaturitySelectionRoutine AS MaturitySelectionRoutine,
  vlogp.DCSPeriodType AS DCSPeriodType,
  vlogp.CommodityUnit AS CommodityUnit,
  vlogp.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  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.CommodityExposureQuantity AS CommodityExposureQuantity,
  vlogp.CommodityExposureUnit AS CommodityExposureUnit,
  vlogp.DCSReportingDate AS DCSReportingDate,
  vlogp.PriceIsRealized AS PriceIsRealized,
  vlogp.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  MinimumConditionTermLimitRate,
  MaximumConditionTermLimitRate,
  ConditionTermLimitRateCurrency,
  ConditionTermLimitRateQuantity,
  CndnTermLimitRateQuantityUnit,
  ConditionTermLimitRateStatus,
  vlogp.TimeToMaturity AS TimeToMaturity,
  vlogp.TotalQuotationPeriodDays AS TotalQuotationPeriodDays,
  vlogp.FirstQuotationPeriodDate AS FirstQuotationPeriodDate,
  vlogp.LastQuotationPeriodDate AS LastQuotationPeriodDate,
  vlogp.QuantityPerDay AS QuantityPerDay,
  vlogp.ContrPriceExposureIsExecuted AS ContrPriceExposureIsExecuted,
  vlogp.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
  vlogp.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
  vlogp.AdjustedQuantityPerDay AS AdjustedQuantityPerDay,
  vlogp.ReportingDate AS ReportingDate,
  cast ( substring(vlogp.ReportingDate, 1, 4) as cds_ftr_reporting_year preserving type ) AS ReportingYear,
  cast ( substring(ReportingDate, 5, 2) as ftr_cty_reporting_period ) AS ReportingMonth,
  vlogp.AdjustedReportingDate AS AdjustedReportingDate,
  cast ( substring(AdjustedReportingDate, 1, 4) as cds_adjusted_reporting_year preserving type ) AS AdjustedReportingYear,
  cast ( substring(AdjustedReportingDate, 5, 2) as cds_adjusted_reporting_month ) AS AdjustedReportingMonth,
  PricedDays,
  UnPricedDays,
  TodayDays,
  vlogp.PriceSettingMethod AS PriceSettingMethod,
  vlogp.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  vlogp.ValidToDateTime AS ValidToDateTime,
  vlogp.PricingProcedure AS PricingProcedure,
  vlogp.PricingConditionTerm AS PricingConditionTerm,
  vlogp.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
  vlogp.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber
FROM P_Vlogp_ReportingDate_Adj
;