How to upload flat file directly into ACDOCU table on SAP S/4 HANA On Premise 1809?

Question

I am using SAP S/4 HANA Group Reporting On Premise 1809,

I need a solution for uploading legacy data from a flat-file (txt, csv) directly into the table ACDOCU.

Is there anybody with an idea ?

Answer 1

SAP S/4HANA Migration Cockpit is the recommended tool for migrating legacy data to S/4HANA since S/4HANA 1511 and higher (see note 2287723).

It can be called via transaction code LTMC and requires role SAP_CA_DMC_MC_USER. Here is the detailed guide how to create migration project and use files for migration:

Transferring Data to SAP S/4HANA Using Files

It uses Excel XML files however it is quite easy to convert CSVs into XMLs. If you don't want to make conversion, migration through staging tables can be an option for you, as HANA Studio allows uploads of CSV.

Another option is Data Integrator tool, which is in fact stripped-down version of SAP Data Services. It is provided free of charge to S/4HANA users and can be downloaded also from the above note.

However, for such simple case as flat file I recommend stick to Migration Cockpit. Read this blog for more clarity about SAP migration strategy now.