Performance tunning for select statements using likp lips and vbrp

[Former Member]

Dear all,

I have a report where i am using select statements using first on likp the for all entries of likp i am taking data from lips and then for all entries in lips i am taking data from vbrp by matching VGBEL and VGPOS. Now the problem is that when it fetches data from vbrp it is taking lot of time around 13mins. to fetch data from vbrp. How can i overcome the problem.

regards

Amit

[Former Member]

Hi,

VBRP does not have secondary index on VGBEL and VGPOS by default.

Consider creating secondary index.

Regards,

--

Przemysław

[Former Member]

Hi Amit,

Use Table VBFA to get preceding and subsequent documents.

Regards

Srikanth M

[Former Member]

Hi,

there is also no secondary index for preceding document in VBFA table.

You will also have to create it here.

Regards,

--

Przemysław

[ThomasZloch]

I suggest you to study SAP note 185530, it has all details on how to efficiently code access to SD document flows.

Thomas

[Former Member]

Issue has been Resolved.

thanks.

[Former Member]

This message was moderated.