SRF_QUERY

Transparent Table System Table (transport)
15 Fields 1 CDS Views

Query definition

SRF_QUERY is an SAP database table in S/4HANA. Query definition. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAC_DART_Z3_QUERY_FIELD view inner Dart Z3 Field View

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY report_id SRF_REPORT_ID Report Definition
KEY report_version SRF_REPORT_VERSION Report Version
KEY query_id SRF_QUERY_ID Query ID
view_name SRF_VIEW_NAME View name
bex_query_name SRF_BEX_QUERY_NAME BEx Query
ana_disp_ind SRF_ANA_DISP_IND Display Indicator
query_source_uuid SRF_QUERY_SOURCE_UUID UUID for Query Srce
logical_hdi_container CTS_HDI_CONTAINER Logical Container
class_name SEOCLSNAME Type Name
method_name SEOCPDNAME Interface Comp.
message_par_name SEOSCONAME Subcomponent
limit_par_name SEOSCONAME Subcomponent
offset_par_name SEOSCONAME Subcomponent
changed_on TIMESTAMPL Time Stamp
query_source_type SRF_QUERY_SOURCE_TYPE Query Source Type

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.

-- Query definition
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRF_QUERY (
    REPORT_ID,              -- Report Definition [SRF_REPORT_ID]
    REPORT_VERSION,         -- Report Version [SRF_REPORT_VERSION]
    QUERY_ID,               -- Query ID [SRF_QUERY_ID]
    VIEW_NAME,              -- View name [SRF_VIEW_NAME]
    BEX_QUERY_NAME,         -- BEx Query [SRF_BEX_QUERY_NAME]
    ANA_DISP_IND,           -- Display Indicator [SRF_ANA_DISP_IND]
    QUERY_SOURCE_UUID,      -- UUID for Query Srce [SRF_QUERY_SOURCE_UUID]
    LOGICAL_HDI_CONTAINER,  -- Logical Container [CTS_HDI_CONTAINER]
    CLASS_NAME,             -- Type Name [SEOCLSNAME]
    METHOD_NAME,            -- Interface Comp. [SEOCPDNAME]
    MESSAGE_PAR_NAME,       -- Subcomponent [SEOSCONAME]
    LIMIT_PAR_NAME,         -- Subcomponent [SEOSCONAME]
    OFFSET_PAR_NAME,        -- Subcomponent [SEOSCONAME]
    CHANGED_ON,             -- Time Stamp [TIMESTAMPL]
    QUERY_SOURCE_TYPE,      -- Query Source Type [SRF_QUERY_SOURCE_TYPE]
    PRIMARY KEY (REPORT_ID, REPORT_VERSION, QUERY_ID)
);

Learn More