Skip to Content
0
Former Member
Dec 03, 2008 at 04:12 PM

Willt his fetch me the correct data

28 Views

Guys,

I am little confused.. will this query get me the current data? I am getting the data where vbtyp_n is only H or vbtyp_n is R as well as bwart should be in ('601', '901', '945', '947'). can I write query like this...

SELECT vbelv

posnv

vbtyp_n

bwart

rfmng

INTO TABLE i_goodsmvt

FROM vbfa

FOR ALL ENTRIES IN p_order

WHERE vbelv = p_order-vbeln AND

posnv = p_order-posnr AND

( vbtyp_n = 'H' OR

( vbtyp_n = 'R' AND

bwart IN ('601', '901', '945', '947') ) ).