I_ILMRetRuleTP

DDL: I_ILMRETRULETP Type: view_entity
19 Fields 2 Data Sources 2 Associations

Interface view entity for LRM_BS_RTP_RULES

I_ILMRetRuleTP is a CDS View that provides data about "Interface view entity for LRM_BS_RTP_RULES" in SAP S/4HANA. It reads from 2 data sources (I_ILMRetConditionFieldValueGP, R_ILMRetRuleTP) and exposes 19 fields with key fields ILMObjectCategory, ILMObject, ILMPolicyCategory, ILMPolicyType, ILMPolicyOrigin. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ILMRetConditionFieldValueGP _I_ILMRetCondGP left_outer
R_ILMRetRuleTP R_ILMRetRuleTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ILMPolicySingletonHNRltn _Single $projection.SingletonID = _Single.SingletonID
[0..*] I_ILMRetConditionFieldValueTP _I_ILMRetConditionFieldValueTP

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface view entity for LRM_BS_RTP_RULES view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ILMObjectCategory R_ILMRetRuleTP ILMObjectCategory Object Category
KEY ILMObject R_ILMRetRuleTP ILMObject Type
KEY ILMPolicyCategory R_ILMRetRuleTP ILMPolicyCategory Policy Category
KEY ILMPolicyType R_ILMRetRuleTP ILMPolicyType Audit Area
KEY ILMPolicyOrigin R_ILMRetRuleTP ILMPolicyOrigin Policy Name
KEY ILMRuleNumber R_ILMRetRuleTP ILMRuleNumber Rule Number
ILMRulePriority R_ILMRetRuleTP ILMRulePriority Rule Priority
ILMRuleInherit R_ILMRetRuleTP ILMRuleInherit Inheriting Possible
ILMRetentionPeriodMin R_ILMRetRuleTP ILMRetentionPeriodMin Min.Retention Period
ILMRetentionPeriodMax R_ILMRetRuleTP ILMRetentionPeriodMax Max.Retention Period
char12endasRetentionPeriodMinChar
char12endasRetentionPeriodMaxChar
ILMRetentionPeriodUnit R_ILMRetRuleTP ILMRetentionPeriodUnit IRM Constant
ILMTimeReference R_ILMRetRuleTP ILMTimeReference IRM Constant
ILMTimeOffset R_ILMRetRuleTP ILMTimeOffset IRM Constant
SingletonID 1
_Single _Single
_I_ILMRetPolicyTP _I_ILMRetPolicyTP
_I_ILMRetConditionFieldValueTP _I_ILMRetConditionFieldValueTP

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_ILMRetRuleTP.
-- 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.

CREATE VIEW I_ILMRetRuleTP AS
SELECT
  R_ILMRetRuleTP.ILMObjectCategory AS ILMObjectCategory,
  R_ILMRetRuleTP.ILMObject AS ILMObject,
  R_ILMRetRuleTP.ILMPolicyCategory AS ILMPolicyCategory,
  R_ILMRetRuleTP.ILMPolicyType AS ILMPolicyType,
  R_ILMRetRuleTP.ILMPolicyOrigin AS ILMPolicyOrigin,
  R_ILMRetRuleTP.ILMRuleNumber AS ILMRuleNumber,
  R_ILMRetRuleTP.ILMRulePriority AS ILMRulePriority,
  R_ILMRetRuleTP.ILMRuleInherit AS ILMRuleInherit,
  R_ILMRetRuleTP.ILMRetentionPeriodMin AS ILMRetentionPeriodMin,
  R_ILMRetRuleTP.ILMRetentionPeriodMax AS ILMRetentionPeriodMax,
  case R_ILMRetRuleTP.ILMRetentionPeriodMin when -1 then cast( ' ' as abap.char( 12 ) ) else cast( R_ILMRetRuleTP.ILMRetentionPeriodMin as abap.char( 12 ) ) end as RetentionPeriodMinChar AS char12endasRetentionPeriodMinChar,
  case R_ILMRetRuleTP.ILMRetentionPeriodMax when -1 then cast( ' ' as abap.char( 12 ) ) else cast( R_ILMRetRuleTP.ILMRetentionPeriodMax as abap.char( 12 ) ) end as RetentionPeriodMaxChar AS char12endasRetentionPeriodMaxChar,
  R_ILMRetRuleTP.ILMRetentionPeriodUnit AS ILMRetentionPeriodUnit,
  R_ILMRetRuleTP.ILMTimeReference AS ILMTimeReference,
  R_ILMRetRuleTP.ILMTimeOffset AS ILMTimeOffset,
  1 AS SingletonID
FROM R_ILMRetRuleTP
LEFT OUTER JOIN I_ILMRetConditionFieldValueGP AS _I_ILMRetCondGP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ILMPolicySingletonHNRltn AS _Single ON SingletonID = _Single.SingletonID  -- association [1..1]
LEFT OUTER JOIN I_ILMRetConditionFieldValueTP AS _I_ILMRetConditionFieldValueTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More