Skip to Content
0
Former Member
Dec 18, 2012 at 04:15 AM

Problem in uploading data into HANA

19 Views

Hi All,

I have to populate a table from csv file to HANA with five columns eg

MANDT ,WERKS, MRPPP, PPBIS, PPVON,PPERI, PPFIX

The column PPFIX is not null and cvs file has no record for PPFIX. While importing the cvs file it throws an error as PPFIX is not null and cvs file contains no values.

I can not drop not null constraint as some developers already implemented it with not null logic.

If I put a ' or ? in PPFIX , table get populated without any issues .Is there any solution to populate the table without any issues and will show up as empty only?

Thanks in advance.

Kiran