07-25-2008 6:44 PM
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.
07-25-2008 6:48 PM
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
07-25-2008 6:46 PM
select * from mara into table itab
where PRDHA like '0050000501%'.
07-25-2008 6:48 PM
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
07-25-2008 6:53 PM