topic Re: Need to insert table control row into database table.. in Application Development and Automation Discussions

Need to insert table control row into database table..

Former Member — Mon, 26 May 2014 11:18:08 GMT

Hi experts,

I have created Table control. There are 4 push button Display, Delete, Exit, Insert.

Now all push buttons are working but Insert button is not working. When I click display button I get records from database table in

my table control. What I need is when I put record in my table control and click Insert push button I want table record to be inserted in

my database table.

Regards,

Sandeep.

Re: Need to insert table control row into database table..

anubhab — Mon, 26 May 2014 11:39:01 GMT

Hi Sandeep,

I guess you want to update the selected records in table control, to database. For this:

1. Assign a function code for INSERT button.

2. Write a logic within CASE-ENDCASE for that function.

WHEN 'INSERT'.

LOOP AT i_tc INTO w_tc WHERE sel = 'X'.

MODIFY/INSERT/UPDATE dbtab FROM w_tc.

CLEAR: w_tc.

ENDLOOP.

NOTE: considered SEL as the column name for selecting entries in table control, i_tc is your internal table and w_tc is work area for the same.

Regards,

Anubhab

Re: Need to insert table control row into database table..

Former Member — Mon, 26 May 2014 11:45:44 GMT

Hi anubhab,

I have already tried this logic. It inserts blank row in DB table.

Re: Need to insert table control row into database table..

anubhab — Mon, 26 May 2014 11:50:16 GMT

Hi Sandeep,

Did you check in debugger if you are getting desired values in PAI while looping at the internal table?

And also if you are directly updating the DB table from work area, are both of them compatible with each other?

Did you check the sy-subrc value after INSERT/MODIFY/UPDATE statement?

Regards,

Anubhab

Re: Need to insert table control row into database table..

former_member196651 — Mon, 26 May 2014 11:53:04 GMT

Hi Sandeep,

First you insert rows into the internal table behind your table control. Then you update your database table with the newly inserted rows in the internal table.

Regards,

Abijith

Re: Need to insert table control row into database table..

yogendra_bhaskar — Mon, 26 May 2014 11:58:37 GMT

Hi sandeep ,

Are you getting the records in table control or not ?

Plz. check it

and then

add COMMIT WORK. after the insert statement

Regards ,

Yogendra Bhaskar

Re: Need to insert table control row into database table..

Former Member — Mon, 26 May 2014 12:23:50 GMT

In pbo I have written MOVE-CORRESPONDING INT_TAB TO DB TABLE.

While inserting record in table control internal table shows blank..

Re: Need to insert table control row into database table..

yogendra_bhaskar — Mon, 26 May 2014 12:34:15 GMT

Hi Sandeep ,

You have to code in PAI

Does this code include in your PAI :

*&SPWIZARD: PAI FLOW LOGIC FOR TABLECONTROL 'TC'

LOOP AT INT_TAB.

CHAIN.

FIELD INT_TAB-FIELD1.

FIELD INT_TAB-FIELD2.

FIELD INT_TAB-FIELD3.

FIELD INT_TAB-FIELD4.

MODULE TC_MODIFY ON CHAIN-REQUEST.

endchain.

ENDLOOP.

Regards

Yogendra Bhaskar

Re: Need to insert table control row into database table..

Former Member — Tue, 27 May 2014 05:26:47 GMT

I do not understand where I am doing wrong.. Tried this logic also, still not working..

Re: Need to insert table control row into database table..

former_member187748 — Tue, 27 May 2014 05:35:07 GMT

Hi Sandeep,

please post your code as a attachment .

Re: Need to insert table control row into database table..

yogendra_bhaskar — Tue, 27 May 2014 05:38:28 GMT

Hi Sandeep ,

Could you paste the code used in PAI with modules ?

Regards,

Yogendra

Re: Need to insert table control row into database table..

Former Member — Tue, 27 May 2014 05:46:06 GMT

Done .. Tnx all..