List All Dynamic Parameters in SAP System

You can refer to this post to determine which parameter is static or dynamic. In this article, you can also list out all the dynamic parameters available in the SAP system.

Execute transaction code SE16N. Put the table name as TPFYPROPTY and press Execute (F8).

From the output result, search for Dynamic column with X marks and sort the column in ascending or descending order.

You can also execute the list using Oracle SQL (for SAP with Oracle database installed).

SQL> column OBJ_NAME format a40
SQL> column PARANAME format a40
SQL> set linesize 300
SQL> select OBJ_NAME, PARANAME, DYNAMIC from sapsr3.TPFYPROPTY where DYNAMIC='X';
OBJ_NAME                        PARANAME                       DYN
------------------------------- ------------------------------ ---
SAPGUI/THEME                    sapgui/theme                   X
SAPGUI/USER_SCRIPTING           sapgui/user_scripting          X
SAPGUI/USER_SCRIPTING_PER_USER  sapgui/user_scripting_per_user X
RSDB/PREFER_FIX_BLOCKING        rsdb/prefer_fix_blocking       X
RSDB/PREFER_IN_ITAB_OPT         rsdb/prefer_in_itab_opt        X
RSDB/PREFER_UNION_ALL           rsdb/prefer_union_all          X

You May Also Like

Leave a Reply?