hi
when i use header Fm going to dump.If i comment I_LINE_HEADER its working fine. pls help me
DATA : BEGIN OF t_header OCCURS 0,
name(40) TYPE c,
END OF t_header.
CLEAR t_header.
t_header-name = 'Client'.
APPEND t_header.
t_header-name = 'Plant Code'.
APPEND t_header.
t_header-name = 'Product Code'.
APPEND t_header.
t_header-name = 'Product Description'.
APPEND t_header.
t_header-name = 'Base UM'.
APPEND t_header.
t_header-name = 'Inner Pack'.
APPEND t_header.
t_header-name = 'Outer Pack'.
APPEND t_header.
t_header-name = 'Ship Pack'.
APPEND t_header.
t_header-name = 'Lst Upd Dt'.
APPEND t_header.
t_header-name = 'Lst Upd By'.
APPEND t_header.
t_header-name = 'Ext date'.
APPEND t_header.
t_header-name = 'Ext Time'.
APPEND t_header.
t_header-name = 'Ext By'.
APPEND t_header.
t_header-name = 'File Name'.
APPEND t_header.
loop at it_material.
CONCATENATE '''' it_material-matnr into it_material-matnr.
modify it_material.
*clear it_material.
endloop.
CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
EXPORTING
I_FIELD_SEPERATOR = 'X'
* I_LINE_HEADER = t_header
i_filename = p_pcfile
* I_APPL_KEEP = ' '
tables
i_tab_sap_data = it_material
* CHANGING
* I_TAB_CONVERTED_DATA =
EXCEPTIONS
CONVERSION_FAILED = 1
OTHERS = 2
.
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.