Skip to Content
0
Former Member
Jun 11, 2008 at 05:38 AM

To update from two internal table data in a ztable

36 Views

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