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

Please Help its an urgent

Dear,

I am making BDC for Transcation Code <b>KKS1</b>. In this transcation when we go through the transcation then the output is shown in ALV Grid format and as we know that we can convert an ALV Grid into List output or Excel sheet. which I want finally in EXCEL Sheet Format. During transaction there is no Problem every thing is happening perfectly.

<b>But if I want to record a BDC for the same</b> then then first of all I have to check the box continue after commit. then only I can record the BDC. because only after checking this box i get the output in ALV format. <b>Now till here I have done sucess fully.</b> Now In BDC I want to convert the ALV into EXCEL SHEET OR LIST OUTPUT. Generally we can't do this. we have to do this manually but is there any way to convert the <b>ALV Grid into EXCEL Sheet or List Output during the BDC.</b>

Please help me Out.

I need it urgently.

who ever will solve my problem I will reward him 10 Points.

Siddarth

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2005 at 11:13 AM

    Hi Siddarth Jain,

    How were you planning on using the BDC-data?

    1. Call transaction using bdc.

    2. Submit RSBDCSUB....

    3. Process the Batch-Input Map from SM35

    If your answer is either 2. or 3. I'm pretty sure it can't be done.

    If your answer is 1. you should be able to export it to Excel.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2005 at 11:37 AM

    Hi Siddarth,

    On the screen where you see the ALV Output..do you see any "Print Preview" Button in the application toolbar.

    If you see any such button then you know what is to be done..

    Hope this helps..

    Sri

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2005 at 12:03 PM

    Hi Siddarth!

    Like already Erik began to describe:

    most probably you can't use a BDC in a way you expect this.

    Excel is just installed on your PCs, also SAP needs GUI interaction to make an excel sheet. So your call transaction would have to run online - but normally you create BATCH input sessions to run something in background...

    Without GUI you won't get a correct ALV (also this can create it's containers with link to a GUI), nor excel download.

    If it's a one-time action: maybe you can run a BDC online and placing a mobile phone or some other office tool on the 'Enter'-key.

    You can also try to record a CATT (transaction SCEM) or eCATT - they are newer and can handle more dynpro situations, especially one option of eCATT should be able to make scripting.

    Regards,

    Christian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2005 at 05:25 PM

    Please do not attempt to write a BDC for such transactions. ALV by nature is intended for online interactive purposes. If you are writing a BDC to replace the interactive part of it, then you are defeating the purpose of that transaction. Try to find out if there are other alternatives to get the same result in an internal table. Then you can use OLE concepts to open an excel file with that data.

    Srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 03:50 AM

    dear Erik;

    My answer is 1 I am doing BDC by Call Transcation Method.

    regards,

    Siddarth

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi siddartha,

      what u do is, After call transaction if sy-subrc = 0.

      then populate those values into the internal table. Then after loop, use the fmodule download. then if sy-subrc = 0. then use the function module excel_ole_standard_dat.

      rgds.

      p.kp

  • author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2005 at 05:57 AM

    hi,

    I think the better way is to read the contents of the ALV grid into an internal table and then use the internal table to run the BDC. Hope this will solve ur problrm.

    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.