topic SAP query output modification in Application Development and Automation Discussions

SAP query output modification

Hari_prasad — Thu, 16 Sep 2010 04:31:14 GMT

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

Re: SAP query output modification

Former Member — Tue, 21 Sep 2010 09:06:32 GMT

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 .

Re: SAP query output modification

Hari_prasad — Wed, 06 Oct 2010 13:29:56 GMT

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.