dynamic query

i am getting 8 records thru my select query ,now i want to save six records in six different variables via using case statement...

and later i will use all this variables in fetching data from database.

just go thru my codes:

select ATINN ATNAM from CABN into corresponding fields of I_CABN .

so when i_cabn-atnam = 'Z_BP_SOURCE'.

SOURCE = I_CABN-ATINN.

this i want to do 4 another 6 variables

just help

thanks in advance.