DEMO_EXPRESSIONS

Transparent Table Application Table
45 Fields 47 CDS Views

Database Table for Expression Examples

DEMO_EXPRESSIONS is an SAP database table in S/4HANA. Database Table for Expression Examples. It contains 45 fields. 47 CDS views read from this table.

CDS Views using this table (47)

ViewTypeJoinVDMDescription
DEMO_CDS_AGGREGATE_VE view_entity from CDS view entity, aggregate expressions
demo_cds_annotation_array view_entity from CDS DDIC-based view, annotation array
Demo_Cds_Avg view from CDS DDIC-based view, aggregate expression AVG
Demo_Cds_Avg_Ve view_entity from CDS view entity, aggregate expression AVG
demo_cds_cast_data_element view from CDS DDIC-based view, cast data element semantics
DEMO_CDS_CAST_SIMPLE_TYPE_VE view_entity from CDS view entity, cast data element semantics
DEMO_CDS_DATE_FUNC_VE view_entity from CDS view entity, date functions
demo_cds_date_functions view from CDS DDIC-based view, date functions
demo_cds_date_time view from CDS DDIC-based view, date/time conversions
DEMO_CDS_DATE_TIME_VE view_entity from CDS view entity, date/time conversions
DEMO_CDS_ENUM_TYPE_USAGE_1 view_entity from CDS view entity, enumerated types
DEMO_CDS_EXCEPT_NESTING view_entity from set operator EXCEPT, nesting
DEMO_CDS_EXPRESSION_REUSE view_entity from CDS view entity, expression reuse
demo_cds_fltp_to_dec view from CDS DDIC-based view, conversion function FLTP_TO_DEC
DEMO_CDS_FLTP_TO_DEC_VE view_entity from CDS view entity, conversion function FLTP_TO_DEC
Demo_Cds_MDE view_entity from CDS view entity, enhanced using metadata enhancements
DEMO_CDS_NULL view_entity from CDS view entity that return a null value
demo_cds_parameter_type view from CDS DDIC-based view, parameter type specified
DEMO_CDS_PARAMETER_TYPE_VE view_entity from CDS view entity, parameter type specified
DEMO_CDS_SCALAR_USE view_entity from CDS view entity, scalar func
demo_cds_session_variables view from CDS DDIC-based view, session variables
demo_cds_session_variables_ve view_entity from CDS view entity, session variables
DEMO_CDS_SIMPLE_TYPE_USAGE view_entity from CDS view entity, simple types
demo_cds_sql_func_string_ve view_entity from CDS view entity, string functions
demo_cds_sql_functions view from CDS DDIC-based view, SQL functions
demo_cds_sql_functions_byte view from CDS DDIC-based view, byte string functions
DEMO_CDS_SQL_FUNCTIONS_BYTE_VE view_entity from CDS view entity, byte string functions
demo_cds_sql_functions_num view from CDS DDIC-based view, numeric functions
DEMO_CDS_SQL_FUNCTIONS_NUM_VE view_entity from CDS view entity, numeric functions
demo_cds_sql_functions_string view from CDS DDIC-based view, string functions
demo_cds_system_fields view from DDIC-based view, parameter for system fields
DEMO_CDS_SYSTEM_FIELDS_VE view_entity from CDS view entity, parameter for system fields
demo_cds_text_annotations view_entity from Demo View with Texts
DEMO_CDS_TIME_FUNC_VE view_entity from CDS view entity, time functions
demo_cds_time_functions view from CDS DDIC-based view, time functions
DEMO_CDS_TIMESTAMP_FUNC_VE view_entity from CDS view entity, CDS time stamp functions
demo_cds_timestamp_functions view from CDS DDIC-based view, CDS time stamp functions
DEMO_CDS_TIMEZONE_FUNC_VE view_entity from CDS view entity, built-in functions for time zones
demo_cds_timezone_functions view from CDS DDIC-based view, built-in functions for time zones
DEMO_CDS_TWO_NUMBERS view_entity from Two numbers
Demo_Cds_Union_Element_Type view from CDS DDIC-based view, element type for union sets
Demo_Cds_Union_Element_Type view union_all CDS DDIC-based view, element type for union sets
DEMO_CDS_UNION_ELEMENT_TYPE_VE view_entity from CDS view entity, element type for union sets
DEMO_CDS_UNION_ELEMENT_TYPE_VE view_entity union_all CDS view entity, element type for union sets
demo_cds_unit_conversion view from CDS DDIC-based view, unit conversion
DEMO_CDS_UNIT_CONVERSION_VE view_entity from CDS view entity, unit conversion
demo_cds_view_annotations view_entity from Demo View with Annotations

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY id char1 Single-Character Flag
num1 abap.int4
num2 abap.int4
numlong1 abap.int8
numlong2 abap.int8
dec1 abap.dec
dec2 abap.dec
dec3 abap.dec
fltp1 abap.fltp
fltp2 abap.fltp
d34n1 abap.decfloat34
d34n2 abap.decfloat34
decf1 abap.df34_dec
decf2 abap.df34_dec
char1 abap.char
char2 abap.char
numc1 abap.numc
numc2 abap.numc
string1 abap.string
string2 abap.string
raw1 abap.raw
raw2 abap.raw
xstring1 abap.rawstring
xstring2 abap.rawstring
datn1 abap.datn
datn2 abap.datn
dats1 abap.dats
dats2 abap.dats
timn1 abap.timn
timn2 abap.timn
tims1 abap.tims
tims2 abap.tims
utcl1 abap.utclong
utcl2 abap.utclong
timestamp1 timestamp Time Stamp
timestamp2 timestamp Time Stamp
timestampl1 timestampl Time Stamp
timestampl2 timestampl Time Stamp
df34_dec abap.df34_dec
df34_raw abap.df34_raw
df16_dec abap.df16_dec
df16_raw abap.df16_raw
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 for Expression Examples
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_EXPRESSIONS (
    MANDT,        -- Client [mandt]
    ID,           -- Single-Character Flag [char1]
    NUM1,         -- abap.int4
    NUM2,         -- abap.int4
    NUMLONG1,     -- abap.int8
    NUMLONG2,     -- abap.int8
    DEC1,         -- abap.dec
    DEC2,         -- abap.dec
    DEC3,         -- abap.dec
    FLTP1,        -- abap.fltp
    FLTP2,        -- abap.fltp
    D34N1,        -- abap.decfloat34
    D34N2,        -- abap.decfloat34
    DECF1,        -- abap.df34_dec
    DECF2,        -- abap.df34_dec
    CHAR1,        -- abap.char
    CHAR2,        -- abap.char
    NUMC1,        -- abap.numc
    NUMC2,        -- abap.numc
    STRING1,      -- abap.string
    STRING2,      -- abap.string
    RAW1,         -- abap.raw
    RAW2,         -- abap.raw
    XSTRING1,     -- abap.rawstring
    XSTRING2,     -- abap.rawstring
    DATN1,        -- abap.datn
    DATN2,        -- abap.datn
    DATS1,        -- abap.dats
    DATS2,        -- abap.dats
    TIMN1,        -- abap.timn
    TIMN2,        -- abap.timn
    TIMS1,        -- abap.tims
    TIMS2,        -- abap.tims
    UTCL1,        -- abap.utclong
    UTCL2,        -- abap.utclong
    TIMESTAMP1,   -- Time Stamp [timestamp]
    TIMESTAMP2,   -- Time Stamp [timestamp]
    TIMESTAMPL1,  -- Time Stamp [timestampl]
    TIMESTAMPL2,  -- Time Stamp [timestampl]
    DF34_DEC,     -- abap.df34_dec
    DF34_RAW,     -- abap.df34_raw
    DF16_DEC,     -- abap.df16_dec
    DF16_RAW,     -- abap.df16_raw
    LCHR_INT,     -- abap.int4
    LCHR,         -- abap.lchr
    PRIMARY KEY (MANDT, ID)
);

Learn More