topic Re: Which FM? in Application Development and Automation Discussions

Which FM?

Former Member — Fri, 15 Jun 2007 08:36:24 GMT

What is the Fn mod 2 upload data in to internal table from an EXCEL file?

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:38:51 GMT

please see these function modules

RH_START_EXCEL_WITH_DATA

GUI_DOWNLOAD

EXCEL_OLE_STANDARD_DAT

Thanks,

Max

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:38:51 GMT

Hi,

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

convert the data in file in excel format to internal table

Reward points

Regards

Re: Which FM?

seshatalpasai_madala — Fri, 15 Jun 2007 08:39:22 GMT

HI,

check

HR_PK_EXCEL_TO_INTERNAL_TABLE.

ALSM_EXCEL_TO_INTERNAL_TABLE

Regards,

Sesh

Message was edited by:

Seshatalpasai Madala

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:40:51 GMT

Hi,

You may use FM GUI_UPLOAD / WS_UPLOAD.

I hope this helps,

Regards

Raju Chitale

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:42:13 GMT

hi John,

Here is a sample code for the same

REPORT  zupload_excel_to_itab.

TYPE-POOLS: truxs.

PARAMETERS: p_file TYPE  rlgrap-filename.

TYPES: BEGIN OF t_datatab,
      col1(30)    TYPE c,
      col2(30)    TYPE c,
      col3(30)    TYPE c,
      END OF t_datatab.
DATA: it_datatab type standard table of t_datatab,
      wa_datatab type t_datatab.

DATA: it_raw TYPE truxs_t_text_data.

* At selection screen
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
  CALL FUNCTION 'F4_FILENAME'
    EXPORTING
      field_name = 'P_FILE'
    IMPORTING
      file_name  = p_file.


***********************************************************************
*START-OF-SELECTION.
START-OF-SELECTION.

  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*     I_FIELD_SEPERATOR        =
      i_line_header            =  'X'
      i_tab_raw_data           =  it_raw       " WORK TABLE
      i_filename               =  p_file
    TABLES
      i_tab_converted_data     = it_datatab[]    "ACTUAL 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.


***********************************************************************
* END-OF-SELECTION.
END-OF-SELECTION.
  LOOP AT it_datatab INTO wa_datatab.
    WRITE:/ wa_datatab-col1,
            wa_datatab-col2,
            wa_datatab-col3.
  ENDLOOP.

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:42:35 GMT

Try this...

ALSM_EXCEL_INTERNAL_TO_TABLE

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:43:18 GMT

Hi,

sorry for previous reply

it the function module "GUI_DOWNLOAD" downloads the data from

an internal table into a file (can be xl, dat ,doc etc) .

Plz follow the usage below ;

Parameters : pa_pfile LIKE rlgrap-filename OBLIGATORY.

Data : lv_filename TYPE STRING.

lv_filename = pa_pfile.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

FILENAME = lv_filename

FILETYPE = 'ASC'

APPEND = ' '

WRITE_FIELD_SEPARATOR = 'X'

HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
IMPORTING
FILELENGTH =

TABLES

DATA_TAB = tb_download " table data to b downlaoded

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.

Reward points

Regards

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:52:15 GMT

You can use ALSM_EXCEL_TO_INTERNAL_TABLE for uploading data from excel to your internal table. You can use GUI_UPLOAD to upload but in your case, you should use ALSM_EXCEL_TO_INTERNAL_TABLE.

Regards,

Sangeeta.

Re: Which FM?

Former Member — Fri, 15 Jun 2007 08:54:50 GMT

Hi John,

please use this function module ALSM_EXCEL_TO_INTERNAL_TABLE

rewards points

regards

Reena

Re: Which FM?

Former Member — Thu, 02 Aug 2007 10:25:58 GMT

ALSM_EXCEL_TO_INTERNAL_TABLE