APS_IAM_W_BU_CAT
IAM: Business Catalog
APS_IAM_W_BU_CAT is an SAP database table in S/4HANA. IAM: Business Catalog. It contains 13 fields. 23 CDS views read from this table.
CDS Views using this table (23)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APS_COM_OA2_SCOPE_BY_BUCAT | view_entity | inner | OAuth2 Scope by Business Catalog | |
| APS_COM_OA2_SCOPE_BY_BUCAT | view_entity | from | OAuth2 Scope by Business Catalog | |
| APS_IAM_APP_APPS_LIST_DDL | view | left_outer | IAM: Get all Apps of catalogs | |
| APS_IAM_APP_APPS_LIST_DDL | view | inner | IAM: Get all Apps of catalogs | |
| aps_iam_app_core | view_entity | left_outer | IAM: App - App Core View | |
| APS_IAM_BC_CDS_AUTH_AGR_BC | view | from | Business Catalogs - AGR | |
| aps_iam_bc_core | view_entity | from | IAM: Business Catalog - Catalog List | |
| APS_IAM_BR_RES_DEF | view | inner | Get restriction metadata of roles | |
| APS_IAM_BR_RES_DEF | view | left_outer | Get restriction metadata of roles | |
| aps_iam_brt_ddl | view | inner | Business Role Template | |
| APS_IAM_CHANGED_BC_MDV | view | left_outer | IAM Business Catalog Versions | |
| APS_IAM_INFO_BU_SERVICE_BASIC | view_entity | inner | Business User - Service Usage Basic | |
| APS_IAM_INFO_BU_SERVICE_UN_BSC | view_entity | inner | Business User - Service Unused Basic | |
| APS_IAM_RSTR_BUC_UI | view | left_outer | Restriction Type and Business Catalog Assignment - Fiori UI | |
| aps_iam_vbcs_ddl | view | from | Business Catalog (Scoped) | |
| aps_iam_vbct_ddl | view | inner | Business Catalog Text | |
| aps_iam_vbuc_ddl | view | from | Business Catalog | |
| aps_iam_vrbuc_ddl | view | from | Restricted Business Catalog | |
| aps_lang_vrs_obj_active_sia1 | view_entity | from | IAM: SIA1 - ABAP Language Version of Active Objects | |
| aps_lang_vrs_obj_edit_sia1 | view_entity | from | IAM: SIA1 - ABAP Language Version of Edited Objects | |
| P_APS_IAM_BC_FIORI_APP | view_entity | inner | IAM: Fiori App | |
| P_APS_IAM_CAT_UIAD | view_entity | inner | IAM: Get UIADs for catalogs | |
| p_aps_iam_iag_br_bc | view_entity | inner | IAM Business Role Bus. Catalog Assgnmnt. |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | bu_catalog_id | aps_iam_bu_catalog_id | ||||
| bu_catalog_type | aps_iam_bu_catalog_type | |||||
| scope_dependent | aps_bc_scope_dependent | Scope Dependent | ||||
| catalog_id | aps_iam_catalog_id | |||||
| flp_group_id | /ui2/group_id | Group ID | ||||
| agr_name | agr_name | Role | ||||
| derivable | aps_iam_bu_cat_derivable | |||||
| restrictable | aps_iam_bu_cat_restrictable | |||||
| read_only | aps_iam_bu_cat_read_only | |||||
| abap_language_version | abap_language_version | Language Version | ||||
| app_migration_status | aps_iam_buc_app_mig_status | |||||
| skip_pfcg_role_gen | xfeld | Checkbox | ||||
| forbid_deactivate_apps | aps_iam_bc_forbid_deact_apps |
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
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_W_BU_CAT (
BU_CATALOG_ID, -- aps_iam_bu_catalog_id
BU_CATALOG_TYPE, -- aps_iam_bu_catalog_type
SCOPE_DEPENDENT, -- Scope Dependent [aps_bc_scope_dependent]
CATALOG_ID, -- aps_iam_catalog_id
FLP_GROUP_ID, -- Group ID [/ui2/group_id]
AGR_NAME, -- Role [agr_name]
DERIVABLE, -- aps_iam_bu_cat_derivable
RESTRICTABLE, -- aps_iam_bu_cat_restrictable
READ_ONLY, -- aps_iam_bu_cat_read_only
ABAP_LANGUAGE_VERSION, -- Language Version [abap_language_version]
APP_MIGRATION_STATUS, -- aps_iam_buc_app_mig_status
SKIP_PFCG_ROLE_GEN, -- Checkbox [xfeld]
FORBID_DEACTIVATE_APPS, -- aps_iam_bc_forbid_deact_apps
PRIMARY KEY (BU_CATALOG_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