topic Re: Use variable in SQL statement in Application Development and Automation Discussions

Use variable in SQL statement

Former Member — Mon, 09 Jan 2006 07:20:32 GMT

HI guys:

I need code three SQL statements.the returned field and selected table are all same,there is only a difference in their "where" statement.

Sample code:

select marc_{matnr marc}werks

into table it_data

from MARC inner join MBEW on marc_{matnr = mbew}matnr

where marc_{matnr like 'A%' and mbew}zplp1 = '001'.

second one........................ mbew~zplp2 = '001'

third one......................... mbew~zplp3 = '001'

Could I write a FORM gather them with transporting a parameter ZPLPX to determine which condiniton will be execute?

thank you very much.

abdul_hakim — Mon, 09 Jan 2006 07:27:06 GMT

Hi Tilani.

Welcome to SDN.

You can very well do it by passing as a parameter of the subroutine.

Abdul

Former Member — Mon, 09 Jan 2006 07:30:08 GMT

Hi,

You can use perform to do that.

it looks good also.

VIjay

Former Member — Mon, 09 Jan 2006 07:39:41 GMT

Hi tianli,

1. source text

This concept of dynamic where

condition is called source text.

2. use like this.

This is important in the code ---> WHERE (mywhere).

REPORT abc LINE-SIZE 80.

DATA : it_data LIKE TABLE OF mara WITH HEADER LINE.

*----

QUOTES ARE IMPORTANT

PERFORM mysql USING 'mbew~zplp2 = ''001'''.

*----

FORM mysql USING mywhere.

SELECT marc_{matnr marc}werks

INTO TABLE it_data

FROM marc INNER JOIN mbew ON marc_{matnr = mbew}matnr

WHERE (mywhere).

ENDFORM. "mysql

regards,

amit m.