sachinbaan
24th January 2015, 07:45
Hi,

What is the use of standard table ttadv500 - Conversion Indicators?

bhushanchanda
24th January 2015, 15:24
Hi,

Information about components like tables & domains are stored in files. Whenever there is a change in these components, the related data is stored in ttadv500 table i.e. Conversion Indicators.

The name itself tells you that whenever CRDD i.e. convert to run time data dictionary session is ran, this table indicates which tables & domains are changed and needs a synchronization. After reading this information, the CRDD synchronizes both tables and the files.

So, this table acts as a source of information for the system to show which tables, domains needs to be converted to runtime.

The Create Runtime Data Dictionary creates entries for tables and domains even if no changes have been made. That is, it doesnt checks the entries in ttadv500. So, people follow Create Runtime DD instead as in multi-super-user environment, you never know, who clears out the data in ttadv500 table.