on 04-28-2010 7:17 AM
Hi Experts
Is there any database table used to view material wise class name ( class in classification view of the material)?
Pls reply ASAP
Regards
Deepak
Hi
Use KSSK and KLAH tables to find the Classes assigned to a Material.
Feed OBJEK field of KSSK with Material# and get the CLINT (Internal Class number) and search KLAH table with this internal number. CLASS field in KLAH will give you the Classes assigned to this Material.
Bilal Ciftci
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Deepak,
I'm not sure I understood your question - I hope these two tables can help you:
KLAH - Class data
KLAT - Class data - texts
Regards,
Joã
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
1: Thnx for the reply. The Tables you mentioned are quite useful. But i am looking for the table which shows the material no. with the name of the class (e.g. Class "ZSEAT" have material "Seat 12X").
2: The table KLAH shows a unique no. assigned to the class name (e.g. No. 345 for class ZSEAT). How can this no be used to find out the materials assigned to tht particular class.
Thnx in Advance
Deepak
Hello,
I'm not sure that it is possible to link directly the material number to the class. Anyway, you can try this:
- Check table AUSP for your material - field OBJEC will be your material number. This table stores characteristic values for the objects;
- Link AUSP to KSML and you will find the class that the characteristic belongs to;
Please note that in the classification system the key for characteristic is the internal number, not the name you assign to your characteristic. For instance, in AUSP the characteristic is in ATINN .
You might also find the following tables useful, for this or other requirement in the future:
- CABN
- CABNT
- CAWN
- CAWNT
Regards,
Joã
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.