USR_BY_GLOBALUID

Transparent Table Application Table
4 Fields 4 CDS Views

Global User ID

USR_BY_GLOBALUID is an SAP database table in S/4HANA. Global User ID. It contains 4 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
aps_iam_api_scim_user_gudhist view_entity from SCIM Interface User GUID History
APS_IAM_BUSR_GHIST view_entity from Business User GUID History
i_aps_iam_busr_rap_ghist view_entity from IAM: Business User - Global User ID History
P_USR_BY_GLOBALUID view from BASIC User UUID

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sap_uid suid_globaluid Global User ID
bname xubname User
active suid_globaluid_active Act. Global User ID

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.

-- Global User ID
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USR_BY_GLOBALUID (
    MANDT,    -- Client [mandt]
    SAP_UID,  -- Global User ID [suid_globaluid]
    BNAME,    -- User [xubname]
    ACTIVE,   -- Act. Global User ID [suid_globaluid_active]
    PRIMARY KEY (MANDT, SAP_UID)
);

Learn More