Wrong entries in tables CRMKUNNR and CRMM_BUT_CUSTNO.

[naval_bhatt4]

Hello Erveryone,

I am facing the data inconsistency issue with the customer master . As you all know the customer master data  is saved in the tables .

BUT000, KNA1 and CRMKUNNR ,  CRMM_BUT_CUSTNO .

Current situation :

Please refer to the above screenshots .

> Customer # 1022102  does not exists either in CRM or ECC . However the GUID linked to it in CRMKUNNR is the one in the table BUT000.

> Customer # CA71016969 exists in CRM and in the table BUT000 ,however in the table CRM_BUT_CUSTNO is linked to a GUID which is not available in ECC or BUT000.

Because of this issue , we are getting an error when a users are trying to create a sales document in CRM as the system uses the GUID from BUT000 and gets the linked customer number from CRMKUNNR.

Please suggest what can be done to make the values in these tables in correct.

Regards,

Naval Bhatt.

[naval_bhatt4 · Accepted solution]

Issue is closed , create a report suggested by SAP oss note 609766.