cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting Personal views of ALV from database

ArtiBhat
Associate
Associate
0 Kudos

Hi All,

Is there any database table where we store the personal views of user for ALV?

If there is one how can we delete it?

Best Regards,

Arti.

Accepted Solutions (0)

Answers (1)

Answers (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

I'm sure it is stored in the DB and you can always do a SQL trace to find out where. SQL trace is a great way to find out where anything is stored. I did a quick SQL trace and it appears that the views are stored in WDY_CONF_USER and WDY_CONF_USERT (for the language depend text description). The component name is SALV_WD_TABLE.

However direct manipulation of this table by your own coding would not be supported by SAP and could potentially be quite dangerous. I can't recommend that you should write your own program to remove entries. There is a Web Dynpro ABAP application however that lets you do some editing and deleting of user configuration. It is WD_ANALYZE_CONFIG_USER. It looks like you can mark several entries and delete them in mass. You can also transport entries. Just search for all configs for component SALV_WD_TABLE. You can also search by user.

ArtiBhat
Associate
Associate
0 Kudos

Thanks a lot for your reply