Skip to Content
0
Former Member
Aug 25, 2006 at 11:14 AM

copy very large table KONV (64 millions of record )to ZZZKONV

302 Views

Hello

We try to copy very large table KONV (64 millions of record) to ZZZKONV

It takes enormous time (actualy it finish after 4 hour with short dump because of rdisp/max_wprun_time was set to 18000).

I increased it to 360000. Do you have an idea?

Thank you in advance

Branko

I used the ABAP code to create ZZZKONV:

*&----


*

*& Report ZFILLKONV1 *

*& *

*&----


*

*& *

*& *

*&----


*

REPORT ZFILLKONV1.

DATA: BEGIN OF S000 OCCURS 100.

INCLUDE STRUCTURE KONV.

DATA: END OF S000.

DATA: wa like konv .

DATA: CUR1 TYPE cursor. .

parameter: test AS CHECKBOX.

OPEN CURSOR WITH HOLD CUR1 FOR

  • Get the data from the database *

SELECT * FROM KONV.

  • WHERE KAPPL = 'V' AND

  • KDATU ge '20040101'.

DO.

FETCH NEXT CURSOR CUR1

INTO TABLE S000 PACKAGE SIZE 1000.

IF SY-SUBRC <> 0.

  • Es wurden keine weiteren Sätze gefunden *

EXIT.

ENDIF.

  • LOOP AT S000.

  • select * from zkonv into wa where KNUMV

*= S000-KNUMV and KPOSN

*= S000-KPOSN and STUNR = S000-STUNR and ZAEHK = S000-ZAEHK and

*kappl = 'V'.

  • endselect.

  • if sy-subrc ne 0.

modify ZZZKONV FROM table S000.

  • endif.

*ENDLOOP.

CALL FUNCTION 'DB_COMMIT'.

ENDDO.

CLOSE CURSOR CUR1.