You have replicated Materials from an external system to C4C. You noticed there are leading zeros in field External ID of materials although you are not sending them in replication.
Example: External ID = 000000000123456.
Reproducing the Issue
- Go to Products and select Products Administration
- Select any Material replicated from external system
- The External ID has leading zeros.
The reason for that is because the External ID accepts different format rules. ie. accept letters and special characters.
For pure numerical External ID, the Alpha-conversion is taken in place. Alpha-conversion means that numerical values are padded with leading zeros until they reach the length of the referenced data type.
For External IDs containing letters or special characters, the alpha-conversion is not needed and hence no leading zeros will be inserted in ID.
For example: External ID = ABC-123 (Contains letters or special characters). In this case, the zeros will not be inserted.
This is a designed system behavior.
KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To