Skip to Content

Problem with secondary index table RSEG

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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

    Regards,

    Suren

    Add comment
    10|10000 characters needed characters exceeded