Skip to Content
0
Jan 31, 2014 at 12:33 PM

Dynamic Select Statement

24 Views

Dear All,

Below is my requirement and I need ur advice on this,

Selection Screen :

Fiscal year :

Period (Select Option)


Table name : ABC


SALE_01 SALE_02 .......to SALE_12 COST_01 COST_02 ......to COST_12 Department XYZ



If the Period is 01.01.2014 TO 31.03.2014 then I should collect SUM of SALE_01 to SALE_03 fields AND COST_01 to COST_03 with Department , XYZ



If the Period is 01.04.2014 TO 31.12.2014 then I should collect SUM of SALE_04 to SALE_12 fields AND COST_04 to COST_12 with Department , XYZ columns;


table could be either standard table or Internal table...


How can I achieve this with less effort..




Thank you all in advance...