I_REIndividualNoticePeriodRule

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_REIndividualNoticePeriodRule.
-- 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: IRENTRULIND

CREATE VIEW I_REIndividualNoticePeriodRule AS
SELECT
  intreno AS InternalRealEstateNumber,
  termtype AS RETermType,
  termno AS RETermNumber,
  ntrule AS RENoticeRule,
  ntruleno AS RENoticeSequenceNo,
  ntlimityears AS RETermPeriodInYears,
  ntlimitmonths AS RETermPeriodInMonths,
  ntlimitdays AS RETermPeriodInDays,
  ntrhythmtype AS REPeriodEndRhythmType,
  ntpermonths AS RENoticePeriodInMonths,
  ntperweeks AS RENoticePeriodInWeeks,
  ntperdays AS RENoticePeriodInDays,
  ntpergracedays AS RENoticeGracePeriod,
  ntpercdwd AS REGracePeriodCalOrWorkDays,
  ntpercalendar AS RENoticePeriodCalendar,
  cast( '2' as retmnttype ) AS RENoticeType,
  cast( '3' as retmntruletype) AS RENoticeRuleType
FROM vitmntrulepr
LEFT OUTER JOIN I_RENoticeRule AS _RENoticeRule ON RENoticeRule = _RENoticeRule.RENoticeRule  -- association [0..1]
LEFT OUTER JOIN I_RECalendarOrWorkDay AS _RECalendarOrWorkDay ON REGracePeriodCalOrWorkDays = _RECalendarOrWorkDay.RECalendarOrWorkDay  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON RENoticePeriodCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_REPeriodEndRhythmType AS _REPeriodEndRhythmType ON REPeriodEndRhythmType = _REPeriodEndRhythmType.REPeriodEndRhythmType  -- association [0..1]
LEFT OUTER JOIN I_RENoticeType AS _RENoticeType ON RENoticeType = _RENoticeType.RENoticeType  -- association [0..1]
LEFT OUTER JOIN I_RENoticeRuleType AS _RENoticeRuleType ON RENoticeRuleType = _RENoticeRuleType.RENoticeRuleType  -- association [0..1]
;