topic Re: save and modify functionality with table control wizard. in Application Development and Automation Discussions

save and modify functionality with table control wizard.

Former Member — Fri, 06 Apr 2012 17:19:30 GMT

Hi Expert,

i have the req i have used the table wizard to display data from internal the step i followed to createtable wizards are

1. provided a internal tab and work area.

2. then field req in tab cont.

3. not selected the line sel property.

there are 6 col in atb cont 4 coloum from data base table 5 col as check box and 6 col as value(which is to be by default value in a 4 colum).

means the value of 4 col = 6 col value.

for exp:

data diplay is like.

f1 f2 f3 f4 f5 f6

1 a g 0 as ck box 0

2 b h 0 as chk box 0

values are same for f4 and f6 .

now i have the text feilds

t1 user inp

t2 user inp

t3 user inp

now as soon as user select the check box against the line item in table control the data is to be saved in one zdb table which contain

all the field t1 t2 t3 f1 f2 f3 f4 f5 f6 .

my ques is if i have not selected a line select property in table control wizard is there be any prob in save and modify data into db table.

and we have single row of data in t1 t2 t3 against multiple line of data in f1 f2 f3 f4 f5 f6.

how to modify the db table ?

thanks in advance.

Former Member — Sat, 07 Apr 2012 05:26:37 GMT

Hi Shashi,

Yes you can do. Just do one thing. Follow this step.

Loop at (internal table) into (workarea) where checkbox = 'X'.

'Process your statement here'.

endloop.

Regards

Vivek

Former Member — Sat, 07 Apr 2012 06:55:09 GMT

Hi vivek ,

you mean to say

loop at itab into wa_itab where itab-chk_box = 'x'. (field name as chkbox in tab control)

now what will be the code line to assing wa_itab(5 coloum )

and 3 input fields value to the database table ztab.

where myztab conatins all the fields t1 t2 t3 f1 f2 f3 f4 f6.

endloop.

thanks.