Skip to Content
Former Member
Oct 06, 2009 at 03:16 PM

How to compare 2 table values


Hi all,

i have one internal table contains all records created in SD. but i need only records created for J_3avasso..

so i am comparing the first internal table (it_cdtemp1) records with values in j_3avasso and moving to another internal table (it_cdtemp2)

Please find the code for below.

select vbeln posnr etenr into corresponding fields of table it_cdtemp2

from j_3avasso for all entries in it_cdtemp1

where belnr = it_cdtemp1-vbeln and posnr = it_cdtemp1-posnr and

etenr = it_cdtemp1-etenr.

i could see the final internal table (it_cdtemp2) contains only 0 records.

please suggest a solution for this