topic Re: Need FM for Modify data into DB in Application Development and Automation Discussions

Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:02:18 GMT

HI All,

Is there any FM for Insert and modify tables?

Thanks,

Rayeez

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:05:13 GMT

Hi,

There is no generic function module that will insert / update specific tables. And more over that should not be done in case of standard tables.

For custom tables, you will have to write your own.

Regards,

Ravi

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:11:42 GMT

there is no any fm ...

u have to use technices for data base upload. like bdc,bapi or lsmw.

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:12:10 GMT

Hi rayeezuddin,

1. Is there any FM for Insert and modify tables?

No, there is no such generic FM.

2. We can use MODIFY statement for such purpose.

eg.

loop at itab.

MODIFY DBTAB FROM ITAB.

endloop.

3. Based upon the primary key values,

it will AUTOMATICALLY

INSERT (if no matching record found)

EDIT (if matching record found)

in to the database table.

regards,

amit m.

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:14:01 GMT

Hi,

Have a look at the foll FM:

COC2_TABLE_INSERT_DB

U need not use FM for updating or inserting..

You can use insert or modify statement for that..

Regards,

Tanveer.

<b>Please mark helpful answers</b>

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:19:39 GMT

use insert dbtab from itab.

or modify dbtab from itab.

Reward points if it helps

Regards

Gunjan

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:21:04 GMT

Hi,

Try this FM

RFC_READ_TABLE

If it helps reward points.

Regards,

Nandha.

Re: Need FM for Modify data into DB

Former Member — Tue, 20 Jun 2006 09:40:18 GMT

Hi,

There is no generic FM to Insert and modify tables.

But for standard tables SAP as provided FM to modify tables

You can search them using the table name

e.g

INSERT_T006 --- Table T006

Sameena

Message was edited by: sameena attarwala