topic Re: Table Controls in Application Development and Automation Discussions

Table Controls

Former Member — Thu, 25 Oct 2007 04:30:58 GMT

hi,

i want to have one Table Control and it is having one table from database.

i want to select the records from database and also want to update certain

fields in TAble control at run time . So, can anybody suggest me the code or

solutions for retrieving records from database and updating the fields.

Points will be definately awarded for Useful answer.

Thanks

Kamal

Re: Table Controls

harimanjesh_an — Thu, 25 Oct 2007 05:18:49 GMT

check these links, it may be helpful to u.

this link contains information about :

1)Table Controls in ABAP Programs

2)Looping Through an Internal Table

3)Table Controls: Examples with Scrolling

http://help.sap.com/saphelp_47x200/helpdata/en/9f/dbac1d35c111d1829f0000e829fbfe/frameset.htm

Instead of using table control, use table control wizard...... very easy to populate the table.... bcoz it will automatically ask everything during its creation...ie from which database table , internal table and which all fields u want to select in the table control etc..

This wizard allows you to create a working table control quickly and easily. It also lets you generate certain standard table maintenance functions.

check this link....

http://help.sap.com/saphelp_47x200/helpdata/en/6d/150d67da1011d3963800a0c94260a5/frameset.htm

Reward me if useful.......

Harimanjesh AN

Re: Table Controls

gopi_narendra — Thu, 25 Oct 2007 05:26:14 GMT

Hi check these basic example for table control in ABAPDOCU.

This will give you a good idea of working on table controls

demo_dynpro_tabcont_loop

demo_dynpro_tabcont_loop_at

RSDEMO_TABLE_CONTROL

Regards

Gopi

Re: Table Controls

Former Member — Thu, 25 Oct 2007 06:34:16 GMT

I have taken 2 screens 2nd one has table control

code to be written in module pool is

process before output.

module populate_it.

loop with control tab_ctrl.

module status_0101.

endloop.

****************************

process after input.

loop with control tab_ctrl.

module modify_mod.

endloop.

module mod_del.

module modify_ttab.

*************************************************

*Below is the code to be written in driver program

**************************************************

&----

*& Module pool Z9_TBCTRL_PRASH *

*& *

&----

*& *

&----

program z9_tbctrl_prash.

data: it_ekko type standard table of z9ekko_prash.

data: it_ekpo type standard table of z9ekpo_prash.

data: it_ekpo_del type standard table of z9ekpo_prash.

data: wa_ekko type z9ekko_prash.

data: wa_ekpo type z9ekpo_prash.

data: wa_ekpo_del type z9ekpo_prash.

data: ok_code_0100 like sy-ucomm.

data: ok_code_0101 like sy-ucomm.

controls: tab_ctrl type tableview using screen 0101.

&----

*& Module POPULATE_IT OUTPUT

&----

text

----

module populate_it output.

clear it_ekpo.

refresh it_ekpo.

clear it_ekko.

refresh it_ekko.

select single ebeln bukrs aedat ernam lifnr ekorg ekgrp waers

into corresponding fields of wa_ekko

from z9ekko_prash where ebeln = wa_ekko-ebeln.

append wa_ekko to it_ekko.

clear wa_ekko.

select ebeln ebelp matnr werks lgort menge meins

into corresponding fields of wa_ekpo

from z9ekpo_prash where ebeln = wa_ekko-ebeln.

append wa_ekpo to it_ekpo.

clear wa_ekpo.

endselect.

endmodule. " POPULATE_IT OUTPUT

&----

*& Module STATUS_0101 OUTPUT

&----

text

----

module status_0101 output.

SET PF-STATUS 'xxxxxxxx'.
SET TITLEBAR 'xxx'.

read table it_ekpo into wa_ekpo index tab_ctrl-current_line.

endmodule. " STATUS_0101 OUTPUT

&----

*& Module validate_ebeln INPUT

&----

text

----

module validate_ebeln input.

if wa_ekko-ebeln <> ' '.

call screen 0101.

endif.

endmodule. " validate_ebeln INPUT

&----

*& Module MODIFY_MOD INPUT

&----

text

----

module modify_mod input.

modify it_ekpo from wa_ekpo index tab_ctrl-current_line.

endmodule. " MODIFY_MOD INPUT

&----

*& Module MODIFY_TTAB INPUT

&----

text

----

module modify_ttab input.

case ok_code_0101.

when 'MODI'.

modify z9ekpo_prash from table it_ekpo.

call screen 0100.

when 'DELE'.

call screen 0100.

endcase.

endmodule. " MODIFY_TTAB INPUT

&----

*& Module MOD_DEL INPUT

&----

text

----

module mod_del input.

case ok_code_0101.

when 'DELE'.

refresh it_ekpo_del.

loop at it_ekpo into wa_ekpo.

if wa_ekpo-mark = 'X'.

move-corresponding wa_ekpo to wa_ekpo_del.

append wa_ekpo_del to it_ekpo_del.

endif.

endloop.

delete z9ekpo_prash from table it_ekpo_del.

endcase.

This code involves deletion from database table also

Hope this will solve ur query

Reward points if it does

Re: Table Controls

Former Member — Thu, 25 Oct 2007 10:23:30 GMT

hi kamal,

check this links.....

http://help.sap.com/saphelp_nw04/helpdata/en/9f/dbac1d35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/dbac1d35c111d1829f0000e829fbfe/frameset.htm

I hope it helps.

reward for useful answers

Regards,

Sunil kumar.