Export with "Unsorted Unload" for R/3 4.7 Ent

[Former Member]

Dears ,

we are trying to export via R3load procedue an environment R/3 47 Ent, 4.7 (Kernel 640_EX2) on Oracle 920/Windows.

We want to optimize the performances of the export, as now to export 370 GB require more that 13 hour.

We are already using the "Split STR files" and the the "Customer data order" options, but we would like to use also the "Unsorted unload" option we used on other releases.

But we wonder this version of Sapinst does not allow the "Unsorted Unload" option (the checkbox field is completely missing) and we do not find Oss Notes about that.

THe Sapinst in use is :

version 642, build 968151

compiled on Mar 14 2008,

The R3load is :

version R6.40/V1.4

Compiled Mar 9 2009 23:01:40

At the beginner we were thinking the R3load was using ,as default, the unsorted Unload, but it's not the case.

Into the export logs for the several packages SAPAPPL* and others we do not see any entry referring to the "unsorted unload".

Beside on Sapnet the CD for 47 Enterprise are not available anymore, so we cannot download a new Sapinst.

In you opinion there is a way to activate the "Unsorted Unload" in this situation ?

best regards

[former_member204746 · Accepted solution]

SAPINST and R3LOAD are quite old, go get newer versions from SAP.

[Former Member · Accepted solution]

You can try to "start migmon manually" and specify it there. You can use a ddl mapping file then:

[ UNSORTED UNLOAD ]
# DDL file for unsorted unload
ddlFile = ./DDLORA_LRG.TPL
# table names
TABLE_A
TABLE_B
TABLE_C

You need to read these notes:

[1040674 - R3ta in combination with unsorted unload|https://service.sap.com/sap/support/notes/1040674]

[954268 - Optimization of export: Unsorted unloading|https://service.sap.com/sap/support/notes/954268]

There are a few restrictions, and as Eric mentioned the R3* tools need to be at a certain patch level.

Cheers Michael

[andreas_herzog]

you'll have to use the appropriate "Patch Collection DVD" (Installation Master 6.20/6.40 Windows Server on IA32 32bit or 64bit)...CD51033746_13 or 51033746_14 or 51033746_15 respectively...the SAPinst version is ok, R3load (and R3ldctl, R3szchk) should be patched beforehand

GreetZ, AH