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
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
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
Post authorGood comment.
Well explained 😆
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.
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.
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?
Helpful…!
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