topic Archive id Updation problem in Application Development and Automation Discussions

Archive id Updation problem

Former Member — Fri, 05 Nov 2010 09:18:34 GMT

Hi Every one,

I have writeen one report for Updating the Archive id , in the selection i given sap object , archive old id, Document id and

Archive newid my problem is when im updaing a new id to table TOAHR instead of changing ARCHIV ID TO the new value, it created a new record with new archiv id for each document id.so i want to update only new value to the database table

how ?

Thanks,

Narasimha

Re: Archive id Updation problem

Former Member — Fri, 05 Nov 2010 09:19:29 GMT

Hi ,

Im using Modify statement here

IF sy-subrc EQ 0.

SORT t_toahr.

APPEND LINES OF t_toahr TO t_old.

APPEND LINES OF t_old TO t_output.

LOOP AT t_toahr ASSIGNING <fs_toahr>.

<fs_toahr>-archiv_id = so_newid-low.

ENDLOOP.

DESCRIBE TABLE t_toahr LINES ld_lines.

MODIFY toahr FROM TABLE t_toahr.

ld_dbcnt = sy-dbcnt.

COMMIT WORK.

ENDIF.

Thanks,

Nara

Re: Archive id Updation problem

Former Member — Fri, 05 Nov 2010 09:46:02 GMT

Hi,

Why don't you try with UPDATE instead of MODIFY?

Cheers.

Re: Archive id Updation problem

Former Member — Fri, 05 Nov 2010 10:34:43 GMT

Hi ,

Im able to update the values to database table here i had one issue i.e instead of changing to the new value it is creating a document id with new value. Now i want to Overlap new values on old values how to do that with Modify statement.

Thanks,

Nara

Re: Archive id Updation problem

Former Member — Thu, 07 Jul 2011 13:05:06 GMT

Problem solved,

Thanks,

Narasimha