updating the database table

[Former Member]

hi experts,

how to update the z database table using reports.

thanks

shyam

[Former Member]

hi experts,

how to update the z database table using reports.

thanks

shyam

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.