Skip to Content
avatar image
Former Member

R3trans Export is appending data only.

Hi All,

I am using R3trans script before refresh to export and later I am running the import script. But I observed Data which is existing get overwrite and other get appended. It is not deleting old tale records.

As I am doing this in refresh I need to do cleanup again for target system data.Also for RFC it is still showing RFC s of source system . Can anyone guide me how to write R3trans script so that while importing it will delete data from table and then It will import exported file.

I am giving sample Script which i used for this refresh.

export

client = 400

file ='SM59export310.dat'

select * from rfcattrib

select * from rfccheck

select * from rfccmc

select * from rfcdes

select * from rfcdoc

select * from rfcsysacl

select * from rfctrust

select * from rzlliclass

select * from rzllitab

select * from rfcdessecu

select * from rsecactb

export

client = 000

file ='SM59export000.dat'

select * from rfcattrib

select * from rfccheck

select * from rfccmc

select * from rfcdes

select * from rfcdoc

select * from rfcsysacl

select * from rfctrust

select * from rzlliclass

select * from rzllitab

select * from rfcdessecu

select * from rsecactb

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 03, 2016 at 03:30 AM

    Hi,

    Check the below mentioned thread and sap note.

    export/import in SAP | SCN

    1942 - How does R3trans work?

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 03, 2016 at 12:34 PM

    spr Ptl wrote:

    Hi All,

    I am using R3trans script before refresh to export and later I am running the import script. But I observed Data which is existing get overwrite and other get appended. It is not deleting old tale records.

    As I am doing this in refresh I need to do cleanup again for target system data.Also for RFC it is still showing RFC s of source system . Can anyone guide me how to write R3trans script so that while importing it will delete data from table and then It will import exported file.

    Hi,

    that is not an "standard" method to do a "refresh".

    What you are doing is "putting" data out and then putting the data in. Export is not supposed to delete data, only to record it out of the database. Import is not suppose to delete data, only to putting the previous data again into the database.

    Therefore, it works as designed.

    I do not think it is very "clever" what you are doing as it will (probably) create inconsistencies.

    if you want to do a refresh you should follow the homogeneus system copy guides, that is the supported, tested way of doing refreshs

    Add comment
    10|10000 characters needed characters exceeded