FPM_SAVED_SEARCH

Transparent Table Application Table
14 Fields 1 CDS Views

FPM Table for saved searches

FPM_SAVED_SEARCH is an SAP database table in S/4HANA. FPM Table for saved searches. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FAMSearchData view_entity from BASIC

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY user_id SYUNAME User Name
KEY role_id AGR_NAME Role
KEY config_id WDY_CONFIG_ID Config ID
KEY config_type WDY_CONFIG_TYPE Configuration Type
KEY config_var WDY_CONFIG_VAR Config. Variant
KEY app_key abap.char
KEY search_id GUID_32 GUID 16
query_string abap.strg
author WB_CREATED_BY Created By
createdon WB_CREATED_ON Created on
changedby WB_CHANGED_BY Last Changed By
changedon WB_CHANGED_ON Changed On
version abap.int1

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.

-- FPM Table for saved searches
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FPM_SAVED_SEARCH (
    MANDT,         -- Client [MANDT]
    USER_ID,       -- User Name [SYUNAME]
    ROLE_ID,       -- Role [AGR_NAME]
    CONFIG_ID,     -- Config ID [WDY_CONFIG_ID]
    CONFIG_TYPE,   -- Configuration Type [WDY_CONFIG_TYPE]
    CONFIG_VAR,    -- Config. Variant [WDY_CONFIG_VAR]
    APP_KEY,       -- abap.char
    SEARCH_ID,     -- GUID 16 [GUID_32]
    QUERY_STRING,  -- abap.strg
    AUTHOR,        -- Created By [WB_CREATED_BY]
    CREATEDON,     -- Created on [WB_CREATED_ON]
    CHANGEDBY,     -- Last Changed By [WB_CHANGED_BY]
    CHANGEDON,     -- Changed On [WB_CHANGED_ON]
    VERSION,       -- abap.int1
    PRIMARY KEY (MANDT, USER_ID, ROLE_ID, CONFIG_ID, CONFIG_TYPE, CONFIG_VAR, APP_KEY, SEARCH_ID)
);

Learn More