topic Re: SAP SCRIPTS - TOTALS in Application Development and Automation Discussions

SAP SCRIPTS - TOTALS

Former Member — Thu, 10 Aug 2006 18:17:03 GMT

Hi Everyone i am using this logic to write the subtotal and total in the script, i am doing the total for the quantity field and writing the perform in main window.

The problem is the first time iam getting correct values but once i go back(not to the transaction but to select the ouptut type and again see the print preview its adding the previous total as well), if i run the transaction from the start thier is no problem.

i am giving the code as well.

FORM GET_TOTAL TABLES INPAR STRUCTURE ITCSY

OUTPAR STRUCTURE ITCSY.

DATA : P_EBELN2 LIKE EKKO-EBELN,

P_TOTAL LIKE EKPO-KTMNG,

P_TOT(13),

value type ktmng.

STATICS VALUE1 TYPE KTMNG.

CLEAR INPAR.

clear value1.

CLEAR VALUE.

READ TABLE INPAR INDEX 1.

MOVE INPAR-VALUE TO value.

value1 = value1 + value.

move value1 to p_tot.

*clear value1.

CLEAR OUTPAR.

READ TABLE OUTPAR INDEX 1.

MOVE p_tot TO OUTPAR-VALUE.

MODIFY OUTPAR INDEX SY-TABIX.

CLEAR P_TOT.

ENDFORM.

Thanks & Regards

Syed

Re: SAP SCRIPTS - TOTALS

Former Member — Thu, 10 Aug 2006 18:19:59 GMT

This usually indicates that something is not getting cleared. I think you need to clear value1, maybe in initialization?

Re: SAP SCRIPTS - TOTALS

Former Member — Thu, 10 Aug 2006 18:21:51 GMT

You variable is defined as STATIC. You will have to clear it somewhere.

Re: SAP SCRIPTS - TOTALS

Former Member — Thu, 10 Aug 2006 18:23:47 GMT

hi syed,

just try im not sure...

comment these 2 lines.

FORM GET_TOTAL TABLES INPAR STRUCTURE ITCSY

OUTPAR STRUCTURE ITCSY.

DATA : P_EBELN2 LIKE EKKO-EBELN,

P_TOTAL LIKE EKPO-KTMNG,

P_TOT(13),

value type ktmng.

STATICS VALUE1 TYPE KTMNG.

*CLEAR INPAR.

clear value1.

CLEAR VALUE.

READ TABLE INPAR INDEX 1.

MOVE INPAR-VALUE TO value.

value1 = value1 + value.

move value1 to p_tot.

*clear value1.

*CLEAR OUTPAR.

READ TABLE OUTPAR INDEX 1.

MOVE p_tot TO OUTPAR-VALUE.

MODIFY OUTPAR INDEX SY-TABIX.

CLEAR P_TOT.

ENDFORM.

Re: SAP SCRIPTS - TOTALS

Former Member — Thu, 10 Aug 2006 18:25:29 GMT

Hi syed,

the value stored in value1 is getting added to value when the perform is called for the secons time.

clear value1 and also value.

clear value1.

clear value.

in the subroutine.

regards,

keerthi.

Re: SAP SCRIPTS - TOTALS

Former Member — Thu, 10 Aug 2006 18:27:51 GMT

Hi Syed,

STATIC values will preseve the value so you are getting the preserved value and this value to is again calculated so clear this value before processing for the next time.

For this just add a CLEAR VALUE1 statement in your code.

CLEAR INPAR.

clear value1.

CLEAR VALUE.

CLEAR VALUE1.

READ TABLE INPAR INDEX 1.

MOVE INPAR-VALUE TO value.

value1 = value1 + value.

Thanks,

Vinay

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 10:32:15 GMT

HI EVERYONE THANKS ALL OF U FOR YOUR ADVICE , BUT STILL THE PROBLEM IS NOT SOLVED . I CANNOT CLEAR VALUE1 IN THE SUBROUTINE AS IT WILL NOT ADD THE OTHER VALUES. IS THEIR ANY OTHER LOGIC FOR THIS ONE.

THANKS & REGARDS SYED

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 10:39:27 GMT

Hi Syed,

Chk the following link.It might solve your problem.

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

Reward points,if helpful.

Regards,

Harini.S

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 11:53:52 GMT

Hello Syed.

I would you to please try the below logic

CLEAR INPAR.

CLEAR VALUE.

READ TABLE INPAR INDEX 1.

MOVE INPAR-VALUE TO value.

CLEAR OUTPAR.

READ TABLE OUTPAR INDEX 1.

MOVE OUTPAR-VALUE to p_tot.

p_tot = p_tot + value.

CLEAR OUTPAR.

READ TABLE OUTPAR INDEX 1.

MOVE p_tot TO OUTPAR-VALUE.

MODIFY OUTPAR INDEX SY-TABIX.

CLEAR P_TOT.

Regards

Anurag

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 17:20:35 GMT

Hi , Anurag n others

thanks for ur valuable advice but the code is not working , do u have any other logic for this as i don't have access to the print program and i can't clear the value in the subroutine.

thanks & regards

Syed

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 18:21:20 GMT

HI Syed,

I think the static variables can change the values within a routine. when u r out of routine then the variable has the initial value what u have assignned.

so when the select statement for second time then it uses the previous value also.

remove the keyword static... and try...

otherwise place a select statement in routine.

hope this helps

Regards

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 18:59:36 GMT

Syed,

Can you please paste the part of code where it calls the particular form.

It is an interesting situation...

Regards

anurag

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 19:31:06 GMT

Hi Syed,

Have you tried SUMMING control command in script for subtotal.

Thanks

Re: SAP SCRIPTS - TOTALS

Former Member — Fri, 11 Aug 2006 20:30:20 GMT

IH &EKPO-EBELP&,,&EKPO-MATNR&,,&EKPO-TXZ01&,,&EKPO-KTMNG&,,&EKPO-MEINS&,,

= &XDAT&

/* DEFINE &XEBEL& = &EKPO-EBELN&

/: DEFINE &XTOT& = &EKPO-KTMNG&

/: DEFINE &XTOTAL& = &EKPO-KTMNG&

/: PERFORM GET_TOTAL IN PROGRAM ZRMLONG1

/: USING &XTOT&

/: CHANGING &XTOTAL&

/: ENDPERFORM THIS IS THE CODE IN THE MAIN WINDOW AND IN THE THREAD U CAN SEE THE CODE FOR THE SUBROUTINE

THANKS & REGARDS

SYED