I_SAPObjectType_2

DDL: I_SAPOBJECTTYPE_2 Type: view_entity BASIC

SAP Object Type

I_SAPObjectType_2 is a Basic CDS View that provides data about "SAP Object Type" in SAP S/4HANA. It reads from 1 data source (ront_header) and exposes 6 fields with key field SAPObjectTypeInUppercase. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ront_header Header from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SAPObjectTypeText_2 _Text $projection.SAPObjectTypeInUppercase = _Text.SAPObjectTypeInUppercase
[0..*] I_SAPObjectNodeType_2 _SAPObjectNodeType $projection.SAPObjectTypeInUppercase = _SAPObjectNodeType.SAPObjectTypeInUppercase

Annotations (10)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SAP Object Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey SAPObjectTypeInUppercase view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SAPObjectTypeInUppercase
SAPObjectType Node node_name_raw SONT Raw Node Name
ObjectTypeCode Node object_type_code Type Code
SAPObjectTypeCategory ront_header type_category SOT Type Category
_Text _Text
_SAPObjectNodeType _SAPObjectNodeType

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_SAPObjectType_2.
-- 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_SAPObjectType_2 AS
SELECT
  cast( Header.ront_name as sap_object_type preserving type ) AS SAPObjectTypeInUppercase,
  Node.node_name_raw AS SAPObjectType,
  Node.object_type_code AS ObjectTypeCode,
  Header.type_category AS SAPObjectTypeCategory
FROM ront_header AS Header
LEFT OUTER JOIN I_SAPObjectTypeText_2 AS _Text ON SAPObjectTypeInUppercase = _Text.SAPObjectTypeInUppercase  -- association [0..*]
LEFT OUTER JOIN I_SAPObjectNodeType_2 AS _SAPObjectNodeType ON SAPObjectTypeInUppercase = _SAPObjectNodeType.SAPObjectTypeInUppercase  -- association [0..*]
;