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') ) ).