DEMO_DDIC_TYPES

Transparent Table Application Table
51 Fields 18 CDS Views

Database Table with Different Dictionary Types

DEMO_DDIC_TYPES is an SAP database table in S/4HANA. Database Table with Different Dictionary Types. It contains 51 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
Demo_Cds_Application_Sess_Var view_entity from CDS view entity, application sess var
DEMO_CDS_BT view_entity from CDS view entity, simple type
DEMO_CDS_CALC_QUANTITY_BASE view_entity from CDS view entity, layer 1 view stack
DEMO_CDS_CHAR_TYPED_LIT view_entity from CDS view entity, typed char literals
DEMO_CDS_COALESCE view_entity from
DEMO_CDS_COALESCE_V1 view from
DEMO_CDS_CURR_AND_QUAN_TYP_LIT view_entity from CDS view entity, typed literals
DEMO_CDS_CURR_TO_DEC view_entity from CDS view entity, CURR_TO_DEC
DEMO_CDS_DATE_AND_TIME_TYP_LIT view_entity from CDS view entity, typed literals
DEMO_CDS_ENUM_2 view_entity from Cast to enum
Demo_Cds_Is_Initial view from
DEMO_CDS_IS_INITIAL_VE view_entity from
DEMO_CDS_NUMERIC_TEXT_TYP_LIT view_entity from CDS view entity, numeric typed literals
DEMO_CDS_NUMERIC_TYPED_LIT view_entity from CDS view entity, numeric typed literals
DEMO_CDS_SCALAR_HELPER view_entity from CDS view entity, scalar func
DEMO_CDS_TYPED_BYTE_LIT view_entity from CDS view entity, typed byte literals
DEMO_CDS_VIEW_CHILD view_entity from CDS view entity, REDEFINED ASSOC
DEMO_CDS_VIEW_PARENT view_entity from CDS view entity, REDEFINED ASSOC

Fields (51)

KeyField Data ElementDescription
KEY mandt abap.clnt
KEY id abap.char
int1 abap.int1
int2 abap.int2
int4 abap.int4
int8 abap.int8
dec10 abap.dec
dec10_2 abap.dec
dec20 abap.dec
dec20_4 abap.dec
d16n abap.decfloat16
df16_dec abap.df16_dec
df16_raw abap.df16_raw
d34n abap.decfloat34
df34_dec abap.df34_dec
df34_raw abap.df34_raw
fltp abap.fltp
char1 abap.char
char10 abap.char
sstring256 abap.sstring
sstring512 abap.sstring
string abap.string
raw1 abap.raw
raw10 abap.raw
rawstring abap.rawstring
dats abap.dats
tims abap.tims
datn abap.datn
timn abap.timn
utcl abap.utclong
accp abap.accp
numc1 abap.numc
numc10 abap.numc
clnt abap.clnt
lang abap.lang
curr10_2 abap.curr
curr10_4 abap.curr
curr20_2 abap.curr
curr20_4 abap.curr
cuky abap.cuky
quan10 abap.quan
quan10_2 abap.quan
quan10_4 abap.quan
quan20 abap.quan
quan20_2 abap.quan
quan20_4 abap.quan
unit2 abap.unit
unit3 abap.unit
geom_ewkb abap.geom_ewkb
lchr_int abap.int4
lchr abap.lchr

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.

-- Database Table with Different Dictionary Types
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_DDIC_TYPES (
    MANDT,       -- abap.clnt
    ID,          -- abap.char
    INT1,        -- abap.int1
    INT2,        -- abap.int2
    INT4,        -- abap.int4
    INT8,        -- abap.int8
    DEC10,       -- abap.dec
    DEC10_2,     -- abap.dec
    DEC20,       -- abap.dec
    DEC20_4,     -- abap.dec
    D16N,        -- abap.decfloat16
    DF16_DEC,    -- abap.df16_dec
    DF16_RAW,    -- abap.df16_raw
    D34N,        -- abap.decfloat34
    DF34_DEC,    -- abap.df34_dec
    DF34_RAW,    -- abap.df34_raw
    FLTP,        -- abap.fltp
    CHAR1,       -- abap.char
    CHAR10,      -- abap.char
    SSTRING256,  -- abap.sstring
    SSTRING512,  -- abap.sstring
    STRING,      -- abap.string
    RAW1,        -- abap.raw
    RAW10,       -- abap.raw
    RAWSTRING,   -- abap.rawstring
    DATS,        -- abap.dats
    TIMS,        -- abap.tims
    DATN,        -- abap.datn
    TIMN,        -- abap.timn
    UTCL,        -- abap.utclong
    ACCP,        -- abap.accp
    NUMC1,       -- abap.numc
    NUMC10,      -- abap.numc
    CLNT,        -- abap.clnt
    LANG,        -- abap.lang
    CURR10_2,    -- abap.curr
    CURR10_4,    -- abap.curr
    CURR20_2,    -- abap.curr
    CURR20_4,    -- abap.curr
    CUKY,        -- abap.cuky
    QUAN10,      -- abap.quan
    QUAN10_2,    -- abap.quan
    QUAN10_4,    -- abap.quan
    QUAN20,      -- abap.quan
    QUAN20_2,    -- abap.quan
    QUAN20_4,    -- abap.quan
    UNIT2,       -- abap.unit
    UNIT3,       -- abap.unit
    GEOM_EWKB,   -- abap.geom_ewkb
    LCHR_INT,    -- abap.int4
    LCHR,        -- abap.lchr
    PRIMARY KEY (MANDT, ID)
);

Learn More