topic Re: Set initial value in a DD table in Application Development and Automation Discussions

Set initial value in a DD table

Former Member — Sun, 12 Jul 2009 03:45:45 GMT

Hi,

I want set initial/default value in a column when create a table by Tcode se11.

please help me.

thanks.

Re: Set initial value in a DD table

Former Member — Sun, 12 Jul 2009 04:43:53 GMT

Hi,

You can do this using the Events in table maintenance generator,

When you save an entry in table using SM30 or any other transaction, the default values get saved in the table along with the other entries...for instance you can disable the fields for input on SM30 for the fields where you want to default values...so that user cant enter values in table entries creation.

To access events: SE11->Table maintenance generator->

On the table maintenance screen->Menu->Details->Modifications->Events.

Events: 01- Before save(Do F4 help for more events available)

Routine: <give form name where you add code to default value on screen field>

For more information on events you can search SDN

Hope this helps you

Regards

Shiva

Re: Set initial value in a DD table

Former Member — Mon, 13 Jul 2009 05:39:49 GMT

At first create a domain there you set default in values tab .. and later assign this domain in table field

anand kumar

Edited by: anand kumar on Jul 13, 2009 7:40 AM

Re: Set initial value in a DD table

Former Member — Mon, 13 Jul 2009 07:55:02 GMT

Hi,

this is very simple....when yu create table in SE11 then when you create data element set the initial value in domain.....just add a Zdomain and set the value in there.

save and activate the domain.then save nad activate the tabel.

Pooja

Re: Set initial value in a DD table

Former Member — Mon, 13 Jul 2009 08:45:55 GMT

Hi,

If you want to to assign values to your field from a list of fixed values then, create a domain and in its fixed value specify the value and then attach it to your database table field.. Now, you will be able to choose from this list only..

But, if you want that particular field to hold some default value then, you can do this with the help of events.. Specify your default value there.. Please look from the list of events which suites your requirement..