Select into another select statement

[Former Member]

Hi all.

Can i write a statement like this

select matnr                                                              "the number of the material

           (select maktx from makt where mantr eq mantr) "the name of the material

from mara

It is a example, but explain what i am looking for; write a select into another select statement

It is posible?

Thanks in advance.

[Former Member]

Hi Luiz,

Yes you can write such a statement(select inside another select statement).

Refer:http://help.sap.com/saphelp_nw04/helpdata/en/dc/dc7614099b11d295320000e8353423/content.htm

However, this is not recomended.

Refer:http://wiki.scn.sap.com/wiki/display/Community/ABAP+Performance+tips

Thanks
Sabal

[Former Member]

Hi,

Better use a join between those two tables.

Regards

Miguel

[Former Member]

Hi all

Thansk a lot for the help.

Following your opinion I could correct my mistake