Primary Index missing in database for table

[Former Member]

Hi,

Primary index missing in database for table ZSD_MAT . we have deleted and recreated

but still primary index is not generated.

database: SQL SERVER 2000

please suggest.

[Former Member]

Hi,

Check when you regenerated the primary index existing at the OS level take the basis help to find. If it not generated at OS level. make sure that is primary index is available at OS level then generate in SAP.

Regards,

Aditya

[vinod_vemuru2]

Hi,

I believe INDEX generation is missing at database level. Please check with your BASIS team.

For testing your self, just enter few entries into this table from table maintenance(If you have) or test program. Now write a select query in this table by passing the key fields in the WHERE clause in a sample report.

Switch on the SQL trace (ST05 t-code) and run the test program which has select query. Now check the trace to see which index it has picked. Ideally it should pick 0~ (Means primary INDEX) if the INDEX is available at database level.

BASIS will regenerate the INDEXes for this table which will resolve the issue.

Thanks,

Vinod.

[Former Member]

In the same client try to create a sample custome table and activate and check if the primary index is automatically created for the activated table..

If created everything should look fine from basis point of view...

If it is not created then try to contact your basis team.

Regards

Satish Boguda

[Former Member]

solved