topic How to insert ,update,delete into database table using Table control??? in Application Development and Automation Discussions

How to insert ,update,delete into database table using Table control???

Former Member — Tue, 31 Jul 2007 09:37:49 GMT

hi all,

<b>How to insert ,update,delete into database table using Table control???</b>

I want to insert update delete into database table using Table controls

thanks.

Re: How to insert ,update,delete into database table using Table control???

Former Member — Tue, 31 Jul 2007 09:47:43 GMT

Please have a look at these pgms

DEMO_DYNPRO_TABLE_CONTROL_1

DEMO_DYNPRO_TABLE_CONTROL_2

demo_dynpro_tabcont_loop_at.

Reward if useful

Re: How to insert ,update,delete into database table using Table control???

former_member196299 — Tue, 31 Jul 2007 10:01:24 GMT

hi ,

Please check this thread :

check for this thread also :

else for step by step process check this :

http://esnips.com/doc/48bd95e8-facc-4932-b923-465ba59bad24/Table-Control.pdf

Regards,

Ranjita

Message was edited by:

Ranjita Kar

Re: How to insert ,update,delete into database table using Table control???

Former Member — Tue, 31 Jul 2007 10:31:26 GMT

Hi,

Please check this sample code for table control.

SAVE_OK = OK_CODE.

CLEAR OK_CODE.

CASE SAVE_OK.

...

WHEN 'INSERT'.

READ TABLE TC-COLS INTO COL WITH KEY SCREEN-INPUT = '1'.

IF SY-SUBRC = 0.

LOOP AT I_BINLOC INTO ZMBINLOC WHERE ZMARK = 'X'.

CLEAR ZMBINLOC.

INSERT ZMBINLOC INTO I_BINLOC INDEX SY-TABIX.

ENDLOOP.

DESCRIBE TABLE I_BINLOC LINES TC-LINES.

ENDIF.

WHEN 'SAVE'.

SORT I_BINLOC ASCENDING BY WERKS LGORT ZBINLOC.

DELETE ADJACENT DUPLICATES FROM I_BINLOC.

IF NOT I_DELETE[] IS INITIAL.

DELETE ZMBINLOC FROM TABLE I_DELETE.

ENDIF.

MODIFY ZMBINLOC FROM TABLE I_BINLOC.

IF SY-SUBRC = 0.

MESSAGE S899(BD) WITH TEXT-002.

ENDIF.

WHEN OTHERS.

ENDCASE.

...

Also please<b> demo program RSDEMO02.</b>

check these links.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/abap-code-samples/table%20control%20in%20abap.pdf

http://sap.niraj.tripod.com/id29.html

http://help.sap.com/saphelp_sm32/helpdata/en/9f/dbac9f35c111d1829f0000e829fbfe/frameset.htm

Regards

Re: How to insert ,update,delete into database table using Table control???

Former Member — Tue, 31 Jul 2007 12:38:31 GMT

hi,

Some code samples on table control,

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1499ec90-0201-0010-769f-860989655f7e

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2165e990-0201-0010-5cbb-b5c2ad436140

This may be useful

http://www.planetsap.com/Tips_and_Tricks.htm#setattr

Rgds

Reshma

Re: How to insert ,update,delete into database table using Table control???

Former Member — Tue, 31 Jul 2007 12:41:50 GMT

see abap example program.

t_code abapdoc.