topic Re: Get Data into excel from internal table. in Application Development and Automation Discussions

Get Data into excel from internal table.

former_member147217 — Fri, 23 Aug 2013 10:41:45 GMT

hi all ,

i hav uploaded the required output . My query is this i have a sugestion table were i have the following cols such as suggestionid,

employee no 1

a in points

a in dirams

a point paid

and so on . Now wen several employes give the same sugestions it should show me all the records in one single row .

as in which suggestion id is selected by how many employees and all employee details should come in one single row.

can any one help me to do this.

Re: Get Data into excel from internal table.

Former Member — Fri, 23 Aug 2013 11:26:16 GMT

Hello Disha,

Your question is ambiguous. Please add more information.

I'm not sure but if you are looking for, "How to download Internal Table Data in Excel from at run time" , then see the screenshots bellow..

Re: Get Data into excel from internal table.

Former Member — Fri, 23 Aug 2013 11:40:27 GMT

Hi Disha, your question I am not able to understand clearly.

By the question text, what I cam suggest you is to use gui_download function module, which will import from program to excel/notepad.

If you need to upload the notepad you have given use FM gui_upload.

Regards,

Niveditha.

Re: Get Data into excel from internal table.

former_member147217 — Fri, 23 Aug 2013 12:55:49 GMT

actual its an excel sheet which is the output .

My query is for example if i hav a table name branch and other table name student.

brach table has branch_id ,branch_name fields .

and student table has student_id ,student_name ,branch_id fields where branch id is a foreign key .

now in my excel i want to show how many students are there in one unique branch in one single row,

the branch id should not be duplicated to an other row.

output

branch_id branch_name student_id student_name student_id student_name student_id student_name

1 abc 1 disha 2 swati 3 nisha

2 pqr 4 sweety 5 neema

3 xyz 6 anil

did u understand the output its dynamic

as how many students are ther in one branch should be displayed in one row.

I want to know how to achive this

Re: Get Data into excel from internal table.

Former Member — Sat, 24 Aug 2013 09:57:03 GMT

Hey Disha,

I think you are worried about how to generate(add) dynamic columns. I'm attaching a small piece of code that will serve your purpose. Download it and upload in your system. Trace and learn it.

.
Another way is to have an ITAB with maximum possible columns. And adjust add them in the field_catlog as per your requirement(logic). Though it looks difficult in the beginning But not much hard once you get the grip of it.

Regards,

N.G.