Upload Excel File

53 Views

Hi Expert.

I need to Upload Excel file on Application server. So I can Use fm GUI_DOWNLOAD but by using this function module i got Error

'Access Denied'. Please help me....

Said Answer is with Example.

My Step : 1 ) Read all data from Database table in Internal table.

2) Try to Upload File to Application server Like

P_L_FILENAME = application server parth.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = P_L_FILENAME

FILETYPE = 'DAT'

APPEND = P_L_APPEND

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = P_I_DATATAB

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22.

IF SY-SUBRC NE 0.

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

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

ENDIF.

Thanks & Regards.

Pradip Patel.