APS_IAM_W_INFO

Transparent Table Application Table
64 Fields 1 CDS Views

IAM: Information System Template Filter

APS_IAM_W_INFO is an SAP database table in S/4HANA. IAM: Information System Template Filter. It contains 64 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
aps_iam_info_filter_template view from Filters

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY business_role_id aps_iam_brole_id
business_role_name aps_iam_brole_description
business_role_price_cat aps_iam_text80
user_id aps_userid
user_name usalias Alias
first_name bu_namep_f First Name
last_name bu_namep_l Last Name
user_price_cat aps_iam_text80
business_catalog_id aps_iam_bu_catalog_id
business_catalog_text aps_iam_text80
business_catalog_price_cat aps_iam_text80
access_category val_text Short Description
access_restriction val_text Short Description
restriction_type aps_iam_text80
restriction_field aps_iam_text80
restriction_value abap.char
maintain_status aps_iam_brole_status_maint_res
business_role_group_v rolegroup Role Group
business_role_group rolegroup_text Group Text
business_user_group xuclass User Group
business_user_group_text xutext Text
service_name sobj_name Object Name
object_type trobjtype Object Type
description abap.char
fiori_transaction tcode Transaction Code
application_text aps_iam_info_app_text
fiori_id /ui2/ad_mm_fiori_id SAP Fiori ID
target_mapping_only xfeld Checkbox
app_usage_count val_text Short Description
usage_counter val_text Short Description
usage_counter_sum val_text Short Description
app_usage_count_tstmp val_text Short Description
usage_timestamp val_text Short Description
is_customer_app boole_d TRUE
app_category abap.char
template_id aps_iam_brt_id
template_name aps_iam_text80
write_access boole_d TRUE
read_access boole_d TRUE
f4_access boole_d TRUE
scope_item_id char40 Char
scope_item_description abap.char
scope_item_price_cat char1 Single-Character Flag
app_auth_variant_id aps_iam_bu_catalog_app_chip_id
fiori_space_id /ui2/space_entity_id Space ID
fiori_space_title /ui2/space_title Space Title
fiori_space_description /ui2/space_description Space Description
page_id /ui2/page_entity_id Page ID
page_title /ui2/page_title_ Page Title
page_description /ui2/page_description Page Description
fiori_space_type abap.char
fiori_page_type abap.char
is_optional boole_d TRUE
app_type aps_iam_app_type
app_type_text val_text Short Description
is_navigation_target boole_d TRUE
is_migrated boole_d TRUE
business_catalog_component ufps_posid Applic. Component
application_component ufps_posid Applic. Component
price_category_id aps_iam_usr_price_cat_id
price_category aps_iam_usr_price_cat_desc
locked boole_d TRUE
valid boole_d TRUE

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: Information System Template Filter
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_IAM_W_INFO (
    CLIENT,                      -- Client [mandt]
    BUSINESS_ROLE_ID,            -- aps_iam_brole_id
    BUSINESS_ROLE_NAME,          -- aps_iam_brole_description
    BUSINESS_ROLE_PRICE_CAT,     -- aps_iam_text80
    USER_ID,                     -- aps_userid
    USER_NAME,                   -- Alias [usalias]
    FIRST_NAME,                  -- First Name [bu_namep_f]
    LAST_NAME,                   -- Last Name [bu_namep_l]
    USER_PRICE_CAT,              -- aps_iam_text80
    BUSINESS_CATALOG_ID,         -- aps_iam_bu_catalog_id
    BUSINESS_CATALOG_TEXT,       -- aps_iam_text80
    BUSINESS_CATALOG_PRICE_CAT,  -- aps_iam_text80
    ACCESS_CATEGORY,             -- Short Description [val_text]
    ACCESS_RESTRICTION,          -- Short Description [val_text]
    RESTRICTION_TYPE,            -- aps_iam_text80
    RESTRICTION_FIELD,           -- aps_iam_text80
    RESTRICTION_VALUE,           -- abap.char
    MAINTAIN_STATUS,             -- aps_iam_brole_status_maint_res
    BUSINESS_ROLE_GROUP_V,       -- Role Group [rolegroup]
    BUSINESS_ROLE_GROUP,         -- Group Text [rolegroup_text]
    BUSINESS_USER_GROUP,         -- User Group [xuclass]
    BUSINESS_USER_GROUP_TEXT,    -- Text [xutext]
    SERVICE_NAME,                -- Object Name [sobj_name]
    OBJECT_TYPE,                 -- Object Type [trobjtype]
    DESCRIPTION,                 -- abap.char
    FIORI_TRANSACTION,           -- Transaction Code [tcode]
    APPLICATION_TEXT,            -- aps_iam_info_app_text
    FIORI_ID,                    -- SAP Fiori ID [/ui2/ad_mm_fiori_id]
    TARGET_MAPPING_ONLY,         -- Checkbox [xfeld]
    APP_USAGE_COUNT,             -- Short Description [val_text]
    USAGE_COUNTER,               -- Short Description [val_text]
    USAGE_COUNTER_SUM,           -- Short Description [val_text]
    APP_USAGE_COUNT_TSTMP,       -- Short Description [val_text]
    USAGE_TIMESTAMP,             -- Short Description [val_text]
    IS_CUSTOMER_APP,             -- TRUE [boole_d]
    APP_CATEGORY,                -- abap.char
    TEMPLATE_ID,                 -- aps_iam_brt_id
    TEMPLATE_NAME,               -- aps_iam_text80
    WRITE_ACCESS,                -- TRUE [boole_d]
    READ_ACCESS,                 -- TRUE [boole_d]
    F4_ACCESS,                   -- TRUE [boole_d]
    SCOPE_ITEM_ID,               -- Char [char40]
    SCOPE_ITEM_DESCRIPTION,      -- abap.char
    SCOPE_ITEM_PRICE_CAT,        -- Single-Character Flag [char1]
    APP_AUTH_VARIANT_ID,         -- aps_iam_bu_catalog_app_chip_id
    FIORI_SPACE_ID,              -- Space ID [/ui2/space_entity_id]
    FIORI_SPACE_TITLE,           -- Space Title [/ui2/space_title]
    FIORI_SPACE_DESCRIPTION,     -- Space Description [/ui2/space_description]
    PAGE_ID,                     -- Page ID [/ui2/page_entity_id]
    PAGE_TITLE,                  -- Page Title [/ui2/page_title_]
    PAGE_DESCRIPTION,            -- Page Description [/ui2/page_description]
    FIORI_SPACE_TYPE,            -- abap.char
    FIORI_PAGE_TYPE,             -- abap.char
    IS_OPTIONAL,                 -- TRUE [boole_d]
    APP_TYPE,                    -- aps_iam_app_type
    APP_TYPE_TEXT,               -- Short Description [val_text]
    IS_NAVIGATION_TARGET,        -- TRUE [boole_d]
    IS_MIGRATED,                 -- TRUE [boole_d]
    BUSINESS_CATALOG_COMPONENT,  -- Applic. Component [ufps_posid]
    APPLICATION_COMPONENT,       -- Applic. Component [ufps_posid]
    PRICE_CATEGORY_ID,           -- aps_iam_usr_price_cat_id
    PRICE_CATEGORY,              -- aps_iam_usr_price_cat_desc
    LOCKED,                      -- TRUE [boole_d]
    VALID,                       -- TRUE [boole_d]
    PRIMARY KEY (CLIENT, BUSINESS_ROLE_ID)
);

Learn More