topic Re: Flat file splitting in Application Development and Automation Discussions

Flat file splitting

Former Member — Mon, 13 Aug 2007 07:48:50 GMT

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

Re: Flat file splitting

Former Member — Mon, 13 Aug 2007 08:19:03 GMT

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'

Re: Flat file splitting

Former Member — Tue, 14 Aug 2007 05:09:04 GMT

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.

Re: Flat file splitting

nivin_varkey — Tue, 14 Aug 2007 09:24:24 GMT

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

Re: Flat file splitting

Former Member — Tue, 14 Aug 2007 10:26:56 GMT

Plz Check out if this is of any use.

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

rgd

Re: Flat file splitting

Former Member — Tue, 14 Aug 2007 10:31:38 GMT

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