topic Re: sap scripts in Application Development and Automation Discussions

sap scripts

Former Member — Wed, 21 Jun 2006 11:15:25 GMT

hi.. all,

i am struck with some problem in script, can any one help me.

my problem is i hv two fields total price & total qty, i hve to get the out put. i wrote the code for that. like that i have 4-5 fields or blocks, i need to get the total of all those fields.

1. total price * qty = total amount

2. total price * qty = total amount

3. total price * qty = total amount

4. total price * qty = total amount

sum = xxxxxxxxxxxx

the sum shld change dynamically as per no. of records, i mean, if i hve two records i shld get sum of total amount for two records. plz help me.

Re: sap scripts

Former Member — Wed, 21 Jun 2006 11:35:10 GMT

Hi,

Its very simple.

Take 2 variables (VAR1, VAR2).

VAR1 - total of all fields within the record.

VAR2 - Sum of all records.

If you are in LOOP,

for each field while calculating total amount, add total amount to one variable (VAR1).

total amount = total price * total quantity

var1 = var1 + total amount.

Then for each end of record (before end loop), assign the var1 to var2.

var2 = var2 + var1.

clear var1.

regards,

Subba.

Re: sap scripts

Former Member — Wed, 21 Jun 2006 12:26:04 GMT

loop at lt_tab.

sum = price * qty.

totsum = totsum + sum.

endloop.

you can use this for any number of records...

Re: sap scripts

Former Member — Wed, 21 Jun 2006 12:30:26 GMT

you can not do the manupulation of fields in script.

so write a PERFORM & define that FORM in any z program & pass all your field values & do the sum & revert it to the script.

regards

srikanth

Re: sap scripts

dani_mn — Wed, 21 Jun 2006 12:31:22 GMT

Hi use 'SUM' statement at end of your loop to get total.

LIKE.

LOOP AT itab.

AT LAST.

SUM.

call your text element to write values.

ENDAT.

ENDLOOP.

Regards,

Wasim Ahmed