Program is deumping - why

[Former Member]

I am getting dump with one of my program

for all the materials of particular plant .....

The program is dumping at below stmt.

at INSERT zadi_m_cr624_tab FROM TABLE gt_output..

Which is in subroutine below..

FORM update_table.

gv_data_found = 'X'.

INSERT zadi_m_tab FROM TABLE gt_output.

ENDFORM. " update_table_624

I need to find the root cause . This program is written in 2003 and since then the program worked with out any problem. However the program dumped 5 days back and I must say what is the root cause for dump.

[Former Member]

Hi ,

May be bcos of duplicate records , what error u are getting in ST22 ?

regards

Prabhu

[Former Member]

check this link for all forms of insert

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb361f358411d1829f0000e829fbfe/content.htm

into which table you want to insert

[Former Member]

Use MODIFY statement OR Try using the addition ACCEPTING DUPLICATE KEYS with INSERT statement. F1 help on INSERT will give you the details.

[Former Member]

Hi Sam,

I have also face this problem several times.. I also don't know the actual reason behind this. But if this problem is there then you can try the Modify statement this will work.

I have changed my code from insert to Modify statement.

[Former Member]

INSERT zadi_m_cr624_tab FROM TABLE gt_output

gt_output should hold the same structure of zadi_m_cr624_tab

and

use thid addition also FROM TABLE itab [ACCEPTING DUPLICATE KEYS]

[Former Member]

THANKS FOR YOUR ANSWERS.

HOWEVER I need to give explanation of what is the root cause for the dump today as this program ran these many years with out interruption ?

Note please the pogram is dumping for a particular plant materials . I don't understand that wy the program is runnung for other plant materials correctly ?

Regards,

[Former Member]

instead why can't you use the MODIFY here.., it inserts if there is no record with the key or else it updates.

[Former Member]

Vijay,

I agree with our answer.

However my team lead told client that we will be finding the rootcause as it was runiing these many years with out interruption.

That is why I am struggling.

Thanks,

I have another problem problem of writing into ftp file...some field values aare missing while writing ftp server. Can you suggest some thing on that if you can ? I was struggling with that problem of writng all fieelds into ftp server...

THANK YOU.