SCRL_DATA

Transparent Table System Table (transport)

CRL: Data

SCRL_DATA is an SAP database table in S/4HANA. CRL: Data. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_SCRL_DATA_TP view from CRL: Data interface view
P_SCRL_DATA_TRANSPORTED view from CRL: Data transported view
P_SCRL_DATA_TRANSPORTED view left_outer CRL: Data transported view

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY library_id SCRL_LIBRARY_ID Library ID
KEY version_number SCRL_VERSION_NUMBER Version Number
KEY data_id SCRL_DATA_ID Data 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
table_name SCRL_TABLE_ID Table 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: Data
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCRL_DATA (
    LIBRARY_ID,      -- Library ID [SCRL_LIBRARY_ID]
    VERSION_NUMBER,  -- Version Number [SCRL_VERSION_NUMBER]
    DATA_ID,         -- Data ID [SCRL_DATA_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]
    TABLE_NAME,      -- Table ID [SCRL_TABLE_ID]
    PRIMARY KEY (LIBRARY_ID, VERSION_NUMBER, DATA_ID)
);