Skip to Content
author's profile photo Former Member
Former Member

Runtime Error :ITAB_DUPLICATE_KEY Select on BSIS and BSAS Table

Hi Experts,

We sometimes get runtime error itab duplicate key in production system on the following select:

select data from BSIS into ITAB where burks on selection screen

gjahr on selection screen

->select data from BSAS appending ITAB where burks on selection screen

gjahr on selection screen

ITAB is sorted table with unqiue key bukrs gjahr belnr buzei.

I belive the dump occurs because it finds duplicate record in BSAS for the same key (bukrs gjahr belnr buzei) and i can change my internal table to

non-unique key and it should resolve the error.

But when i check my dev system i dont see any records on BSAS for the key (bukrs gjahr belnr buzei) which are in BSIS.

Can someone please advice if this can happen in any scenario?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 28, 2013 at 03:44 AM

    Hi Bhanu,

    Just a thought - production system always contains real-time data hence maybe you need to analyze how the data is stored in BSIS and BSAS and replicate the same in DEV system and see what happens!

    We generally do that. If we get a dump in Prod, we replicate it in Dev and correct the dump. Prod always has or is understood to have correct and real-time data unlike DEV which can have dummy data too.

    Try this and let us know if this helps!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.