Get Data into excel from internal table.

[former_member147217]

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.

[Former Member]

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..

[Former Member]

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.

[former_member147217]

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        

[Former Member]

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.