topic Re: How to create a link in Application Development and Automation Discussions

How to create a link

Former Member — Tue, 29 Jul 2008 07:10:23 GMT

Hi All,

I need your help,. my requirement is as follows,.. please advise me on this..

in the help documentation for a Zreport ( se38- > documentation ).. from here i need to link to files uploaded in the SAP system...

my secon question is how do i upload files like .xls .doc files to the SAP system...

Re: How to create a link

bpawanchand — Tue, 29 Jul 2008 07:11:37 GMT

Use

ALSM_EXCEL_TO_INTERNAL_TABLE to upload XLS data

Use GUI_UPLOAD to upload any other kind of extension files

Regards

Pavan

Re: How to create a link

Former Member — Tue, 29 Jul 2008 07:16:03 GMT

hiiii

for uploading data use follwoing code

Upload data from Excel sheet to internal table.
  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = p_pfile
      i_begin_col             = 1
      i_begin_row             = 2
      i_end_col               = 13
      i_end_row               = 8
    TABLES
      intern                  = it_excel
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.
  IF sy-subrc <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.


*Populate data to internal tables and structures

  SORT it_excel BY row col.

  LOOP AT it_excel INTO ls_excel.

    CASE ls_excel-col.
      WHEN 1.
        ls_data-rec_no = ls_excel-value.
        IF ls_data-rec_no NE w_docno.
          WRITE:
            'You Have Entered wrong Document Number'.
        ELSE.
          WRITE:
            'Document Number Same'.
        ENDIF.                           " IF ls_data-rec_no NE w_docno.
      WHEN 2.
        ls_data-doc_type = ls_excel-value.
      WHEN 3.
        ls_data-doc_part = ls_excel-value.
      WHEN 4.
        ls_data-doc_ver = ls_excel-value.
      WHEN 5.
        ls_data-application = ls_excel-value.
      WHEN 6.
        ls_data-data_car = ls_excel-value.
      WHEN 7.
        ls_data-file_path = ls_excel-value.
      WHEN 8.
        ls_data-matnr = ls_excel-value.

    ENDCASE.                             " CASE ls_excel-col.

regards

twinkal

Re: How to create a link

Former Member — Tue, 29 Jul 2008 07:17:34 GMT

Hi,

Use FM ALSM_EXCEL_TO_INTERNAL_TABLE for uploading .xls files.

Use FM GUI_UPLOAD to upload files from presentation server into SAP system.

Thanks,

Phani Diwakar.

Re: How to create a link

Former Member — Tue, 29 Jul 2008 07:29:11 GMT

1) Copy the FM ALSM_EXCEL_TO_INTERNAL_TABLE and edit what you have to.

2) Save your excel data with format "Text (Tab delimited) .txt"

and use function module GUI_UPLOAD with parameter DAT_MODE set

[http://www.sapdev.co.uk/file/file_upexcelalt2.htm]

Regards,

Sravanthi

Re: How to create a link

Former Member — Sat, 02 Aug 2008 05:17:37 GMT

The option to linkk a transaction was available in the editor of the help documentation..