Skip to Content
0
Former Member
Oct 29, 2015 at 04:54 AM

Replace Left Outer Join in Select Qeury

75 Views

Hello Experts,

This is my select query :

SELECTvbap~vbeln vbap~posnr vbep~etenr
vbap~matnr vbap~lgort vbap~lprio vbap~zzdelv
vbap~faksp vbap~netwr vbap~abgru vbap~werks

vbap~vstel vbap~arktx vbap~prodh vbap~vrkme
vbap~route vbep~edatu vbep~wadat vbep~bmeng

vbep~wmeng vbep~lifsp

INTO TABLE gt_vbapep FROM vbap

LEFT OUTER JOINvbep

ON vbep~vbeln = vbap~vbeln AND

vbep~posnr = vbap~posnr

FOR ALL ENTRIES IN gt_vbakuk

WHERE vbap~vbeln = gt_vbakuk-vbeln.

Now I want to put a condition where vbep~bmeng NE 0. But since VBEP table is left outer joined, I cant put condition in this select query.

After select query I can delete the entries from internal table where BMENG <> 0 but what if I am not selecting BMENG?

So require your help in this please.

Can we replace it with inner join or can we put condition in this select query itself?

Thanks,

Onkar