topic Re: materail group (MATKL) table in Application Development and Automation Discussions

materail group (MATKL) table

Former Member — Thu, 17 Apr 2008 04:49:56 GMT

HI All,

Is there any table to store only materail group (matkl).

I want to fetch the materials whose material group starts with to characters( for example AB***** ).

how can i write the condition on mara table to fetch the materail whose materal group starts with "AB".

if material group field values stores in separate table than i can fetch all material group values, filter required materail group based on than i can write select query.

Re: materail group (MATKL) table

former_member156446 — Thu, 17 Apr 2008 04:52:27 GMT

you can create a range ra_matkl and use that in the select statement..


MOVE 'E' TO ra_matkl-sign.
MOVE 'BT' TO ra_matkl-option.
MOVE 'AB' TO ra_matkl-low.
APPEND ra_matkl.


select 1 2 3 
          from 
         where matkl in ra_matkl.

Re: materail group (MATKL) table

Former Member — Thu, 17 Apr 2008 04:52:49 GMT

select * from mara into table <itab> where MATKL like ab%.

i hope its correct

any issue let me know

regards if helpful

baskaran

Re: materail group (MATKL) table

kiran_k8 — Thu, 17 Apr 2008 04:55:43 GMT

Hi,

Check in MARA table.You can get both matnr and matkl.

data:begin of itab occurs 0,

matnr like mara-matnr,

matkl like mara-matkl.

end of itab.

parameter p_matkl like mara-matkl

select matnr

matkl

from mara

into table itab

where matkl = p_matkl.

In the selection screen given the value as AB* and execute.

K.Kiran.

Re: materail group (MATKL) table

Former Member — Thu, 17 Apr 2008 04:55:44 GMT

Hi,

T023 is the table where all the defined mat groups are stored.

Reward points if you find it useful.

Regards,

Prasanna

Re: materail group (MATKL) table

Former Member — Thu, 17 Apr 2008 06:30:19 GMT

hI Baskaran,

thanks for the reply,

but select * from mara into table <itab> where MATKL like ab%.

is giving error.

kindly let me know the error, if u know.

thaks

Re: materail group (MATKL) table

rahul2000 — Thu, 17 Apr 2008 06:33:31 GMT

hi..

give AB* in selection screen and execute...it should server u r purpose...

but i guess u dont have material group in u r selection screen...am i right?

Re: materail group (MATKL) table

Former Member — Thu, 17 Apr 2008 06:40:50 GMT

Hi,

Use like this

select * from mara into table t_itab1
                            where MATKL like 'AB%'.

Re: materail group (MATKL) table

Former Member — Thu, 17 Apr 2008 06:41:56 GMT

thanks prasanna i required that table only.

it solved my problem.