topic Re: update database table in Application Development and Automation Discussions

update database table

Former Member — Sat, 06 Feb 2010 12:15:36 GMT

Hello experts,

i want to update a field in a database table.In production one value is posteb in the table is wrong.

I know only through update statement we can update a field in the database table.Is it possible.

Ex: update bseg set fname = ' ' where condition.

please give me the details.

what are the steps to be taken to update a field in a database table(sap table).

i want immediate answers for this.

please help me in this.

simentaneously i am seraching sdn also.

Re: update database table

rajeshswami_swami — Sat, 06 Feb 2010 13:02:52 GMT

Moderator message - Please respect the 2,500 character maximum when posting. Post only the relevant portions of code

this small example for update..using alv reports

i hope this will slove ur problem

regards

rajesh swami

Edited by: Rob Burbank on Feb 6, 2010 6:13 PM

Re: update database table

vinod_vemuru2 — Sat, 06 Feb 2010 14:01:02 GMT

Hi,

We are not supposed to do the direct table update for ANY standard table.

Find out the appropriate transaction and develop a program with BAPI/BDC for updating that field. Take help from your functional consultant in identifying the T-code used.

Thanks,

Vinod.

Re: update database table

Former Member — Sat, 06 Feb 2010 14:16:51 GMT

Hi Sachin,

Since BSEG is a standard table it is not recommended to update a particular field in it becoz it may lead to data inconsistencies & may cause further processing problems .

My suggestion to you is find how did a wrong entry get posted, if it is manual mistake then there will be some way to reverse this entry for this contact your functional consultant. He might be able to tackle this problem in better manner.

Regards,

Abhijit G. Borkar

Re: update database table

Former Member — Sat, 06 Feb 2010 23:18:59 GMT

Moderator message - Please do not ask for "immediate" answers. And don't even think about updating BSEG this way - locked to prevent damage

Rob