What is I_REIndividualNoticeRule in SAP S/4HANA?

I_REIndividualNoticeRule is a basic CDS view in SAP S/4HANA. Individual Notice Period Rule It contains 35 fields.

Which tables does I_REIndividualNoticeRule read from?

I_REIndividualNoticeRule reads data from: I_REIndividualNoticeProcedure.

What VDM layer is I_REIndividualNoticeRule?

I_REIndividualNoticeRule is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_REIndividualNoticeRule

DDL: I_REINDIVIDUALNOTICERULE SQL: IRENTRULINDVL Type: view BASIC

35 Fields 1 Data Sources 10 Associations

Individual Notice Period Rule

I_REIndividualNoticeRule is a Basic CDS View that provides data about "Individual Notice Period Rule" in SAP S/4HANA. It reads from 1 data source (I_REIndividualNoticeProcedure) and exposes 35 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, RENoticeRule, RENoticeSequenceNo. It has 10 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_REIndividualNoticeProcedure	_REIndNoticeProcedure	from

Associations (10)

Cardinality	Target	Alias	Condition
[0..*]	I_REIndividualNoticePeriodRule	_REPeriodRule	`_REIndNoticeProcedure.InternalRealEstateNumber = _REPeriodRule.InternalRealEstateNumber and _REIndNoticeProcedure.RETermType = _REPeriodRule.RETermType and _REIndNoticeProcedure.RETermNumber = _REPeriodRule.RETermNumber and _REIndNoticeProcedure.RENoticeRule = _REPeriodRule.RENoticeRule and _REIndNoticeProcedure.RENoticeRuleType = '3'`
[0..*]	I_REIndivNoticeDeadlineRule	_REDeadlineRule	`_REIndNoticeProcedure.InternalRealEstateNumber = _REDeadlineRule.InternalRealEstateNumber and _REIndNoticeProcedure.RETermType = _REDeadlineRule.RETermType and _REIndNoticeProcedure.RETermNumber = _REDeadlineRule.RETermNumber and _REIndNoticeProcedure.RENoticeRule = _REDeadlineRule.RENoticeRule and _REIndNoticeProcedure.RENoticeRuleType = '4'`
[0..1]	I_RENoticeRule	_RENoticeRule	`$projection.RENoticeRule = _RENoticeRule.RENoticeRule`
[0..1]	I_RECalendarOrWorkDay	_REGracePeriodCalOrWorkDay	`$projection.regraceperiodcalorworkdays = _REGracePeriodCalOrWorkDay.RECalendarOrWorkDay`
[0..1]	I_RECalendarOrWorkDay	_RENoticeReceiptCalOrWorkDay	`$projection.renoticercptcalorworkdays = _RENoticeReceiptCalOrWorkDay.RECalendarOrWorkDay`
[0..1]	I_FactoryCalendar	_RENoticePeriodCalendar	`$projection.renoticeperiodcalendar = _RENoticePeriodCalendar.FactoryCalendar`
[0..1]	I_FactoryCalendar	_RENoticeReceiptCalendar	`$projection.renoticereceiptcalendar = _RENoticeReceiptCalendar.FactoryCalendar`
[0..1]	I_REPeriodEndRhythmType	_REPeriodEndRhythmType	`$projection.reperiodendrhythmtype = _REPeriodEndRhythmType.REPeriodEndRhythmType`
[0..1]	I_RENoticeRuleType	_RENoticeRuleType	`$projection.RENoticeRuleType = _RENoticeRuleType.RENoticeRuleType`
[0..1]	I_RENoticeGivingParty	_RENoticeGivingParty	`$projection.RENoticeGivingParty = _RENoticeGivingParty.RENoticeGivingParty`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IRENTRULINDVL	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Individual Notice Period Rule	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view

Fields (35)

Key	Field	Source Table	Source Field	Description
KEY	InternalRealEstateNumber	I_REIndividualNoticeProcedure	InternalRealEstateNumber	RE Key
KEY	RETermType	I_REIndividualNoticeProcedure	RETermType	Term Category
KEY	RETermNumber	I_REIndividualNoticeProcedure	RETermNumber	Number
KEY	RENoticeRule	I_REIndividualNoticeProcedure	RENoticeRule	Notice Rule
KEY	RENoticeSequenceNo
	RENoticeGivingParty		RENoticeGivingParty	Giving Notice
	RENoticeRuleType		RENoticeRuleType	Rule Type
	RENoticeRuleDescription		RENoticeRuleDescription	NoticeRule Name
	RENoticeType
	RETermPeriodInYears
	RETermPeriodInMonths
	RETermPeriodInDays
	REPeriodEndRhythmType	_REPeriodRule	REPeriodEndRhythmType
	RENoticePeriodInMonths	_REPeriodRule	RENoticePeriodInMonths
	RENoticePeriodInWeeks	_REPeriodRule	RENoticePeriodInWeeks
	RENoticePeriodInDays	_REPeriodRule	RENoticePeriodInDays
	RENoticeGracePeriod	_REPeriodRule	RENoticeGracePeriod
	REGracePeriodCalOrWorkDays	_REPeriodRule	REGracePeriodCalOrWorkDays
	RENoticePeriodCalendar	_REPeriodRule	RENoticePeriodCalendar
	RENoticeYear	_REDeadlineRule	RENoticeYear
	RENoticeMonth	_REDeadlineRule	RENoticeMonth
	RENoticeDay	_REDeadlineRule	RENoticeDay
	RENoticeReceiptYear	_REDeadlineRule	RENoticeReceiptYear
	RENoticeReceiptMonth	_REDeadlineRule	RENoticeReceiptMonth
	RENoticeReceiptDay	_REDeadlineRule	RENoticeReceiptDay
	RENoticeRcptCalOrWorkDays	_REDeadlineRule	RENoticeRcptCalOrWorkDays
	RENoticeReceiptCalendar	_REDeadlineRule	RENoticeReceiptCalendar
	_RENoticeRule		_RENoticeRule
	_REGracePeriodCalOrWorkDay		_REGracePeriodCalOrWorkDay
	_RENoticeReceiptCalOrWorkDay		_RENoticeReceiptCalOrWorkDay
	_RENoticePeriodCalendar		_RENoticePeriodCalendar
	_RENoticeReceiptCalendar		_RENoticeReceiptCalendar
	_REPeriodEndRhythmType		_REPeriodEndRhythmType
	_RENoticeRuleType		_RENoticeRuleType
	_RENoticeGivingParty		_RENoticeGivingParty

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_REIndividualNoticeRule.
-- 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: IRENTRULINDVL

CREATE VIEW I_REIndividualNoticeRule AS
SELECT
  _REIndNoticeProcedure.InternalRealEstateNumber AS InternalRealEstateNumber,
  _REIndNoticeProcedure.RETermType AS RETermType,
  _REIndNoticeProcedure.RETermNumber AS RETermNumber,
  _REIndNoticeProcedure.RENoticeRule AS RENoticeRule,
  coalesce( _REPeriodRule.RENoticeSequenceNo, _REDeadlineRule.RENoticeSequenceNo ) AS RENoticeSequenceNo,
  RENoticeGivingParty,
  RENoticeRuleType,
  RENoticeRuleDescription,
  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_REIndividualNoticeProcedure AS _REIndNoticeProcedure
LEFT OUTER JOIN I_REIndividualNoticePeriodRule AS _REPeriodRule ON _REIndNoticeProcedure.InternalRealEstateNumber = _REPeriodRule.InternalRealEstateNumber AND _REIndNoticeProcedure.RETermType = _REPeriodRule.RETermType AND _REIndNoticeProcedure.RETermNumber = _REPeriodRule.RETermNumber AND _REIndNoticeProcedure.RENoticeRule = _REPeriodRule.RENoticeRule AND _REIndNoticeProcedure.RENoticeRuleType = '3'  -- association [0..*]
LEFT OUTER JOIN I_REIndivNoticeDeadlineRule AS _REDeadlineRule ON _REIndNoticeProcedure.InternalRealEstateNumber = _REDeadlineRule.InternalRealEstateNumber AND _REIndNoticeProcedure.RETermType = _REDeadlineRule.RETermType AND _REIndNoticeProcedure.RETermNumber = _REDeadlineRule.RETermNumber AND _REIndNoticeProcedure.RENoticeRule = _REDeadlineRule.RENoticeRule AND _REIndNoticeProcedure.RENoticeRuleType = '4'  -- 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 _RENoticePeriodCalendar ON renoticeperiodcalendar = _RENoticePeriodCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _RENoticeReceiptCalendar ON renoticereceiptcalendar = _RENoticeReceiptCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_REPeriodEndRhythmType AS _REPeriodEndRhythmType ON reperiodendrhythmtype = _REPeriodEndRhythmType.REPeriodEndRhythmType  -- 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]
;

Depth:

I_REIndividualNoticeRule view

I_REIndividualNoticeProcedure view