Re: [sap-dev] SAP query: display only subtotals
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by naresheedara on Feb 12 at 10:08 PM |  Mark as helpful |
i Know Something About this .
If u want totals by default what ever it may be it's classical reports or
interactive report.
we can use.
in side the loop and loop.
Example.
amont field is: vbeln,ntgew
write this procedure like.
at new vbeln.
sum.
write:/5 'total',wa_out-ntgew.
endat.
at end of vbeln.
sum.
write:/2 'sub total', wa_out-ntgew.
endat.
On Fri, Feb 12, 2010 at 2:23 PM, infnik via sap-dev <
sap-dev@groups.ittoolbox.com> wrote:
>
> Posted by infnik (Business
> Analyst)
> on Feb 12 at 5:24 PM
>
> Indeed report could be easier but it costs money (indeed to external
> company) so if I can manage the same with the query that would be great.
> Stephen, you might be right with your advise - will check on Monday. Thank
> you and have a nice weekend!
>
> ---------------Original Message---------------
> From: infnik
> Sent: Friday, February 12, 2010 8:10 AM
> Subject: SAP query: display only subtotals
>
> > Hi<br/>I need to display only subtotals in SAP query. Cannot find the way
> to do this.<br/>SAP documentation (
> http://help.sap.com/saphelp_46c/helpdata/EN/d2/cb408a455611d189710000e8322d00/frameset.htm) says:<br/>'If you are summing
> fields in a basic list, the overall total is always output. Sub-totals are
> also output for the different sort levels, if defined. You can suppress the
> individual values used to generate the totals with the Display totals only
> function. To return to the original list, select Back.'. <br/>But I cannot
> find this 'Display totals only' function anywhere in SQ01. Please
> help.<br/>Thanks&Regards<br/>Nikolay
__.____._ If u want totals by default what ever it may be it's classical reports or
interactive report.
we can use.
in side the loop and loop.
Example.
amont field is: vbeln,ntgew
write this procedure like.
at new vbeln.
sum.
write:/5 'total',wa_out-ntgew.
endat.
at end of vbeln.
sum.
write:/2 'sub total', wa_out-ntgew.
endat.
On Fri, Feb 12, 2010 at 2:23 PM, infnik via sap-dev <
sap-dev@groups.ittoolbox.com> wrote:
>
> Posted by infnik (Business
> Analyst)
> on Feb 12 at 5:24 PM
>
> Indeed report could be easier but it costs money (indeed to external
> company) so if I can manage the same with the query that would be great.
> Stephen, you might be right with your advise - will check on Monday. Thank
> you and have a nice weekend!
>
> ---------------Original Message---------------
> From: infnik
> Sent: Friday, February 12, 2010 8:10 AM
> Subject: SAP query: display only subtotals
>
> > Hi<br/>I need to display only subtotals in SAP query. Cannot find the way
> to do this.<br/>SAP documentation (
> http://help.sap.com/saphelp_46c/helpdata/EN/d2/cb408a455611d189710000e8322d00/frameset.htm) says:<br/>'If you are summing
> fields in a basic list, the overall total is always output. Sub-totals are
> also output for the different sort levels, if defined. You can suppress the
> individual values used to generate the totals with the Display totals only
> function. To return to the original list, select Back.'. <br/>But I cannot
> find this 'Display totals only' function anywhere in SQ01. Please
> help.<br/>Thanks&Regards<br/>Nikolay
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
