dd_drty_st_enum_value_t_int2
CDS ST: Enum Values INT2 with Text
dd_drty_st_enum_value_t_int2 is a CDS View that provides data about "CDS ST: Enum Values INT2 with Text" in SAP S/4HANA. It reads from 2 data sources (dd_drty_st_enum_values_int2, dddrty_a_enum_t) and exposes 8 fields with key fields simpleType, enumIdentifier, enumValue, language, enumTextName. It has 1 association to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| dd_drty_st_enum_values_int2 | enum | from |
| dddrty_a_enum_t | enum_t | inner |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Language | _Language | $projection.Language = _Language.Language |
Annotations (3)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.entityBuffer.definitionAllowed | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | CDS ST: Enum Values INT2 with Text | view |
Fields (8)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | simpleType | dd_drty_st_enum_values_int2 | simpleType | |
| KEY | enumIdentifier | dd_drty_st_enum_values_int2 | enumIdentifier | |
| KEY | enumValue | dd_drty_st_enum_values_int2 | enumValue | |
| KEY | language | dddrty_a_enum_t | language | |
| KEY | enumTextName | dddrty_a_enum_t | anno_name | |
| enumText | dddrty_a_enum_t | anno_text | ||
| _EnumValue | _EnumValue | |||
| _Language | _Language |
@AbapCatalog.entityBuffer.definitionAllowed: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS ST: Enum Values INT2 with Text'
define view entity dd_drty_st_enum_value_t_int2
as select from dd_drty_st_enum_values_int2 as enum
inner join dddrty_a_enum_t as enum_t on enum.simpleType = enum_t.type_name
and enum.enumIdentifier = enum_t.enum_name
association to parent dd_drty_st_enum_values_int2 as _EnumValue on $projection.simpleType = _EnumValue.simpleType
and $projection.enumIdentifier = _EnumValue.enumIdentifier
and $projection.enumValue = _EnumValue.enumValue
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
key enum.simpleType,
key enum.enumIdentifier,
key enum.enumValue,
key enum_t.language as language,
key enum_t.anno_name as enumTextName,
enum_t.anno_text as enumText,
_EnumValue,
_Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD_DRTY_ST_ENUM_VALUES_INT2",
"DDDRTY_A_ENUM_T"
],
"ASSOCIATED":
[
"DD_DRTY_ST_ENUM_VALUES_INT2",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA