topic code of update a customized table in Application Development and Automation Discussions

code of update a customized table

Former Member — Sat, 24 Nov 2007 04:23:54 GMT

hi guys,

can any one show me a code, of how to update the customized table with criteria?

i need to do a mass update of the field to become blank. please help. thanks

Re: code of update a customized table

Former Member — Sat, 24 Nov 2007 04:25:16 GMT

Hi,

You can use BDC for the corresponding transaction to update the field

You can record using the transaction SHDB..

Thanks

Naren

Re: code of update a customized table

naimesh_patel — Sat, 24 Nov 2007 04:25:50 GMT

You can use this:


UPDATE ZTAB
SET FIELD1 = ' '
WHERE FIELD2 = condition

Regards,

Naimesh Patel

Re: code of update a customized table

Former Member — Sat, 24 Nov 2007 04:26:29 GMT

Your Question is not clear

Regards,

Satish

Re: code of update a customized table

Former Member — Sat, 24 Nov 2007 04:38:52 GMT

hi,

now i have a request, to update all the details in the field ( sold to party, customer record) to become blank for a customize table (store of serial number), with criteria.

and i go to SE38, create a program, with type executable program, and in the program, my source code is as below

UPDATE zsd_serial1
SET delnum = ' '
    rec_customer = ' '
    customer = ' '
WHERE material EQ '100000' AND sloc1 = 't100'
AND rec_customer EQ 'x'.

however, there is no respond and it does not update anything. can any one please help. thanks

Re: code of update a customized table

Former Member — Sat, 24 Nov 2007 04:41:39 GMT

UPDATE zsd_serial1
SET delnum = ' '
    rec_customer = ' '
    customer = ' '
WHERE material EQ '100000' AND sloc1 = 'T100' "<< Upper Case
AND rec_customer EQ 'X'. "<< Upper Case.

Regards,

Satish