Flat file splitting

[Former Member]

Can i upload a flat file which contains entries around 12 lakhs.where in when i am trying to upload with ws_upload it is reading the entries but thrwoing error when trying to open a file.

Is there any way so that the flat file can be splitted in to parts and do the validation

[Former Member]

hI

WHEN UR UPLOADING FLAT FILE

IF U MAINTAIN TAB DELIMITED PACE

THEN YOU HAVE TO MENTION THAT IN UR FUNCTION MODULE CALLING

OTHER WISE DON'T MENTION IT

I THINK IT MAY BE THE PROBLEM

IF USEFULL REWARD'

[Former Member]

pass parameters correctly.

WS_UPLOAD functions to upload data from PC to SAP

• Declare upload format

DATA: BEGIN OF ITAB OCCURS 0,

PLANT(2) TYPE C,

MATERIAL(18) TYPE C,

DATA: END OF ITAB.

PARAMETERS: F-FILE LIKE RLGRAP-FILENAME DEFAULT 'C:\TEMP\FILE.TXT'..

• FILETYPE -> 'BIN' OR 'DAT' OR 'ASC' OR 'IBM' OR 'WK1' OR 'DBF' OR 'SPL' OR 'TRU'.

call function 'WS_UPLOAD'

EXPORTING

FILENAME = F-FILE

FILETYPE = 'DAT'

tables

data_tab = ITAB

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

OTHERS = 6.

[nivin_varkey]

Hello Amit,

considering the size of the file.i suggest you to not import the file from presentaion server as it would be resource intensive and slow..why not import this huge file from the application server. Is this import a frequent requirement..or one time?? who is going to do the transaction??.answering these questions would help solve the problem..

Thanks,

Nivin

[Former Member]

Plz Check out if this is of any use.

http://help.sap.com/saphelp_nw04/helpdata/en/54/863b65e05311d2b46a0060941936e3/frameset.htm

rgd

[Former Member]

Hi Teja

here check this program i am spliting the record depend upon ',' and dont use ws_upload etc fm's are obsolete....

data: begin of itab_string occurs 0,

record type char255,

end of itab_string.

data: L_FILETABLE TYPE FILETABLE,

L_FILETAB_H TYPE FILETABLE WITH HEADER LINE.

data: p_file1 type string.

• selection screen .

PARAMETERS: P_FILE TYPE LOCALFILE.

initialization.

at selection-screen on value-request for P_FILE.

• IF THE USER SELECT EXTENTION BUTTON IT WILL OPEN THE LOCAL DIRECTORY FOR SELECTING THE FILE LOCATION.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG

• EXPORTING

• WINDOW_TITLE =

• DEFAULT_EXTENSION = 'CSV'

• DEFAULT_FILENAME = 'C:\Documents and Settings\196093\Desktop\STATUS.csv'

• FILE_FILTER =

• INITIAL_DIRECTORY = 'C:\Documents and Settings\196093\Desktop\'

• MULTISELECTION =

• WITH_ENCODING =

CHANGING

FILE_TABLE = L_FILETABLE

RC = RC

• USER_ACTION =

• FILE_ENCODING =

EXCEPTIONS

FILE_OPEN_DIALOG_FAILED = 1

CNTL_ERROR = 2

ERROR_NO_GUI = 3

NOT_SUPPORTED_BY_GUI = 4

others = 5

.

IF SY-SUBRC <> 0.

ELSE.

LOOP AT l_filetable INTO L_FILETAB_H.

P_FILE = L_FILETAB_H-FILENAME.

move p_file to p_file1.

EXIT.

ENDLOOP.

ENDIF.

• passing the selected file name to gui_upload for loading the data

• into internal table

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = p_file1

• FILETYPE = 'ASC'

• HAS_FIELD_SEPARATOR = ' '

• HEADER_LENGTH = 0

• READ_BY_LINE = 'X'

• DAT_MODE = ' '

• CODEPAGE = ' '

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• CHECK_BOM = ' '

• NO_AUTH_CHECK = ' '

• IMPORTING

• FILELENGTH =

• HEADER =

TABLES

DATA_TAB = itab_string

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17

.

IF SY-SUBRC <> 0.

MESSAGE I000(Z00) WITH 'PLEASE PROVIDE CORRECT FILE NAME'.

ENDIF.

loop at itab_string.

• now split the statuses

split itab_string at ',' into itab_status-aufnr itab_status-asttx itab_status-asttx1.

• and move one internal table

append itab_status.

clear itab_status.

endloop.

reward points to all helpful answers

kiran.M