topic Re: dynamic query in Application Development and Automation Discussions

dynamic query

Former Member — Thu, 26 Jul 2007 06:59:47 GMT

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.

Former Member — Thu, 26 Jul 2007 07:04:02 GMT

See this dynamic query

parameter : p_matnr type mara-matnr.

select single * from mara into wa_mara where (p_matnr).

Reward if useful

Former Member — Thu, 26 Jul 2007 07:07:43 GMT

declare the 8 varaibles and

after select statement write the case statement and move the fields to these variables

select ATINN ATNAM from CABN into corresponding fields of I_CABN .

case i_cabn-atinn.

when 'Z_BP_SOURCE'.

v_var1 = i_cabn-atnam (or some other field).

when 'ZB_ATYUN'.

v_var2 = i_cabn-atnam .

.....................................

endcase.

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member — Thu, 26 Jul 2007 07:14:45 GMT

sample:

data: condition1 type string.

concatenate 'ATINN =' I_CABN-ATINN into condition1.

select * from CABN

where (condition1).

Former Member — Mon, 30 Jul 2007 07:31:34 GMT

thanks problem has solved