code of update a customized table

[Former Member]

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

[Former Member]

Hi,

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

You can record using the transaction SHDB..

Thanks

Naren

[naimesh_patel]

You can use this:

UPDATE ZTAB
SET FIELD1 = ' '
WHERE FIELD2 = condition

Regards,

Naimesh Patel

[Former Member]

Your Question is not clear

Regards,

Satish

[Former Member]

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

[Former Member]

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