I have a "Z" table and I have set "Change Log" for this table under "Technical Setting".
The standard "Change Log" report shows the below columns
Here the USER NAME column is the SAP USER ID example "S00111111"
In addition to these columns it will also show the table columns on which operation (Insert, Update, Delete) were performed.
I wan to to have the below columns
i.e I wan to add First name and Last Name column to the standard log.
Here the First Name and Last Name should come from "USER_ADDR" table corresponding to the USER-ID in USERNAME Column.
How can I achieve this?