Archive id Updation problem

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

Cheers.

[Former Member]

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

[Former Member]

Problem solved,

Thanks,

Narasimha