topic Re: Primary Index missing in database for table in Application Development and Automation Discussions

Primary Index missing in database for table

Former Member — Mon, 11 Jan 2010 05:36:02 GMT

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.

Re: Primary Index missing in database for table

Former Member — Mon, 11 Jan 2010 06:10:03 GMT

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

Re: Primary Index missing in database for table

vinod_vemuru2 — Mon, 11 Jan 2010 14:41:32 GMT

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.

Re: Primary Index missing in database for table

Former Member — Mon, 11 Jan 2010 21:17:28 GMT

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

Re: Primary Index missing in database for table

Former Member — Fri, 07 May 2010 13:35:05 GMT

solved