Dear All,
I have to pick data from 2 tables....table1 and table 2 ... and need to make a infoset or view Table 3 in SAP R3..... Please help.....
Regards
AN
Table 1
Class
RollNumber
std1
1
std5
22
std1
2
std1
3
std5
23
Table 2
Roll Number
Instalment
Date
Fees
1
1
1.1.2012
1000
1
2
6.1.2012
1500
1
3
11.11.2011
3000
22
1
10.01.2012
4000
22
2
22.10.2012
2500
2
1
01.01.2012
5500
23
1
11.01.2012
4000
23
2
10.10.2012
2500
3
1
11.01.2012
2000
3
2
10.10.2012
3500
Table 3
Class
Roll Number
Fees
Std1
1
5500
std1
2
5500
std1
3
5500
std2
22
6500
std2
23
6500