I_IlmObject

DDL: I_ILMOBJECT SQL: IILMOBJECT Type: view

Interface view for ILM Objects

I_IlmObject is a CDS View that provides data about "Interface view for ILM Objects" in SAP S/4HANA. It reads from 1 data source (lrm_t_ot_c) and exposes 3 fields with key fields object_type, object_group. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
lrm_t_ot_c lrm_t_ot_c from

Associations (2)

CardinalityTargetAliasCondition
[1..1] lrm_t_ot_t _IlmObjectDesc _IlmObjectDesc.object_type = $projection.object_type and _IlmObjectDesc.object_category = $projection.object_category and _IlmObjectDesc.spras = $session.system_language
[1..1] lrm_t_oc_og _IlmObjectGroup _IlmObjectGroup.object_category = $projection.object_category and _IlmObjectGroup.object_group = $projection.object_group

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName IILMOBJECT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface view for ILM Objects view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY object_type object_type Type
KEY object_group object_group Object Group
_IlmObjectDesc _IlmObjectDesc

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_IlmObject.
-- 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: IILMOBJECT

CREATE VIEW I_IlmObject AS
SELECT
  object_type,
  object_group
FROM lrm_t_ot_c
LEFT OUTER JOIN lrm_t_ot_t AS _IlmObjectDesc ON _IlmObjectDesc.object_type = object_type AND _IlmObjectDesc.object_category = object_category AND _IlmObjectDesc.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN lrm_t_oc_og AS _IlmObjectGroup ON _IlmObjectGroup.object_category = object_category AND _IlmObjectGroup.object_group = object_group  -- association [1..1]
;