Skip to Content
  • Community
  • Topics
  • Answers
  • Blogs
  • Events
  • Programs
  • Resources
  • What's New
    • Manage my Account
          • Logout
      • Search
      • Home
      • Community
      • Ask a Question
      • Write a Blog Post
      • Login / Sign-up
      Author's profile photo Rachel Tang
      Rachel Tang
      Posted on August 16, 2013 1 minute read

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

      Follow RSS feed Like
      20 Likes 39,755 Views 9 Comments

      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

      • Alert Moderator

      Assigned tags

      Related Blog Posts

        Related Questions

          /
          Picture1.jpg
          9 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)
            • Author's profile photo Rachel Tang
              Rachel Tang Post author
              January 13, 2015 at 4:54 am

              Good comment.

              • Like(0)
          • Author's profile photo Nancy Guo
            Nancy Guo
            November 7, 2014 at 1:21 am

            Well explained 😆

            • Like(0)
          • 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)
          • 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)
            • Author's profile photo Shanthi Kumar Juluru
              Shanthi Kumar Juluru
              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)
          • Author's profile photo Former Member
            Former Member
            April 30, 2018 at 7:18 pm

            Helpful…!

            • Like(0)
          • 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)
          • 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)
            /
            🙂
          Find us on
          • Privacy
          • Terms of Use
          • Legal Disclosure
          • Copyright
          • Trademark
          • Newsletter
          • Support