APS_IAM_D_BR

Transparent Table Application Table
2 Fields 51 CDS Views

IAM: Business Role Header

APS_IAM_D_BR is an SAP database table in S/4HANA. IAM: Business Role Header. It contains 2 fields. 51 CDS views read from this table.

CDS Views using this table (51)

ViewTypeJoinVDMDescription
aps_iam_api_scim_group view_entity from SCIM Interface Group
aps_iam_api_scim_group_schemas view_entity from SCIM Interface Group Schemas
aps_iam_api_scim_group_schemas view_entity union SCIM Interface Group Schemas
aps_iam_br_ddl view from Business Role
aps_iam_br_price_tag_ddl view from Business Role Price Tag
APS_IAM_BR_RES_F4_CNT view from Get counted unmaintained res f4
APS_IAM_BR_RES_F4_GRP view left_outer Get unmaintained res grouped for F4
APS_IAM_BR_RES_OVERVIEW view from Get unmaintained restrictions ov
APS_IAM_BR_RES_READ_CNT view from Get counted unmaintained res read
APS_IAM_BR_RES_READ_GRP view left_outer Get unmaintained res grouped for read
APS_IAM_BR_RES_WRITE_CNT view from Get counted unmaintained res write
APS_IAM_BR_RES_WRITE_GRP view left_outer Get unmaintained res grouped for write
aps_iam_br_root view from Business Role Root View
APS_IAM_BR_UUID view_entity from Maps UUID to char
APS_IAM_BRMS view from Business Role to Master Association
aps_iam_brole_pfcg_log view left_outer IAM: Business Role pfcg generation log
aps_iam_brole_pub view from Business Role
aps_iam_brole_read_role view_entity left_outer Business Roles
aps_iam_brole_read_role view_entity from Business Roles
aps_iam_brole_read_role_deriv view_entity from Derived Business Roles
aps_iam_brole_res_value_pub view_entity from IAM: Business Role Restriciton Values
aps_iam_brole_restriction view from IAM: Business Role Restriction & values
APS_IAM_BROLE_SYNCH_DEL_RES view_entity left_outer BR Synch Delete Restrictions
APS_IAM_BROLE_SYNCH_DEL_VAL view_entity left_outer BR Synch Delete Values
APS_IAM_BROLE_SYNCH_DERIVED view_entity left_outer BR Synch Derived Values
APS_IAM_BROLE_SYNCH_DERIVED view_entity from BR Synch Derived Values
APS_IAM_BROLE_SYNCH_LEADING view_entity left_outer BR Synch Leading Values
aps_iam_brole_user_pfcg_pub view_entity from IAM: Business Role - User - PFCG
aps_iam_brrm_ddl view from Business Role Access Category Max Restriction
APS_IAM_DIFF_VALUES view_entity left_outer Get differences to actual role values
aps_iam_info_br_bc_basic view_entity from Business Role - Business Catalog Basic
APS_IAM_INFO_BR_BRT_BASIC view_entity from Business Role - Bus. Rol. Template Basic
aps_iam_info_br_bu_basic view from Business Role - Business User Basic
APS_IAM_INFO_BR_DBR_BASIC view_entity from Business Role - Derived Business Role
APS_IAM_INFO_BR_DBR_BASIC view_entity left_outer Business Role - Derived Business Role
APS_IAM_INFO_BU_SERVICE_BASIC view_entity inner Business User - Service Usage Basic
APS_IAM_INFO_BU_SERVICE_UN_BSC view_entity from Business User - Service Unused Basic
APS_IAM_INFO_BU_SERVICE_UN_BSC view_entity union Business User - Service Unused Basic
APS_IAM_READ_DIFF_VALUES view_entity left_outer Read difference staging and active val
APS_IAM_REP_OW_REST view from IAM Key Figures App overwritten restrict
APS_IAM_REP_RES_SELECTION view left_outer IAM Key Figures App Restrictions select
Aps_Iam_Siag_Br_Dll view from IAG Business Role View
I_IAMBusinessRole view_entity from BASIC Business Role
P_APS_IAM_BR_CATALOG_APPS view_entity from IAM: Get UIADs for BR catalogs
p_aps_iam_brole_api_bc view_entity inner IAM: Business Role - external API -Business Catalogs
p_aps_iam_brole_api_root view_entity from IAM: Business Role - external API
p_aps_iam_iag_br_app view_entity inner APS-IAM: IAG Business Role - Apps
p_aps_iam_iag_br_bc view_entity inner IAM Business Role Bus. Catalog Assgnmnt.
p_aps_iam_price_cat_x_br_wgh view_entity from IAM: Price Category X - Business Role Weight
P_APS_IAM_USER_FIORI_APP view_entity from IAM: Fiori Apps a Business User can use
P_IAMBUSINESSROLE view_entity from IAM: Business Role

Fields (2)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY uuid uuid UUID

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 Role Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_D_BR (
    CLIENT,  -- Client [mandt]
    UUID,    -- UUID [uuid]
    PRIMARY KEY (CLIENT, UUID)
);

Learn More