SRF_QUERY
Query definition
SRF_QUERY is an SAP database table in S/4HANA. Query definition. It contains 12 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAC_DART_Z3_QUERY_FIELD | view | inner | Dart Z3 Field View |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 (
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]
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA