SAP Note 181514 - ITAB_DUPLICATE_KEY with SELECT ... FOR ALL ENTRIES

Composant : Syntax, Compiler, Runtime -

Solution : https://service.sap.com/sap/support/notes/181514 (Connexion à SAP Service Marketplace requise)

Résumé :
This SAP Note addresses a runtime error ITAB_DUPLICATE_KEY that occurs when executing a SELECT statement involving a HASHED TABLE using 'INTO/APPENDING ... FOR ALL ENTRIES'. The error stems from how the database interface splits the result of such SELECT queries into multiple portions, creating temporary duplicate entries that were not correctly handled internally. Corrections have been implemented through a kernel patch which adjusts the processing of the SELECT and 'FOR ALL ENTRIES' operations. Patch details include an improvement to handle ORDERED BY PRIMARY KEY and is available from patch level 265.

Mots Clés :
additional key words hash table, symptom runtime error itab_duplicate_key, entries und ordered, primary keypatch level, type hashed table, hashed table, internal table, select statement, database interface, internal elimination

Notes associées :

183118SELECT FOR ALL ENTRIES and ORDER BY PRIMARY KEY