topic Re: SAP Script : using Perform to do Arthematic Operation in Application Development and Automation Discussions

SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 16:42:20 GMT

Dear All,

I am having a problem in SAP Script. I have 2 fields total and Tax, I have to perform a arthematic operation and get sub-total, Total - Tax. I am using below code but I am getting error as CONVT_NO_NUMBER. UNABLE TO INTERPRET ' 01500.00'as a number.

Please help me in this regard. please seee the code ..as I am a new-bie, I might making some silly mistake. Please look at this problem and suggest me.

I have been suggested by my friend to use ..Move but I am not sure ..how to do that. Please kindly spare some time.

/: PERFORM GET_SUBTOTAL IN PROGRAM ZGET_SUBTOTAL

/: USING &BSEG-WRBTR&

/: USING &BSEG-WMWST&

/: CHANGING &S_SUBTOTAL&

/: ENDPERFORM.

Sub-routine Program.

PROGRAM ZGET_SUBTOTAL.

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA : W_WRBTR TYPE BSEG-WRBTR, " Total

W_WMWST TYPE BSEG-WMWST. " Tax

READ TABLE INT_COND INDEX 1.

W_WRBTR = INT_COND-VALUE.

READ TABLE INT_COND INDEX 2.

W_WMWST = INT_COND-VALUE.

OUT_COND-NAME = 'S_SUBTOTAL'.

OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

ENDFORM.

Thanking you.

With kind Regards

Venkat

Re: SAP Script : using Perform to do Arthematic Operation

RichHeilman — Wed, 10 May 2006 16:47:55 GMT

Please try this instead.



DATA : W_WRBTR TYPE BSEG-WRBTR, " Total
       W_WMWST TYPE BSEG-WMWST. " Tax

READ TABLE INT_COND INDEX 1.
<b>
clear w_wrbtr.
W_WRBTR =  W_WRBTR + INT_COND-VALUE.</b>

READ TABLE INT_COND INDEX 2.
<b>
clear w_wmwst.
W_WMWST =  W_WMWST + INT_COND-VALUE.</b>

Regards,

Rich Heilman

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 17:03:32 GMT

Hi Rich,

Thank you very much for your quick response.

I tried that but getting same error.

I guess this is conversion error.

Anyway, Please kindly complete the code.

right Now I am using.

PROGRAM ZGET_SUBTOTAL.

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA : W_WRBTR TYPE BSEG-WRBTR,

W_WMWST TYPE BSEG-WMWST.

READ TABLE INT_COND INDEX 1.

clear w_wrbtr.

W_WRBTR = W_WRBTR + INT_COND-VALUE. 'I am having small confusion here, both fields are same.

READ TABLE INT_COND INDEX 2.

clear w_wmwst.

W_WMWST = W_WMWST + INT_COND-VALUE.

OUT_COND-NAME = 'S_SUBTOTAL'.

OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

ENDFORM.

Thanking you.

Regards

Venkat

Re: SAP Script : using Perform to do Arthematic Operation

former_member181966 — Wed, 10 May 2006 17:13:17 GMT

Do like this :

PROGRAM ZGET_SUBTOTAL.

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA : W_WRBTR TYPE BSEG-WRBTR,

W_WMWST TYPE BSEG-WMWST,

new_var TYPE BSEG-WMWST.

READ TABLE INT_COND INDEX 1.

clear w_wrbtr.

W_WRBTR = W_WRBTR + INT_COND-VALUE. 'I am having small confusion here, both fields are same.

READ TABLE INT_COND INDEX 2.

clear w_wmwst.

W_WMWST = W_WMWST + INT_COND-VALUE.

OUT_COND-NAME = 'S_SUBTOTAL'.

new_var = W_WRBTR - W_WMWST.

write new_var to OUT_COND-VALUE.

MODIFY OUT_COND INDEX 1.

ENDFORM.

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: SAP Script : using Perform to do Arthematic Operation

RichHeilman — Wed, 10 May 2006 17:13:42 GMT

Please check the value of INT_COND-VALUE right before the execution of the statement. You will need a break-point here. If the value of this field contains any non-numerical value, you will get this dump. I'm thinking that a comma may be causing the problem. If so, we can take care of that. First, check the value of the field at runtime.

Regards,

Rich Heilman

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 17:13:54 GMT

Delete the BOLD part and enter Underline and Italic part.

/: PERFORM GET_SUBTOTAL IN PROGRAM ZGET_SUBTOTAL

/: USING &BSEG-WRBTR&

/: USING &BSEG-WMWST&

/: CHANGING &S_SUBTOTAL&

/: ENDPERFORM.

Sub-routine Program.

PROGRAM ZGET_SUBTOTAL.

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA : W_WRBTR TYPE BSEG-WRBTR, " Total

W_WMWST TYPE BSEG-WMWST. " Tax

READ TABLE INT_COND INDEX 1.

W_WRBTR = INT_COND-VALUE.

READ TABLE INT_COND INDEX 2.

W_WMWST = INT_COND-VALUE.

OUT_COND-NAME = 'S_SUBTOTAL'.

READ TABEL OUT_COND INDEX 1.

OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

ENDFORM.

Re: SAP Script : using Perform to do Arthematic Operation

RichHeilman — Wed, 10 May 2006 17:15:26 GMT

If the problem is that the comma is coming in the variable, then we can strip it out.



READ TABLE INT_COND INDEX 1.

<b>translate INT_COND-VALUE using ', '.
condense INT_COND-VALUE no-gaps.</b>

W_WRBTR = INT_COND-VALUE.

Regards,

Rich Heilman

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 17:17:10 GMT

Hi venkat,

<b>READ TABLE INT_COND INDEX 1.
clear w_wrbtr.
W_WRBTR = W_WRBTR + INT_COND-VALUE. 

READ TABLE INT_COND INDEX 2.
clear w_wmwst.
W_WMWST = W_WMWST + INT_COND-VALUE.</b>

here you need to change your logic little,

see you will get the data as chars. so you need to move the data to currecncy field.

then do calculation.

some thing like this..

READ TABLE INT_COND INDEX 1.
clear w_wrbtr.
write int_cond-value to x_wrbtr . "x_wrbtr of type wrbtr
W_WRBTR = W_WRBTR + x_wrbtr.

now you will not get that error.

i think clear not required. i think you are doing it item wise and printing, in this case one all items over you can print.

can you confirm it ...

Regards

vijay

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 17:26:34 GMT

Hi Rich / Khan / Aman,

Thank you very much for your inputs ...

I tried to debug, the value of INT_COND-VALUE is ' 1,500.00'. morever I am getting many blank spaces before '1,500.00'

with old code, error was at arthematic operation but now just after this step, it causes dump.

Please advice me further.

Anyway, I guess the problem would be same for Khan's suggestion. however I will try and let you know.

looking farward for futher suggestions.

Thanking you.

Venkat

Re: SAP Script : using Perform to do Arthematic Operation

RichHeilman — Wed, 10 May 2006 17:28:40 GMT

The comma is definitly your problem, you can remove it by using the translate statement.



DATA : W_WRBTR TYPE BSEG-WRBTR, " Total
W_WMWST TYPE BSEG-WMWST. " Tax



READ TABLE INT_COND INDEX 1.
<b>translate INT_COND-VALUE using ', '.
condense INT_COND-VALUE no-gaps.</b>
W_WRBTR = INT_COND-VALUE.

READ TABLE INT_COND INDEX 2.
<b>translate INT_COND-VALUE using ', '.
condense INT_COND-VALUE no-gaps.</b>
W_WMWST = INT_COND-VALUE.

Regards,

Rich Heilman

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 17:51:25 GMT

Hi All,

Thank you very much once again. I will try all your suggestions and get back to you.

Anyway, Vijay.. I am getting snytax error with your code.

it says

X_WRbtr must be a Charecter-type field (data type C,N,D,T).

Please advice me futher.

Thanking you .. will allot points to all of you as a token of gratitude.

Regards

Venkat.

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 17:58:42 GMT

Ok, but you need to make it as currency field with out commas and you will be able to do manipulations.

i think Rich's suggestion will work.

Regards

vijay

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 18:51:39 GMT

Hi All,

Thanks for your inputs,

Rich I followed your suggestion but I am unable to get OUT_COND-VALUE. it just shoes blank spaces.

I guess that I am doing some silly mistake.

Please have a look at this code.

PROGRAM ZGET_SUBTOTAL.

Thanking you.

Regards

Venkat

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA : W_WRBTR TYPE BSEG-WRBTR,

W_WMWST TYPE BSEG-WMWST.

READ TABLE INT_COND INDEX 1.

translate INT_COND-VALUE using ', '.

condense INT_COND-VALUE no-gaps.

W_WRBTR = INT_COND-VALUE.

READ TABLE INT_COND INDEX 2.

translate INT_COND-VALUE using ', '.

condense INT_COND-VALUE no-gaps.

W_WMWST = INT_COND-VALUE.

OUT_COND-NAME = 'S_SUBTOTAL'.

OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

ENDFORM.

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 18:59:41 GMT

Hi Venkat,

are you getting any value of the below diff.

*OUT_COND-NAME = 'S_SUBTOTAL'. "this is not required

OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

Regards

vijay

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 19:05:59 GMT

Hi Vijay,

No, I am unable to get that difference.

I could get values for INT_COND-VALUE for 2 times

as 1500.00 and 0.00 respectively but could not get the difference i,e OUT_COND-VALUE

Moreover, if *OUT_COND-NAME = 'S_SUBTOTAL'.

is not required, how can I print on form.

sorry for my ingnorance. Thanking you.

Regards

Venkat

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 19:12:12 GMT

Hi,

some how try to move to some number fields then find the difference , and then use move.

MOVE v_diff TO out_tab-value.

*OUT_COND-NAME = 'S_SUBTOTAL'.

and you are having that already(in index1) then why do you need?

try to take some number variables and then convert them to numbers and find diff.

and use move

Regards

vijay

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 19:23:36 GMT

Hi Venkat,

Pls make the following changes in form routine.

PROGRAM ZGET_SUBTOTAL.

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA: STR_AMT(255) TYPE C.

W_WRBTR TYPE BSEG-WRBTR, " Total

W_WMWST TYPE BSEG-WMWST. " Tax

READ TABLE INT_COND INDEX 1.

STR_AMT = INT_COND-VALUE.

SY-SUBRC = 0.

WHILE SY-SUBRC = 0.

REPLACE ',' WITH ' ' INTO STR_AMT.

ENDWHILE.

CONDENSE STR_AMT NO-GAPS.

MOVE STR_AMT TO W_WRBTR.

READ TABLE INT_COND INDEX 2.

STR_AMT = INT_COND-VALUE.

SY-SUBRC = 0.

WHILE SY-SUBRC = 0.

REPLACE ',' WITH ' ' INTO STR_AMT.

ENDWHILE.

CONDENSE STR_AMT NO-GAPS.

MOVE STR_AMT TO W_WMWST.

READ TABLE OUT_COND INDEX 1.

IF SY-SUBRC EQ 0.

OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

ENDIF.

ENDFORM.

Hope this give you some idea!!!

Cheers,

Vikram

Pls reward points for helpful replies!!

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 19:35:55 GMT

/: PERFORM GET_SUBTOTAL IN PROGRAM ZGET_SUBTOTAL

/: USING &BSEG-WRBTR&

/: USING &BSEG-WMWST&

/: CHANGING &S_SUBTOTAL&

/: ENDPERFORM.

As you are already passing the S_SUBTOTAL with the changing paramter and in the Form you have that value in table OUT_COND.

So no need to for this statment OUT_COND-NAME = 'S_SUBTOTAL'.

As you have only 1 value in the CHANGING . If there are multipal values in the CHANGING then you need to READ THE TABLE OUT_COND WITH INDEX.

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 19:43:53 GMT

Hi All.

Thanks you very much !!!!!!

Finally I got it ... But dont know how to keep it in form. I used a Number field and got the difference, But I wondering ..which field should I keep in form.

Here is my code. I got the result in debug mode.

PROGRAM ZGET_SUBTOTAL.

FORM GET_SUBTOTAL TABLES INT_COND STRUCTURE ITCSY

OUT_COND STRUCTURE ITCSY.

DATA : W_WRBTR TYPE BSEG-WRBTR,

W_WMWST TYPE BSEG-WMWST,

Num1 type p decimals 2.

READ TABLE INT_COND INDEX 1.

translate INT_COND-VALUE using ', '.

condense INT_COND-VALUE no-gaps.

W_WRBTR = INT_COND-VALUE.

READ TABLE INT_COND INDEX 2.

translate INT_COND-VALUE using ', '.

condense INT_COND-VALUE no-gaps.

W_WMWST = INT_COND-VALUE.

OUT_COND-NAME = 'NUM1'.

NUM1 = W_WRBTR - W_WMWST.

MOVE Num1 TO out_cond-value.

*OUT_COND-VALUE = W_WRBTR - W_WMWST.

MODIFY OUT_COND INDEX 1.

ENDFORM.

In SAP script editor my Perform statement is :

/: PERFORM GET_SUBTOTAL IN PROGRAM ZGET_SUBTOTAL

/: USING &BSEG-WRBTR&

/: USING &BSEG-WMWST&

/: CHANGING &S_SUBTOTAL&

/: ENDPERFORM

Finally, please suggest me how to populate this on form.

Thanks very much

Regards

Venkat

Re: SAP Script : using Perform to do Arthematic Operation

Former Member — Wed, 10 May 2006 19:47:36 GMT

hi venkat,

from your post you are getting the difference showing it as subtotal.

as you are getting the diff , and movig the content to sub_total, after calling the perform, you can use &S_SUBTOTAL&

Regards

vijay