2670791 - Error Message: “Date and time XXXXXXXXXXXXXX not valid for Purchase Date Time” While Updating the Reference Date of Registered Products Using Data Workbench

Your requirement is to update the Reference Date of Registered Products using Data Workbench, but you are not able to proceed due to Processing Error:

Date and time XXXXXXXXXXXXXX not valid for Purchase Date Time (where XXXXXXXXXXXXXX represents the DateTime of Registered Product)

SAP Cloud for Customer

To Export the Registered Products

1. Login to the HTML5 client
2. Go to Data Workbench workcenter
3. Go to Export tab
4. In the Search field, select the object Registered Product
5. Select Data
6. Select field
7. Select Next
8. Export Data
9. Go to the Monitor tab
10. Download the exported file
11. Update the field ReferenceDate with Date and Time 

To Upload the file:

1. Login to the HTML5 client
2. Go to Data Workbench workcenter
3. Go to the Import tab
4. Select the radio button Individual Objects
5. Go to Update tab
6. Select the object Registered Product
7. Select Next and Browse for the file
8. Select Upload
9. Choose Next
10. Select Import
11. In the Monitor tab, check for the respective Task ID

The records in the file have the Processing Error

You may have updated the ReferenceDate by opening the CSV file in Microsoft Excel. The Update is failing when the CSV file is opened for modification in Microsoft Excel because Microsoft Excel approximates large numbers (ReferenceDate in this case).

The field ReferenceDate should be specified with the Date in YYYYMMDD format and Time in HHMMSS format without any spaces.

Example: 31st December 2019 12:00 AM should be specified as 20191231000000

 

If the file is opened using CSV editor then there is no approximation, and the file Update works correctly. It is recommended to use a CSV editor instead of Microsoft Excel to process data.

You may follow the below steps in the system:

1. Use the Notepad++ to edit your CSV file
2. Save the exported CSV file on your system
3. Right Click on the CSV file and select Edit with Notepad++
4. Make the changes to the ReferenceDate field
5. Select Encoding and Select Convert UTF-8
6. Save the file on Menu->File->Save as
7. Provide a name for the file and add the extension .CSV for example: filename.csv
8. Upload this file in Data Workbench 

Check the Products workcenter for the respective Registered Products to understand if the Reference Date is updated.

Note:
You may use software which is approved by your organization/IT.

Data Workbench User Guide on guidelines to update CSV files.

Data Workbench User Guide, Reference Date, Registered Product, ReferenceDate, Purchase Date Time , KBA , purchase date time , data workbench user guide , reference date , registered product , referencedate , LOD-CRM-INT-DWB , Data Workbench , Problem

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