Skip to Content
0
Former Member
Dec 22, 2006 at 09:14 AM

Select querry

22 Views

Hi

I would like to get all stock information

My selections screen contains

three materials like:

s_matnr1

....

s_matnr2

....

s_matnr3

.....

So , I have written querry like this:

but getting values only for one matnr at a time.

  • SELECT amatnr bwerks blabst bumlme

  • binsme beinme bspeme bklabs

  • bkinsm bkeinm bkspem bretme

  • INTO CORRESPONDING FIELDS OF TABLE it_result

  • FROM mara AS a INNER JOIN mard AS b

  • ON amatnr = bmatnr

  • WHERE b~matnr IN s_matnr1 AND

  • b~matnr IN s_matnr2 AND

  • b~matnr IN s_matnr3 AND

  • b~werks IN s_werks.

I want to get the stock values for all matnrs: matnr1 ,matnr2 &matnr3

please help me ...