C_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 C_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: CILMRULEGROUPTP

CREATE VIEW C_IlmRuleGroupTP AS
SELECT
  object_category AS ILMObjectCategory,
  policy_category AS ILMPolicyCategory,
  rule_group AS ILMRuleGroup,
  object_group AS ILMObjectGroup,
  ILMRuleGroupForEdit,
  rule_group_t AS ILMRuleGroupDescription,
  ILMAuthorizationGroup,
  ILMResidencePeriod,
  ILMResidencePeriodUnit,
  ILMMinimumRetentionPeriod,
  ILMMaximumRetentionPeriod,
  ILMRetentionPeriodUnit,
  ILMTimeReference,
  ILMTimeOffset,
  ILMArchiveStore
FROM I_IlmRuleGroupTP
LEFT OUTER JOIN C_IlmObjectGroupTP AS _IlmObjectGroupTP ON _IlmObjectGroupTP.ILMObjectCategory = ILMObjectCategory AND _IlmObjectGroupTP.ILMPolicyCategory = ILMPolicyCategory AND _IlmObjectGroupTP.ILMObjectGroup = ILMObjectGroup  -- association [1..1]
LEFT OUTER JOIN I_IlmTimeRefVH AS _IlmTimeRefVH ON _IlmTimeRefVH.constant_value = ILMTimeReference  -- association [1..1]
LEFT OUTER JOIN I_IlmTimeUnitVH AS _IlmResTimeUnitVH ON _IlmResTimeUnitVH.constant_value = ILMResidencePeriodUnit  -- association [1..1]
LEFT OUTER JOIN I_IlmTimeUnitVH AS _IlmRetTimeUnitVH ON _IlmRetTimeUnitVH.constant_value = ILMRetentionPeriodUnit  -- association [1..1]
LEFT OUTER JOIN I_IlmTimeOffsetVH AS _IlmTimeOffsetVH ON _IlmTimeOffsetVH.constant_value = ILMTimeOffset  -- association [1..1]
LEFT OUTER JOIN I_IlmArchStoreVH AS _IlmArchStoreVH ON _IlmArchStoreVH.store_name = ILMArchiveStore  -- association [1..*]
LEFT OUTER JOIN I_ILMAUTHGROUPVH AS _ILMAUTHGROUPVH ON _ILMAUTHGROUPVH.auth_group = ILMAuthorizationGroup  -- association [1..1]
;