Unable to Import sap table from CSV file to hana

[Former Member]

Hi,

I am trying to import a SAP table AUFK to hana with flat file import.

I am getting the following error-

Can any one please help?

Thank you

[former_member226419 · Accepted solution]

From your error I can see some formatting and datatype issue. Please try changing your existing data type of table and try again.

BR

Sumeet

[Former Member · Accepted solution]

Hi,

I am not creating a table on hana and then import.

I am trying this blog post SAP HANA :: Loading Data from Flat Files via SAP HANA Studio | Skybuffer

option 2. Target not created.

So How should i change it?

[jyoti_senapati]

Hi Namita,

This type of error comes from CSV files. So please try below two points in your CSV file

1>Format all numeric fields as 'General'

2> Date fields as per below format.

I hope this may help you.

[Former Member]

Hi, thank you for your reply.

Actually it is very difficult to format data fields because i have lots off data in CSV file...is there any other way to solve this problem???

Or can you please tell me how to get the TABLE DEFINATION in SQL format for a table from the SAP system.

[jyoti_senapati]

You can double click on the table name so that you can see the table definition and you can also see the field size.

[Former Member]

You can get table definition from view table_columns .

Select * from table_columns where schema_name = <schema> and table_name = <table>

~Tarun

[Former Member]

Hi,

Seems it is data type problem between source field and target field.

looks like the data in the source file for one of the field is Alpha numeric and HANA table field is declared only numeric.

As per the screen shot, source data is 'U600-2350' / 'T-PM4320', may be the target field declared only numeric.

try to change data type of target field.

let me know target and source data types.

Thanks,

Sreedhara

[Former Member]

Hi,

I am not creating a table on hana and then import.

I am trying this blog post   SAP HANA :: Loading Data from Flat Files via SAP HANA Studio | Skybuffer

option 2. Target not created.

So How should i change it?

[Former Member]

Hi,

I believe you have option to change the data type/length in the below screen.

[former_member226419]

How many records are you having in your csv file?

Have you tried doing with less number of records? From where data is coming for AUFK ECC I guess?

BR

Sumeet

[Former Member]

Hi,

I have 7000 rows in the csv file.

I tried with till 1000 lines, then it's retrieving 499 rows to the Hana table.