topic Re: Select statement info needed in Application Development and Automation Discussions

Select statement info needed

Former Member — Fri, 25 Jul 2008 17:44:09 GMT

Hello all,

My req. with select statement is as below.

Need to select all materials from MARA where the product hierarchy (PRDHA) contains u20180050000501u2019 as the first ten characters, and insert them into an internal table .

awaiting for earlier response.

Thanking you.

Bharat.

Re: Select statement info needed

Former Member — Fri, 25 Jul 2008 17:46:24 GMT

select * from mara into table itab

where PRDHA like '0050000501%'.

Re: Select statement info needed

Former Member — Fri, 25 Jul 2008 17:48:37 GMT

Hi,

Check this code..

data: t_mara type standard table of mara.

* Make sure to remove * and check whether there is an index on the field PRDHA.
SELECT * FROM MARA INTO TABLE t_mara
             where PRDHA LIKE '0050000501%'.

Thanks

Naren

Re: Select statement info needed

Former Member — Fri, 25 Jul 2008 17:53:24 GMT

Thanks for your help...