topic Re: VBFA table access in Application Development and Automation Discussions

VBFA table access

Former Member — Thu, 20 May 2010 14:43:32 GMT

Hi Experts,

I have a section in code due to which it takes longer time to execute. This select statement fetches single record from VBFA table without providing all the primary keys coz i dont have any other option. Due to this, processing takes longer time.

According to the code written, it needs to fetch VBELV field from VBFA for VBELN & POSNN provided.


    select vbelv UP TO 1 ROWS                                   
      INTO VBFA-VBELV                                          
      FROM VBFA                                                 
      WHERE VBELN = tvbdpl-VBELN                                
      AND   POSNN = tvbdpl-POSNR.                               
    ENDSELECT.

I checked that it takes longer time for few document numbers not for all. I need to know why? Please help.

Thanks.

Re: VBFA table access

Former Member — Thu, 20 May 2010 14:59:53 GMT

What type of document are you using in your WHERE (delivery, sales order)?? And what type of document are you trying to retrieve???

Rob

Re: VBFA table access

RaymondGiuseppi — Thu, 20 May 2010 15:02:58 GMT

There are many OSS notes available for this query, check notes like [Note 103218 - Performance of document flow, File VBFA|https://service.sap.com/sap/support/notes/103218]

Regards,

Raymond

Re: VBFA table access

sylvain_vels — Thu, 20 May 2010 17:45:22 GMT

there is no index on vbeln from VBFA.

If you need to access at vbfa with vbeln after reading oss notes you can create an index VBELN

We have created this index without any problem( vbfa > 60.000.000 records)

Best regards

Re: VBFA table access

Former Member — Thu, 20 May 2010 17:53:37 GMT

Sylvain - if you read the notes, why did you end up creating an index?

Rob

Re: VBFA table access

Former Member — Fri, 21 May 2010 06:37:20 GMT

Hi Sylvain,

I didnt find any section in the note where we ned to create the index for VBFA.

Rob - I am using VL03N transaction, provind delivery, giving the output type and wana display the form. But I didnt understand why the performance not affecting for all documents. I encoutered the performance issue for few. And even those douments have not more that 5 material.

reagrds.

Re: VBFA table access

Former Member — Fri, 21 May 2010 06:46:48 GMT

Hi,

I hope the purpose of your select statment based on VBFA is to get the preceeding document number (Sales order number). If you are looking for the reference document number, then fetching the fields VGBEL from LIPS will be helpful.

select vgbel 
      INTO <variable>
      FROM LIPS
      WHERE VBELN = tvbdpl-VBELN                                
      AND   POSNR = tvbdpl-POSNR.                               
ENDSELECT.

Regards

Vinod

Re: VBFA table access

Former Member — Fri, 21 May 2010 07:57:27 GMT

Hello,

Generally if you are using some of the Key fields then the problem should not occur.

But try and use the function module "SD_VBFA_SINGLE_READ"

Since this is standard it should work efficiently and also please give input to field "I_VBTYP_N"

( Document category of subsequent document )

This will improve performance.

Regards,

Uday Desai.

Re: VBFA table access

Former Member — Fri, 21 May 2010 08:36:44 GMT

Hi Uday

I am providing the below selection in the FM SD_VBFA_SINGLE_READ

I_VBELN 80593481

I_POSNN 000010

I_VBTYP_N J

But its not giving any output records. I think this Fm works well only if u provide all the selection entries. can you plz check at your end.

According to my senario i need to fetch VBELV.

Regards.

Re: VBFA table access

Former Member — Fri, 21 May 2010 08:42:56 GMT

Hi Khan,

Have you tried the solution of using table LIPS (field : LIPS-VGBEL) instead of VBFA.

Regards

Vinod

Re: VBFA table access

Former Member — Fri, 21 May 2010 10:42:45 GMT

Hello,

Yes. I realized this later that you won't get VBELV and that you are trying to find VBELV.

So please try this FM "WB2_VBFA_READ_WITH_VBELN". This will work

if you have VBELN and you don't know what is VBELV.

I had tried this on my system and it works well.

Hope this will solve the issue.

Regards,

Uday Desai.

Re: VBFA table access

Former Member — Fri, 21 May 2010 13:25:23 GMT

Hi Vinod,

I tried it to search the entries in LIPS and got the same, But I didnt got the permission from my senior to change it for LIPS. They are keen to find some thing else. May be later i convince for this change

Regards,

Re: VBFA table access

Former Member — Wed, 26 May 2010 00:56:54 GMT

We created following index in table VBFA.

MANDT / VBELN / POSNN

we think this index is useful not only the program but also other program.

Regards,

Gaito

Re: VBFA table access

Former Member — Wed, 26 May 2010 13:08:02 GMT

Moderator message - If your question is answered, please assign po1nts and mark this as closed.

My 2 cents - wrong solution.

Rob