Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to find duplicate key in NLS?

Hi experts,

we are using HANA and NLS to archive data.

Currently we are facing the following problem:

due to rebookings in former periods we have load data back from the NLS-archive to the original DSO. This doesn´t work for the given period. According to the error message there´s a duplicate key error.

Our key in the DSO:

- 0FISCVARNT ("Fiscal Year Variant")

- 0DOC_NUMBER ("Sales Document")

- 0S_ORD_ITEM ("Position")

As 0FISCVARNT is set to "K4" and 0S_ORD_ITEM only sorts the lines in 0DOC_NUMBER the latter is the field that seems to be as well in actual BW as well as archived in NLS.

My Task now is to find the specific 0DOC_NUMBER(s) that is (are) doubled. I tried to use one of our BEx-Queries, but the amount of data exceeds data-limits of the infoprovider. I do get data out of the specific DSO.

But how am I able to get data with the keys from NLS to be able to identify the specific duplicate data set?

thx a lot for your help in advance,


PS: here the error-message in NLS-protocol (in German, hope that is OK though)

Ausnahmebedingung DBSQL_DUPLICATE_KEY_ERROR in Zeile 15 des Include CL_RSDA_INFOPROV_WRITE

Ausnahmebedingung UNCAUGHT_EXCEPTION in Zeile 1 des Include CL_RSDA_INFOPROV_WRITER_ODSO==


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question