topic BSEG table in Application Development and Automation Discussions

BSEG table

Former Member — Thu, 17 Jan 2013 13:16:11 GMT

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

Re: BSEG table

former_member195270 — Thu, 17 Jan 2013 13:25:09 GMT

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

Re: BSEG table

Former Member — Thu, 17 Jan 2013 14:35:49 GMT

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

Re: BSEG table

former_member491621 — Thu, 17 Jan 2013 17:56:09 GMT

Hi Sreenivasulu,

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

Re: BSEG table

Abhijit74 — Fri, 18 Jan 2013 11:47:04 GMT

Hello,

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

Thanks

Re: BSEG table

Former Member — Fri, 18 Jan 2013 15:16:26 GMT

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. ....

Re: BSEG table

SreekanthKrishn — Wed, 30 Jan 2013 22:39:12 GMT

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

Re: BSEG table

Former Member — Thu, 31 Jan 2013 18:06:37 GMT

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.

Re: BSEG table

harkesh_deshwal — Fri, 01 Feb 2013 08:47:33 GMT

there will be no prob u can adjust the table