P_SI3_CalendarDate1

DDL: P_SI3_CALENDARDATE1 SQL: PSDSI3CD1 Type: view COMPOSITE
8 Fields 2 Data Sources

P_SI3_CalendarDate1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_SI3_Period) and exposes 8 fields with key field CalendarDate.

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate CD from
P_SI3_Period P left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PSDSI3CD1 view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate I_CalendarDate CalendarDate Calendar Date
CalendarYear CalendarYear Year
YearQuarter YearQuarter Year Quarter
CalendarQuarter CalendarQuarter Calendar Quarter
YearMonth YearMonth Year Month
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week
CalendarDay CalendarDay Occur Day in a Month

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_SI3_CalendarDate1.
-- 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: PSDSI3CD1

CREATE VIEW P_SI3_CalendarDate1 AS
SELECT
  CD.CalendarDate AS CalendarDate,
  CalendarYear,
  YearQuarter,
  CalendarQuarter,
  YearMonth,
  CalendarMonth,
  CalendarWeek,
  CalendarDay
FROM I_CalendarDate AS CD
LEFT OUTER JOIN P_SI3_Period AS P ON /* join condition not captured in parsed metadata */
;

Learn More