topic Re: Database Update in Application Development and Automation Discussions

Database Update

Former Member — Tue, 05 Jul 2005 08:34:40 GMT

Hi,

I am having an interal table which is of database table type.

After populating few fields of the itab (Not all), I want to

modify the dbtable using this itab.

Insted of using the open SQL stmt (Update) for this scenario, can anyone of you

suggest a solution for the above.

FYI : If I am declaring the itab with only few fields that I wanted to update, I am

getting erros during activation (in the modify stmt)-since the size of itab

& dbtab are not matching

Re: Database Update

jayanthi_jayaraman — Tue, 05 Jul 2005 08:46:57 GMT

Hi,

For updating the database,you can use either UPDATE or MODIFY statement.If you are not sure whether the record is already there in database,you can use MODIFY.Because it will help you to both insert and update the database.

I hope that you are populating the internal table at a strecth and then using UPDATE statement.

loop at itab into wa.

....

modify itab...transporting....

endloop.

update db from table itab.

Here itab should be declared as db type.

I don't think there is another solution to update database.

Re: Database Update

Former Member — Tue, 05 Jul 2005 08:49:05 GMT

Hi,

Don't try to directly update the db tables using SQL statement as we actually don't know how many tables that are related.

Therefore you'd better use method: CALL TRANSACTION.

Re: Database Update

Former Member — Tue, 05 Jul 2005 09:19:13 GMT

As mentioned, I just wanted to know

whether we can change the contents of dbtable

without using "update"

Macy Lo, could you please explain in detail about

the use of call transaction in update?

Usha

Re: Database Update

Former Member — Tue, 05 Jul 2005 09:25:39 GMT

Hi usha,

For db upadte u can use the following:

db table insert --> Modify statement

db table edit --> Update statement

Thanks & Regds,

Ravikiran.

Re: Database Update

nishanthbhandar — Tue, 05 Jul 2005 09:30:14 GMT

Hi Usha,

It is advisable not to use UPDATE command unless it is really required.If you are trying to update a custom table,then no problem.But if you are trying to update a standard table you should first look if there are any function modules which do the work.It is advisable to look for BAPI's.Also the call transaction method will work only if you have all the mandatory data that needs to be supplied to the transaction.

Cheers

Nishanth

Re: Database Update

Former Member — Tue, 05 Jul 2005 09:34:47 GMT

Hi Usha,

Yes, we can change the contents of dbtable without using "update" statement.

My suggested method is like this:

For example, if I want to update the lab/office field for certain materials, I could use the call transaction method which simulates the transaction MM02.

When executing the program, it automatically updates the lab/office values of the selected materials by running MM02 in the background.

Re: Database Update

Former Member — Tue, 05 Jul 2005 09:53:35 GMT

Hello Usha,

1. The UPDATE statement or for that matter the MODIFY statement in Open SQL will always require you to specify the internal table or the work area which is of the same type as the database table. It is not possible otherwise.

2. The SET clause of the UPDATE statement cannot be used when you are trying to update from an internal table.

3. When you use the UPDATE statement with a work area, then you can use the SET clause of this statement to specify which of the fields should be actually updated.

4. If your work area is not of the same type as the db table type, then you must first move the data to another work area which has got the correct line type (same as the database table).

5. I'm afraid, there's no oter way to update the database table other than using the UPDATE statement. (we do have the MODIFY statement, bu that does not seem to be applicable in your case).

Also, whether you want to use a CALL TRANSACTION to do this is something that you have not mentioned. If you just want to know a way of updating the database table from an internal table, then that is not an option.

Regards,

Anand Mandalika.