topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 17 Sep 2007 09:43:25 GMT

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

Re: select statement

Former Member — Mon, 17 Sep 2007 09:45:42 GMT

Hi ,

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

Regadrs

Arun

Re: select statement

Former Member — Mon, 17 Sep 2007 09:50:02 GMT

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

Re: select statement

Former Member — Mon, 17 Sep 2007 09:52:57 GMT

ekgrp and dispo r not there in mara tabel yaar

Re: select statement

Former Member — Mon, 17 Sep 2007 09:54:56 GMT

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

Re: select statement

dev_parbutteea — Mon, 17 Sep 2007 09:55:16 GMT

Hi,

select matnr mtart matkl

from mara

where mtart in s_matty

and matkl in s_matgrp

into it_mara.

Regards.

Re: select statement

Former Member — Mon, 17 Sep 2007 09:59:19 GMT

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^