I_REStandardNoticeRule

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_REStandardNoticeRule.
-- 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: IRENTRULSTDPRC

CREATE VIEW I_REStandardNoticeRule AS
SELECT
  RENoticeProcedure,
  _RENoticeProcedureToRule.RENoticeRule AS RENoticeRule,
  coalesce( _REPeriodRule.RENoticeSequenceNo, _REDeadlineRule.RENoticeSequenceNo ) AS RENoticeSequenceNo,
  RENoticeGivingParty,
  coalesce( _REPeriodRule.RENoticeRuleType, _REDeadlineRule.RENoticeRuleType ) AS RENoticeRuleType,
  coalesce( _REPeriodRule.RENoticeType, _REDeadlineRule.RENoticeType ) AS RENoticeType,
  coalesce( _REPeriodRule.RETermPeriodInYears, _REDeadlineRule.RETermPeriodInYears ) AS RETermPeriodInYears,
  coalesce( _REPeriodRule.RETermPeriodInMonths, _REDeadlineRule.RETermPeriodInMonths ) AS RETermPeriodInMonths,
  coalesce( _REPeriodRule.RETermPeriodInDays, _REDeadlineRule.RETermPeriodInDays ) AS RETermPeriodInDays,
  _REPeriodRule.REPeriodEndRhythmType AS REPeriodEndRhythmType,
  _REPeriodRule.RENoticePeriodInMonths AS RENoticePeriodInMonths,
  _REPeriodRule.RENoticePeriodInWeeks AS RENoticePeriodInWeeks,
  _REPeriodRule.RENoticePeriodInDays AS RENoticePeriodInDays,
  _REPeriodRule.RENoticeGracePeriod AS RENoticeGracePeriod,
  _REPeriodRule.REGracePeriodCalOrWorkDays AS REGracePeriodCalOrWorkDays,
  _REPeriodRule.RENoticePeriodCalendar AS RENoticePeriodCalendar,
  _REDeadlineRule.RENoticeYear AS RENoticeYear,
  _REDeadlineRule.RENoticeMonth AS RENoticeMonth,
  _REDeadlineRule.RENoticeDay AS RENoticeDay,
  _REDeadlineRule.RENoticeReceiptYear AS RENoticeReceiptYear,
  _REDeadlineRule.RENoticeReceiptMonth AS RENoticeReceiptMonth,
  _REDeadlineRule.RENoticeReceiptDay AS RENoticeReceiptDay,
  _REDeadlineRule.RENoticeRcptCalOrWorkDays AS RENoticeRcptCalOrWorkDays,
  _REDeadlineRule.RENoticeReceiptCalendar AS RENoticeReceiptCalendar
FROM I_RENoticeProcedureToRule AS _RENoticeProcedureToRule
LEFT OUTER JOIN I_REStandardNoticePeriodRule AS _REPeriodRule ON _RENoticeProcedureToRule.RENoticeRule = _REPeriodRule.RENoticeRule  -- association [0..*]
LEFT OUTER JOIN I_REStandardNoticeDeadlineRule AS _REDeadlineRule ON _RENoticeProcedureToRule.RENoticeRule = _REDeadlineRule.RENoticeRule  -- association [0..*]
LEFT OUTER JOIN I_RENoticeRule AS _RENoticeRule ON RENoticeRule = _RENoticeRule.RENoticeRule  -- association [0..1]
LEFT OUTER JOIN I_RECalendarOrWorkDay AS _REGracePeriodCalOrWorkDay ON regraceperiodcalorworkdays = _REGracePeriodCalOrWorkDay.RECalendarOrWorkDay  -- association [0..1]
LEFT OUTER JOIN I_RECalendarOrWorkDay AS _RENoticeReceiptCalOrWorkDay ON renoticercptcalorworkdays = _RENoticeReceiptCalOrWorkDay.RECalendarOrWorkDay  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _NoticePeriodCalendar ON renoticeperiodcalendar = _NoticePeriodCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _NoticeReceiptCalendar ON renoticereceiptcalendar = _NoticeReceiptCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_REPeriodEndRhythmType AS _REPeriodEndRhythmType ON reperiodendrhythmtype = _REPeriodEndRhythmType.REPeriodEndRhythmType  -- association [0..1]
LEFT OUTER JOIN I_RENoticeProcedure AS _RENoticeProcedure ON RENoticeProcedure = _RENoticeProcedure.RENoticeProcedure  -- association [0..1]
LEFT OUTER JOIN I_RENoticeRuleType AS _RENoticeRuleType ON RENoticeRuleType = _RENoticeRuleType.RENoticeRuleType  -- association [0..1]
LEFT OUTER JOIN I_RENoticeGivingParty AS _RENoticeGivingParty ON RENoticeGivingParty = _RENoticeGivingParty.RENoticeGivingParty  -- association [0..1]
;