Que about User made table....

[Former Member]

Hiii ... Dear ABAPers

I have a que regarding table :

my question is

" i made a table called "yvinward" and also populated it with some data ... but with the some reason i needed to change the field name of my table ... i changed the

field using se14 trasction for "adjust database table and save data" option.....

when i came back to table i came to know that data that column was contained whose name i have changed now vanished....howwwww its possible???????/

and when i try to maintain the data by " create entries " or sm30 i got error?????

now how to solve this problem......

I m waiting for ur reply.....

Cool Regards,

Nirav Parekh . . .

[Former Member]

Hiii ... Dear ABAPers

I have a que regarding table :

my question is

" i made a table called "yvinward" and also populated it with some data ... but with the some reason i needed to change the field name of my table ... i changed the

field using se14 trasction for "adjust database table and save data" option.....

when i came back to table i came to know that data that column was contained whose name i have changed now vanished....howwwww its possible???????/

and when i try to maintain the data by " create entries " or sm30 i got error?????

now how to solve this problem......

I m waiting for ur reply.....

Cool Regards,

Nirav Parekh . . .

[Former Member]

Regenerate table maintenence dialog to mainatain data in that table via SM30.

[RaymondGiuseppi]

You should have created a new field, write and execute a program which copy the data from old field to new field. Then you may remove the old field.(Or not, even SAP keep many old fields for "compatibility" reasons) Then you use SE14 to adjust Database. And you must adjust maintenance Dialog through SE54.

Else, depending on your Database system, you may try to ALTER the actual database table on server via SQL instruction (or tools of the DB system). Then SE11 to remove/add field giving a structure compatible with the new structure in DB system, then SE14 and SE54.

Regards

[Former Member]

... but with the some reason i

> needed to change the field name of my table ... i

> changed the

> field using se14 trasction for "adjust database table

> and save data" option.....

>

> when i came back to table i came to know that data

> that column was contained whose name i have changed

> now vanished....howwwww its possible???????/

-

---

When you change the name of a column in SE14, what you are doing effectively is modifyin the table. That means, you deleted the old column from the table definition (along with the contents of course) and added a new column. That exlains why your data went missing.

You need to regenerate the table maintenance dialog.

[Former Member]

after adjustments of able , again u have to re-generate TMG for that table, but be careful.

Regards

Prabhu