UST12

Transparent Table Control Table (SAP+Cust)
7 Fields 23 CDS Views

User master: Authorizations

UST12 is an SAP database table in S/4HANA. User master: Authorizations. It contains 7 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
/dmbe/I_User_Master_Authority view from User master: Authorizations
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 Authizations of a user
I_IBCAuthorization view_entity inner BASIC IBC Authorization
I_LogAccMActvUsrAuthorizations view from BASIC Authorizations
I_PPS_POAuthznProfileBasic view_entity from BASIC PPS Purchase Order Authorizatin Profile
I_RequestOwners view_entity inner Request Owners
P_CmplRqRsltUserProfile view from BASIC
P_GRIRUSR_ALL_AUTH view from BASIC
P_MDQltyBusRuleAuthznProfile view_entity inner BASIC
P_MDQltyDrvtnScenAuthznProfile view_entity from BASIC
P_MDQltyDrvtnScenAuthznProfile view_entity inner BASIC
P_MDQltyDrvtnScenRuleAuthPrfl view_entity from BASIC
P_MDQltyDrvtnScenRuleAuthPrfl view_entity inner BASIC
P_MDQltyMndRuleAuthznProfile view inner BASIC
P_MDQltyRuleMnngAuthznProfile view inner BASIC
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

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objct XUOBJECT Object
KEY auth XUAUTH Authorization
KEY aktps XUAKTPAS Version
KEY field XUFIELD Field Name
KEY von XUVAL Value
KEY bis XUVAL Value

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.

-- User master: Authorizations
-- 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