Skip to Content

Problem with secondary index table RSEG

Mar 06, 2017 at 11:09 AM


avatar image

Hi Experts,

I have a requirement pass PO and Line item to RSEG-EBELN and RSEG-EBELP and get the BELNR and XBLNR. But EBELN is a non primary key i will use for all entries in select query performance issue will come, I am seeing there secondary index is there for EBELN and EBELP filed but the status is " Index does not exist in database system DB6". Anyone can suggest whether i will use that index or not.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Suren Anakala Mar 06, 2017 at 11:44 AM

It needs to check the existence of Indexes of the table RSEG at DB level.

Go to transaction SE14 and make sure the status 'exists in database' as shown below, if not activate




rseg-index.jpg (59.7 kB)
10 |10000 characters needed characters left characters exceeded