I_REStandardNoticeDeadlineRule

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_REStandardNoticeDeadlineRule.
-- 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: IRENTRULDLSTD

CREATE VIEW I_REStandardNoticeDeadlineRule AS
SELECT
  ntrule AS RENoticeRule,
  ntruleno AS RENoticeSequenceNo,
  ntlimityears AS RETermPeriodInYears,
  ntlimitmonths AS RETermPeriodInMonths,
  ntlimitdays AS RETermPeriodInDays,
  ntnotyear AS RENoticeYear,
  ntnotmonth AS RENoticeMonth,
  ntnotday AS RENoticeDay,
  ntrecyear AS RENoticeReceiptYear,
  ntrecmonth AS RENoticeReceiptMonth,
  ntrecday AS RENoticeReceiptDay,
  ntreccdwd AS RENoticeRcptCalOrWorkDays,
  ntreccalendar AS RENoticeReceiptCalendar,
  cast( '1' as retmnttype ) AS RENoticeType,
  cast( '2' as retmntruletype) AS RENoticeRuleType
FROM tivtmntruledr
LEFT OUTER JOIN I_RENoticeRule AS _RENoticeRule ON RENoticeRule = _RENoticeRule.RENoticeRule  -- association [0..1]
LEFT OUTER JOIN I_RECalendarOrWorkDay AS _RECalendarOrWorkDay ON RENoticeRcptCalOrWorkDays = _RECalendarOrWorkDay.RECalendarOrWorkDay  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON RENoticeReceiptCalendar = _FactoryCalendar.FactoryCalendar  -- 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]
;