topic Re: updating the database table in Application Development and Automation Discussions

updating the database table

Former Member — Wed, 16 May 2007 06:35:23 GMT

hi experts,

how to update the z database table using reports.

thanks

shyam

Re: updating the database table

Former Member — Wed, 16 May 2007 06:39:37 GMT

Hi,

tables ztable.

ztable-fld1 = 'dfhgfd'.

ztable-fld2 = 'grg'.

ztable-fld3 = 'err'.

modify ztable.(this is for creating nw records if the record withese primary keys doesnot exist)

update ztable.(this will update existing field if primary keys macches and does not create any new records).

check these links for more help.

<b>modify</b>

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/dba4b235c111d1829f0000e829fbfe/content.htm

<b>update</b>

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3a94358411d1829f0000e829fbfe/content.htm

rgds,

bharat.

Re: updating the database table

Former Member — Wed, 16 May 2007 06:39:48 GMT

Hi,

tables: ztable.

ztable-f1 = 'f1val'.
ztable-f2 = 'f2val'.
INSERT ztable.

"if u want to use itab then use:
insert ztable from table itab.

Jogdand M B

Re: updating the database table

Former Member — Wed, 16 May 2007 06:40:18 GMT

the best way to do it .

create a function module in update task

use update statement inside the function module

please lock the table before calling the function module and release it at the end

Re: updating the database table

Former Member — Wed, 16 May 2007 06:40:24 GMT

Hi,

If you are updating the ZTABLE from getting values from different SAP tables used in the report then it can be done using the INSERT/MODIFY statement.

Can you please explain in detail your requirement so that I can provide more specific solution.

Regards,

Atish

Re: updating the database table

Former Member — Wed, 16 May 2007 07:11:13 GMT

Hi,

If u want to change a field in a record of the database table, u can use

UPDATE databasetablename SET fieldname = 'AAA' WHERE KEYFIELD EQ p_NO.

HOPE THIS WILL SOLVE UR QUESTION.

Reward if helpful.

Regards,

Karthick.