SAP Knowledge Base Article - Public

2317691 - National Register Number Deep Validation for Belgium "National ID"

Symptom

For the Belgium “National Register Number” the following format shall be provided in the system:

Display format: YY.NN.NN-NNN.NN

Regular Expression: [\d]{2}.[\d]{2}.[\d]{2}-[\d]{3}.[\d]{2}

The following format changes need to be completed in the Country Specific XML for Succession Data Model.

To have this change completed, please log a ticket with Support Engineer, SAP Product Support support

Deep Validation logic:

If National ID deep validation check-box is not enabled then:

  1. Valid values should be as per the regular expression format in CSF SDM.
  2. For Invalid values - validation should be thrown to match the regular expression values.

 If National ID deep validation check-box is enabled then:

  1. Valid values should be as per the logic defined for the respective country.
  2. If  a valid matching the regular expression as per CSF SDM is updated, but that value doesn't match the logic defined for that country then validation should be thrown.

Environment

SAP SuccessFactors Employee Central

Resolution

Validation Details:

The National Register Number consists of 11 digits:

  • First 6 digits: date of birth YYMMDD

Note: For persons whose complete date of birth cannot be determined based on official documents, only the year of birth is taken into account followed by a sequential number i.e. 560000, 560001, 560002,…

  • Next 3 digits: day counter for the births (even = female, odd = male)
    • Last 2 digits: check digit

To verify if the national register number is correct, the ‘check digit’ of the number has to be determined.

The check digit (A) is a number of two digits and corresponds to the difference between 97 and the modulo 97 of the value B, which is determined as:

  • For persons born until 31/12/1999 (see first 6 digits of the number,  YYMMDD):

     First 9 digits of the national register number (Y)

  • For persons born since 01/01/2000 (see first 6 digits of the number,  YYMMDD):

Concatenation of the value ‘2’ with the first 9 digits of the national register number

 

Support Engineer Action:

 

Add below information to customer Country Specific XML for Succession Data Model

 

<country id="BEL">

    <format-group id="national-id">

      <format id="NationalRegisterNumber">

        <instruction>National Register Number</instruction>

<instruction xml:lang="en-GB">National Register Number</instruction>

 <instruction xml:lang="fr-FR">Numéro de registre national</instruction>

<display-format>YY.NN.NN-NNN.NN</display-format>

        <reg-ex>[\d]{2}.[\d]{2}.[\d]{2}-[\d]{3}.[\d]{2}</reg-ex>

      </format>

</format-group>

</country>

Customer Action:

  1. Login to your Instance
  2. Go to Admin Tool- Company Settings
  3. Company System and Logo Settings
  4. Enable " Enable National ID"

 

Steps 3: Maintain Test user "Date of Birth" and "Gender"

 

  1. Go to Admin Tool
  2. Navigate to a test user Personal Information Portlet
  3. In Biographical Information add is : Date of Birth
  4. In Personal Information add is : Gender

 

Steps 4: Maintain Test user National Id Information:

  1. Enter a valid: National Register Number
  2. Save

Keywords

Belgium, deep validation for Belgium National Register Number, National Identity, country/region-specific , KBA , LOD-SF-EC-PER-NAT , National ID - Config, Rules, RBP, UI , Problem

Product

SAP S/4HANA Cloud Public Edition all versions