Hi All ,
i need to fetch data from <b>mara</b> based on <b>matnr</b> and <b>series</b> from a custom table.Problem is <b>mara</b> doesnt have <b>series</b> . I have to compare last 8 digits of MARA-prdha with series. This <b>series</b> is a select-option in selection screen.
So how to compare only last 8digit of prdha while fetching data from mara.
SELECT matnr prdha
INTO TABLE gi_mara
FROM mara
WHERE matnr IN s_matnr.
AND prdha
Thanks in advance.
shyam.