topic Re: dump in ecc 6 in Application Development and Automation Discussions

dump in ecc 6

Former Member — Wed, 06 Aug 2008 15:36:40 GMT

one of our old program having issue when it runs

I have an internal tabe called iI_ORDERS. then decleard like this.

DATA: I_ORDERS99 LIKE SORTED TABLE OF I_ORDERS

WITH NON-UNIQUE KEY VBELN.

and after one select statement, give like this

APPEND I_ORDERS TO I_ORDERS99.

but getting dump says

A line is to be inserted or changed at position 36 in the sorted

internal table (type SORTED_TABLE)

"\PROGRAM=ZRSD_ODERS_WITHOUT_DELV\DATA=I_ORDERS99".

In doing so, the sorting sequence - determined by the table key - was

destroyed.

any idea, who can I correct this.

Re: dump in ecc 6

JozsefSzikszai — Wed, 06 Aug 2008 15:39:07 GMT

hi Mat,

you cannot APPEND to a SORTED table, you have to use INSERT ... INTO TABLE ... instead.

hope this helps

Re: dump in ecc 6

Former Member — Wed, 06 Aug 2008 15:39:37 GMT

Hi...

Can you please post u r code....

Hw is i_orders declared.....

Is I_orders a work area????

Thanks,

Chaitanya

Re: dump in ecc 6

Former Member — Wed, 06 Aug 2008 15:40:42 GMT

It means y're appending the records without to respect the sorting: try to replace APPEND statament with INSERT

*APPEND I_ORDERS TO I_ORDERS99.

INSERT I_ORDERS INTO TABLE I_ORDERS99.

Max

Re: dump in ecc 6

Former Member — Wed, 06 Aug 2008 15:42:31 GMT

it is an internal table.

DATA: BEGIN OF I_ORDERS,

VBELN LIKE VBAK-VBELN,

POSNR LIKE VBAP-POSNR,

ZZIHREZ_E LIKE VBKD-IHREZ_E,

KUNNR LIKE VBAK-KUNNR,

K_NAME(50),

CLIENT LIKE VBAK-KUNNR,

C_NAME(50),

MATNR LIKE VBAP-MATNR,

M_NAME(35),

ZZWERKS LIKE VBAP-WERKS,

ERDAT LIKE VBAK-ERDAT,

VDATU LIKE VBAK-VDATU,

ERNAM LIKE VBAK-ERNAM,

KWMENG LIKE VBAP-KWMENG,

PRODH LIKE VBAP-PRODH,

NETWR LIKE VBAP-NETWR,

REJ(15),

END OF I_ORDERS.

what is the use of declaring like sorted tables, instad of that, at end of all the selection and update, sort that internal table by vbeln is enough?

DATA: I_ORDERS99 LIKE SORTED TABLE OF I_ORDERS

WITH NON-UNIQUE KEY VBELN.

Re: dump in ecc 6

Former Member — Wed, 06 Aug 2008 16:00:11 GMT

hi for the sorted tables no need to use the sort command .

sorted table means itself is sorted by definition

Re: dump in ecc 6

Former Member — Wed, 06 Aug 2008 16:06:52 GMT

It's usually used to improve the performance if the internal table can have a very large number of hits.

If it uses a SORTED TABLE the record is inserted in the internal table in according to the sorting way, after inserting it the system creates an index to be used for reading, in your case a index for field VBELN.

U should also consider the SORT statament needs memory space and this space is defined by system variables and it couldn't be enough for very big table, in this case a dump occurs.

Max