spfl_history_view

DDL: SPFL_HISTORY_VIEW SQL: SPFL_HISTORY_SQL Type: view
7 Fields 1 Data Sources

Change Log of Profile Parameters Values

spfl_history_view is a CDS View that provides data about "Change Log of Profile Parameters Values" in SAP S/4HANA. It reads from 1 data source (pfl_history) and exposes 7 fields.

Data Sources (1)

SourceAliasJoin Type
pfl_history pfl_history from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SPFL_HISTORY_SQL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Log of Profile Parameters Values view

Fields (7)

KeyFieldSource TableSource FieldDescription
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
log_date
log_time
instance app_server AS Instance
deleted deleted Truth Value
username username User who owns item
client client Workflow definition: Client

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view spfl_history_view.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SPFL_HISTORY_SQL

CREATE VIEW spfl_history_view AS
SELECT
  timestamp,
  cast( substring( timestamp , 1, 8 ) as abap.dats ) AS log_date,
  cast( substring( timestamp , 9, 6 ) as abap.tims ) AS log_time,
  app_server AS instance,
  deleted,
  username,
  client
FROM pfl_history
;

Learn More