topic Re: Scripts in Application Development and Automation Discussions

Scripts

Former Member — Mon, 01 Dec 2008 13:19:55 GMT

Hi All,

Am working on Scripts.

In print program I have given select query and i have given sysubrc to check the records.

Am getting records which doesn't have values.

In print program :

SELECT SINGLE KBETR FROM KONV INTO TOTAL_1 WHERE KNUMV = VBDKA-KNUMV AND KPOSN = VBDPA-POSNR AND KSCHL = 'PROO'.

IF SY-SUBRC = 0.

FLAG_1 = 1.

Endif.

In script :

IF &FLAG_1& NE 0

&TOTAL_1&

ENDIF.

The problem is am getting the zero value if there is no value in &TOTAL_1& even though i mentioned the

SY-SUBRC condition.

I have given this condition also IF &FLAG_1& NE 0 AND &TOTAL_1& NE 0

&TOTAL_1&

ENDIF

How I can prevent zero values.

Please help me.

Thanks In advance,

Regards,

Murthy.

Please use meaningful subject in furture

Edited by: Vijay Babu Dudla on Dec 1, 2008 8:31 AM

Re: Scripts

Former Member — Mon, 01 Dec 2008 13:24:21 GMT

Hello,

Try to write it as:

IF &FLAG_1& EQ C_1. --> As you are passing 1 to flag if sy-subrc <> 0.

&TOTAL_1& --> Print the total

ENDIF.

Hope it helps.

Thanks,

Jayant

Re: Scripts

Former Member — Mon, 01 Dec 2008 13:31:03 GMT

Hi Jayant,

Thanks for ur quick reply.

I have given that condition also like IF &FLAG_1& EQ 1

&TOTAL_1&

ENDIF

Then am not geting any values (even zero values and actual values)

Thanks & regards,

Murthy.

Re: Scripts

Former Member — Mon, 01 Dec 2008 13:42:39 GMT

Dear friend,

In script :

IF &FLAG_1& EQ 1

&TOTAL_1&

ENDIF.

Re: Scripts

Former Member — Mon, 01 Dec 2008 13:47:47 GMT

Hello Kan,

Select query is in your driver program, are you passing the flag information to the Sap Script? Did you try to debug the value in the script.

Best possible solution would be to check if the Total that you have used in the program is initial.

If the total value is 2 decimal places then check it as.

if &TOTAL_1& NE '0.00'.

<print the total here>.

endif.

Hope this will solve your problem.

Thanks,

Jayant

Re: Scripts

Former Member — Mon, 01 Dec 2008 20:52:33 GMT

i would write:

SELECT SINGLE KBETR FROM KONV INTO TOTAL_1 WHERE KNUMV = VBDKA-KNUMV AND KPOSN = VBDPA-POSNR AND KSCHL = 'PROO'.

IF SY-SUBRC EQ 0

and not TOTAL_1 is intitial.

FLAG_1 = 1.

else.

flag = 0.

Endif.

In script :

IF &FLAG_1& NE 0

&TOTAL_1&

ENDIF.

if u dont get any results maybe the flag isnt defined global

dont forget 2 clear the flag if the statement aint true

Regards

Stefan Seeburger