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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

query output from horizontal to vertical

andreagiugio
Explorer

‎02-18-2020 1:54 PM

0 Kudos

Hello,

I have a custom table with following columns for each entry:

  1. text1
  2. text2
  3. text3
  4. text4
  5. text5

I need to have in output following in my query

record. n 1

  • text1
  • text4
  • text5

record. n 2

  • text2
  • text4
  • text5

record. n 3

  • text3
  • text4
  • text5

Do you know how I can achieve it with ABAP in SQ02?

Basically I need to loop the same record in custom table 3 times in order to create 3 records in the ouput of my query

Thanks

3 REPLIES 3

FredericGirod
Active Contributor

‎02-18-2020 1:55 PM

0 Kudos

ABAP or Querry ?

michael_piesche
Active Contributor

‎02-18-2020 3:56 PM

0 Kudos

1. Could you add e.g. screenshots of excel what you table data looks like and what your output is supposed to be.

2. Do you want to create a SQ02 infoset with abap coding?

Sorry, I dont wanna wrap my head around what you want to achieve, only to realize that you might have wanted something. Please help us so we can help you 😉

andreagiugio
Explorer

‎12-07-2020 5:21 PM

0 Kudos

yes, I want to achieve this result with SQ02 infoset.

Is it possible? Do you have any suggestions?