topic Re: SELECT STATEMENT IN SCRIPTS in Application Development and Automation Discussions

SELECT STATEMENT IN SCRIPTS

Former Member — Sun, 09 Jul 2006 08:26:42 GMT

can v write a select statement in scripts ? if yes where and how?

Pls reply to my query and send me example code as well..

Answers will be rewarded with points for sure.

Thanks inadvance.

Rgds

Giri

Re: SELECT STATEMENT IN SCRIPTS

Former Member — Sun, 09 Jul 2006 08:42:59 GMT

Hi,

FOr the details like what can be done in the form painter go through the link,

http://help.sap.com/saphelp_47x200/helpdata/en/d1/802ffa454211d189710000e8322d00/frameset.htm

Coming to your question, why do you need to write the select statement in a form? You can write the select statements in your form calling program and then you can call the form by using the function modules.

Regards,

Azaz Ali.

Re: SELECT STATEMENT IN SCRIPTS

Former Member — Sun, 09 Jul 2006 09:56:21 GMT

Thnaks Ali..

But if v do't have any print program for Script then where will v write a select statemnt?

rgds,Giri

Re: SELECT STATEMENT IN SCRIPTS

Former Member — Sun, 09 Jul 2006 10:06:09 GMT

Hi,

Small confusion , dose ur requirment don't have any driver program ?

if no, and if at all it is a standard program, then just write a perform in the form itself.

Eg: Perfrom gte_data in program Zxyz

using VAR1 VAR2...

changing VAR3 VAR4.

Endform.

1 create a program with Zxyz

2 Form Zxyz in_tab like structure ITCSY

outtab like structure ITCSY

using ...

changing...

Ur select atatement.

Endform.

Re: SELECT STATEMENT IN SCRIPTS

Clemenss — Sun, 09 Jul 2006 14:10:40 GMT

OK,

every sapscript form is triggered (started an filled with data) from a print program.

Sometimes the print program is a complex standard module (like in purchasing) where you can not or do not want to change anything standard.

In this cas you copy a form to user name space. You can not select direcly in SAPSCRIPT, but you can call forms from sapscript.

See documentation on sapscript command PERFORM and note that paramaters passed to and from sapscript are pure text values.

Need more hints? feel free to ask.

Regards,

Clemens