APS_IAM_W_APP_RT

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

IAM: IAM App - Restriction Type

APS_IAM_W_APP_RT is an SAP database table in S/4HANA. IAM: IAM App - Restriction Type. It contains 9 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
aps_iam_app_core_rt view_entity from IAM: App - Restriction Types Core
aps_iam_bc_core_rt_av view_entity inner IAM: Business Catalog - Restriction Types AAV
APS_IAM_BER_RES_APPS_ASS view left_outer Get app assigned restriction types
APS_IAM_BR_RTF_A view_entity inner Role Aggregatable Restriction Type Field for Apps
APS_IAM_BR_RTF_AD view_entity inner Role Aggregatable RTField Apps in draft
APS_IAM_INFO_APP_RE_BASIC view_entity inner Basic View for App - Restriction Types
aps_iam_phase_out_restr_app view from IAM Apps - Restriction Types in Phase out status
APS_IAM_RTYPE_A view_entity inner Restriction Types from apps
APS_IAM_RTYPE_AD view_entity inner Restriction Types from apps in draft
p_aps_iam_iag_app_rt view_entity from IAM App - Restriction Type

Fields (9)

KeyField Data ElementDescription
KEY app_id aps_iam_app_id
KEY restriction_type_id aps_iam_cat_rtype_id
read_access aps_iam_cat_rtype_acc_read
write_access aps_iam_cat_rtype_acc_write
f4_access aps_iam_cat_rtype_acc_f4
inactive aps_iam_buc_rt_inactive
read_access_status aps_iam_cat_rtype_acc_status
write_access_status aps_iam_cat_rtype_acc_status
f4_access_status aps_iam_cat_rtype_acc_status

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 - Restriction Type
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_W_APP_RT (
    APP_ID,               -- aps_iam_app_id
    RESTRICTION_TYPE_ID,  -- aps_iam_cat_rtype_id
    READ_ACCESS,          -- aps_iam_cat_rtype_acc_read
    WRITE_ACCESS,         -- aps_iam_cat_rtype_acc_write
    F4_ACCESS,            -- aps_iam_cat_rtype_acc_f4
    INACTIVE,             -- aps_iam_buc_rt_inactive
    READ_ACCESS_STATUS,   -- aps_iam_cat_rtype_acc_status
    WRITE_ACCESS_STATUS,  -- aps_iam_cat_rtype_acc_status
    F4_ACCESS_STATUS,     -- aps_iam_cat_rtype_acc_status
    PRIMARY KEY (APP_ID, RESTRICTION_TYPE_ID)
);

Learn More