Select statement info needed

[Former Member]

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.

[Former Member]

select * from mara into table itab

where PRDHA like '0050000501%'.

[Former Member]

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

[Former Member]

Thanks for your help...