topic Re: ABAP Query : code to change the display in Application Development and Automation Discussions

ABAP Query : code to change the display

Former Member — Tue, 13 Mar 2007 17:56:24 GMT

Hi all,

I have created an Abap Query and generated it. I see the output now as follows:

Bill.doc Item Net value Total amt

900000 10 100 600

900000 20 200 600

900000 30 300 600

900001 10 250 250

900002 10 300 500

900002 20 200 500

Now I want the total amt to be displayed only once for each billing document only for the first item and for the other line items it should be blank as shown below.

Bill.doc Item Net value Total amt

900000 10 100 600

900000 20 200

900000 30 300

900001 10 250 250

900002 10 300 500

900002 20 200

Can someone please explain me where and how I should write the code to get this working?

Thanks,

Helpful answers will be awarded for sure.

Re: ABAP Query : code to change the display

Manohar2u — Tue, 13 Mar 2007 18:15:30 GMT

How you are getting total amount??

Try this way..

Loop at itab.

at new bill doc.

sum. and modify your itab record with the total.

endat.

endloop.

Hope this is what you are looking for...

Cheers

Manohar

Re: ABAP Query : code to change the display

Former Member — Tue, 13 Mar 2007 18:24:49 GMT

Hi Manohar,

I am getting the total amount from a field which exists in one of the tables which i used in the abap query.

the total amount is appearing correctly...i dont need to modify that. i just need to display it only once for each billing doc for the first item.

i want to know where i should do the coding...i mean in the Infoset or the Abap Program that gets created when i generate the infoset.

Thanks!

Message was edited by:

Narmada Mallavaram

null

Re: ABAP Query : code to change the display

Former Member — Wed, 14 Mar 2007 15:08:13 GMT

Can anyone help?

I can post the query code if it helps.

thanks,