Missing database objects

Missing secondary indices

Check which indices are missing

Call transaction DB02OLD and click on “Check” button.

wiki sap missing database objects

Click on “Database <-> ABAP Dictionary” to compare these two.

wiki sap missing database objects

Click on “New Check” to perform new check. To make a new check is good as indices might get generated meanwhile.

wiki sap missing database objects

Select all missing indices for mass processing

Click on the root or on each separate index and then on “Select/Deselect” button in top left corner.

wiki sap missing database objects

Click on “Create in DB” to enter selected objects for mass processing and then click on “Yes” to confirm the step.

wiki sap missing database objects
wiki sap missing database objects

Mass processing of DB requests

Call transaction SE14. From top menu select “DB Requests” -> “Mass Processing”

wiki sap missing database objects

Select all objects you want to process and click on “Schedule Selections”.

wiki sap missing database objects

Enter scheduling options for job. Click on “Immediate” to run it immediately and then save it.

wiki sap missing database objects
wiki sap missing database objects

Refresh the screen until job is finished and check the return from mass processing.

Verify that no indices are missing

Call transaction DB02OLD and click on “Check” button.

wiki sap missing database objects

Click on “Database <-> ABAP Dictionary” to compare these two.

wiki sap missing database objects

Click on “New Check” to perform new check. To make a new check is good as indices might get generated meanwhile.

wiki sap missing database objects

Now you should not see any missing indices.

wiki sap missing database objects

Leave a Reply