Skip to Content

How to download data from an intrenal table into CSV file from CRM WEB UI

Hi Experts,

I have a requirement where i need to download data from an internal table into CSV file from CRM WEB UI.

Can somebody please tell me how i can download the internal table data into CSV file from CRM WEB UI.

I will really appreciate any help on this.

Thanks & Regards,

Kapil Kumar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2012 at 11:31 AM

    Hi Kapil,

    Can't you fill your data to context node in list view and use stadard Excel download function.

    If you want to download only via button on formview, then create a dumy value node inherited from CL_WCF_BSP_BASE_SR_CN00_2.

    Redefine GET_TABLE_COMPONENTS method and return your table structure inform BSP_DLC_COLUMN_DESCR_TAB.

    Then redefine GET_DATA_XML and convert your internal table to XML use cl_chtmlb_xml_provider=>get_xml_from_model for this.

    Now put code for your button to call standard excel service, like

    ls_button-on_client_click = cl_chtmlb_config_tab_excel_exp=>create_button_script(

    iv_table_binding_string = '//RESULT/Table' "Result is context node name

    iv_page_context = page_context

    iv_id = controller->COMPONENT_ID ).

    cl_chtmlb_config_tab_excel_exp=>get_download_button(

    importing

    ev_src = ls_button-icon_src

    ev_tooltip = ls_button-tooltip ).

    append ls_button to lt_button.

    I hope you got the idea. let me know if you need any help.

    PS: reward point if helpful. thanks.

    BR,

    Tauqir

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Tauqir,

      I appreciate you help.

      Actually i am new to web ui ,can you please explain the above steps in little detail.

      i could not get much out of above steps.

      Actually my requirement is : When i am in quotation overview page

      I should be able to download some specific data of the quotation like ( quotation no., customer no.,

      name, sales engineer no., name) in excel by click of a button.

      I am able to bring all the required data in an internal table inside the badi implementation EXEC_METHODCALL_PPF and i have linked that badi via action profile to the quotation.

      but i am not getting how can i download the data persent in the internal table in CSV file. I tried using

      GUI_DOWNLOAD but it works only for GUI not for WEB UI.

      Please help me in this.

      Thanks & Regards,

      Kapil Kumar

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.