Change in data element

[former_member211992]

dear all ,

I have changed my data element of a field in a  table , previously that was N 5 length , now i have changed to P decimal 3 ..if i move this to qas server , this table already in qas with datas,, when i try to moving that to qas i cannot move the request to qas but i can see the changes in table i mean data element changed to P in qas , but when i try to see contents in se11 , i am getting TABLE IS NOT FOUND IN DATABASE , and i tried to adjust thro SE14 , ther was error log and i tried to  unlock the table but it showing 'data will be lost ' . what should i do to rectify that .

Thanks

[Florian]

Hi peter,

it just depends on how much entries we talk about. If there are just plenty in, download it and upload it again after repairing the table via SE14.

Another suggestion would be to contact your basis and let them get a backup of the table via direct SQL.

It all depends how much entries we talk about

~Florian

[former_member211992]

Thanks for u reply ,

is ther any option to upload with going thro programming?

[Florian]

Hi peter,

what do you mean. Possible to upload stuff via excel? If so here is a link

http://wiki.scn.sap.com/wiki/display/ABAP/ABAP+code+snippet+to+upload+Excel+file+into+an+internal+ta...

But I'm pretty sure you know that...I think I just do not got the question

~Florian

[Former Member]

Hi,

If you increase the size then wont be any problem and you can use SE14 and be-careful, there are option to delete the entries and adjust the structure...

Done delete table entries..

Better consult with BASIS experts.

Regards,

Vadamalai A

[Former Member]

Hi peter,

Hope you solve your problem.

SE14 is a interface between ABAP Dictionary and the Relational Database. If your database table is not exist then you should be click on "Create database" from the transaction SE 14.

Regards,

Niraj Sinha