update database table

[Former Member]

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.

[rajeshswami_swami]

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

[vinod_vemuru2]

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.

[Former Member]

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

[Former Member]

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

Rob