regarding the input to tables

[Former Member]

Hi experts,

i have created a DB table of my own in se11.. i dont have any data in my database table ..i want to fill the data base table for the fields, that is empid,name ,managerid,dept id etc...using screen painter..

ie in the screen painter if i give the values in the i/o field it should fill the respective field of the db table ...can any one tell me how to do this with one example code to fill one field value ?

or if there is any other better option than the screen painter suggest me ,...

I will reward the maximum points for all valuable answer...please be more descriptive as i m new to ABAP and i m a BW guy.....

regards,

Rk

[Former Member]

Hello,

If you want to fill only one table I suggest you to use the Table Maintenance Generator. To use it do the following:

1 - Open the table in transaction SE11;

2 - Go to the menu Utilities and select the option Table Maintanance Generator;

3 - Fill the fields in the screen and the will be generated to you a program to maintain the table.

If you want to access it again go to the transaction SM30 and fill the field with the table name.

You can create an transation to maintain the table, too. Just go to the transaction SE93 define the transaction name, click on Create button and in the next screen select the option Transaction with parameters (parameter transaction).

In the next screen, define the transaction SM30, mark the flag Skip initial screen and in the defaul values table fill with the following:

NAME OF SCREEN FIELD VIEWNAME VALUE <TABLE_NAME>

NAME OF SCREEN FIELD UPDATE VALUE X

Regards.

Edited by: David Pietroniro on Apr 19, 2008 8:10 PM

[Former Member]

Hi

I dont get this..can you be more descriptive ...i dont understand all the options in table maintenance generator..

Regards,

Rk

[Former Member]

Hello,

First of all, go to the transaction SE80, select the Function Group in the first field, define the name in the next field and press ENTER. You will be asked to create a new Function Group. Now save it.

Go to the Table Maintanance Generator, in the field Authorization Group fill with &NC&, in the field Function Group put the name of the function group that you've created and change the Maintanance Type to one step, and press the button Find Scr. Number(s). Select the option Propose screen number(s) and when you return to the screen, select the button Create (F6).

Will be generate to you an program, to access it go to the transaction SM30 and fill in this the name of the table.

Now you can fill the table.

If you want to learn more about the Table Maintanance Generator, I suggest you to read this [HOW TO IMPLEMENT EVENTS IN TABLE MAINTENANCE|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc]

Regards,

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 21, 2008 5:39 PM

[Former Member]

Hi ,

Thanks for your reply its working i am able to fill the table what if i want to fill in the fields of the table through screen painter....how can i do that how can i link the fields of the table to the fields in screen painter..i will really appreciate and award you the maximum if you answer me for this.

Regards,

Rk

[Former Member]

Hello Karthik,

To link the fields of the screen with the fields of the dictionary table, you need to create and declaration for the table in the TOP include of the module pool or in the executable program. For this, you can use the command TABLES.

And in the screen painter you can use the button Dictionary/Program Fields Window (F6) to select the declared fields/structure from DDIC.

For more information about creation of screens and module pools, I suggest you to read the following:

[ABAP Code Sample for Table Controls|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2165e990-0201-0010-5cbb-b5c2ad436140],

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

[Vehicle Management System: Creating Actions|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/102da700-2c65-2a10-7eaf-e0b4e5bc7e2b]

Regards,