APS_IAM_BR_ROOT

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);