Header row: number of the row in which the header is.Header row exists: check if the file contains a header row.Select worksheet: data worksheet, in the case of an excel file with more than one worksheet.Field delimiter: field separator character, which can be comma, semicolon, colon or tab.File encoding: encoding for reading and processing data.Select Data from Local File option and click Nextįigure 2 – SAP ADT Import wizard (click to enlarge)ģ – On the next screen, select the Target System and click Nextįigure 3 – SAP ADT Import environment (click to enlarge)Ĥ – On this screen it is necessary to inform the import data: With SAP ADT or Hana Studio, using an access to the Hana database, it is possible to import CSV\Flat files into the database directly, through a wizard.ġ – Access your Hana environment through SAP ADT (using Hana Modeler Perspective) or Hana Studioįigure 1 – SAP ADT Hana Connections (click to enlarge)Ģ – Go to menu File > Import… On the Import screen, type CSV in filter to make the search easier.
The most common possibilities for this import are through the LSMW transaction (which requires a certain time to prepare the data and scenario) or carrying out the development of a program for this purpose (which generates a single-use program), however, there is a third alternative with great performance and ease of use: import via Hana Studio or SAP ADT directly into the Hana database. Import some CSV\Flat files to Z tables in the S/4 Hana environment. Through SAP ADT or Hana Studio, we can load the CSV\Flat file without the need to use SAP S/4, facilitating the process and gaining speed in execution.