Skip to Content

When you assign a class in material master or batch or any other object and maintain the characteristics values in the class for the objects, you can see the data from MM02, MSC2N or other object master data transaction, but how the data is read from database?

The first thing is to check the “Multiple Objects Allowed” indicator for the class type of that table in transaction O1CL.

If this is ticked:

Take class type 023 of table MCHA for batch at material level as an example.

To find the classification maintained in material:

MARA-MATNR/MARC-MATNR = INOB-OBJEK

To find the classification maintained in batch:

MCH1-CUOBJ BM =  INOB-CUOBJ

Then:

INOB-CUOBJ = KSSK-OBJEK (Here you need to use the full digit of INOB-CUOBJ including the leading zero to find the KSSK-OBJEK.)

KSSK-CLINT = KLAH-CLINT  <<<<Class name can be found here

KLAH-CLINT = SWOR-CLINT  <<<<Description can be found here with corresponding language key

INOB-CUOBJ = AUSP-OBJEK <<<<Characteristic value can be found here

Picture1.jpg

If this is not ticked:

Take class type 001 of table MARA for material as an example.

MARA-MATNR/MARC-MATNR = KSSK-OBJEK

KSSK-CLINT = KLAH-CLINT  <<<<Class name can be found here

KLAH-CLINT = SWOR-CLINT  <<<<Description can be found here with corresponding language key

MARA-MATNR/MARC-MATNR = AUSP-OBJEK  <<<<Characteristic value can be found here

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Craig S

    Just a comment on the 001 material class.  SAP provided program RCCLUKA2 can convert a class to be allowed to use the “multiple objects allowed” flag.  (to allow the change documents flag to be set, the multiple objects flag must be set).

    In chemicals and pharma the change documents are often required for the 001 material class so many of these clients will have already done this conversion.  In this case as indicated above, the multiple objects flag will then be set for the 001 class and you have to access the 001 data as described above for the 023 class via the INOB table.

    FF



    (0) 
  2. Sergiu Iatco

    Characteristics values for sales order and delivery can be extracted from following tables:

    V_IBINR-INSTANCE=VBAP-CUOBJ

    V_IBINR-IN_RECNO=V_IBIN_SYVAL-IN_RECNO

    V_IBINR-INSTANCE=LIPS-CUOBJ

    V_IBINR-IN_RECNO=V_IBIN_SYVAL-IN_RECNO

    If document has been processed and changing is not possible one may use tcode SE16N with edit function to add or change values in IBINVALUES from IBSYMBOL. Clear IBINVALUES-ATAUT in order to make changes effective.

    (0) 
  3. Sylvia Scheidhammer

    explained very well but my Problem now is that I have several entries in table INOB for only one object. how do I know which is the correct INOB entry(CUOBJ) to read the AUSP.

    (0) 
    1. Shanthi Kumar Juluru

      There can not be multiple entries in INOB table with the same CUOBJ number as it is the only primary key in it. Can you check this again? Can you post a screenshot?

      (0) 

Leave a Reply