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,
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.
DELETE DATAPAK WHERE /BIC/ARIBACODE IN LT_ARIBACODE.