I_IlmRuleGroup

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_IlmRuleGroup.
-- 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: IILMRULEGROUP

CREATE VIEW I_IlmRuleGroup AS
SELECT
  RuleGroups.rule_group AS rule_group,
  RuleGroupsDesc.spras AS spras,
  RuleGroupsDesc.rule_group_t AS rule_group_t,
  object_group
FROM lrm_t_oc_rg
LEFT OUTER JOIN lrm_t_oc_rg_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldRetMin ON _IlmRuleGrpFldRetMin.object_category = object_category AND _IlmRuleGrpFldRetMin.policy_category = policy_category AND _IlmRuleGrpFldRetMin.rule_group = rule_group AND _IlmRuleGrpFldRetMin.field_name = 'RET_PERIOD_MIN'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldRetMax ON _IlmRuleGrpFldRetMax.object_category = object_category AND _IlmRuleGrpFldRetMax.policy_category = policy_category AND _IlmRuleGrpFldRetMax.rule_group = rule_group AND _IlmRuleGrpFldRetMax.field_name = 'RET_PERIOD_MAX'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldResidence ON _IlmRuleGrpFldResidence.object_category = object_category AND _IlmRuleGrpFldResidence.policy_category = policy_category AND _IlmRuleGrpFldResidence.rule_group = rule_group AND _IlmRuleGrpFldResidence.field_name = 'RESIDENCE_TIME'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldRetUnit ON _IlmRuleGrpFldRetUnit.object_category = object_category AND _IlmRuleGrpFldRetUnit.policy_category = policy_category AND _IlmRuleGrpFldRetUnit.rule_group = rule_group AND _IlmRuleGrpFldRetUnit.field_name = 'RET_PER_UNIT'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldResUnit ON _IlmRuleGrpFldResUnit.object_category = object_category AND _IlmRuleGrpFldResUnit.policy_category = policy_category AND _IlmRuleGrpFldResUnit.rule_group = rule_group AND _IlmRuleGrpFldResUnit.field_name = 'RST_TIME_UNIT'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldTimeRef ON _IlmRuleGrpFldTimeRef.object_category = object_category AND _IlmRuleGrpFldTimeRef.policy_category = policy_category AND _IlmRuleGrpFldTimeRef.rule_group = rule_group AND _IlmRuleGrpFldTimeRef.field_name = 'STARTTIME_TYPE'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldTimeOff ON _IlmRuleGrpFldTimeOff.object_category = object_category AND _IlmRuleGrpFldTimeOff.policy_category = policy_category AND _IlmRuleGrpFldTimeOff.rule_group = rule_group AND _IlmRuleGrpFldTimeOff.field_name = 'TIME_OFFSET'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldAuthGrp ON _IlmRuleGrpFldAuthGrp.object_category = object_category AND _IlmRuleGrpFldAuthGrp.policy_category = policy_category AND _IlmRuleGrpFldAuthGrp.rule_group = rule_group AND _IlmRuleGrpFldAuthGrp.field_name = 'AUTH_GROUP'  -- association [1..1]
LEFT OUTER JOIN I_IlmRuleGroupField AS _IlmRuleGrpFldArchStore ON _IlmRuleGrpFldArchStore.object_category = object_category AND _IlmRuleGrpFldArchStore.policy_category = policy_category AND _IlmRuleGrpFldArchStore.rule_group = rule_group AND _IlmRuleGrpFldArchStore.field_name = 'ARCHIVE_STORE'  -- association [1..1]
;