PFL_HISTORY

Transparent Table Temporary Data
8 Fields 1 CDS Views

History of profile parameter values

PFL_HISTORY is an SAP database table in S/4HANA. History of profile parameter values. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
spfl_history_view view from Change Log of Profile Parameters Values

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY timestamp SPFL_SNAPSHOT_TIMESTAMP time stamp
KEY app_server MSNAME2 AS Instance
KEY executable SPFL_SNAPSHOT_EXECUTABLE Executable
KEY param_name PFEPARNAME Parameter Name
param_value SPFL_PARAMETER_VALUE_HIST Value
deleted abap.char
username SYUNAME User Name
client abap.char

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.

-- History of profile parameter values
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PFL_HISTORY (
    TIMESTAMP,    -- time stamp [SPFL_SNAPSHOT_TIMESTAMP]
    APP_SERVER,   -- AS Instance [MSNAME2]
    EXECUTABLE,   -- Executable [SPFL_SNAPSHOT_EXECUTABLE]
    PARAM_NAME,   -- Parameter Name [PFEPARNAME]
    PARAM_VALUE,  -- Value [SPFL_PARAMETER_VALUE_HIST]
    DELETED,      -- abap.char
    USERNAME,     -- User Name [SYUNAME]
    CLIENT,       -- abap.char
    PRIMARY KEY (TIMESTAMP, APP_SERVER, EXECUTABLE, PARAM_NAME)
);

Learn More