Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Converting the alsmex_tabline format to excel sheet format

Hi All

I am using ALSM_EXCEL_TO_INTERNAL_TABLE to get data from an excel sheet to an internal table.

I am able to get values into the internal table.

please help me with converting the internal table in the format alsmex_tabline to the required format

  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = p_sfile
      i_begin_col             = 1
      i_begin_row             = 1
      i_end_col               = 100
      i_end_row               = 100
    TABLES
      intern                  = i_excel
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.

data in excel sheet is in the format

DATA: BEGIN OF t_gb,
        rebuscode(15),
        pt(1),
        longtxt(30),
        shrttxt(20),
        code(4),
        infotype(4),
        templete(4),
        sapcode(4),
        paydeduct(4),
        amtunit(20),
        pensionable(1),
        rmcpenfund4(1),
        rmcexecfund5(1),
        rugbynoncon1(1),
        rugbycon2(1),
        rmcover4024(1),
        rmcmoneypurch12(1),
        rmcdc30to36(1),
        ni(1),
        tax(1),
        arrestablepayments(1),
        factoredprorata(1),
        pretaxdeductions(1),
        netdedpay(1),
        totalgrosstaxablepay(1),
        truegrossallgrosspay(1),
        annualperiodic(1),
        cashrateformula(1),
        validation(1),
        locationcontractvalidation(1),
        aweavweeklyearnings(1),
        payslipnra(1),
        ytdnra(1),
        ficoignore(1),
END OF t_gb.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question