I_OBJECTHEADERANNO

DDL: I_OBJECTHEADERANNO Type: view_entity Package: S_ESH_VB
5 Fields 2 Data Sources 1 Associations

CDS View Browser Object Headers

I_OBJECTHEADERANNO is a CDS View that provides data about "CDS View Browser Object Headers" in SAP S/4HANA. It reads from 2 data sources (ddheadanno, sadl_gw_ann_em) and exposes 5 fields with key fields CDSView, HeaderAnnotation. It has 1 association to related views. Part of development package S_ESH_VB.

Data Sources (2)

SourceAliasJoin Type
ddheadanno _objectHeaderDesc from
sadl_gw_ann_em _objectModel left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] sadl_gw_ann_em_t _annotationText _objectModel.enum_key = _annotationText.enum_key and _objectModel.anno_key = _annotationText.anno_key and _annotationText.lang = $session.system_language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View Browser Object Headers view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CDSView ddheadanno strucobjn DD: Name of a structured object (e.g. entity, context)
KEY HeaderAnnotation ddheadanno name Zone name
HeaderAnnotationRaw ddheadanno value Value from table
HeaderAnnotationValue sadl_gw_ann_em enum_key Enum Value
Description _annotationText description Well Code Des.

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_OBJECTHEADERANNO.
-- 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.

CREATE VIEW I_OBJECTHEADERANNO AS
SELECT
  _objectHeaderDesc.strucobjn AS CDSView,
  _objectHeaderDesc.name AS HeaderAnnotation,
  _objectHeaderDesc.value AS HeaderAnnotationRaw,
  _objectModel.enum_key AS HeaderAnnotationValue,
  _annotationText.description AS Description
FROM ddheadanno AS _objectHeaderDesc
LEFT OUTER JOIN sadl_gw_ann_em AS _objectModel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sadl_gw_ann_em_t AS _annotationText ON _objectModel.enum_key = _annotationText.enum_key AND _objectModel.anno_key = _annotationText.anno_key AND _annotationText.lang = $session.system_language  -- association [0..1]
;

Learn More