SQL1_HEAD

Transparent Table System Table (transport)
16 Fields 14 CDS Views

SQL Service Binding Header (SQL1)

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

CDS Views using this table (14)

ViewTypeJoinVDMDescription
dbc2abap_cds_elements view_entity from CDS Entities in SQL1 Service Bindings
dbc2abap_cds_entities view_entity from CDS View Entities in SQL1 Service Bindings
DBC2ABAP_CDS_PARAMETERS view_entity from CDS Entity Parameters in SQL1 ServiceB
DBC2ABAP_CDS_TABLE_ELEMENTS view_entity from CDS Table Entities in SQL1 Services
DBC2ABAP_CDS_TABLES view_entity from CDS Table Entities in SQL1 Service Bindings
DBC2ABAP_CDS_VIEW_ELEMENTS view_entity from CDS Entities in SQL1 Service Bindings
DBC2ABAP_CDS_VIEWS view_entity from CDS View Entities in SQL1 Service Bindings
DBC2ABAP_PROC_PARM_COLS_ALL view_entity from Procedure param cols for SQL service
dbc2abap_proc_parms_all view_entity from Procedure parameters for SQL service
dbc2abap_procs_all view_entity from Procedures for SQL service
DBC2ABAP_SCHEMAS view_entity from Schemas for SQL service
DBC2ABAP_SQL1_RT_HEAD view_entity from Schemas for SQL service runtime
SQL1_LANG_VRS_OBJ_ACTIVE_SQL1 view_entity from SQL Service: Language Version (Active)
SQL1_LANG_VRS_OBJ_EDIT_SQL1 view_entity from SQL Service: Language Version (Edited)

Fields (16)

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
abap_language_version abap_language_version Language Version
disabled_for_select sql1_disabled_for_select
enabled_for_replicate sql1_enabled_for_replicate
enabled_for_insert sql1_enabled_for_insert
enabled_for_update sql1_enabled_for_update
enabled_for_delete sql1_enabled_for_delete
enabled_for_execute sql1_enabled_for_execute

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
    ABAP_LANGUAGE_VERSION,  -- Language Version [abap_language_version]
    DISABLED_FOR_SELECT,    -- sql1_disabled_for_select
    ENABLED_FOR_REPLICATE,  -- sql1_enabled_for_replicate
    ENABLED_FOR_INSERT,     -- sql1_enabled_for_insert
    ENABLED_FOR_UPDATE,     -- sql1_enabled_for_update
    ENABLED_FOR_DELETE,     -- sql1_enabled_for_delete
    ENABLED_FOR_EXECUTE,    -- sql1_enabled_for_execute
    PRIMARY KEY (SQL1_NAME, STATE)
);

Learn More