topic Re: subtotal in sap script in Application Development and Automation Discussions

subtotal in sap script

Former Member — Mon, 17 Sep 2007 06:44:09 GMT

Hi,

How do we code for subtotal in sap script. The scenario is i have to total the extended price field (dmbtr) and that is subtotal.

Another doubt: how do i code division operator . ie. dividing quantity by extended price? in sap script i know i have to introduce a variable. kindly give me how do i code.

Re: subtotal in sap script

Former Member — Mon, 17 Sep 2007 06:59:32 GMT

Hi,

Actually you cannot code division operator directly in the SAP Script form.SAP Script consists of two things i) SAP Script form(use SE71 to explore it) and ii) Driver program.

Script form(or) Layout set:

It specifies the layout of the output(where to put what).

Driver program:

It will have all the logic(for example selecting records from required tables for displaying the layout set and processing logic, for eg: Multiplication, division etc).

so, in your case you need to calculate the sub total in the driver program using a global variable and use the same variable name in the Layout set at the required position for printing the subtotal in output.

For eg: For your case consider w_qty(quantity variable), w_ext_prc(extended price) and if w_sub_tot is the subtotal field.

you can code the following logic in the driver program.

w_sub_tot = w_ext_prc / w_qty.

In the Layout set, you can use the &w_qty& to print the subtotal value in the output.

Hope this helps.....

Re: subtotal in sap script

Former Member — Mon, 17 Sep 2007 07:00:12 GMT

hi,

u can use SUM keyword in script.

/: If &itab-pernr&.

/: sum.

and to declare a variable use && as

for ex: &&suresh = 13.

/: write &&suresh.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: subtotal in sap script

Former Member — Mon, 17 Sep 2007 07:10:10 GMT

Hi,

Check the following link:

http://sap-img.com/sapscripts/sapscript-how-to-calculate-totals-and-subtotals.htm

Regards,

Bhaskar