Skip to Content
author's profile photo Former Member
Former Member

ALV OOPs

I am using ALV OOPs. How to write code to upload data from Excel sheet. can anybody suggest.

Regards,

Naseer.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 03, 2007 at 07:36 AM

    Hi,

    Use FM ALSM_EXCEL_TO_INTERNAL_TABLE

    Regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 07:40 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 07:43 AM

    Naseer,

    Even if you use OOPS or normal ABAP, to upload the data from excel you can use FM ALSM_EXCEL_TO_INTERNAL_TABLE.

    Regards,

    Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 07:43 AM

    hi naseer..

    chk tis code..

    data: begin of itab_string occurs 0,

    record type char255,

    end of itab_string.

    data: L_FILETABLE TYPE FILETABLE,

    L_FILETAB_H TYPE FILETABLE WITH HEADER LINE.

    data: p_file1 type string.

    • selection screen .

    PARAMETERS: P_FILE TYPE LOCALFILE.

    initialization.

    at selection-screen on value-request for P_FILE.

    • IF THE USER SELECT EXTENTION BUTTON IT WILL OPEN THE LOCAL DIRECTORY FOR SELECTING THE FILE LOCATION.

    CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG

    • EXPORTING

    • WINDOW_TITLE =

    • DEFAULT_EXTENSION = 'CSV'

    • DEFAULT_FILENAME = 'C:\Documents and Settings\196093\Desktop\STATUS.csv'

    • FILE_FILTER =

    • INITIAL_DIRECTORY = 'C:\Documents and Settings\196093\Desktop\'

    • MULTISELECTION =

    • WITH_ENCODING =

    CHANGING

    FILE_TABLE = L_FILETABLE

    RC = RC

    • USER_ACTION =

    • FILE_ENCODING =

    EXCEPTIONS

    FILE_OPEN_DIALOG_FAILED = 1

    CNTL_ERROR = 2

    ERROR_NO_GUI = 3

    NOT_SUPPORTED_BY_GUI = 4

    others = 5

    .

    IF SY-SUBRC <> 0.

    ELSE.

    LOOP AT l_filetable INTO L_FILETAB_H.

    P_FILE = L_FILETAB_H-FILENAME.

    move p_file to p_file1.

    EXIT.

    ENDLOOP.

    ENDIF.

    • passing the selected file name to gui_upload for loading the data

    • into internal table

    CALL FUNCTION 'GUI_UPLOAD'

    EXPORTING

    FILENAME = p_file1

    • FILETYPE = 'ASC'

    • HAS_FIELD_SEPARATOR = ' '

    • HEADER_LENGTH = 0

    • READ_BY_LINE = 'X'

    • DAT_MODE = ' '

    • CODEPAGE = ' '

    • IGNORE_CERR = ABAP_TRUE

    • REPLACEMENT = '#'

    • CHECK_BOM = ' '

    • NO_AUTH_CHECK = ' '

    • IMPORTING

    • FILELENGTH =

    • HEADER =

    TABLES

    DATA_TAB = itab_string

    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 I000(Z00) WITH 'PLEASE PROVIDE CORRECT FILE NAME'.

    ENDIF.

    loop at itab_string.

    • now split the statuses

    split itab_string at ',' into itab_status-aufnr itab_status-asttx itab_status-asttx1.

    • and move one internal table

    append itab_status.

    clear itab_status.

    endloop.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.