topic Re: Modify database table record in Application Development and Automation Discussions

Modify database table record

Former Member — Mon, 27 Apr 2009 15:43:37 GMT

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,

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 15:50:45 GMT

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

Rob

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 15:53:24 GMT

Why dont you use modify then?

Re: Modify database table record

MaryM — Mon, 27 Apr 2009 15:59:42 GMT


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

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 16:12:37 GMT

Hello Rob,

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

Thanks,

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 16:21:25 GMT

Seems dangerous - what field?

Rob

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 17:01:28 GMT

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

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 17:02:04 GMT

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,

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 17:12:24 GMT

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

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 17:18:21 GMT

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.

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 18:12:04 GMT

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.

Re: Modify database table record

Former Member — Mon, 27 Apr 2009 18:15:56 GMT

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

Rob