How to specify values on newly added table fields for existing records?

[Former Member]

Hello,

I'm new to ABAP. I've added a new field to an existing table using SE11.

Now I want to define a value for this newly added field that all the existing records in the table would take when the table is enhanced in the DB.

Thanks & Regards,

Gaurav

[Former Member]

hi

if this is a standard table ( which i am assuming)

Then you need to goto transaction SE30, maintenace generator.

Populate the field with the value.

Thanks.

[Former Member]

HI Gaurav,

You can do so by creating a <b>domain</b> for the data element of field added and then give the set of values for this field in <b>value range tab of this domain</b>.

*Always reward points for helpful answers.

Regards,

Amit

[Former Member]

Hi,

U can use the Tcode--SM30 and manullay update the records.

But it wud be tiresome if there r large no of records in the DBT.

Instead u create a prgm and fetch all the records into an internal table. Update the field in the internal table with the reqd values and Update the DBT.

*Reward pts if useful!

[Former Member]

Thanks for all your answers.