UST04
Benutzerstaemme
UST04 is an SAP database table in S/4HANA. Benutzerstaemme. It contains 3 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_LogAccMUserMaster | view | from | BASIC | User Master |
| P_PROF | view | left_outer | Get Profiles for users | |
| P_PROF_PAR | view | inner | Profiles with Parameter | |
| P_PROF_PAR_REF | view | inner | Profiles with Parameter for ref.users | |
| P_USER_COMPOSITE_PROF | view | left_outer | Get Profiles for users | |
| P_USER_OBJECT_AUTH | view | left_outer | Users from UST12 for single Profiles | |
| P_UserObjectAuth | view | left_outer | Users with Object and Authorization | |
| P_USR_AUTH_PROF | view | inner | User with Profiles or Authorizations | |
| P_USR_AUTH_PROF_BUF | view | left_outer | User with Profiles or Authorizations | |
| P_USR_AUTH_ROLE | view | inner | User with Roles or Authorizations | |
| SUIM_GET_US_AUTH_S_TABU_DIS | view_entity | inner | Get S_TABU_DIS Auth. for User | |
| SUIM_GET_US_AUTH_S_TABU_NAM | view_entity | inner | Get S_TABU_NAM Auth. for User |
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.
-- Benutzerstaemme
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UST04 (
MANDT, -- Client [mandt]
BNAME, -- User [xubname]
PROFILE, -- Profile [xuprofile]
PRIMARY KEY (MANDT, BNAME, PROFILE)
);
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