I_IlmRuleGroupTP

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_IlmRuleGroupTP.
-- 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: IILMRULEGROUPTP

CREATE VIEW I_IlmRuleGroupTP AS
SELECT
  rule_group,
  object_group,
  rule_group AS ILMRuleGroupForEdit,
  spras,
  rule_group_t,
  _IlmRuleGrpFldResidence.field_value AS ILMResidencePeriod,
  _IlmRuleGrpFldResUnit.field_value AS ILMResidencePeriodUnit,
  _IlmRuleGrpFldRetMax.field_value AS ILMMaximumRetentionPeriod,
  _IlmRuleGrpFldRetMin.field_value AS ILMMinimumRetentionPeriod,
  _IlmRuleGrpFldRetUnit.field_value AS ILMRetentionPeriodUnit,
  _IlmRuleGrpFldTimeOff.field_value AS ILMTimeOffset,
  _IlmRuleGrpFldTimeRef.field_value AS ILMTimeReference,
  _IlmRuleGrpFldAuthGrp.field_value AS ILMAuthorizationGroup,
  _IlmRuleGrpFldArchStore.field_value AS ILMArchiveStore
FROM I_IlmRuleGroup
LEFT OUTER JOIN I_IlmObjectGroupTP AS _IlmRuleGroupObjectGroupTP ON _IlmRuleGroupObjectGroupTP.object_group = object_group AND _IlmRuleGroupObjectGroupTP.object_category = object_category AND _IlmRuleGroupObjectGroupTP.policy_category = policy_category  -- association [1..1]
;