SAP Knowledge Base Article - Public

2730128 - Warnings for Date Values During Migration of Employee and User Data

Symptom

During the Migration of Employee and User Data, in the Validation step, the system throws warnings that the values for date will be truncated:

Warning detected in source record with key value ‘XXXXX’
Working Hours: value YYYY1.MM1.DD1 in column Start Date will be truncated; edit source value
Working Hours: value YYYY2.MM2.DD2 in column End Date will be truncated; edit source value

XXXXX represents the Employee ID
YYYY1.MM1.DD1 represents the Start Date
YYYY2.MM2.DD2 represents the End Date

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Select Implementation Projects view or Overview.
  3. Search and Open the activity Migration of Employee and User Data.
  4. Choose Migration of Employee & User Data using the migration tool.
  5. Execute Migration for the respective Migration File with migration mode Add new records.
  6. In the Validation step, system throws the error:
  • Warning detected in source record with key value ‘XXXXX’
  • Working Hours: value YYYY1.MM1.DD1 in column Start Date will be truncated; edit source value
  • Working Hours: value YYYY2.MM2.DD2 in column End Date will be truncated; edit source value
  1. Select Edit Source Record.
  2. Go to Working Hours tab.
  3. Hover the mouse over the column Start Date and column End Date.
  4. Type:Date Length:8.

Cause

In the Migration template of Employee and User Data, the Start Date and End Date format is 8 characters.

Resolution

Fill the Start Date and End Date fields with format YYYYMMDD and proceed with the migration activity.

Keywords

Migration of Employee and User Data, Start Date, End Date, Start Date will be truncated, End Date will be truncated , KBA , LOD-LE-MIG-CNT , LEAP Migration Content , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions