Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Elizaveta2
Product and Topic Expert
Product and Topic Expert
1,954

With this blog, I would like to show you how to update the instances that have been already uploaded to the staging tables with the CSV files. Please be aware, that the CSV upload functionality is available as of SAP S/4HANA 2208.


Let's assume, you have already transferred your data to the staging tables and have 10 instances. You have done some changes to the CSV.File (e.g. added entries, changed some values) and you want to upload this updated CSV.File.



If you try to upload another file with the "updated" instances in the same CSV folder, your validation will fail and you will not be able to proceed.



In the error description of the monitoring page, you will see that your new file contains the duplicate key values:



This "failure" behavior will be changed in the next releases, but, as for now, we offer you to perform the following workaround:


Open the CSV folder, which contains your CSV files, and delete the CSV files that you have used to fill the staging tables.



Now you can validate the file with the updated values one more time.



After the validation is completed successfully, you can transfer data to staging tables.



At this step, the migration cockpit recognizes that the data were from this CSV folder to the staging tables and offers you to overwrite the values.



The data in the staging tables have been updated!


More about using CSV upload:


Demo Video:  CSV upload for File/Staging


KBA: Additional Information about Transferring Data from CSV Template Files to Staging Tables for the Mig...


Best regards,


Elizaveta


PM of SAP S/4HANA migration cockpit