SCI_TEST_DBTAB_I

Transparent Table Temporary Data
6 Fields 1 CDS Views

Verification Test for dbtab with several indices

SCI_TEST_DBTAB_I is an SAP database table in S/4HANA. Verification Test for dbtab with several indices. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sci_ddl_vtest_3 view from sci ddl test 3

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY key1 CHAR12 Character Field of Length 12
KEY key2 CHAR12 Character Field of Length 12
KEY key3 INT2 INT2
val1 INT2 INT2
val2 INT2 INT2
val3 INT4 INT4

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.

-- Verification Test for dbtab with several indices
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCI_TEST_DBTAB_I (
    KEY1,  -- Character Field of Length 12 [CHAR12]
    KEY2,  -- Character Field of Length 12 [CHAR12]
    KEY3,  -- INT2 [INT2]
    VAL1,  -- INT2 [INT2]
    VAL2,  -- INT2 [INT2]
    VAL3,  -- INT4 [INT4]
    PRIMARY KEY (KEY1, KEY2, KEY3)
);

Learn More