topic Performance Problems by select VBFA in Application Development and Automation Discussions

Performance Problems by select VBFA

Former Member — Thu, 01 Dec 2011 15:27:58 GMT

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

Re: Performance Problems by select VBFA

Former Member — Thu, 01 Dec 2011 15:33:55 GMT

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

Re: Performance Problems by select VBFA

ThomasZloch — Thu, 01 Dec 2011 16:10:55 GMT

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

Re: Performance Problems by select VBFA

Former Member — Fri, 02 Dec 2011 07:45:38 GMT

Hi Thomas,

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

The perfomance is now OK.

Regards, Dieter