BSEG table

[Former Member]

Hi Gurus,

need your advice in following scenario.

for implemenatation of one requirment,we have added customized fields in BSEG table ( Not in Custom include ) in dev system and  due to upgrade activity those changes moved to production.

Still now no data has been populated in those two fields as remaining code is yet to trasport in production.

But now we are going to approach another way so we want to delete those two fields from BSEG table.

Just wanted to know is there any risk in reverting  BSEG back to it’s original structure .

Please advice

[former_member195270]

If there is no data then it should be fine otherwise you will lose data.

[Former Member]

Hi Sreeni,

I suggest not to make any table structure adjustments in production server. Though you will be adjusting the table structure through DB utly, there is always a risk of loosing data.

Try creating another table in dev, and move to production and then move data.

Thanks

Vivek

[former_member491621]

Hi Sreenivasulu,

There is no risk in reverting back the changes done in BSEG.

[Abhijit74]

Hello,

Don't fear of loosing data. There will be no problem if you revert back the table as there is no data.

Thanks

[Former Member]

Hi Sreenivasulu ,

Yes u can revert it back but check for the data loss .....

as in production it is one of the most important table for client and it contains very large data as well.

Take some functional team advise as well. ....

[SreekanthKrishn]

Hi,

You can go ahead and remove the field from the table.

But make sure of following things:-

1. The field is not used in any programs/objects.

2. Do not directly activate the table directly in SE11. Use SE14 and choose "Activate and Save Data" option. You should be fine.

Thanks,

Sreekanth

[Former Member]

Hi Sreenivasulu,

I suggest not to make any table structure adjustments in production server. Though you will be adjusting the table structure through DB utly, there is always a risk of loosing data.

Try creating another table in dev, and move to production and then move data.

You can go ahead and remove the field from the table.

But make sure of following things:-

1. The field is not used in any programs/objects.

2. Do not directly activate the table directly in SE11. Use SE14 and choose "Activate and Save Data" option. You should be fine.

Thanks & Regards,

Seshu.

[harkesh_deshwal]

there will be no prob u can adjust the table