SQL1_HEAD

Transparent Table System Table (transport)
11 Fields 10 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. 10 CDS views read from this table.

CDS Views using this table (10)

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_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 (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