I_IlmObjectVH

DDL: I_ILMOBJECTVH SQL: IILMOBJECTVH Type: view Package: S_APS_MIOG_ODATA

ILM Object Value Help

I_IlmObjectVH is a CDS View that provides data about "ILM Object Value Help" in SAP S/4HANA. It reads from 2 data sources (lrm_t_ot, lrm_t_ot_t) and exposes 2 fields with key field object_type. It has 2 associations to related views. Part of development package S_APS_MIOG_ODATA.

Data Sources (2)

SourceAliasJoin Type
lrm_t_ot ILMObjects from
lrm_t_ot_t ILMObjectsDesc left_outer

Associations (2)

CardinalityTargetAliasCondition
[1..1] lrm_t_ot_c _ILMObjectsMapping _ILMObjectsMapping.object_type = ILMObjects.object_type
[1..1] tilm_obj_excl_ce _ILMObjectsExclCe _ILMObjectsExclCe.object_type = ILMObjects.object_type

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName IILMOBJECTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ILM Object Value Help view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY object_type lrm_t_ot object_type Type
_ILMObjectsMapping _ILMObjectsMapping

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_IlmObjectVH.
-- 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: IILMOBJECTVH

CREATE VIEW I_IlmObjectVH AS
SELECT
  ILMObjects.object_type AS object_type
FROM lrm_t_ot AS ILMObjects
LEFT OUTER JOIN lrm_t_ot_t AS ILMObjectsDesc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lrm_t_ot_c AS _ILMObjectsMapping ON _ILMObjectsMapping.object_type = ILMObjects.object_type  -- association [1..1]
LEFT OUTER JOIN tilm_obj_excl_ce AS _ILMObjectsExclCe ON _ILMObjectsExclCe.object_type = ILMObjects.object_type  -- association [1..1]
;