topic Re: Update database table - Urgent in Application Development and Automation Discussions

Update database table - Urgent

Former Member — Mon, 28 Jan 2008 15:31:39 GMT

Hi Experts,

I want to update a database table from an internal table with a certain condition .

For example I want to update the MARA table from values in the internal table it_mara (say) with a condition MTART in MARA eq 'XYZ'.

Could any one tell me the syntax for this.Its bit urgent.

Regards,

Vishnu.

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 15:34:57 GMT

YOu have another internal table and get only the records that you need.

loop at itab where mtart = 'XYZ'.

move-corresponding itab to itab_new.

append itab_new.

clear itab_new.

endloop.

modify mara from table itab_new.

Regards,

Ravi Kanth Talagana

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 15:40:00 GMT

It's generally a bad idea to directly update standard SAP tables. There may be other tables that need to be updated as well and if you don't take that into account, you could run into a problem with data integrity.

Rob

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 15:54:08 GMT

Do not pursue any coding options that perform direct table updates!!!

Look for BAPIs or even resort to an old-fashioned BDC ot make your updates.

Direct table updates can quickly destroy the referential integrity of the database.

And it could quickly end your employment as well.

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 16:31:32 GMT

Hi Experts,

I want to transfer some data from 3 internal tables into an app server.I remember that there is some syntax 'Open file with appending mode'.

Could you tell me the correct syntac for the same.

Regards,

Vishnu.

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 16:36:13 GMT

Vishnu,

Just to be clear - you did NOT implement direct table updates - did you?

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 16:38:00 GMT

Vishnu,

Your answer:

OPEN DATASET your_app_server_path_and_filename_here FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

Re: Update database table - Urgent

Former Member — Mon, 28 Jan 2008 16:45:01 GMT

This is an entirely different question. Since you've marked it as solved, you'll probably get more response if you post a new thread.

Rob