APS_IAM_BR_ROOT
Business Role Root View
APS_IAM_BR_ROOT is a CDS View in S/4HANA. Business Role Root View. It contains 18 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APS_IAM_BER_RES_APPS_ASS | view | inner | Get app assigned restriction types | |
| aps_iam_br_root_tp | view | from | BR Draft Root. |
Fields (18)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | UUID | UUID | 1 |
| brole_group | brole_group | 1 | |
| brole_type | brole_type | 1 | |
| brt_id | brt_id | 1 | |
| cflp_exposed | cflp_exposed | 1 | |
| creation_date_time | creation_date_time | 1 | |
| creation_user_name | creation_user_name | 1 | |
| derive_fiori_space_id | derive_fiori_space_id | 1 | |
| fiori_space_id | fiori_space_id | 1 | |
| fiori_space_pfcg_role | fiori_space_pfcg_role | 1 | |
| ID | BroleId,ID | 2 | |
| incl_rel_tcode | incl_rel_tcode | 1 | |
| last_change_date_time | last_change_date_time | 1 | |
| last_change_user_name | last_change_user_name | 1 | |
| master_brole_id | master_brole_id | 1 | |
| master_brole_ind | master_brole_ind | 1 | |
| master_brole_uuid | master_brole_uuid | 1 | |
| status | status | 1 |
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.
-- Business Role Root View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_BR_ROOT (
UUID,
BROLE_GROUP,
BROLE_TYPE,
BRT_ID,
CFLP_EXPOSED,
CREATION_DATE_TIME,
CREATION_USER_NAME,
DERIVE_FIORI_SPACE_ID,
FIORI_SPACE_ID,
FIORI_SPACE_PFCG_ROLE,
ID,
INCL_REL_TCODE,
LAST_CHANGE_DATE_TIME,
LAST_CHANGE_USER_NAME,
MASTER_BROLE_ID,
MASTER_BROLE_IND,
MASTER_BROLE_UUID,
STATUS,
PRIMARY KEY (UUID)
);
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