topic Re: Regarding GUI_UPLOAD in Application Development and Automation Discussions

Regarding GUI_UPLOAD

sreeramkumar_madisetty — Fri, 29 Feb 2008 07:46:14 GMT

Hi Friends

I am getting some error while downloading the data from my presentation server.

TYPES: BEGIN OF type_compensationawards,

pernr TYPE pspar-personid_ext,

subtype TYPE p0759-citem,

carea TYPE p0759-carea,

amount TYPE p0759-cpamt,

currency TYPE p0759-curre,

timeunit TYPE q0759-prfre,

effectivedate TYPE q0759-effdt,

END OF type_compensationawards.

DATA: it_compawards TYPE STANDARD TABLE OF type_compensationawards,

wa_compawards TYPE type_compensationawards.

DATA: lv_file TYPE string.

lv_file = p_file.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = lv_file

filetype = 'ASC'

has_field_separator = 'X'
HEADER_LENGTH = 0
READ_BY_LINE = 'X'
DAT_MODE = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
CHECK_BOM = ' '
VIRUS_SCAN_PROFILE =
NO_AUTH_CHECK = ' '
IMPORTING
FILELENGTH =
HEADER =

TABLES

data_tab = it_compawards

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 ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Here I am getting Sy-subrc = 8.

I tried with the file:

899910 07ls 10 3000 usd 010162007

What’s the wrong in my code?

Please correct me. If possible send me some sample files also.

Regards,

Sree

Re: Regarding GUI_UPLOAD

Former Member — Fri, 29 Feb 2008 07:49:44 GMT

Hi,

Is your file data separated by a tab-delimiter? is the data in the same order of internal table declaration? Also do the size of the field and data match?

Regards,

Ramya

Re: Regarding GUI_UPLOAD

Former Member — Fri, 29 Feb 2008 08:14:47 GMT

hi sree ram,

use the data in the notepad using tab.

like this....

899910 07ls 10 3000 usd 0101 62007.

regards,

venkat.

Re: Regarding GUI_UPLOAD

Former Member — Wed, 08 Jan 2014 11:53:20 GMT

Hi.

You have define the lv_file as a string.

And you are trying to upload fileds defined as currency.

All your fields should be defined as char fields.

Bye

Re: Regarding GUI_UPLOAD

sreeramkumar_madisetty — Tue, 21 Jan 2014 15:54:23 GMT

Issue is with the file format.Not with the program logic.

It's working now.