Performance Problems by select VBFA

[Former Member]

Hi,

i try to select some value of table VBFA:

    SELECT VBELV FROM VBFA INTO WA_VBFA-VBELV
                WHERE VBELN   = VBRK-VBELN
                  AND VBTYP_V IN ('C', 'K', 'L').
*
      COLLECT WA_VBFA INTO IT_VBFA.
*
    ENDSELECT.

it take a long time (VBFA = 80000 entries). has anyone an idea to read faster?

thanks.

Regards, Dieter

[Former Member]

Well, you're going to the wrong table and not using an index. Rather than using the subsequent document to get the preceding document, you should go to whichever table holds the subsequent document (LIPS for deliveries say). It will refer back to the preceding document.

Rob

Edited by: Rob Burbank on Dec 1, 2011 10:35 AM

[ThomasZloch]

It's all explained in SAP note 185530 (see 4a for your particular problem), I suggest you have a look and avoid any SD-related performance problems in the future. Similar notes are available for other modules, I believe.

Thomas

[Former Member]

Hi Thomas,

thanks for your answer, i use VBRP to get the informations i need.

The perfomance is now OK.

Regards, Dieter