Skip to Content

Table relations in MM

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 06:20 AM

    hi,

    check with KLAH, KSSK and MCHA and FM QMSP_MATERIAL_BATCH_CLASS_READ

    cheers,

    sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2005 at 06:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 06:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 07:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 07:40 AM

    Hi,

    KSSK-OBJEK = MATNR (18 Characters)

    hope this might help you.

    Regards,

    Malathi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.