I could see that a 'Primary Index' is missing in DB02 transaction and in EWA as well. When I checked the same, I found that table TST03's index TST03~0 is missing.
When I check the same in DB02 under TST03 table, I could see that there is an index which exists as 'TST03~0#$'. If I go to SE14 and check the same then I see that this doesn't exist in the DB and the last change was during 1997 only. I have only 'Create database Index' option in SE14 for TST03~0 using 'Direct'/'BG'/'Mass Processing' method.
Now my doubt as below,
How the index went missing and name changed to 'TST03~0#$'?
Can we create it using SE14? Will there be any impact on Spool generation and saving in SAP?