Join Condition

[Former Member]

Hi,

I have one code , in that i used many JOIN Conditions.It degrades the performance. Can u plz send me a new code by splitting bellow code.

• select vapma~matnr

• vapma~werks

• vbep~wmeng

• vbep~cmeng "rounded quantity

• vbep~vrkme

• vbep~meins

• vbep~vbeln

• vbep~posnr

• vbep~etenr

• vapma~audat

• vbap~kzwi2

• kna1~name1

• into table it_orders

• from vapma

• join vbak

• on vbak_{vbeln = vapma}vbeln

• join vbuk

• on vbuk_{vbeln = vapma}vbeln

• join vbup

• on vbup_{vbeln = vapma}vbeln

• and vbup_{posnr = vapma}posnr

• join vbep

• on vbep_{vbeln = vapma}vbeln

• and vbep_{posnr = vapma}posnr

• join vbap

• on vbap_{vbeln = vapma}vbeln

• and vbap_{posnr = vapma}posnr

• join kna1

• on kna1_{kunnr = vapma}kunnr

• for all entries in i_marc

• where vapma~matnr = i_marc-matnr

• and vapma~werks = i_marc-werks

• and vapma~auart in s_auart

• and vbep~wmeng <> 0

• and vbep~edatu < sy-datum

• and vbup~lfgsa <> 'C'

• and vbup~absta <> 'C'

• and vbup~rfgsa <> 'C'

• and vbup~gbsta <> 'C'

• and ( vbak~lifsk = ' ' and

• vbep~lifsp = ' ' and

• vbuk~cmgst not in ('B', 'C') ).

[Former Member]

Hello,

Try using the 'FOR ALL ENTRIES'

Regards,

Shehryar Dahar

[Former Member]

Hi Nagaraju

U can use the statment

FOR ALL ENTRIES

or else you can also use <b>View</b> to join all these conditions dynamically

Reward all helpfull answers

Regards

Pavan

[Former Member]

Hi

What for you are using the VAPMA table?

remove it and take MATNR and WERKS from VBAP table and AUDAT from VBAK table

and see the sequence of the table fields

and tables like VBAK, VBAP,VBEP, VBUK,VBUP, KNA1

• select

• vbak~audat

• vbap~matnr

• vbap~werks

• vbap~kzwi2

• vbep~wmeng

• vbep~cmeng "rounded quantity

• vbep~vrkme

• vbep~meins

• vbep~vbeln

• vbep~posnr

• vbep~etenr

• kna1~name1

• into table it_orders

• from vbak join vbap

• on vbak_{vbeln = vbap}vbeln

• join vbep

• on vbep_{vbeln = vapma}vbeln

• and vbep_{posnr = vapma}posnr

• join vbuk

• on vbuk_{vbeln = vbak}vbeln

• join vbup

• on vbup_{vbeln = vbap}vbeln

• and vbup_{posnr = vbap}posnr

• join kna1

• on kna1_{kunnr = vbak}kunnr

• for all entries in i_marc

• where vbap~matnr = i_marc-matnr

• and vbap~werks = i_marc-werks

• and vbak~auart in s_auart

• and ( vbak~lifsk = ' ' and

• vbep~lifsp = ' ' and

• and vbep~wmeng <> 0

• and vbep~edatu < sy-datum

• and vbup~lfgsa <> 'C'

• and vbup~absta <> 'C'

• and vbup~rfgsa <> 'C'

• and vbup~gbsta <> 'C'

• vbuk~cmgst not in ('B', 'C') ).

Reward points for useful Answers

Regards

Anji