topic Re: performance issue table vbrp in Application Development and Automation Discussions

performance issue table vbrp

Former Member — Fri, 06 May 2011 05:02:31 GMT

Hi experts

I have writen a select query in z program but i am getting the prformance issue. The program is taking more than 40 min when execute the below select query. could anyone please give me the idea how to resolve this performance issue. can i replace with view.

select  vbrp~vbeln
            vbrp~posnr
           vbrk~fkdat
           vbrk~fksto
           vbrk~vbtyp
           vbrk~rfbsk
            vbrp~matnr
           vbrp~fkimg
           vbrp~werks
            vbrp~shkzg
     into table it_billcom
     from vbrk inner join vbrp "wb2_v_vbrk_vbrp2
      on vbrk~vbeln eq vbrp~vbeln
      for all entries in it_alv_output
        where vbrp~vbeln eq vbrk~vbeln

with regards

chandan_vigi

Re: performance issue table vbrp

Former Member — Fri, 06 May 2011 05:45:06 GMT

Hi Chandan,

I see that the ON CLAUSE and the WHERE CLAUSE are the same, since you are using FOR ALL ENTRIES against IT_ALV_OUTPUT, i presume that your SELECT WHERE CLAUSE must be more like VBRK~VBELN EQ IT_ALV_OUTPUT-VBELN?

Also, it is better to have a check if IT_ALV_OUTPUT is not initial before the WHERE CLAUSE.

Regards,

Chen

Re: performance issue table vbrp

yuri_ziryukin — Fri, 06 May 2011 07:29:53 GMT


Hi Chandan,
> 
> I see that the ON CLAUSE and the WHERE CLAUSE are the same, since you are using FOR ALL ENTRIES against IT_ALV_OUTPUT, i presume that your SELECT WHERE CLAUSE must be more like VBRK~VBELN EQ IT_ALV_OUTPUT-VBELN?
> 
> Also, it is better to have  a check if IT_ALV_OUTPUT is not initial before the WHERE CLAUSE.
> 
> Regards,
> Chen

Chen is absolutely right. I would just fix his last sentence:

"it is necessary to have a check if IT_ALV_OUTPUT is not initial before the SELECT statement".

Re: performance issue table vbrp

ravi_lanjewar — Fri, 06 May 2011 11:00:50 GMT

Hi,

1. In you SQL Where clause has not written correctly or incomplete.

2. Why are you using the join and for all entries togather ?

first used the for all entries on table vbrk using internal table it_alv_output

2nd used the for all entries on table vbrp using data read in table step 1.

Don't forget to check driver table internal table is not initial while apply the for all entries

Kind Rgds

Ravi Lanjewar

Re: performance issue table vbrp

Former Member — Fri, 06 May 2011 12:18:37 GMT

Hi,

1. correct your code as Chen KV suggested.

2. Dont use join or use item table(VBRP) in left side. ref below statment

select vbrp~vbeln

vbrp~posnr

vbrk~fkdat

vbrk~fksto

vbrk~vbtyp

vbrk~rfbsk

vbrp~matnr

vbrp~fkimg

vbrp~werks

vbrp~shkzg

into table it_billcom

from vbrp inner join vbrk

on vbrk_{vbeln eq vbrp}vbeln