Skip to Content
0
Former Member
Nov 07, 2008 at 11:31 AM

getting Issue while uploading CSV file into internal table

18 Views

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