How to find duplicate key in NLS?
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==