How can I import the tables necessary for currency conversion in SAP HANA 2.0 Express Edition?

[patricksteffens]

I wanted to play around with currency conversion on SAP HANA and figured out, that my system is lacking the obligatory tables (i.e. TCURC, TCURF, TCURN, TCURR, TCURT, TCURV, TCURW and TCURX).

While researching, I always only found help saying something like "Import the tables" but never how this has to be done. Is this even possible in HXE (server-only)?

[lsubatin]

I might be getting the question wrong, as there is plenty of documentation available on importing data into HANA (in general, but it applies to HANA Express too most of the times). Some of the quickest methods:

Using HANA Studio (which can even create the table for you from the CSV definition):

- https://help.sap.com/viewer/fc5ace7a367c434190a8047881f92ed8/2.0.02/en-US/d7a79a58bb5710149ed293cc61...

- Example: https://www.sap.com/developer/tutorials/studio-view-data-calculation-mdx.html

Using the IMPORT FROM statement:

- https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-US/20f712e175191014907393741f...

- Example (step 5): https://www.sap.com/developer/tutorials/hxe-cj1-create-table-upload-data.html