Skip to Content
0
Former Member
Dec 11, 2006 at 09:16 AM

Fetching data from Mara by using last 8 digits of prdha field

622 Views

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.