P_VLOGP_QUOT_TIMESERIES_MTM

DDL: P_VLOGP_QUOT_TIMESERIES_MTM Type: view COMPOSITE
12 Fields 2 Data Sources

P_VLOGP_QUOT_TIMESERIES_MTM is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_QuotTimeSeries, P_Vlogp_Dendrun) and exposes 12 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

Data Sources (2)

SourceAliasJoin Type
I_QuotTimeSeries _tser left_outer
P_Vlogp_Dendrun P_Vlogp_Dendrun from

Parameters (6)

NameTypeDefault
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

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PVLOGPQUOT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PricingKey vlogp PricingKey Pricing Key
KEY Version vlogp Version XML Vers.
KEY PricingDocumentItem vlogp PricingDocumentItem Item
KEY ConditionType vlogp ConditionType Condition type
KEY SubConditionType vlogp SubConditionType
KEY valuationDate vlogp valuationDate Valuation Date
KEY QuotationPeriodDate I_QuotTimeSeries PriceQuotationDate Quotation date
SubstitutePriceQuotationDate I_QuotTimeSeries SubstitutePriceQuotationDate Substitution Date
SnapshotDate0 vlogp SnapshotDate0
SnapshotDate1 vlogp SnapshotDate1
DataSelectionType vlogp DataSelectionType
QuotationDateList vlogp QuotationDateList Date list key

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_QUOT_TIMESERIES_MTM.
-- 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_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_VLOGP_QUOT_TIMESERIES_MTM AS
SELECT
  vlogp.PricingKey AS PricingKey,
  vlogp.Version AS Version,
  vlogp.PricingDocumentItem AS PricingDocumentItem,
  vlogp.ConditionType AS ConditionType,
  vlogp.SubConditionType AS SubConditionType,
  vlogp.valuationDate AS valuationDate,
  _tser.PriceQuotationDate AS QuotationPeriodDate,
  _tser.SubstitutePriceQuotationDate AS SubstitutePriceQuotationDate,
  vlogp.SnapshotDate0 AS SnapshotDate0,
  vlogp.SnapshotDate1 AS SnapshotDate1,
  vlogp.DataSelectionType AS DataSelectionType,
  vlogp.QuotationDateList AS QuotationDateList
FROM P_Vlogp_Dendrun
LEFT OUTER JOIN I_QuotTimeSeries AS _tser ON /* join condition not captured in parsed metadata */
;

Learn More