Skip to Content
0
Former Member
Mar 24, 2009 at 08:52 AM

Secondary index not working in BSAD

130 Views

Hi All,

I have requirement to select some values in BSAD(Customer cleared items) based on Clearing date(AUGDT) and Clearing document type(BLART).

For this requirement I have created a secondary index in BSAD with the combination of Clearing date and the Clearing document type.The secondary index is working only when I have one value in Clearing date without any range and any value for Clearing document type.

EX:

Case 1)

BSAD-AUGDT = '09.03.2009'

BSAD-BLART ='RV' .

When the select is with the above the secondary index is used and the time taken is too low.

Case 2)

BSAD-AUGDT = '09.03.2009' to '11.03.2009' and

BSAD-BLART ='RV' .

When the select is with the above values the secondary index is not used and time taken in too high.

I have analysed using ST05 trace.

Please let me know your valuable comments.

Thanks and regards,

SIva