APS_IAM_D_BU_CAT
IAM: Business Catalog (Local Data)
APS_IAM_D_BU_CAT is an SAP database table in S/4HANA. IAM: Business Catalog (Local Data). It contains 15 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APS_IAM_New_Migrated_BC | view | left_outer | IAM Newly Migrated Catalogs After Upgrade | |
| APS_IAM_OUTDATED_BR_MDV | view | left_outer | IAM Business Role Versioning - Business Roles to be updated | |
| p_aps_iam_bc_max_non_curr_vrs | view_entity | from | IAM: Max non current version in aps_iam_d_bu_cat |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | bu_catalog_id | aps_iam_bu_catalog_id | ||||
| KEY | version | aps_iam_version | ||||
| is_current_vrs | xfeld | Checkbox | ||||
| bu_catalog_type | aps_iam_bu_catalog_type | |||||
| scope_dependent | aps_bc_scope_dependent | Scope Dependent | ||||
| catalog_id | aps_iam_catalog_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 | |||||
| forbid_deactivate_apps | aps_iam_bc_forbid_deact_apps | |||||
| sap_release | saprelease | SAP Release | ||||
| trkorr | trkorr | Request/Task |
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 (Local Data)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_D_BU_CAT (
BU_CATALOG_ID, -- aps_iam_bu_catalog_id
VERSION, -- aps_iam_version
IS_CURRENT_VRS, -- Checkbox [xfeld]
BU_CATALOG_TYPE, -- aps_iam_bu_catalog_type
SCOPE_DEPENDENT, -- Scope Dependent [aps_bc_scope_dependent]
CATALOG_ID, -- aps_iam_catalog_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
FORBID_DEACTIVATE_APPS, -- aps_iam_bc_forbid_deact_apps
SAP_RELEASE, -- SAP Release [saprelease]
TRKORR, -- Request/Task [trkorr]
PRIMARY KEY (BU_CATALOG_ID, VERSION)
);
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