SAP BW ABAP class program steps required for the logic below

Hi, I have data from BW Queries and data respectively as shown in table 1, table 2 and table 3 below Table 1: BW Query 1 New Store Dept Sales (Total Last 3 periods) Store Ratio Store 1 Bath 303 0.2523 (303/1201) Store 1 HDW 898 0.7477 (898/1201) Total: 1201 Table 2: BW Query 2 Comp Store Dept Sales (Total Last 3 periods) Store Ratio Store 4 Bath 645 0.2689 (645/3630) Store 7 HDW 2985 0.7754 (2985/3630) Total: 3630 Table 3: BW Query 3 Comp Store Dept Last Year Month Historic Sales Store 4 Bath 4 230 Store 4 Bath 5 240 Store 4 Bath 6 250 Store 7 HDW 4 1050 Store 7 HDW 5 1110 Store 7 HDW 6 1100 Table 4: BW Query 4 Comp Store 4 5 6 Store 1 800 1000 800 Store 4 1000 1100 1200 Store 7 1200 1250 1400 Requirement: Step 1: Select New Store = Store 1 and Dept = HDW from table one and check the store ratio = in the example above it is 0.2523. Step 2: Taking reference of the store ratio above i.e 0.2523 check which Comp store has the closest matching new Store Ratio in in Table 2 Step 3: 3a: Copy the Historic sales for the matched comp store for upcoming/future three months for the new store. In the example 4, 5, 6 periods from table 3. Copy the strategic store plan for the store from Table 4 for all the stores (data is available for both Comp and new stores) for future period 4, 5 and 6 in this query. Step 4: Calculate New store SSP/Comp Store SSP Step 5: Calculate final clone value which is : SSP ratio* Historic Sales And the logic would be same for rest of the stores by department. The Final expected result table would look similar to below: New Store Comp store Dept Month SSP ratio Historic Sales Clone Ratio Store 1 Store 4 Bath 4 800/1000 =0.8 230 184 (0.8*230) Store 1 Store 7 HDW 4 800/1200=0.6667 1100 733.3 (0.6667*1100) Store 1 Store 4 Bath 5 1000/1100 240 218.8 (0.90*240) Store 1 Store 7 HDW 5 1000/1250 1050 840 (0.8*1050) Store 1 Store 4 Bath 6 800/1200 250 166.6 (0.66*250) Store 1 Store 7 HDW 6 800/1400 1110 634.29 (0.57*1110)