topic Re: getting Issue while uploading CSV file into internal table in Application Development and Automation Discussions

getting Issue while uploading CSV file into internal table

Former Member — Fri, 07 Nov 2008 11:31:48 GMT

Hi,

CSV file Data format as below

a b c d e f

2.01E14 29-Sep-08 13:44:19 2.01E14 SELL T+1

actual values of column A is 201000000000000

and columen D is 201000000035690

I am uploading above said CSV file into internal table using

the below coding:

TYPES: BEGIN OF TY_INTERN.

INCLUDE STRUCTURE KCDE_CELLS.

TYPES: END OF TY_INTERN.

CALL FUNCTION 'KCD_CSV_FILE_TO_INTERN_CONVERT'

EXPORTING

I_FILENAME = P_FILE

I_SEPARATOR = ','

TABLES

E_INTERN = T_INTERN

EXCEPTIONS

UPLOAD_CSV = 1

UPLOAD_FILETYPE = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

am getting all columns data into internal table,

getting problem is columan A & D. am getting values into internal table for both; 2.01E+14. How to get actual values without modifying the csv file format.

waiting for your reply...

thanks & regards,

abhi

Re: getting Issue while uploading CSV file into internal table

Former Member — Fri, 07 Nov 2008 11:41:20 GMT

Hi ...... Abhi.....

Generally you dont have to modify your CSV file......

Go to your CSV File expand the A and D Column or duble click on these columns.....

and then try to upload it will work.....

Thanjks

Saurabh

Re: getting Issue while uploading CSV file into internal table

Former Member — Fri, 07 Nov 2008 13:01:24 GMT

Hi Saurabh,

Thanks for your reply.

even i can't double click on those columns.

b'se the program needs be executed in background there can lot of csv file in one folder. No manual interaction on those csv files.

regards,

abhi