SQL1_HEAD

Transparent Table System Table (transport)
11 Fields 5 CDS Views

SQL Service Binding Header (SQL1)

SQL1_HEAD is an SAP database table in S/4HANA. SQL Service Binding Header (SQL1). It contains 11 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
dbc2abap_cds_elements view_entity from CDS Entities in SQL1 Service Bindings
dbc2abap_cds_entities view_entity from CDS Entities in SQL1 Service Bindings
DBC2ABAP_CDS_PARAMETERS view_entity from CDS Entity Parameters in SQL1 ServiceB
DBC2ABAP_SCHEMAS view_entity from SQL1 Service Bindings
DBC2ABAP_SQL1_RT_HEAD view_entity from ABAP SQL Runtime Access to SQL Services

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY sql1_name sql1_name SQL Service ID
KEY state r3state Program Status
sql1_name_raw sql1_name_raw SQL Service Name
changed_by wb_changed_by Last Changed By
changed_on wb_changed_on Changed On
changed_at wb_changed_at Changed At
version_id uuid UUID
service_def_name abap.char
service_def_version abap.numc
read_only abap_boolean Truth Value
abap_language_version abap_language_version Language Version

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.

-- SQL Service Binding Header (SQL1)
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SQL1_HEAD (
    SQL1_NAME,              -- SQL Service ID [sql1_name]
    STATE,                  -- Program Status [r3state]
    SQL1_NAME_RAW,          -- SQL Service Name [sql1_name_raw]
    CHANGED_BY,             -- Last Changed By [wb_changed_by]
    CHANGED_ON,             -- Changed On [wb_changed_on]
    CHANGED_AT,             -- Changed At [wb_changed_at]
    VERSION_ID,             -- UUID [uuid]
    SERVICE_DEF_NAME,       -- abap.char
    SERVICE_DEF_VERSION,    -- abap.numc
    READ_ONLY,              -- Truth Value [abap_boolean]
    ABAP_LANGUAGE_VERSION,  -- Language Version [abap_language_version]
    PRIMARY KEY (SQL1_NAME, STATE)
);

Learn More