topic Re: download error in Application Development and Automation Discussions

download error

Former Member — Mon, 11 Feb 2013 13:14:25 GMT

Hi guys i need your help badly .

i am downloading data using function module ws_download or gui_download .datas are getting downloaded , but few columns are blank . on those blank columns data are getting populated from next column. it doesnt take any blank space. actually internal table doesnt have any data corresponding to that field.

solution pls.

Re: download error

Abhijit74 — Mon, 11 Feb 2013 13:42:06 GMT

Hello,

Have you specified any field separator ? WRITE_FIELD_SEPARATOR .

-------------------------------------------------------------------------------------------------------------

data:begin of it occurs 0,

grp type c,

val type i,

end of it.

data:begin of heading occurs 0,

TEXT(10) type c,

end of heading.

it-grp = 'A'.

it-val = 100.

append it.

it-grp = 'B'.

it-val = 200.

append it.

* heading-text = 'GROUP'.

* append heading.

* heading-text = 'VALUE'.

* append heading.

call function 'GUI_DOWNLOAD'

exporting

filename = 'C:\text.xls'

FILETYPE = 'DAT'

WRITE_FIELD_SEPARATOR = '#'

SHOW_TRANSFER_STATUS = 'X'

tables

data_tab = it[]

* FIELDNAMES = heading[]

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 <> 0.

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

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

endif.

-----------------------------------------------------------------------------------------------------------------------

Thanks,

Abhijit

Re: download error

Former Member — Mon, 11 Feb 2013 13:42:38 GMT

Hello.

Could you post ur code (the download part) so we can have a look and help you?.

Regards

Re: download error

Former Member — Tue, 12 Feb 2013 04:04:58 GMT

Hi Miguel Sure ...

REPORT zmbcrp0081 NO STANDARD PAGE HEADING LINE-SIZE 900 LINE-COUNT 90.

************************************************************************

* Program Title : Download data in Excel and Send mail

* Program Description : Download data from ZMSD_LOP_OUT table into Excel

* format and Send an mail with attachment if Send

* mail checkbox is selected.

* SAP R/3 Module : SD

* SAP R/3 Release : 4.6c

* Development Log

* ---------------

* Name Date Description

*--------------- ---------- --------------------------------------------

*-----------------------------------------------------------------------

*TYPE-POOLS DECLARATION

*-----------------------------------------------------------------------

TYPE-POOLS:slis.

*-----------------------------------------------------------------------

*TABLES DECLARATION

*-----------------------------------------------------------------------

TABLES: zmsd_lop_out.

**----------------------------------------------------------------------

** RANGES

**----------------------------------------------------------------------

*RANGES : r_chrcode FOR zmsd_lop_out-zchrcode.

*r_chrcode-low = '2*'.

*r_chrcode-high = ' '.

*r_chrcode-sign = 'I'.

*r_chrcode-option = 'CP'.

*APPEND r_chrcode.

*CLEAR r_chrcode.

*-----------------------------------------------------------------------

* TYPES DECLARATIONS

*-----------------------------------------------------------------------

TYPES: BEGIN OF ty_lopout,

zvkorg TYPE zmsd_lop_out-zvkorg,

zfcode TYPE zmsd_lop_out-zfcode,

zinvno TYPE zmsd_lop_out-zinvno,

zfdate TYPE zmsd_lop_out-zfdate,

zchrcode TYPE zmsd_lop_out-zchrcode,

zhawb TYPE zmsd_lop_out-zhawb,

z_cntr_type TYPE zmsd_lop_out-z_cntr_type,

zmawb TYPE zmsd_lop_out-zmawb,

zshipmod TYPE zmsd_lop_out-zshipmod,

zdpport TYPE zmsd_lop_out-zdpport,

zdsport TYPE zmsd_lop_out-zdsport,

zqty TYPE zmsd_lop_out-zqty,

zpr_uom TYPE zmsd_lop_out-zpr_uom,

zf_cur TYPE zmsd_lop_out-zf_cur,

zexrate TYPE zmsd_lop_out-zexrate,

zamount TYPE zmsd_lop_out-zamount,

zgst_amt TYPE zmsd_lop_out-zgst_amt,

ztot_amt TYPE zmsd_lop_out-ztot_amt,

zccode TYPE zmsd_lop_out-zccode,

zccp_no TYPE zmsd_lop_out-zccp_no,

z_cif_val TYPE zmsd_lop_out-z_cif_val,

z_tax_inv TYPE zmsd_lop_out-z_tax_inv,

z_tax_inv_dt TYPE zmsd_lop_out-z_tax_inv_dt,

z_rem_1 TYPE zmsd_lop_out-z_rem_1,

zbtvol TYPE zmsd_lop_out-zbtvol,

zbrgew TYPE zmsd_lop_out-zbrgew,

z_no_of_cntr TYPE zmsd_lop_out-z_no_of_cntr,

zfnum1 TYPE zmsd_lop_out-zfnum1,

zvessel TYPE zmsd_lop_out-zvessel,

zatd TYPE zmsd_lop_out-zatd,

zeta TYPE zmsd_lop_out-zeta,

zrate TYPE zmsd_lop_out-zrate,

zrate_cur TYPE zmsd_lop_out-zrate_cur,

zdpport_nm TYPE zmsd_lop_out-zdpport_nm,

zdsport_nm TYPE zmsd_lop_out-zdsport_nm,

zcc_pp TYPE zmsd_lop_out-zfpstatus,

zrate_type TYPE zmsd_lop_out-z_rate_type,

END OF ty_lopout.

*-----------------------------------------------------------------------

* INTERNAL TABLES

*-----------------------------------------------------------------------

DATA: t_lopout TYPE TABLE OF ty_lopout,

w_lopout TYPE ty_lopout,

t_head TYPE STANDARD TABLE OF slis_fieldcat_alv,

w_head TYPE slis_fieldcat_alv.

*-----------------------------------------------------------------------

* VARIABLES DECLARATION

*-----------------------------------------------------------------------

DATA: v_file TYPE rlgrap-filename.

*-----------------------------------------------------------------------

* SELECT-OPTIONS AND PARAMETERS

*-----------------------------------------------------------------------

SELECTION-SCREEN BEGIN OF BLOCK a WITH FRAME TITLE text-001.

SELECT-OPTIONS : s_zvkorg FOR zmsd_lop_out-zvkorg NO INTERVALS,

s_zfcode FOR zmsd_lop_out-zfcode NO INTERVALS,

s_crdate FOR zmsd_lop_out-creation_date.

SELECTION-SCREEN SKIP.

PARAMETERS : p_zsts TYPE zzsts DEFAULT 'T' OBLIGATORY.

SELECTION-SCREEN END OF BLOCK a.

SELECTION-SCREEN BEGIN OF BLOCK b WITH FRAME TITLE text-002.

PARAMETERS : p_file TYPE rlgrap-filename.

SELECTION-SCREEN SKIP.

PARAMETERS : p_mail AS CHECKBOX.

SELECTION-SCREEN END OF BLOCK b.

*-----------------------------------------------------------------------

* INITIALIZATION

*-----------------------------------------------------------------------

* AT SELECTION-SCREEN

*-----------------------------------------------------------------------

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

field_name = ' '

IMPORTING

file_name = p_file.

*-----------------------------------------------------------------------

* START OF SELECTION

*-----------------------------------------------------------------------

START-OF-SELECTION.

PERFORM get_data.

PERFORM fetch_header.

PERFORM downld_excel.

*&---------------------------------------------------------------------*

*& Form get_data

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM get_data.

SELECT *

FROM zmsd_lop_out

INTO CORRESPONDING FIELDS OF TABLE t_lopout

WHERE zvkorg IN s_zvkorg

AND zfcode IN s_zfcode

AND creation_date IN s_crdate

AND zsts = p_zsts

AND zchrcode <> space.

ENDFORM. " get_data

*&---------------------------------------------------------------------*

*& Form downld_excel

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM downld_excel.

DATA: lv_chrcode TYPE z_chcd.

LOOP AT t_lopout INTO w_lopout.

lv_chrcode = w_lopout-zchrcode.

lv_chrcode = lv_chrcode+0(1).

IF lv_chrcode <> '2'.

DELETE t_lopout.

ENDIF.

ENDLOOP.

IF sy-subrc = 0.

v_file = p_file.

ENDIF.

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

filename = v_file

filetype = 'DAT'

TABLES

data_tab = t_lopout

fieldnames = t_head.

ENDFORM. " downld_excel

*&---------------------------------------------------------------------*

*& Form fetch_header

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM fetch_header.

w_head = 'Company Code'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Forwarder Code'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Invoice Number'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Invoice Date'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Charge Code'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Ref Doc No'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Container Type'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'MAWB'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Transport'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Departure Port'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Destination City'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Charges Incuured'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Pricing Unit'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Currency Code'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Exchange Rate'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Amount'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'GST Amount'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Total Amount'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Carrier Code'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'CCP Number'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'CIF Value'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Tax Invoice Number'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Tax Invoice Date'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Remarks 1'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Remarks 2'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Remarks 3'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Volume(M3)'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Weight'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'No. of Container'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Flight Number'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Vessel'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'ATD'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'ETA'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Rate'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Rate Currency'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Departure Port Name'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Destination Port Name'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Freight Paid Status'.

APPEND w_head TO t_head.

CLEAR w_head.

w_head = 'Rate Type'.

APPEND w_head TO t_head.

CLEAR w_head.

ENDFORM. " fetch_header

Re: download error

Rushikesh_Yeole — Tue, 12 Feb 2013 04:10:07 GMT

Best way to use GUI_DOWNLOAD...as suggested above

WS_DOWNLOAD is obsolete now

Re: download error

Former Member — Tue, 12 Feb 2013 04:14:25 GMT

hi Abhijit,

i have used write_field_separator , it doesnt make any differencr in the output. Any other solutions

regards

kaushik

Re: download error

Former Member — Tue, 12 Feb 2013 04:16:10 GMT

Hi rushikesh

i have even used GUI download. it doesnt make any difference, and it is throwing dump in gui download that the reason i used ws_download

Re: download error

Former Member — Tue, 12 Feb 2013 06:13:01 GMT

hi ,

Suggest i am really having no clue now tried all possibilities

Re: download error

Former Member — Tue, 12 Feb 2013 06:27:30 GMT

Hi Kaushik Chand,

Have you tested your internal table which you downloading?

if the table is having empty column then the download file will be the same.

Could you please give the code what you are using for the download?

it may help us to help you soon..

Re: download error

kakshat — Tue, 12 Feb 2013 06:33:27 GMT

Hi Kaushik,

I tried simulating your scenario by preparing an internal table which has some columns blank. Then, I used FM GUI_DOWNLOAD to download the contents into an excel. I see the contents in the excel as in the internal table i.e. the blank columns remain blank in the excel.

I would suggest have a real close look at the contents of your internal table just before the call to GUI_DOWNLOAD. Also, I am posting an excerpt from my sample code below.

CALL FUNCTION 'GUI_DOWNLOAD'
   EXPORTING
     filename                = 'C:\test.xls'
     filetype                = 'DAT'
     write_field_separator   = '#'
     show_transfer_status    = 'X'
   TABLES
     data_tab                = lt_prod
   EXCEPTIONS
     OTHERS                  = 99.

Re: download error

Former Member — Tue, 12 Feb 2013 06:36:21 GMT

try to use GUI_DOWNLOAD

and in the fieldname use gt_xlsfield as a table you can download the file

Re: download error

Former Member — Tue, 12 Feb 2013 06:40:24 GMT

REPORT zmbcrp0081 NO STANDARD PAGE HEADING LINE-SIZE 900 LINE-COUNT 90.

************************************************************************

* Program Title : Download data in Excel and Send mail

* Program Description : Download data from ZMSD_LOP_OUT table into Excel

* format and Send an mail with attachment if Send

* mail checkbox is selected.

* SAP R/3 Module : SD

* SAP R/3 Release : 4.6c

* Development Log

* ---------------

* Name Date Description

*--------------- ---------- --------------------------------------------

*-----------------------------------------------------------------------

*TYPE-POOLS DECLARATION

*-----------------------------------------------------------------------

TYPE-POOLS:slis.

*-----------------------------------------------------------------------

*TABLES DECLARATION

*-----------------------------------------------------------------------

TABLES: zmsd_lop_out.

*-----------------------------------------------------------------------

* TYPES DECLARATIONS

*-----------------------------------------------------------------------

TYPES: BEGIN OF ty_lopout,

zvkorg TYPE zmsd_lop_out-zvkorg,

zfcode TYPE zmsd_lop_out-zfcode,

zinvno TYPE zmsd_lop_out-zinvno,

zfdate TYPE zmsd_lop_out-zfdate,

zchrcode TYPE zmsd_lop_out-zchrcode,

zhawb TYPE zmsd_lop_out-zhawb,

z_cntr_type TYPE zmsd_lop_out-z_cntr_type,

zmawb TYPE zmsd_lop_out-zmawb,

zshipmod TYPE zmsd_lop_out-zshipmod,

zdpport TYPE zmsd_lop_out-zdpport,

zdsport TYPE zmsd_lop_out-zdsport,

zqty TYPE zmsd_lop_out-zqty,

zpr_uom TYPE zmsd_lop_out-zpr_uom,

zf_cur TYPE zmsd_lop_out-zf_cur,

zexrate TYPE zmsd_lop_out-zexrate,

zamount TYPE zmsd_lop_out-zamount,

zgst_amt TYPE zmsd_lop_out-zgst_amt,

ztot_amt TYPE zmsd_lop_out-ztot_amt,

zccode TYPE zmsd_lop_out-zccode,

zccp_no TYPE zmsd_lop_out-zccp_no,

z_cif_val TYPE zmsd_lop_out-z_cif_val,

z_tax_inv TYPE zmsd_lop_out-z_tax_inv,

z_tax_inv_dt TYPE zmsd_lop_out-z_tax_inv_dt,

z_rem_1 TYPE zmsd_lop_out-z_rem_1,

zbtvol TYPE zmsd_lop_out-zbtvol,

zbrgew TYPE zmsd_lop_out-zbrgew,

z_no_of_cntr TYPE zmsd_lop_out-z_no_of_cntr,

zfnum1 TYPE zmsd_lop_out-zfnum1,

zvessel TYPE zmsd_lop_out-zvessel,

zatd TYPE zmsd_lop_out-zatd,

zeta TYPE zmsd_lop_out-zeta,

zrate TYPE zmsd_lop_out-zrate,

zrate_cur TYPE zmsd_lop_out-zrate_cur,

zdpport_nm TYPE zmsd_lop_out-zdpport_nm,

zdsport_nm TYPE zmsd_lop_out-zdsport_nm,

zcc_pp TYPE zmsd_lop_out-zfpstatus,

zrate_type TYPE zmsd_lop_out-z_rate_type,

END OF ty_lopout.

*-----------------------------------------------------------------------

* INTERNAL TABLES

*-----------------------------------------------------------------------

DATA: t_lopout TYPE TABLE OF ty_lopout,

w_lopout TYPE ty_lopout,

t_head TYPE STANDARD TABLE OF slis_fieldcat_alv,

w_head TYPE slis_fieldcat_alv.

*-----------------------------------------------------------------------

* VARIABLES DECLARATION

*-----------------------------------------------------------------------

DATA: v_file TYPE rlgrap-filename.

*-----------------------------------------------------------------------

* SELECT-OPTIONS AND PARAMETERS

*-----------------------------------------------------------------------

SELECTION-SCREEN BEGIN OF BLOCK a WITH FRAME TITLE text-001.

SELECT-OPTIONS : s_zvkorg FOR zmsd_lop_out-zvkorg NO INTERVALS,

s_zfcode FOR zmsd_lop_out-zfcode NO INTERVALS,

s_crdate FOR zmsd_lop_out-creation_date.

SELECTION-SCREEN SKIP.

PARAMETERS : p_zsts TYPE zzsts DEFAULT 'T' OBLIGATORY.

SELECTION-SCREEN END OF BLOCK a.

SELECTION-SCREEN BEGIN OF BLOCK b WITH FRAME TITLE text-002.

PARAMETERS : p_file TYPE rlgrap-filename.

SELECTION-SCREEN SKIP.

PARAMETERS : p_mail AS CHECKBOX.

SELECTION-SCREEN END OF BLOCK b.

*-----------------------------------------------------------------------

* INITIALIZATION

*-----------------------------------------------------------------------

* AT SELECTION-SCREEN

*-----------------------------------------------------------------------

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

field_name = ' '

IMPORTING

file_name = p_file.

*-----------------------------------------------------------------------

* START OF SELECTION

*-----------------------------------------------------------------------

START-OF-SELECTION.

PERFORM get_data.

PERFORM fetch_header.

PERFORM downld_excel.

*&---------------------------------------------------------------------*

*& Form get_data

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM get_data.

SELECT *

FROM zmsd_lop_out

INTO CORRESPONDING FIELDS OF TABLE t_lopout

WHERE zvkorg IN s_zvkorg

AND zfcode IN s_zfcode

AND creation_date IN s_crdate

AND zsts = p_zsts

AND zchrcode <> space.

ENDFORM. " get_data

*&---------------------------------------------------------------------*

*& Form downld_excel

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM downld_excel.

DATA: lv_chrcode TYPE z_chcd.

LOOP AT t_lopout INTO w_lopout.

lv_chrcode = w_lopout-zchrcode.

lv_chrcode = lv_chrcode+0(1).

IF lv_chrcode <> '2'.

DELETE t_lopout.

ENDIF.

ENDLOOP.

IF sy-subrc = 0.

v_file = p_file.

ENDIF.

* break-point.

* CALL FUNCTION 'GUI_DOWNLOAD'

* EXPORTING

** BIN_FILESIZE =

* filename = v_file

* filetype = 'ASC'

** APPEND = ' '

* write_field_separator = 'X'

* TABLES

* data_tab = t_head

* .

* CALL FUNCTION 'GUI_DOWNLOAD'

* EXPORTING

* filename = v_file

* filetype = 'ASC'

** APPEND = ' '

* write_field_separator = 'X'

* TABLES

* data_tab = t_lopout

* .

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

filename = v_file

filetype = 'DAT'

TABLES

data_tab = t_lopout

fieldnames = t_head.

ENDFORM.

" downld_excel

*&---------------------------------------------------------------------*

*& Form fetch_header

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM fetch_header.

* w_head-col_pos = '1'.

w_head-fieldname = 'Company Code'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '2'.

w_head-fieldname = 'Forwarder Code'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '3'.

w_head-fieldname = 'Invoice Number'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '4'.

w_head-fieldname = 'Invoice Date'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '5'.

w_head-fieldname = 'Charge Code'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '6'.

w_head-fieldname = 'Ref Doc No'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '7'.

w_head-fieldname = 'Container Type'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '8'.

w_head-fieldname = 'MAWB'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '9'.

w_head-fieldname = 'Transport'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '10'.

w_head-fieldname = 'Departure Port'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '11'.

w_head-fieldname = 'Destination City'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '12'.

w_head-fieldname = 'Charges Incuured'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '13'.

w_head-fieldname = 'Pricing Unit'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '14'.

w_head-fieldname = 'Currency Code'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '15'.

w_head-fieldname = 'Exchange Rate'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '16'.

w_head-fieldname = 'Amount'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '17'.

w_head-fieldname = 'GST Amount'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '18'.

w_head-fieldname = 'Total Invoice Amount'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '19'.

w_head-fieldname = 'Carrier Code'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '20'.

w_head-fieldname = 'CCP Number'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '21'.

w_head-fieldname = 'CIF Value'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '22'.

w_head-fieldname = 'Tax Invoice Number'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '23'.

w_head-fieldname = 'Tax Invoice Date'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '24'.

w_head-fieldname = 'Remarks 1'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '25'.

w_head-fieldname = 'Volume(M3)'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '26'.

w_head-fieldname = 'Weight'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '27'.

w_head-fieldname = 'No. of Container'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '28'.

w_head-fieldname = 'Flight Number'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '29'.

w_head-fieldname = 'Vessel'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '30'.

w_head-fieldname = 'ATD'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '31'.

w_head-fieldname = 'ETA'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '32'.

w_head-fieldname = 'Rate'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '33'.

w_head-fieldname = 'Rate Currency'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '34'.

w_head-fieldname = 'Departure Port Name'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '35'.

w_head-fieldname = 'Destination Port Name'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '36'.

w_head-fieldname = 'Freight Paid Status'.

APPEND w_head TO t_head.

CLEAR w_head.

* w_head-col_pos = '37'.

w_head-fieldname = 'Rate Type'.

APPEND w_head TO t_head.

CLEAR w_head.

ENDFORM.

" fetch_header

pls help asap

Re: download error

Former Member — Tue, 12 Feb 2013 06:42:46 GMT

hi kumar ,

gui download is throwing dump when i use filetypw dat. and it is not fetching the header as there are some functionality like fieldnames is not available in this server

Re: download error

Former Member — Tue, 12 Feb 2013 06:45:01 GMT

Hi Kumar when i use gui download with file type 'asc' data are populating right but header is not coming.

Re: download error

Former Member — Tue, 12 Feb 2013 07:05:28 GMT

i dont have the functionality of fieldnames in gui_download is there any way to populate header?

Re: download error

kakshat — Tue, 12 Feb 2013 07:14:31 GMT

I don't think you are using the correct table type to pass data to fieldnames parameter for GUI_DOWNLOAD. Check this link and try the approach described - https://scn.sap.com/message/6743229

Re: download error

Former Member — Tue, 12 Feb 2013 07:17:22 GMT

Hi kumar i am using 4.6c there is no functionality of fieldnames in gui download fm

Re: download error

kakshat — Tue, 12 Feb 2013 07:23:17 GMT

Then, why don't you simply add the column names to your internal table?

By the way, the link I shared a while ago talks about the 4.6C scenario also. They say something about calling the function twice. Please check.

Message was edited by: Kumar Akshat

Re: download error

Former Member — Tue, 12 Feb 2013 07:34:00 GMT

how to perform that

Re: download error

Former Member — Tue, 12 Feb 2013 07:36:06 GMT

hi kumar

REPORT zmbcrp0081 NO STANDARD PAGE HEADING LINE-SIZE 900 LINE-COUNT 90.

************************************************************************

* Program Title : Download data in Excel and Send mail

* Program Description : Download data from ZMSD_LOP_OUT table into Excel

* format and Send an mail with attachment if Send

* mail checkbox is selected.

* SAP R/3 Module : SD

* SAP R/3 Release : 4.6c

* Development Log

* ---------------

* Name Date Description

*--------------- ---------- --------------------------------------------

*-----------------------------------------------------------------------

*TYPE-POOLS DECLARATION

*-----------------------------------------------------------------------

TYPE-POOLS:slis.

*-----------------------------------------------------------------------

*TABLES DECLARATION

*-----------------------------------------------------------------------

TABLES: zmsd_lop_out.

*-----------------------------------------------------------------------

* TYPES DECLARATIONS

*-----------------------------------------------------------------------

TYPES: BEGIN OF ty_lopout,

zvkorg TYPE zmsd_lop_out-zvkorg,

zfcode TYPE zmsd_lop_out-zfcode,

zinvno TYPE zmsd_lop_out-zinvno,

zfdate TYPE zmsd_lop_out-zfdate,

zchrcode TYPE zmsd_lop_out-zchrcode,

zhawb TYPE zmsd_lop_out-zhawb,

z_cntr_type TYPE zmsd_lop_out-z_cntr_type,

zmawb TYPE zmsd_lop_out-zmawb,

zshipmod TYPE zmsd_lop_out-zshipmod,

zdpport TYPE zmsd_lop_out-zdpport,

zdsport TYPE zmsd_lop_out-zdsport,

zqty TYPE zmsd_lop_out-zqty,

zpr_uom TYPE zmsd_lop_out-zpr_uom,

zf_cur TYPE zmsd_lop_out-zf_cur,

zexrate TYPE zmsd_lop_out-zexrate,

zamount TYPE zmsd_lop_out-zamount,

zgst_amt TYPE zmsd_lop_out-zgst_amt,

ztot_amt TYPE zmsd_lop_out-ztot_amt,

zccode TYPE zmsd_lop_out-zccode,

zccp_no TYPE zmsd_lop_out-zccp_no,

z_cif_val TYPE zmsd_lop_out-z_cif_val,

z_tax_inv TYPE zmsd_lop_out-z_tax_inv,

z_tax_inv_dt TYPE zmsd_lop_out-z_tax_inv_dt,

z_rem_1 TYPE zmsd_lop_out-z_rem_1,

zbtvol TYPE zmsd_lop_out-zbtvol,

zbrgew TYPE zmsd_lop_out-zbrgew,

z_no_of_cntr TYPE zmsd_lop_out-z_no_of_cntr,

zfnum1 TYPE zmsd_lop_out-zfnum1,

zvessel TYPE zmsd_lop_out-zvessel,

zatd TYPE zmsd_lop_out-zatd,

zeta TYPE zmsd_lop_out-zeta,

zrate TYPE zmsd_lop_out-zrate,

zrate_cur TYPE zmsd_lop_out-zrate_cur,

zdpport_nm TYPE zmsd_lop_out-zdpport_nm,

zdsport_nm TYPE zmsd_lop_out-zdsport_nm,

zcc_pp TYPE zmsd_lop_out-zfpstatus,

zrate_type TYPE zmsd_lop_out-z_rate_type,

END OF ty_lopout.

types:begin of ty_head,

col_name(30) type c,

end of ty_head.

*-----------------------------------------------------------------------

* INTERNAL TABLES

*-----------------------------------------------------------------------

DATA: t_lopout TYPE TABLE OF ty_lopout,

w_lopout TYPE ty_lopout,

* t_head TYPE STANDARD TABLE OF slis_fieldcat_alv,

* w_head TYPE slis_fieldcat_alv.

t_head type table of ty_head,

w_head type ty_head.

*-----------------------------------------------------------------------

* VARIABLES DECLARATION

*-----------------------------------------------------------------------

DATA: v_file TYPE string.

*-----------------------------------------------------------------------

* SELECT-OPTIONS AND PARAMETERS

*-----------------------------------------------------------------------

SELECTION-SCREEN BEGIN OF BLOCK a WITH FRAME TITLE text-001.

SELECT-OPTIONS : s_zvkorg FOR zmsd_lop_out-zvkorg NO INTERVALS,

s_zfcode FOR zmsd_lop_out-zfcode NO INTERVALS,

s_crdate FOR zmsd_lop_out-creation_date.

SELECTION-SCREEN SKIP.

PARAMETERS : p_zsts TYPE zzsts DEFAULT 'T' OBLIGATORY.

SELECTION-SCREEN END OF BLOCK a.

SELECTION-SCREEN BEGIN OF BLOCK b WITH FRAME TITLE text-002.

PARAMETERS : p_file TYPE rlgrap-filename.

SELECTION-SCREEN SKIP.

PARAMETERS : p_mail AS CHECKBOX.

SELECTION-SCREEN END OF BLOCK b.

*-----------------------------------------------------------------------

* INITIALIZATION

*-----------------------------------------------------------------------

* AT SELECTION-SCREEN

*-----------------------------------------------------------------------

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

field_name = ' '

IMPORTING

file_name = p_file.

*-----------------------------------------------------------------------

* START OF SELECTION

*-----------------------------------------------------------------------

START-OF-SELECTION.

PERFORM get_data.

PERFORM fetch_header.

PERFORM downld_excel.

*&---------------------------------------------------------------------*

*& Form get_data

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM get_data.

SELECT *

FROM zmsd_lop_out

INTO CORRESPONDING FIELDS OF TABLE t_lopout

WHERE zvkorg IN s_zvkorg

AND zfcode IN s_zfcode

AND creation_date IN s_crdate

AND zsts = p_zsts

AND zchrcode <> space.

ENDFORM. " get_data

*&---------------------------------------------------------------------*

*& Form downld_excel

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM downld_excel.

DATA: lv_chrcode TYPE z_chcd.

LOOP AT t_lopout INTO w_lopout.

lv_chrcode = w_lopout-zchrcode.

lv_chrcode = lv_chrcode+0(1).

IF lv_chrcode <> '2'.

DELETE t_lopout.

ENDIF.

ENDLOOP.

IF sy-subrc = 0.

v_file = p_file.

ENDIF.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

* BIN_FILESIZE =

filename = v_file

filetype = 'ASC'

* append = 'X'

write_field_separator = 'X'

TABLES

data_tab = t_head

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = v_file

filetype = 'ASC'

APPEND = 'X'

write_field_separator = 'X'

TABLES

data_tab = t_lopout

ENDFORM.

"downld_excel

*&---------------------------------------------------------------------*

*& Form fetch_header

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM fetch_header.

* w_head-col_pos = '1'.

* w_head-fieldname = 'Company Code'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '2'.

* w_head-fieldname = 'Forwarder Code'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '3'.

* w_head-fieldname = 'Invoice Number'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '4'.

* w_head-fieldname = 'Invoice Date'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '5'.

* w_head-fieldname = 'Charge Code'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '6'.

* w_head-fieldname = 'Ref Doc No'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '7'.

* w_head-fieldname = 'Container Type'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '8'.

* w_head-fieldname = 'MAWB'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '9'.

* w_head-fieldname = 'Transport'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '10'.

* w_head-fieldname = 'Departure Port'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '11'.

* w_head-fieldname = 'Destination City'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '12'.

* w_head-fieldname = 'Charges Incuured'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '13'.

* w_head-fieldname = 'Pricing Unit'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '14'.

* w_head-fieldname = 'Currency Code'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '15'.

* w_head-fieldname = 'Exchange Rate'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '16'.

* w_head-fieldname = 'Amount'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '17'.

* w_head-fieldname = 'GST Amount'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '18'.

* w_head-fieldname = 'Total Invoice Amount'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '19'.

* w_head-fieldname = 'Carrier Code'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '20'.

* w_head-fieldname = 'CCP Number'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '21'.

* w_head-fieldname = 'CIF Value'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '22'.

* w_head-fieldname = 'Tax Invoice Number'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '23'.

* w_head-fieldname = 'Tax Invoice Date'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '24'.

* w_head-fieldname = 'Remarks 1'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '25'.

* w_head-fieldname = 'Volume(M3)'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '26'.

* w_head-fieldname = 'Weight'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '27'.

* w_head-fieldname = 'No. of Container'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '28'.

* w_head-fieldname = 'Flight Number'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '29'.

* w_head-fieldname = 'Vessel'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '30'.

* w_head-fieldname = 'ATD'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '31'.

* w_head-fieldname = 'ETA'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '32'.

* w_head-fieldname = 'Rate'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '33'.

* w_head-fieldname = 'Rate Currency'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '34'.

* w_head-fieldname = 'Departure Port Name'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '35'.

* w_head-fieldname = 'Destination Port Name'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '36'.

* w_head-fieldname = 'Freight Paid Status'.

* APPEND w_head TO t_head.

* CLEAR w_head.

* w_head-col_pos = '37'.

* w_head-fieldname = 'Rate Type'.

* APPEND w_head TO t_head.

* CLEAR w_head.

ENDFORM.

" fetch_header

this is d code. can u tell in brief .