Duplicate Key issue while Loading BSEG data

[Former Member]

Hello Experts,

I was loading and not replicating BSEG data into HANA and it seems that after loading around 100 million record, it went into an error with the below error message in SLG1:

I don't think we can ever have a duplicate record in BSEG table itself for a given combination of Company Code, Accounting Document, Fiscal Year and Item. Then how come we are having this issue in replication.

There is a SLT piece of code which we have, wherein we are performing two things:

a) Loading only 2013 data

b) Defaulting for Invalid/Blank Date Issue as shown below

It would be great, if somebody can throw some light on this.

Thanks & regards,

Jomy

[former_member182465]

Hi Joy,

Even I have faced Duplicate key error but once I change the setting to Array Modify in data transfer monitor after starting the replication , the data movement was successful.

Thanks

Abilash

[tobias_koebler]

Hi,

have you implemented this note in the system?

1992138

SLT (2011 SP06 / 2010 SP10) - Correction 09

Best,

Tobias

[Former Member]

Hi Tobias,

It seems this note is not applicable on DMIS 2011 SP4. We are on SP4.

It would be great, if you could suggest some other solutions ?

Thanks & regards,

Jomy

[roger_rodriguez1]

You can change the transfer behavior from 1 to 3.

[sudipDas]

Could you let me know the process to change the transfer behavior from 1 to 3.

[gajendra_moond]

Hi Sudip

Refer SAP note 1919356 - Duplicate key error on System Landscape Transformation (SLT) system.

Regards

Gajendra