Skip to Content
0
Former Member
Aug 25, 2006 at 04:36 PM

Code Optimization

25 Views

All -

I have written a piece of code that goes in my transfer rules. Basically, I am trying to load data master data from one BW system to another. I am loading a couple million records and the load completes after 24 hours. I have tried to optimize this code by addin a hash table but this doesn't seem to improve my ETL. Does anyone have any ideas as to how I can improve the load time?

DATA: WA_DATAPAK TYPE TRANSFER_STRUCTURE,

IT_ARIBA LIKE HASHED TABLE OF /BIC/MARIBACODE WITH UNIQUE KEY

/BIC/ARIBACODE OBJVERS WITH HEADER LINE,

WA_ARIBA TYPE /BIC/PARIBACODE.

DATA : BEGIN OF LT_ARIBACODE OCCURS 20,

SIGN(1),

OPTION(2),

LOW TYPE RSLOW,

HIGH TYPE RSHIGH,

END OF LT_ARIBACODE.

SELECT /BIC/ARIBACODE OBJVERS FROM /BIC/PARIBACODE

INTO CORRESPONDING FIELDS OF TABLE IT_ARIBA WHERE OBJVERS = 'A' AND

/BIC/G_ICODE NE ''.

LOOP AT IT_ARIBA into WA_ARIBA.

LT_ARIBACODE-SIGN = 'I'.

LT_ARIBACODE-OPTION = 'EQ'.

LT_ARIBACODE-LOW = WA_ARIBA-/BIC/ARIBACODE.

Append LT_ARIBACODE.

Endloop.

DELETE DATAPAK WHERE /BIC/ARIBACODE IN LT_ARIBACODE.