R3trans control file

[Former Member]

Hello,

I need to extract few (say 100) service orders from service order tables which contains millions of records. How do I write control file for R3trans to achieve this?

I tried following one but it end up extracting and loading only the first service order

export

file = '/Test/SO/SO.txt'

SELECT * FROM AFVC where aufpl = '1005701961'

SELECT * FROM AFVC where aufpl = '1005701982'

SELECT * FROM AFVC where aufpl = '1005701983'

SELECT * FROM AFVC where aufpl = '1005701984'

SELECT * FROM AFVC where aufpl = '1005701985'

SELECT * FROM AFVC where aufpl = '1005702001'

SELECT * FROM AFVC where aufpl = '1005702002'

SELECT * FROM AFVC where aufpl = '1005702003'

SELECT * FROM AFVC where aufpl = '1005702006'

SELECT * FROM AFVC where aufpl = '1005702007'

SELECT * FROM AFVC where aufpl = '1023702008'

SELECT * FROM AFVC where aufpl = '1054702010'

SELECT * FROM AFVC where aufpl = '1034702011'

Abhijeet

[former_member206552]

Hi Abhijeet,

is it not easier to get the data as database level ?

I have never done it using R3trans but maybe try adding a client as well ?

export

client = 020

file = 'clone.export.<sid>.<client no>.data'

select * from <client_dependent_tablename1>

select * from <client_dependent_tablename2>

Best Regards

Marius

[Former Member]

Hi Marius,

Yah it is but I havent got access at database level.

Looks like it is not possible. Thanks anyways for your suggestion but as I told earlier I need only few out of million entries to be exported.

Abhijeet

[stefan_koehler]

Hi Abhijeet,

> Looks like it is not possible.

... "Impossible is nothing" ...

Why not using a simple IN List like that ?

SELECT * FROM AFVC where AUFPL IN ('1005701961', '1005701982', '1005701983', ....., '1034702011')

... or use a SAP transport request (with object TABU) with a simple filter?

Regards

Stefan

[former_member206552]

Hi Abhijeet,

How about db02 -> sql command editor then you can save it to an excel file ?

but if you want to import into another system then i would use Stefan's solution

Best Regards

Marius

[Former Member]

Thanks for reply Stefan,

Yes I did try this syntax but it is giving error. It expects either 'Like' or 'Eq' instead of 'IN' operator.

Thats why I tried individual sql statements but it looks like it only store the last one (must be getting overwritten)

I might try transport request option, thanks!

[Former Member]

Thanks Marius for reply,

Excel is worst thing when it comes to data handling. It makes unnecessary changes to data and then uploading again is the problem.

[former_member206552]

Hi,

Yes you are right this is why i do it directly on db

best option will be transport

best regards

marius

[Former Member]

Hi Abhijeet,

Please refer to link http://scn.sap.com/thread/660542.

Also refer to Note 1942 - How does R3trans work?

Johan

[Former Member]

Thanks Johan

This link provides basic info about R3trans and how it can be used to move data across client in same machine.

I need to move few entries out of million one across two different systems.

Abhijeet

[Former Member]

Hi,

Refer to this link.

http://venkata-pagolu.blogspot.com/2011/07/how-to-copy-tables-to-another-system.html

Johan

[Former Member]

Thanks Johan.

But looks like you haven't read my question correctly. I know the basics about R3trans command and its use to copy table across systems. I need info to copy only selected few out of millions of entries.

Abhijeet

[former_member188883]

Hi Abhijeet,

Please check whether you have created the import file as described in the link below

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/using-r3trans-to-copy-tables-between-...

Regards,

Deepak Kori