SAP Knowledge Base Article - Public

2486141 - Leading Zeros in External ID of Materials

Symptom

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

  1. Go to Products and select Products Administration
  2. Select any Material replicated from external system
  3. The External ID has leading zeros.

Cause

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.

 

Resolution

This is a designed system behavior.

Keywords

KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711 ; SAP HYBRIS C4C ADDINS 1705 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711