FPM_SAVED_SEARCH

Transparent Table Application Table
7 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 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FPMSavedSearchData view_entity from BASIC WDGA Bookmark and Variants data

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY user_id syuname User Name
KEY role_id agr_name Role
KEY app_key abap.char
KEY search_id guid_32 GUID 16
query_string abap.string
version abap.int1 Filled internally when public view has been created

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]
    APP_KEY,       -- abap.char
    SEARCH_ID,     -- GUID 16 [guid_32]
    QUERY_STRING,  -- abap.string
    VERSION,       -- Filled internally when public view has been created [abap.int1]
    PRIMARY KEY (MANDT, USER_ID, ROLE_ID, APP_KEY, SEARCH_ID)
);

Learn More