Skip to Content
0
Former Member
Nov 17, 2012 at 07:32 AM

Creating View or INFOSET in SAP R3 / SAP ECC

49 Views

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