topic Re: create transaction for update a custom table in Application Development and Automation Discussions

create transaction for update a custom table

was_wasssu — Wed, 19 May 2010 12:29:30 GMT

Hi,

I have a custom table Z****. What are all the steps to create a transaction for updating my custom table? I don't want to use SM30 anymore.

Thank you.

Former Member — Wed, 19 May 2010 12:35:21 GMT

hi,

Create an editable ALV in oops with all the fields Same in ztable and from ther u can create as well as update entries.

Former Member — Wed, 19 May 2010 12:35:44 GMT

Create a Table maintainence through the maintainence generator.

Open table in SE11, goto utilities => table maintainence generator.

Once the generator is created,

In the same screen of generator - Goto Environment => Transaction Code

Select Transaction Code with Parameter.

In the default values - Enter the Transaction as SM30 . Select skip first screen.

In default values at the bottom

Add

screen field = VIEWNAME and value = Ztable name.

screen field =UPDATE and value = 'X'.

Edited by: Pranu Pranu on May 19, 2010 2:36 PM

Former Member — Wed, 19 May 2010 12:41:54 GMT

HI Was,

Definatly, you have no. of ways to update database table.

1. You can create table maintainance and assign this TMG with Z tcode.

If you need how to assign this, I can suggest you. If required?

2. You can create an Editable ALV or oops ALV to update database table.

3. you can create module pool (Dialog) screen to update entries into database table.

I hope, this information helps you.

If any issue, reply back.

Regards,

Narendra

ThomasZloch — Wed, 19 May 2010 12:52:38 GMT

Please search for available information before posting, don't expect step-by-step guides.

Thread locked.

Thomas