APS_IAM_W_BUC_RT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description |
|---|---|---|---|
| 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)
);
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