Import data into a Z transparent table using S/4HANA Migration Cockpit

[maissa93]

Hello experts,

does anyone have an idea if it's possible to import data from a CSV file into a table that I created myself as a transparent table in se11?

If it's not possible, what options do I have to import data into my table?

Thank you in advance

Maissa

[maulik · Accepted solution]

Maissa

You can achieve this in different ways. Here are a few pointers for you. Pick one that best works for your situation. Drop a note here if you require additional assistance.

(1) Use of Hana Studio

https://www.youtube.com/watch?v=4B55DrzFyIM

https://blogs.sap.com/2019/08/01/download-and-installation-of-sap-hana-studio-2.0-sp3-with-abap-bw-p...

(2) Write your own ABAP

rich.heilman has provided a working program here.

https://answers.sap.com/questions/1569009/csv-file-to-ztable.html

(3) Write your own ABAP - Steps

https://answers.sap.com/questions/10769631/how-can-i-load-a-flat-file-into-a-ztable-dynamical.html

[maissa93 · Accepted solution]

Hello Maulik,

thank you so much for your answer and the suggested solutions.

I created an ABAP program and now it's working like a charm.