Community
Application Development and Automation 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: 
Read only

SAP query output modification

Hari_prasad
Participant

‎2010 Sep 16 5:31 AM

0 Likes
808

Dear all,

Currently in one sap query having tables EKBE and other tables, output is comming. But now I need to add some more data from the table EKBZ to the same columns of the output which are from EKBE. If i use join then i need to use separate column for EKBZ, but i want EKBZ data ( additional records) to the same columns of EKBE in the output in addition to to the records of EKBE . Please help me how to do this.

Thanks,

Prasad

2 REPLIES 2
Read only

Former Member

‎2010 Sep 21 10:06 AM

0 Likes
480

U can insert ur desired fields By Go to INFOSET / FUNCTIONAL AREA in that u can add fields by click on JOIN , INSERT u can add ur next tables, after that u can go Query(SQ01) in that u can select ur desired fields .

Read only

Hari_prasad
Participant
In response to Former Member

‎2010 Oct 06 2:29 PM

0 Likes
480

thanks for your reply dear. Actually its not my requirement.

But I found the answer my self. I have created the separate internal table and selected the data directly from the database table ( like normal report) and inserted my records at the event 'At end of selection after processing' into the auto generated internal table using field symbols.