Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Please Help its an urgent

Former Member
0 Kudos

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

13 REPLIES 13

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

christian_wohlfahrt
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

dear Erik;

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

regards,

Siddarth

0 Kudos

as per my understanding, CALL TRANSACTION will allow you to do in a BDC all that you can do if you execute the transaction the standard way...so if u can achieve thru some button on the application toolbar or some menu option then it is possible...otherwise does not seem to be likely...

rgds,

PJ

0 Kudos

Hi Siddarth,

the critical question is not SM35 / call transaction in an own program (transaction or report) - the critical question is foreground or background processing.

PJ: "CALL TRANSACTION will allow you to do in a BDC all that you can do if you execute the transaction the standard way..." - if you don't use the mouse. Small, but crucial restriction. It's not scripting, there is no complete user simulation.

Regards,

Christian

0 Kudos

Dear Christian Wolhfahrt,

Generally BDC run in background processing so I also need the <b>Background Processing</b>. Moreover if i wanna check error than only I need the foreground processing. so right now I need the concept or way for background processing only. The note you added in the 'PJ: 'I am quite aware of this.

regards,

Siddarth

0 Kudos

Hi siddarth,

U want to open excel with out interaction of the user in the windows?

if it is right then there is a function module

rgds.

p.kp

0 Kudos

Hi Krishna,

I wanna use the same function module in the BDC so tell me how to use in the BDC because BDC first of all performs all the forms of its own then go for function module.

so if I can use the same in BDC recording the tell me .

Regards

Siddarth

0 Kudos

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

Former Member
0 Kudos

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.

0 Kudos

Swamy,

I don't wanna read the data from ALV just wanna convert the output of ALV in the EXCEL Sheet

Regards,

Siddarth