Skip to Content
author's profile photo Shristy Priyadarshi
0
Shristy Priyadarshi

In ALV grid report ,the excel sheet does not display any data.

Posted on Jul 28, 2020 at 09:57 AM 169 Views

In ALV grid report , when we click on Microsoft Excel button(CTRL+SHIFT+F7) , the excel sheet does not display any data.

I have already enabled all macro setting, still not getting any data in excel.
Any help would be appreciated.

Thanks in advance !!

1.png (15.6 kB)
2.png (61.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo S Abinath
    S Abinath
    Posted on Jul 28, 2020 at 11:14 AM
    0

    Hi,

    Check the Fieldcatalog code, refer all field element are mentioned in CAPS.

    Add a comment
    10|10000 characters needed characters exceeded

    • Shristy Priyadarshi
      Jul 28, 2020 at 12:02 PM

      Do we write any thing else for excel functionality, its an standard functionality right?

      Its is my code for field-catalog

      fieldcatalog-fieldname = 'ZSP_ID'.
      fieldcatalog-seltext_m = 'Id'.
      fieldcatalog-col_pos = 0.
      APPEND fieldcatalog TO fieldcatalog.
      CLEAR fieldcatalog.

      Please guide me.

      Thanks

  • author's profile photo Jigang Zhang 张吉刚
    Jigang Zhang 张吉刚
    Posted on Jul 29, 2020 at 02:52 AM
    0
    1. if it's standard Icon button, then no need to do anything. Maybe try to re-login if some ALV setting/field changes. Sometimes it's not refresh everything immediately for me.
    2. If it's a customized button, then check the table populate logic at customized code.
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Jigang Zhang 张吉刚
    Jigang Zhang 张吉刚
    Posted on Jul 29, 2020 at 06:17 AM
    0

    @Shristy,

    As this icon already there and excel can be triggered, I think all ALV setting is fine for this button.

    I'll check the internal table contents and debug the Click Event.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Shristy Priyadarshi
    Shristy Priyadarshi
    Posted on Jul 30, 2020 at 06:01 AM
    0

    Thanks to all for your help.
    I have raised issue to SAP.
    Hope it helps me to get the issue fixed.

    Add a comment
    10|10000 characters needed characters exceeded