I_ApplicationObject

DDL: I_APPLICATIONOBJECT Type: view_entity Package: S_APPL_OBJECT

Application Object View

I_ApplicationObject is a CDS View that provides data about "Application Object View" in SAP S/4HANA. It reads from 1 data source (appl_object) and exposes 12 fields with key field ApplicationObjectName. It has 5 associations to related views. Part of development package S_APPL_OBJECT.

Data Sources (1)

SourceAliasJoin Type
appl_object appl_object from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_ApplicationObjectText _Description _Description.ApplicationObjectName = $projection.ApplicationObjectName
[0..*] I_SAPObjectType_2 _SAPObjectType _SAPObjectType.SAPObjectType = $projection.SapObjectType
[0..1] I_DATACATEGORY _DataCategory _DataCategory.DataCategoryName = $projection.CategoryName
[0..1] I_IlmObjectVH _IlmObject _IlmObject.object_type = $projection.IlmObject
[0..1] I_AppObjectKeyStructure _AppObjectKeyStructure _AppObjectKeyStructure.DatabaseTable = $projection.AppObjectKeyStructure

Annotations (6)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ApplicationObjectName ao_name Application Object
AppObjectDescription
AppObjectKeyStructure ao_key_struct Key Str for AO
SapObjectType sap_object_type SAP Object Type
CategoryName categ_name Data Category
IlmObject ilm_object ILM Object
ABAPLanguageVersion abap_language_version Language Version
_Description _Description
_SAPObjectType _SAPObjectType
_DataCategory _DataCategory
_IlmObject _IlmObject
_AppObjectKeyStructure _AppObjectKeyStructure

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_ApplicationObject.
-- 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_ApplicationObject AS
SELECT
  ao_name AS ApplicationObjectName,
  _Description[1: Language=$session.system_language].AppObjectDescription AS AppObjectDescription,
  ao_key_struct AS AppObjectKeyStructure,
  sap_object_type AS SapObjectType,
  categ_name AS CategoryName,
  ilm_object AS IlmObject,
  abap_language_version AS ABAPLanguageVersion
FROM appl_object
LEFT OUTER JOIN I_ApplicationObjectText AS _Description ON _Description.ApplicationObjectName = ApplicationObjectName  -- association [0..*]
LEFT OUTER JOIN I_SAPObjectType_2 AS _SAPObjectType ON _SAPObjectType.SAPObjectType = SapObjectType  -- association [0..*]
LEFT OUTER JOIN I_DATACATEGORY AS _DataCategory ON _DataCategory.DataCategoryName = CategoryName  -- association [0..1]
LEFT OUTER JOIN I_IlmObjectVH AS _IlmObject ON _IlmObject.object_type = IlmObject  -- association [0..1]
LEFT OUTER JOIN I_AppObjectKeyStructure AS _AppObjectKeyStructure ON _AppObjectKeyStructure.DatabaseTable = AppObjectKeyStructure  -- association [0..1]
;