Duplicate transaction IDs for CRMD_ORDERADM_H

[former_member215542]

Hi All,

We are facing a strange issue, we are having duplicate object id for a particular transaction type i.e. the object_id field in table CRMD_ORDERADM_H contains two records with same number.

I checked the number range configuration for the transaction type but didnt found anything wrong over there.

Has anyone faced this kind of issue earlier?Any help in this regards would be appreciated.

Thanks,

Pulkit

[Former Member · Accepted solution]

Hi Pulkit,

Table CRMD_ORDERADM_H contains Client and Obect guid as primary key(i.e. they will be unique)

Can u specify where this transaction was created i.e was this transaction created in ECC and then downloaded in CRM ?

It would more helpful if you explain the duplicate creation of transaction in Detail.

Regards,

Anubhav

[former_member215542 · Accepted solution]

Yes, you are correct that object_id is not the primary key and instead Guid is the primary key in the table. But if you read the document related to the number ranges and also check the standard SAP behaviour, the object id or the transaction number should be unique for a particular transaction type.

We do not have connection to ECC to answer your other question. Regarding the scenario, I am not able to pin point if its only for specific scenario as I am looking into the system for the cause.

[former_member215542 · Accepted solution]

Got the reason. The interval is quite less compared to the volume fo credit memos generated. This caused it to reset the interval and reuse the same number range.