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