Problem with secondary index table RSEG

[former_member244346]

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.

Thanks.

[Former Member]

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

Regards,

Suren