select statement

[Former Member]

hai i need a select statement based on given conditions ,

selection-screen fields: marc-dispo like s_matctr

mara-mtart like s_matty

mara-matkl like s_matgrp

ekko-ekgrp like s_ekgrp

and my data in internal table should be only matnr in the table mara .

can u pls give code for this

[Former Member]

Hi ,

All these fields are there in the table MARA , so perform a select on the table MARA.

Regadrs

Arun

[Former Member]

ekgrp and dispo r not there in mara tabel yaar

[Former Member]

hi tell me correctly what are the fields u want to select

from which table

and also the internal table u want to be fill

[Former Member]

only one field from mara table and conditions based on those four fields and stores in internal table having only one field matnr-mara

[dev_parbutteea]

Hi,

select matnr mtart matkl

from mara

where mtart in s_matty

and matkl in s_matgrp

into it_mara.

Regards.

[Former Member]

hi

good

you can join these three tables using a common field presnt in these tables,it is confusing that you have mentioned that your internal table should be only matnr in the table mara.

Refer to join statement and write your code to join the three table.

thanks

mrutyun^