dd_drty_st_enum_values_char_5

DDL: DD_DRTY_ST_ENUM_VALUES_CHAR_5 Type: view_entity

CDS ST: Enumeration Values CHAR 5

dd_drty_st_enum_values_char_5 is a CDS View that provides data about "CDS ST: Enumeration Values CHAR 5" in SAP S/4HANA. It reads from 2 data sources (dddrty_smpl_enum, dddrty_smpl_type) and exposes 4 fields with key fields simpleType, enumIdentifier, enumValue. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
dddrty_smpl_enum enum inner
dddrty_smpl_type type from

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd_drty_st_enum_value_t_char_5 _Text

Annotations (3)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS ST: Enumeration Values CHAR 5 view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY simpleType dddrty_smpl_type type_name Type Name
KEY enumIdentifier dddrty_smpl_enum enum_name Enum of CDS Type
KEY enumValue dddrty_smpl_enum value_char_5 Enum Value Char 5
_Text _Text

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 dd_drty_st_enum_values_char_5.
-- 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 dd_drty_st_enum_values_char_5 AS
SELECT
  type.type_name AS simpleType,
  enum.enum_name AS enumIdentifier,
  enum.value_char_5 AS enumValue
FROM dddrty_smpl_type AS type
INNER JOIN dddrty_smpl_enum AS enum ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd_drty_st_enum_value_t_char_5 AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;