Repair the consnumber in communication tables
[AM 883] [AM 897] [BAS_COMMUNICATION]
Symptom
If the communication table has and entry with consnumber 999, then while inserting the next entry it gives the error ‘Internal error – insert in sorted table’.
Other terms
BAS_COMMUNICATION
AM 883
AM 897
Reason and Prerequisites
In the communication tables only 999 entries can be stored for the combination of addressnumber, personnumber and communication type.
The highest consnumber is stored in ADRCOMC table. If we try to enter the new entry in the table it look for the adrcomc entry. If it find the HIGH_VALUE as 999 it will throw the error.
The following are the two conditions that the report Z_OSSNOTE_1070798 handles.
Condition 1:
If consnumber is 999 either in ADRCOMC or ADR2-13 tables for any addressnumber or for any communication type.
For this condition, donot enter any values in the input parameters addrnumber & communication type.
Condition 2:
Only for the given address number & communication type even if the highest consnumber is not 999.
For this condition, Please enter values in the input parameters addrnumber & communication type.
Note:
Please do not run this report without consulting SAP Development Support.
If the communication table has already total of 999 entries for a given Address Number & Persnumber, then its a restriction from Address Management that the maximum number of entries can be 999 entries and cannot add anymore further.
Solution
Please run the report Z_OSSNOTE_1070798. It will Re-arrange the consnumbers in the communication table ADR2 to ADR13, by filling up the missing/deleted consnumber inbetween. It also updates the value in ADRCOMC table. The report produces the log with the address number & Person number in which it has done the repair.