cancel
Showing results for 
Search instead for 
Did you mean: 

table

Former Member
0 Kudos

Hi Experts,

For reporting purpose I need the table and field which come from MSC3N-CLASSIFICATION-GENERAL-VALUE.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member1345686
Active Participant
0 Kudos

Hi Shabir,

Instead of tables, please use the function CLAF_CLASSIFICATION_OF_OBJECTS .

If you want to retrieve information for class 022, then use the following input sample :

CLASS = 'FG_BATCH_ML'

CLASSTEXT 'X'

CLASSTYPE '022'

FEATURES 'X'

LANGUAGE 'EN'

OBJECT '00000000003000074374563A7137' OBJECTTABLE

Where Object is concatenation of Material Number, Plant and Batch No .

The tables related is either KSSK or AUSP or KSSKAUSP . But for class type 022 try read table INOB first .

Rgds,

Tuwuh SW

Lakshmipathi
Active Contributor
0 Kudos

Dear Shabir

Table - CAWN - Field - ATWRT. For information, in TCode MSC3N, you cannot create these values. To maintain the Characteristic Value, you have to run CT04. From there only, the value is fetching.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Thanks Lakshmipathi for ur reply but I am not getting any value in ATWRT field which I have maintained.

Lakshmipathi
Active Contributor
0 Kudos

Dear Shabir

Go to CL02, create a class, click on characteristic and input the characteristic value and save. Now go to MSC2N, assign the class in the classification tab and save.

Now check the report.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Dear Lakshmipati,

We have created the characterstic by CT04 and also assigned it to class and class type by CL02. We have also entered the charerstic value in MSC2N against that new characterstic.

But problem is that we are not able to find that charerstic value in CAWN-ATWRT. This field is blank while we have enter the value "210".

So, please reply the table where we can find the charerstic value.

Regards,

shabir

Former Member
0 Kudos

AUSP table.

Former Member
0 Kudos

There is same problem in AUSP table ATWRT fild is blank

while we have entered the value "210".

So, please reply the table where we can find the charerstic value.

Regards,

shabir

AUSP

Former Member
0 Kudos

For the material and batch combination using MCH1 table get the CUOBJ_BM filed value.

Put the value of MCH1-CUOBJ_BM (Internal Object No) in the OBJEK field of AUSP table, The AUSP-ATWRT will return the required value. Also make sure that if more then one characteristics are used then AUSP-ATINN field should be fixed.

Also note that using simple query you can not join MCH1-CUOBJ_BM with AUSP-OBJEK, as they are different "data type" (1st one is numeric and second one is char type). You have to use ABAP coding for this.

Also take the numeric value of the field ATINN. (The value for particular characteristic may differ between production and dev server - Just a possibility)

Using SE16N you can however test the values.