To extract data from t.code mm02

[Former Member]

Hi,

I want to write the program to extract the data from t.code mm02 for clsiification and unit of measure .

In classification there are charactersitcs and values which i want to extract. And in unit of measure i want to extract the data .

please if somebudy knows plz let me know.

[Former Member]

Hi Rahul,

You can use following tables to extact default material characteristics.

CABN,CABNT,CAWN & CAWNT

And you can also refer following code where I have used FM's -

*&--- Select class type available for material table (MARA)

SELECT klart

FROM tcla

INTO TABLE t_klart

WHERE obtab = c_mara AND

klart = '300'. " GIves Material class type

REFRESH t_objkeys.

LOOP AT t_klart INTO w_klart.

CLEAR : w_objkeys.

w_objkeys-class_type = w_klart.

w_objkeys-objectkey = w_matnr2. "material number

w_objkeys-objecttable = c_mara. " MARA

APPEND w_objkeys TO t_objkeys.

CLEAR : w_klart,

w_objkeys.

ENDLOOP.

REFRESH : t_allocations, t_class_char1, t_class_char.

*&---FM to get the Class Name for the material

CALL FUNCTION 'CLBPAX_READ_CLASSIFICATIONS'

EXPORTING

t_object_keys = t_objkeys

keydate = sy-datum

IMPORTING

t_allocations = t_allocations

t_valuations_char = t_value_char

t_valuations_num = t_value_num.

IF t_allocations[] IS NOT INITIAL.

LOOP AT t_allocations INTO w_allocations WHERE class_type = '300'.

CALL FUNCTION 'BAPI_CLASS_GETDETAIL'

EXPORTING

classtype = w_allocations-class_type

classnum = w_allocations-classnum

TABLES

classcharacteristics = t_class_char1

classcharvalues = t_class_char.

ENDLOOP.

ENDIF.

[Former Member]

hai,

ct04-characteristics t.code

CABN---characteristics table

cl02--classification t.code

KLAH ---classification table..........

shan.