on 06-24-2008 5:24 AM
Hi Experts,
For reporting purpose I need the table and field which come from MSC3N-CLASSIFICATION-GENERAL-VALUE.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
100 | |
11 | |
10 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.