UST12
Benutzerstamm: Berechtigungen
UST12 is an SAP database table in S/4HANA. Benutzerstamm: Berechtigungen. It contains 7 fields. 22 CDS views read from this table.
CDS Views using this table (22)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Accessible_Views | view | inner | Accessible views(START auth checked) | |
| Accessible_Views_Comp | view | inner | Accessible Views - S_RS_COMP validation | |
| Auth_Objct_Activity | view | inner | Activity Values for S_RS_COMP,S_RS_COMP1,SDDLVIEW | |
| Auth_Profiles | view | inner | Authorization profiles with valid restrictions on all fields | |
| FCCX_V_AUTH_CHECK | view_entity | inner | Authorization for users | |
| hpa_user_authority_read | view | inner | Read User Authorizations | |
| I_LogAccMActvUsrAuthorizations | view | from | BASIC | Authorizations |
| I_MKT_UserAuthority | view | inner | BASIC | User Authority |
| I_RequestOwners | view_entity | inner | Request Owners | |
| P_CmplRqRsltUserProfile | view | from | BASIC | User Profile |
| P_GRIRUSR_ALL_AUTH | view_entity | from | BASIC | User Authorization for GRIR Reconciliation |
| P_MDQltyBusRuleAuthznProfile | view_entity | inner | BASIC | Master Data Quality Business Rule Authorization Profile |
| P_MDQltyDrvtnScenAuthznProfile | view_entity | from | BASIC | Derivation Scenario Authorization Profile |
| P_MDQltyDrvtnScenAuthznProfile | view_entity | inner | BASIC | Derivation Scenario Authorization Profile |
| P_MDQltyDrvtnScenRuleAuthPrfl | view_entity | from | BASIC | Derivation Rule Authorization Profile |
| P_MDQltyDrvtnScenRuleAuthPrfl | view_entity | inner | BASIC | Derivation Rule Authorization Profile |
| P_MDQltyMndRuleAuthznProfile | view | inner | BASIC | MDQ Mined Rule Authorization Profile |
| P_MDQltyRuleMnngAuthznProfile | view | inner | BASIC | MDQ Rule Mining Authorization Profile |
| SUIM__USR_VAL_4_FLD_X | view_entity | inner | SUIM | Get Authorization Values | |
| suim_auth_field_val_x | view_entity | from | Analyze Authorization Values | |
| SUSR_NORMAL_UST12 | view | from | Removes any quote marks from UST12 | |
| SUSR_NORMALIZE_UST12 | view | from | Removes any quote marks from UST12 |
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.
-- Benutzerstamm: Berechtigungen
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UST12 (
MANDT, -- Client [mandt]
OBJCT, -- Object [xuobject]
AUTH, -- Authorization [xuauth]
AKTPS, -- Version [xuaktpas]
FIELD, -- Field Name [xufield]
VON, -- Value [xuval]
BIS, -- Value [xuval]
PRIMARY KEY (MANDT, OBJCT, AUTH, AKTPS, FIELD, VON, BIS)
);
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