sql query...

Former Member — Thu, 11 Jan 2007 12:00:16 GMT

Hi ,

I have 2 database tables . one is vbep and the other one is zsodate. values will be changed in vbep . when we add a new records in vbep it will also adds the rows in zsodate. but our requirement is if one value is changed in vbep we have to updated the values in zsodate table by wrting the sql query by comparing the fields in vbeln and posnr .

give me update query how to find the exact row in zsodate and replace the value...

my code is this.

report z_test1 message-id xx .

tables : zsodate, vbap , vbep .

data : itab type standard table of zsodate with header line.

data : jtab type standard table of vbep with header line.

select-options : ordno for vbap-vbeln no intervals no-extension ,

itemno for vbap-posnr no intervals.

start-of-selection.

select * from zsodate into table itab where vbeln in ordno.

if sy-dbcnt = 0 .

message s999 with 'You Entered Wrong Order No ' .

exit.

endif.

select * from vbep into corresponding fields of table jtab

where vbeln in ordno.

loop at jtab.

write 😕 jtab-vbeln,

jtab-edatu,

jtab-posnr.

select * from zsodate into corresponding fields of zsodate

where vbeln = jtab-vbeln and posnr = jtab-posnr.

loop at itab where vbeln = jtab-vbeln and posnr = jtab-posnr.

if sy-subrc = 0.

write / 'vbep entries '.

*write :/4 jtab-etenr , 'vbep etenr',

15 jtab-edatu , 'vbep edatu'.
uline.

*write:/2 zsodate-vbeln,

13 zsodate-posnr,
26 zsodate-etenr,
45 'has been updated'.

move jtab-etenr to zsodate-etenr.

write jtab-edatu to zsodate-origdate mm/dd/yyyy.

zsodate-mandt = sy-mandt.

zsodate-uname = sy-uname.

modify zsodate.

write:/2 zsodate-vbeln,

13 zsodate-posnr,

26 zsodate-etenr,

45 'has been updated.'.

endif.

endselect.

Re: sql query...

Former Member — Thu, 11 Jan 2007 12:05:55 GMT

not sure abt ur exact requirement but update query shud be liek this -

update zsodate set field 1 = '1' field2 = '2' where field3 = 'abc'.

but better to use Modify statement as it will serve both the purpose create and update..

so press F1 on modify and use it..

amit

Re: sql query...

Former Member — Thu, 11 Jan 2007 12:07:49 GMT

but it is adding the new line ..

not it is modifying the alreday existing one...

i used modify only...

topic Re: sql query... in Application Development and Automation Discussions

sql query...

Re: sql query...

Re: sql query...

Re: sql query...