DDDRTY_A_ENUM_T
Annotation Texts of CDS Type Enums
DDDRTY_A_ENUM_T is an SAP database table in S/4HANA. Annotation Texts of CDS Type Enums. It contains 8 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| dd_drty_st_enum_value_t_char_1 | view_entity | inner | CDS ST: Enum Values CHAR 1 with Text | |
| dd_drty_st_enum_value_t_char_2 | view_entity | inner | CDS ST: Enum Values CHAR 2 with Text | |
| dd_drty_st_enum_value_t_char_3 | view_entity | inner | CDS ST: Enum Values CHAR 3 with Text | |
| dd_drty_st_enum_value_t_char_4 | view_entity | inner | CDS ST: Enum Values CHAR 4 with Text | |
| dd_drty_st_enum_value_t_char_5 | view_entity | inner | CDS ST: Enum Values CHAR 5 with Text | |
| dd_drty_st_enum_value_t_char_6 | view_entity | inner | CDS ST: Enum Values CHAR 6 with Text | |
| dd_drty_st_enum_value_t_char_7 | view_entity | inner | CDS ST: Enum Values CHAR 7 with Text | |
| dd_drty_st_enum_value_t_char_8 | view_entity | inner | CDS ST: Enum Values CHAR 8 with Text | |
| dd_drty_st_enum_value_t_int1 | view_entity | inner | CDS ST: Enum Values INT1 with Text | |
| dd_drty_st_enum_value_t_int2 | view_entity | inner | CDS ST: Enum Values INT2 with Text | |
| dd_drty_st_enum_value_t_int4 | view_entity | inner | CDS ST: Enum Values INT4 with Text | |
| dd_drty_st_enum_value_t_numc_1 | view_entity | inner | CDS ST: Enum Values NUMC 1 with Text | |
| dd_drty_st_enum_value_t_numc_2 | view_entity | inner | CDS ST: Enum Values NUMC 2 with Text | |
| dd_drty_st_enum_value_t_numc_3 | view_entity | inner | CDS ST: Enum Values NUMC 3 with Text | |
| dd_drty_st_enum_value_t_numc_4 | view_entity | inner | CDS ST: Enum Values NUMC 4 with Text | |
| dd_drty_st_enum_value_t_numc_5 | view_entity | inner | CDS ST: Enum Values NUMC 5 with Text | |
| dd_drty_st_enum_value_t_numc_6 | view_entity | inner | CDS ST: Enum Values NUMC 6 with Text | |
| dd_drty_st_enum_value_t_numc_7 | view_entity | inner | CDS ST: Enum Values NUMC 7 with Text | |
| dd_drty_st_enum_value_t_numc_8 | view_entity | inner | CDS ST: Enum Values NUMC 8 with Text | |
| dd_drty_st_enum_values_t | view_entity | inner | CDS ST: Enum Values with Text |
Fields (8)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | type_name | DD_DRTY_NAME | CDS Type Name | |||
| KEY | language | DDLANGUAGE | Lang. | |||
| KEY | as4local | AS4LOCAL | Activation State | |||
| KEY | element_name | DD_DRTY_ELEMENT | Element Name | |||
| KEY | enum_name | DD_DRTY_ENUM | Enum of CDS Type | |||
| KEY | anno_name | DDANNOTATION_KEY | DD: Key/Name for Annotation | |||
| KEY | anno_position | DDFDPOS | DD: Marked Position in a Repeat Group | |||
| anno_text | DDTEXT255 | DD: Text of Length 255 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Annotation Texts of CDS Type Enums
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDDRTY_A_ENUM_T (
TYPE_NAME, -- CDS Type Name [DD_DRTY_NAME]
LANGUAGE, -- Lang. [DDLANGUAGE]
AS4LOCAL, -- Activation State [AS4LOCAL]
ELEMENT_NAME, -- Element Name [DD_DRTY_ELEMENT]
ENUM_NAME, -- Enum of CDS Type [DD_DRTY_ENUM]
ANNO_NAME, -- DD: Key/Name for Annotation [DDANNOTATION_KEY]
ANNO_POSITION, -- DD: Marked Position in a Repeat Group [DDFDPOS]
ANNO_TEXT, -- DD: Text of Length 255 [DDTEXT255]
PRIMARY KEY (TYPE_NAME, LANGUAGE, AS4LOCAL, ELEMENT_NAME, ENUM_NAME, ANNO_NAME, ANNO_POSITION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA