topic Re: Regarding Table Control: in Application Development and Automation Discussions

Regarding Table Control:

Former Member — Tue, 06 Jan 2009 08:14:58 GMT

Hi,

I am using the table control first time.

I have a requirement : After entering the material number in the screen the data stored in the custom table needs to be shown in the table control based on the Material Number.

Please provide me some sort of reference code to build the module pool program.

Also there is one more difficulty that, the structure of the table control is not similar to that of the actual custom table from which the data needs to be displayed.(The order of the fields)

Please suggest me if the above requirement is possible.

Looking forward for your replies.

Thanks.

Regards,

Anuja.

Re: Regarding Table Control:

Former Member — Tue, 06 Jan 2009 08:39:21 GMT

check this program.......

SAPMTZ60 ( tcode TZ60)

Re: Regarding Table Control:

Former Member — Tue, 06 Jan 2009 08:53:40 GMT

Hi Anuja,

Firstly create an input field in you screen using the dictinoary reference.

Next, Place a button beside that input field to trigger the action.

Assign Function code to the button, say, 'OUT'.

Now, create a table control on your screen, with the name, say 'TC'.

Now call the dictionary( press F6 ) and now type the table name and select the desired fields from it.

Now, Press OK, and place the fields on the table control.

This completes your mapping of fields to table control.

NOTE: The mandatory thing at the time of creating a table control is to have loops in both PBO and PAI.

Here is the sample code for the flow logic.

PROCESS BEFORE OUTPUT.

LOOP AT it_bukrs INTO wa_bukrs WITH CONTROL tc1 CURSOR tc1-current_line.

MODULE display_data. " Send the data to table control.

ENDLOOP.

PROCESS AFTER INPUT.

LOOP AT it_bukrs.

ENDLOOP.

This is the TOP part of the program:

TABLES: t001.

DATA ok_code TYPE sy-ucomm.

Table control declaration.

CONTROLS tc1 TYPE TABLEVIEW USING SCREEN 1001.

Internal table for listdropdown

DATA: it_bukrs TYPE TABLE OF lty_bukrs,

wa_bukrs TYPE lty_bukrs.

The include for PBO code is like this

MODULE display_data OUTPUT.

if ok_code = 'OUT'.

t001-butxt = wa_bukrs-butxt.

t001-ort01 = wa_bukrs-ort01.

t001-land1 = wa_bukrs-land1.

endif.

ENDMODULE. " DISPLAY_DATA OUTPUT

I Hope it meets your requirements.

Good day!

Regards,

Shashikanth. D

Re: Regarding Table Control:

Former Member — Tue, 06 Jan 2009 08:55:09 GMT

hi,

Refer to this link...

https://forums.sdn.sap.com/click.jspa?searchID=20576590&messageID=6428426

Re: Regarding Table Control:

Former Member — Tue, 06 Jan 2009 09:57:33 GMT

hi,

i have done a same scenerio in which there is first screen ask for material number and after pressing enter it will go to next screen and have eenteries in table control acc. to material number.

so for this

first u have to give name to material number text box say material_no and define variable

material_no like <databse table>-<fieldname>,

in pai of first screen

PROCESS AFTER INPUT.

MODULE USER_COMMAND_0400.

SELECT * INTO CORRESPONDING FIELDS OF itab <<<this is internal table used in table control>>

FROM dbtab WHERE matnr = material_no.

in pbo of second screen

LOOP AT ITAB WITH CONTROL Tbl_ctrl>>>> name of table control .

MODULE STATUS_0201.

ENDLOOP

and for order of data ,, you have to create internal table as ur requirement means the order in which data have to show and use that internal table in table control .

and u can change the order manually by double click on the column of tabele control and change the name of column as per your requirement.

hope it helps you.

for any queries revert me back

thanks

Sachin

Re: Regarding Table Control:

Former Member — Tue, 06 Jan 2009 12:04:29 GMT

hi...

Thanks for the replies....

I have used the tabele control wizard to get the table control on the screen.

Now, when i enter the material number, i get the corresponding data present in the table for that material number displayed in the table control.

1. Now i want to add new record with this displayed data and want to add the selection coloum for selecting the rows.

2. Also, when i scroll in the table control the same records are getting repeated and displayed in the table control.

Please suggest me the approach for the above three points.

Thanks in advance .

Regards,

Anuja