Skip to Content
A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!
Not yet a member on the new home? Join today and start participating in the discussions!
Read about the migration and join SAP Community Groups!
  • Home
  • Community
  • Ask a Question
  • Write a Blog Post
  • Login / Sign-up
Author's profile photo Rachel Tang
Rachel Tang
August 16, 2013 1 minute read

Do you know the links among tables in Classification and Variant Configuration?

10 30 73,529

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

Alerting is not available for unauthorized users

Assigned Tags

      /
      Picture1.jpg
      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Craig S
      Craig S
      August 16, 2013 at 2:09 pm

      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



      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Rachel Tang
      Rachel Tang
      Blog Post Author
      January 13, 2015 at 4:54 am

      Good comment.

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Nancy Guo
      Nancy Guo
      November 7, 2014 at 1:21 am

      Well explained 😆

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Sergiu Iatco
      Sergiu Iatco
      September 3, 2015 at 1:28 pm

      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.

      • Like 1
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Sylvia Scheidhammer
      Sylvia Scheidhammer
      June 6, 2017 at 9:00 am

      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.

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Kumar J
      Kumar J
      June 6, 2017 at 9:15 am

      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?

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Former Member
      Former Member
      April 30, 2018 at 7:18 pm

      Helpful...!

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Amarpreet Singh
      Amarpreet Singh
      June 13, 2018 at 9:07 am

      Thanks this is very helpful , But can you please also explain what is the purpose of ADZHL field in all the classification tables ?

      KSSK , CABN , CAWN ..

      Regards

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal
      December 3, 2020 at 2:16 pm

      Hello Rachel Tang,

      I have a question related with MCH1-CUOBJ_BM that i try to post good movement with BAPI_GOODSMVT_CREATE this field is empty. it is not fillout when i also post good movement with MIGO. Is there any trick 🙂 I estimate that this problem occurs movement that transfer material to material. Such a MATNR and UMMAT is different .

      Then , i run FM –> VB_UPDATE_BATCH , MCH1-CUOBJ_BM is updated.

      Another way –> BMCC tcode is run, MCH1-CUOBJ_BM is updated. (

      1310017 – Field CUOBJ_BM is empty after stock transfer) This oss not for S/4HANA!

       

      You hope that i do not want to prefer these methods. Do you have any idea about it?

      BR

      M.Ozgur Unal

       

      • Like 0
      • Share
        Right click and copy the link to share this comment
      /
      🙂
      Author's profile photo Zar Zar
      Zar Zar
      September 8, 2021 at 8:36 am

      I have one questions if we define as single batch, Can we use movement type 262 for reversal?

      • Like 0
      • Share
        Right click and copy the link to share this comment
      Find us on
      • Privacy
      • Terms of Use
      • Legal Disclosure
      • Copyright
      • Trademark
      • Newsletter
      • Support

      Insert/edit link

      Enter the destination URL

      Or link to existing content

        No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.