Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Time Out error on Select from VBRP

Hi Everyone,

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

SELECT vbeln

posnr

aubel

aupos

netwr

fkimg

kzwi2

INTO TABLE it_vbrp

FROM 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.

Thanks,

Vinotha M

Former Member
Former Member replied

Hi,

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....

Use this...RV_INVOICE_DOCUMENT_READ

Or look for the FM in Invoice Print program RVADIN01.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question