Time Out error on Select from VBRP
We get a time out error on Select from VBRP even though we do not have much data.
Say we have data of about 10,000 records.
Could anyone suggest how this could be rectified.
This is our select
INTO TABLE it_vbrp
FOR ALL ENTRIES IN it_vbap
WHERE aubel EQ it_vbap-vbeln
AND aupos EQ it_vbap-posnr.
VBAP has about 50,000 records.
I will not suggest you to for Secondary Index creation just for this Issue. Best one is to use the Sales Flow Table VBFA and find the Direct Relation among the SO & Invoice and get the PK of VBRP into SELECT.
I believe you can also look for a FM......to get Invoice Line Item Details....
Or look for the FM in Invoice Print program RVADIN01.