APS_IAM_D_BU_CAT

Transparent Table Temporary Data

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)

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

KeyField Data ElementDescription DomainTypeLength
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)
);