ITAB_DUPLICATE_KEY

[Former Member]

hi all

i ve designed one APD which extracts financial data. here i am storing query result in one ODS. this APD runs fine in development server but when i run it in live server it throws error : ITAB_DUPLICATE_KEY.

ShrtText

There is already a line with the same key.

What happened?

Error in ABAP application program.

The current ABAP program "CL_RSAN_RT2_DS_QUERY_RUNNER===CP" had to be

terminated because one of the

statements could not be executed.

This is probably due to an error in the ABAP program.

i am unable to understand how it runs fine in development but not in live? what could be the problem?

[Former Member · Accepted solution]

Priyadarshini,

Due to Duplicate records.

Try to design query for required output(same as ODS keyfields and datafields) only and try.

Srini

[Former Member]

Hi

Due to duplicate records with report, try to get only required out put.

Hope it helps

[former_member204514]

Hi,

There can be duplicate records in the data,so its giving error. Use the statement

Delete Adjacent Duplicates itab. (check the syntax) before the result.

Regards,

anil