Use variable in SQL statement

[Former Member]

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.

[Former Member]

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.

[abdul_hakim]

Hi Tilani.

Welcome to SDN.

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

Abdul

[Former Member]

Hi,

You can use perform to do that.

it looks good also.

VIjay

[Former Member]

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.