Table relations in MM

[Murali_Shanmu]

Hi

I am working in MM module. When i goto MM03 giving material number and Chosing Classification view, i get to see the Class name and a list of Characteristic values maintained.As an ABAper i need to find the class and Characteristic that are maintained a for a material.I need to know the underlying tables related to this. Pls help.

[Former Member · Accepted solution]

hi,

check with KLAH, KSSK and MCHA and FM QMSP_MATERIAL_BATCH_CLASS_READ

cheers,

sasi

[Former Member]

Hi,

KSSK-OBJEK = MATNR (18 Characters)

hope this might help you.

Regards,

Malathi

[Former Member]

Hi,

Here are the steps to retrieve Class Name and Characteristics Value

1. From KSSK table for the given material# get field values of CLINT KLART OBJEK.

2. Table KLAH gives you the Class Name(KLAH-CLASS) for the selected CLINT and KLART.

3. Use function Module CLA2_GET_ALL_ALLOCATION to get Characteristics Value

Eg:

CALL FUNCTION 'CLA2_GET_ALL_ALLOCATIONS'

EXPORTING

object = kssk-objek

class_type = kssk-objek

alloc_id = 'O'

table = 'MCH1'

key_date = sy-datum

TABLES

values = it_ausp

• ALLOCATIONS =

EXCEPTIONS

invalid_class_type = 1

invalid_object = 2

OTHERS = 3

.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

4. Get Characteristics description from CABN for all entries in IT_AUSP

Thanks and regards,

Malathi

[Murali_Shanmu]

Thanks malathi

But how do i pass Matnr to KSSK ?

[Former Member]

Hi;

These are the important Tables in MM.

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

Regards

Afsal

[Former Member]

HI,

followings tables are used in mm module.

Name Description Uses

MARA Inventory Master

MARC Plant Data

MARD Current Inventory

MAKT Descriptions

MBEW Material Valuation

T179 Product Hierarchy

MVKE Sales data (materials)

MKPF Material document Status code 'R' in VBFA

Regards