P_FctryClndrDate2

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_FctryClndrDate2.
-- 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: PFCTRYCLNDRDATE2
-- Parameters: P_CountryCode : SMI_COUNTRYCODE_FCTRYCLNDR

CREATE VIEW P_FctryClndrDate2 AS
SELECT
  Date.CalendarYear AS CalendarYear,
  Date.CalendarMonth AS CalendarMonth,
  Date.CalendarWeek AS CalendarWeek,
  Date.CalendarQuarter AS CalendarQuarter,
  Date.YearQuarter AS YearQuarter,
  Date.YearMonth AS YearMonth,
  Date.YearWeek AS YearWeek,
  Date.CalendarDate AS CalendarDate,
  Date.CalendarDay AS CalendarDay,
  Date.WeekDay AS WeekDay,
  FactoryCalendar.ident AS ident,
  FactoryCalendar.jahr AS jahr,
  FactoryCalendar.mon01 AS mon01,
  FactoryCalendar.mon02 AS mon02,
  FactoryCalendar.mon03 AS mon03,
  FactoryCalendar.mon04 AS mon04,
  FactoryCalendar.mon05 AS mon05,
  FactoryCalendar.mon06 AS mon06,
  FactoryCalendar.mon07 AS mon07,
  FactoryCalendar.mon08 AS mon08,
  FactoryCalendar.mon09 AS mon09,
  FactoryCalendar.mon10 AS mon10,
  FactoryCalendar.mon11 AS mon11,
  FactoryCalendar.mon12 AS mon12,
  FactoryCalendar.basis AS basis,
  FactoryCalendar.fenum AS fenum,
  FactoryCalendar.wenum AS wenum,
  FactoryCalendar.load AS load
FROM I_CalendarDate AS Date
INNER JOIN tfacs AS FactoryCalendar ON /* join condition not captured in parsed metadata */
;