APS_IAM_W_APPAUI

Transparent Table System Table (transport)
9 Fields 7 CDS Views

IAM: IAM App - Authorization

APS_IAM_W_APPAUI is an SAP database table in S/4HANA. IAM: IAM App - Authorization. It contains 9 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
APS_IAM_AUTH_FIELD_VAL view_entity from auth object fields with value
i_aps_iam_app_core_auth view_entity from IAM: App - Authorizations
i_aps_iam_app_core_auth view_entity union IAM: App - Authorizations
p_aps_iam_app_auth_val view_entity left_outer IAM: IAM App Auth and values
p_aps_iam_iag_app_auth view_entity inner IAM App - Authorization
p_aps_iam_iag_app_auth_val view_entity inner IAM App - Authorization Values
p_aps_iam_iag_br_app_auth_core view_entity inner IAM IAG Business Role Authorizations

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY app_id aps_iam_app_id
KEY uuid uuid UUID
auth_object agobject Object
auth_object_inst_id aps_iam_auth_obj_inst_id
ibs_source xupname Name
status aps_iam_auth_obj_field_status
inactive aps_iam_app_auth_inactive
copied aps_iam_app_auth_copied
ibs_source_type usobtype Test status type

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.

-- IAM: IAM App - Authorization
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_W_APPAUI (
    APP_ID,               -- aps_iam_app_id
    UUID,                 -- UUID [uuid]
    AUTH_OBJECT,          -- Object [agobject]
    AUTH_OBJECT_INST_ID,  -- aps_iam_auth_obj_inst_id
    IBS_SOURCE,           -- Name [xupname]
    STATUS,               -- aps_iam_auth_obj_field_status
    INACTIVE,             -- aps_iam_app_auth_inactive
    COPIED,               -- aps_iam_app_auth_copied
    IBS_SOURCE_TYPE,      -- Test status type [usobtype]
    PRIMARY KEY (APP_ID, UUID)
);

Learn More