Modify database table record

[Former Member]

Hello,

We want to modify a database table record. We are unable to do this through the standard transaction. What are the best & safe options to modify a database table record directly?

Thanks,

[Former Member]

Standard SAP table or custom table? If SAP - which table and field?

Rob

[Former Member]

Why dont you use modify then?

[MaryM]

data: wa type TABLE.
select single * from TABLE into corresponding fields of wa
   where...


wa-field1 = ...
wa-field2 = ...
...
update TABLE from wa.

At leas like this you only modify a single record in your table.

Regards,

MayM

[Former Member]

Hello Rob,

It is a standard SAP table and the table is EINA.

Thanks,

[Former Member]

Seems dangerous - what field?

Rob

[Former Member]

Small correction. Table is EINE and field is MWSKZ. I need to confirm if these are the right table and field. But for now let's say these are the right table and field. What options do we have?

Thanks,

[Former Member]

If those are correct, then it seems even more dangerous. You could get into big trouble with data integrity if you simply update the database table here. I'd look at cancelling the original transaction and re-creating it with the correct tax code.

Rob

[Former Member]

Rob,

From what I heard from business, they are unable to either change or delete the record. I'm just looking to see what all ways(except doing it through a small program) in which we can update the table record. Please let me know all the ways in which we can update a table record. Thanks.

[Former Member]

Any thoughts Rob? I do not think we will be making any updates but just want to know how we can update a database table record other than doing it through a small program to update the table. Thanks.

[Former Member]

If you cannot change it using the original transaction (in change mode), look for another transaction that can change the value.

Rob

[Former Member]

Hi Stone,

For your requirement write one small program.

<< Very bad example removed >>

Thanks,

Kiran Kumar G.A

Edited by: Rob Burbank on Apr 27, 2009 1:19 PM