APS_IAM_W_BUC_RT

Transparent Table System Table (transport)

IAM: Business Catalog Restriction Type

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

CDS Views using this table (10)

ViewTypeJoinVDMDescription
aps_iam_bc_core_rt_bc view_entity from IAM: Business Catalog - Restriction Types BC
APS_IAM_BC_RT_FLD view from Business Catalog Restriction Type Field
APS_IAM_BR_RES_DEF view inner Get restriction metadata of roles
aps_iam_br_rtf view inner Business Role Aggregatable Restriction Type Fields
APS_IAM_BR_RTF_D view inner Business Role Aggregatable Restriction Type Fields
aps_iam_info_bc_re_basic view inner Business Catalog - Restriction Field
APS_IAM_RSTR_BUC_UI view from Restriction Type and Business Catalog Assignment - Fiori UI
APS_IAM_RTYPE view inner Restriction Types
APS_IAM_RTYPE_D view inner Restriction Types
aps_iam_vbcrt_ddl view from Business Catalog Restriction Type

Fields (9)

KeyField Data ElementDescription
KEY bu_catalog_id aps_iam_bu_catalog_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: Business Catalog 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_BUC_RT (
    BU_CATALOG_ID,        -- aps_iam_bu_catalog_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 (BU_CATALOG_ID, RESTRICTION_TYPE_ID)
);