finding material from mara

[Former Member]

hi,

i have a problem that i have to find material or barcode from mara table which has same till its size and color.here i am giving example:--

abc/hs-01-40

abc/hs-02-40

abc/fs-01-40

now i want that my program show only those article which are same till its - sign and different from 01 or o2.

thanx/regards,

vaneet thakur

[Former Member]

hi,

i have a problem that i have to find material or barcode from mara table which has same till its size and color.here i am giving example:--

abc/hs-01-40

abc/hs-02-40

abc/fs-01-40

now i want that my program show only those article which are same till its - sign and different from 01 or o2.

thanx/regards,

vaneet thakur

[Former Member]

Hii,

u can use select material using below condition , if u want to select material starting with abc/

mara-matnr+0(4) = abc/

Thanks

[Former Member]

hi,

mine problem is this that i have number of records of articles and i have to find out those articles which are same before - sign but they differ in mrp.

thanx/regards,

vaneet thakur

[agnihotro_sinha2]

can you give us the fields in MARA based on which you want the comparison to happen?

do you want to judge based on MARA-MATNR only or other fields also?

Edited by: ags on Jun 8, 2009 11:39 AM

[Former Member]

hi,

well i m using 4 tables.MARA,MAKT,A504,KONP.based on these tables i am finding mrp of materials

thanx/regards,

vaneet thakur