I_IL_IndexValuesPrev123Month

DDL: I_IL_INDEXVALUESPREV123MONTH Type: view_entity COMPOSITE
13 Fields 4 Data Sources

Index value for 1 and 2 and 3 month back

I_IL_IndexValuesPrev123Month is a Composite CDS View that provides data about "Index value for 1 and 2 and 3 month back" in SAP S/4HANA. It reads from 4 data sources (I_IL_IndexValuesAdditionalInfo, I_IL_IndexValuesAdditionalInfo, I_IL_IndexValuesAdditionalInfo, I_IL_IndexValuesAdditionalInfo) and exposes 13 fields with key fields IL_InfltnAdjustmentIndexId, IL_InfltnAdjIdxDateValValdFrom.

Data Sources (4)

SourceAliasJoin Type
I_IL_IndexValuesAdditionalInfo I_IL_IndexValuesAdditionalInfo from
I_IL_IndexValuesAdditionalInfo IL_Previous1Month inner
I_IL_IndexValuesAdditionalInfo IL_Previous2Month inner
I_IL_IndexValuesAdditionalInfo IL_Previous3Month inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Index value for 1 and 2 and 3 month back view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY IL_InfltnAdjustmentIndexId I_IL_IndexValuesAdditionalInfo IL_InfltnAdjustmentIndexId
KEY IL_InfltnAdjIdxDateValValdFrom I_IL_IndexValuesAdditionalInfo IL_InfltnAdjIdxDateValValdFrom
IL_IndexCurrentPeriodValue I_IL_IndexValuesAdditionalInfo IL_InfltnAdjustmentIndexValue
IL_IndexFinAdjustmentFactor I_IL_IndexValuesAdditionalInfo IL_IndexFinAdjustmentFactor
IL_InfltnAdjustmentIndexStatus I_IL_IndexValuesAdditionalInfo IL_InfltnAdjustmentIndexStatus
IL_IdxValueValidFromFormatDate I_IL_IndexValuesAdditionalInfo IL_IdxValueValidFromFormatDate
IL_IndexDateYearMonth I_IL_IndexValuesAdditionalInfo IL_IndexDateYearMonth
IL_IdxValValdForPrev1MonthDate I_IL_IndexValuesAdditionalInfo IL_IdxValValdForPrev1MonthDate
IL_IdxValValdForPrev2MonthDate I_IL_IndexValuesAdditionalInfo IL_IdxValValdForPrev2MonthDate
IL_IdxValValdForPrev3MonthDate I_IL_IndexValuesAdditionalInfo IL_IdxValValdForPrev3MonthDate
IL_IndexForPrevious1MonthValue I_IL_IndexValuesAdditionalInfo IL_InfltnAdjustmentIndexValue
IL_IndexForPrevious2MonthValue I_IL_IndexValuesAdditionalInfo IL_InfltnAdjustmentIndexValue
IL_IndexForPrevious3MonthValue I_IL_IndexValuesAdditionalInfo IL_InfltnAdjustmentIndexValue

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 I_IL_IndexValuesPrev123Month.
-- 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.

CREATE VIEW I_IL_IndexValuesPrev123Month AS
SELECT
  I_IL_IndexValuesAdditionalInfo.IL_InfltnAdjustmentIndexId AS IL_InfltnAdjustmentIndexId,
  I_IL_IndexValuesAdditionalInfo.IL_InfltnAdjIdxDateValValdFrom AS IL_InfltnAdjIdxDateValValdFrom,
  I_IL_IndexValuesAdditionalInfo.IL_InfltnAdjustmentIndexValue AS IL_IndexCurrentPeriodValue,
  I_IL_IndexValuesAdditionalInfo.IL_IndexFinAdjustmentFactor AS IL_IndexFinAdjustmentFactor,
  I_IL_IndexValuesAdditionalInfo.IL_InfltnAdjustmentIndexStatus AS IL_InfltnAdjustmentIndexStatus,
  I_IL_IndexValuesAdditionalInfo.IL_IdxValueValidFromFormatDate AS IL_IdxValueValidFromFormatDate,
  I_IL_IndexValuesAdditionalInfo.IL_IndexDateYearMonth AS IL_IndexDateYearMonth,
  I_IL_IndexValuesAdditionalInfo.IL_IdxValValdForPrev1MonthDate AS IL_IdxValValdForPrev1MonthDate,
  I_IL_IndexValuesAdditionalInfo.IL_IdxValValdForPrev2MonthDate AS IL_IdxValValdForPrev2MonthDate,
  I_IL_IndexValuesAdditionalInfo.IL_IdxValValdForPrev3MonthDate AS IL_IdxValValdForPrev3MonthDate,
  IL_Previous1Month.IL_InfltnAdjustmentIndexValue AS IL_IndexForPrevious1MonthValue,
  IL_Previous2Month.IL_InfltnAdjustmentIndexValue AS IL_IndexForPrevious2MonthValue,
  IL_Previous3Month.IL_InfltnAdjustmentIndexValue AS IL_IndexForPrevious3MonthValue
FROM I_IL_IndexValuesAdditionalInfo
INNER JOIN I_IL_IndexValuesAdditionalInfo AS IL_Previous1Month ON /* join condition not captured in parsed metadata */
INNER JOIN I_IL_IndexValuesAdditionalInfo AS IL_Previous2Month ON /* join condition not captured in parsed metadata */
INNER JOIN I_IL_IndexValuesAdditionalInfo AS IL_Previous3Month ON /* join condition not captured in parsed metadata */
;

Learn More