SCRL_TABLE

Transparent Table System Table (transport)
10 Fields 3 CDS Views

CRL: Table

SCRL_TABLE is an SAP database table in S/4HANA. CRL: Table. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_SCRL_TABLE_TP view from CRL: Table interface view
P_SCRL_TABLE_TRANSPORTED view from CRL: Table transported view
P_SCRL_TABLE_TRANSPORTED view left_outer CRL: Table transported view

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY library_id scrl_library_id Library ID
KEY version_number scrl_version_number Version Number
KEY table_id scrl_table_id Table ID
description scrl_description Description
type scrl_parameter_type Parameter type
length scrl_parameter_length Parameter length
scale scrl_parameter_scale Parameter scale
code_list sccl_codelist_id Code List ID
data_source scrl_data_source Data Source
structure scrl_structure_id Structure ID

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.

-- CRL: Table
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCRL_TABLE (
    LIBRARY_ID,      -- Library ID [scrl_library_id]
    VERSION_NUMBER,  -- Version Number [scrl_version_number]
    TABLE_ID,        -- Table ID [scrl_table_id]
    DESCRIPTION,     -- Description [scrl_description]
    TYPE,            -- Parameter type [scrl_parameter_type]
    LENGTH,          -- Parameter length [scrl_parameter_length]
    SCALE,           -- Parameter scale [scrl_parameter_scale]
    CODE_LIST,       -- Code List ID [sccl_codelist_id]
    DATA_SOURCE,     -- Data Source [scrl_data_source]
    STRUCTURE,       -- Structure ID [scrl_structure_id]
    PRIMARY KEY (LIBRARY_ID, VERSION_NUMBER, TABLE_ID)
);

Learn More