on 04-01-2010 5:21 AM
Hello
We want to know the chrs assigned in the material . Where we can find the material class -relation , class and chars table .
Any suggestion are welcome.
Thanks,
Nic
Characteristics TCode = CT04
Class TCode = CL02
First you need to make Class, then characteristics, then apply characteristics to Class and apply them in Material Master under Classification view
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Table KSSK will give the details regarding the classes for a material
Get the class number and pass it on to KLAH and get the description
From table AUSP, get the characteristics details for a given material
Pass the characteristics to get the description from CABNT
From the table AUSP get the char.value ID and pass it on to CAWN and get the respective Int Counter value and pass the value to table CAWNT to get the value of each charateristics
Using table INOB- enter material number in OBJEK field, u will get intl.object no(CUOBJ), pass this CUOBJ into table KSSK field OBJEK we will get CLINT
Pass CLINT into table KLAH we will get the class name
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nick,
If you are just lookin for reporting. TCODE is CL30N -Find objects in Classes.
If its Material Class- 001, Pick the class assigned to it and hit "ENTER".
Then Click "Find in Initial Class". You will see the materials assigned to the class.
You have to "Change Layout" in that screen to see all the characteristics assigned to the material.
or
If you working on enhancements and need a logic.
If you know Class and Class Type and Characteristic and are finding the material.
For Class(KLAH-CLASS = XXXXXX), Class Type(KLAH-KLART = XXX), Characteristic(CABN-ATNAM = XXXXX), get
AUSP-OBJEK which is equal to MARA-MATNR.
Where CABN-CLINT=KLAH-CLINT,
CABN-ATINN=AUSP- ATINN,
CABN-ADZHL=AUSP-ADZHL
Cheers,
Shekhar Ramineni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
7 | |
7 | |
6 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.