ERP <--> SCM integration tricks

BALHDR Duplicate Records

During Integration Model Activation (CFM2), espessially if you are playing with IDES, error message can appears:

• SAP SQL Insert Duplicate Records

Or short Dump (check both systems, ERP and SCM)

• SAPSQL_ARRAY_INSERT_DUPREC

The reason could be difference between current number of records BALHDR-table, t-code SLGN
You should implement note:

196113 - SAPSQL_ARRAY_INSERT_DUPREC, BALHDR

Errors clarifying

During Integration Model Activation (CFM2), you can have general errors, like this (ERP system):

To have more information, you can go to SCM system, t-code /SAPAPO/CC Core Interface Cockpit, where error is more detailed:

After error correction you have to delete Queues with errors (t-code SMQ1) and re-launch activation.