topic Re: Populating new database table field? in Application Development and Automation Discussions

Populating new database table field?

Former Member — Wed, 03 Dec 2008 16:56:51 GMT

Hello,

I've added a new field (key) to an existing database table. Is there an "easy" way to populate field without writing an ABAP program?

FYI: I know field is populated with initial values per field data type when table activated. I want to initially populate with a "real" value.

Thanks in advance,

Billy

Re: Populating new database table field?

Former Member — Wed, 03 Dec 2008 17:41:49 GMT

there is NO way, easy or otherwise; to populate the new field for the existing records as you have defined that as a key field

Re: Populating new database table field?

Former Member — Wed, 03 Dec 2008 18:04:47 GMT

Thanks MxG....If it wasn't a key field what would you suggest?

Re: Populating new database table field?

Former Member — Wed, 03 Dec 2008 18:06:16 GMT

go to se11 create a table maintenence for your table once you have created that ,go to SM30 and start maintaining your table.

In this case you don`t need to write any ABAP Program.

Regards

Neha

Edited by: Neha Shukla on Dec 3, 2008 11:36 PM

Re: Populating new database table field?

Former Member — Wed, 03 Dec 2008 18:14:06 GMT

Thanks Neha..I did consider that but there are thousands of existing records.

Re: Populating new database table field?

BH2408 — Wed, 03 Dec 2008 18:20:23 GMT

Hi ,

Better write the program in case of having thousand of records rather than the entering through SM30 .

regards,

Bharani

Re: Populating new database table field?

Former Member — Wed, 03 Dec 2008 18:25:03 GMT

I for myself will write simple code using ABAP query to update the non key field for a custom table if needed

Re: Populating new database table field?

Former Member — Thu, 04 Dec 2008 00:43:22 GMT

Generate the table maintains from SE11. Create a LSMW to fill the field from SM30. if the table data in DEV and PRD are same you can atttach the new rows into a request and can transport it to PRD.

You can minimise the efforts this way.

Thanks

Lakshman

Re: Populating new database table field?

Former Member — Mon, 08 Dec 2008 22:13:03 GMT

A simple piece of code in program which updates the table field seems very appropriate. ( if the values that need to be updated are less in number and the conditions precise ).

Regards

Raj

Edited by: Rajasekhar Dinavahi on Dec 9, 2008 3:43 AM

Re: Populating new database table field?

Former Member — Tue, 16 Dec 2008 13:52:24 GMT

Thanks to all who replied....I considered most suggested (SM30, LSMW, ABAP, etc). I was hoping that database utility (SE14) was "smart enough" to reorganize data but obviously not. I probably should have been more specific in my question, but I didn't want to preclude another possibility. Again, thanks to all. FYI: ABAP is the path I choose.

Re: Populating new database table field?

former_member217112 — Mon, 12 Dec 2011 09:49:26 GMT

how to populate custom database table through abap program. ? write sample code

Re: Populating new database table field?

Former Member — Mon, 12 Dec 2011 10:32:01 GMT

Hello friend,

This is the simple code for populating the custom table.

select * from scarr into TABLE t_scarr.

loop at t_scarr into x_scarr.

insert zrtest1 from x_scarr.

ENDLOOP.

zrtest1 is the custom table which will be now populated with the values from the internal table t_scarr which in turn are having the values from scarr.

Thanks,

Sri Hari

Re: Populating new database table field?

Former Member — Tue, 13 Dec 2011 06:49:51 GMT

Hi,

By using Data Base Structures you can Add any number of new fields to an existing Table.

Warm Regards,

PavanKumar.G

Re: Populating new database table field?

kiran_k8 — Wed, 04 Jan 2012 08:52:17 GMT

You have added a new field as a primary key in an existing table which is having lots of entries and now you want to fill this field with some real value for all the existing entries.

A lot depends on the usage of this field,the kind of data that it is going to hold and were there any existing programs which is already having some logic build up based on the existing primary keys of this table.

1.If this Z table is getting updated from any standard transaction then it doesn't make any sense to populate a value to existing entries because the existing data is TRANSACTION DATA.

2.Won't this affect the existing programs logic if they are already using this table.

3.I suggest better you do a where used list of this table and check what are the programs that are already using this and accordingly take a call.

Thanks,

K.Kiran.

Re: Populating new database table field?

kiran_k8 — Wed, 04 Jan 2012 08:57:03 GMT

Deleted as the same reply got posted twice.

Edited by: Kiran K on Jan 4, 2012 9:57 AM