hi
i ahve a requirement as below
there is a internal table it_Record having below records
with fields
cus date statistic intrest received
having four data records
00432CAR2 2008/13/03 Failed 5000
00432CAR2 2008/13/03 sold 10000
194267AG5 2008/13/03 failed 6000
207784AH2 2008/13/03 sold 7000
now i have to select data from a ztable zmaster based on the cuspip of this internal table where cussip is primary key in database table
for each cusip i have to get some more records from this master table zmaster
and all this records as in above internal table it_Record
and the data as selected from the zmaster table needs to be entered in third table zmatrix table
how to do it please suggest optimum way to do it
the zmatrix table fields are all present in zmaster table i have to select based on the internal table it_Record and make entry in the zmatrix table for all
please suggest asap
regards
arora