‎2007 Jul 25 9:43 AM
Hi all,
can any body help me in which table we can find material characteristics and classification
thanks in advance
‎2007 Jul 25 9:54 AM
Hi,
To find the material classes ,use the table KSSK.Here klart = '001' for material classes.KSSK-OBJEK is the material no.KSSK-CLINT is the internal class no which you have to pass in table KLAH to get he class detais. To get characteristics use the tables CABN,KSML.
‎2007 Jul 25 9:48 AM
Hi Siva,
Look at table AUSP which shows the characteristics values for an object. The object ID is the material number. you may need to fill in with leading zeros up to the full 18 bytes of the material number field. Also look at supporting tables CAWN, CAWNT, and CABN.
Thanks,
Reward If Helpful.
‎2007 Jul 25 9:54 AM
Hi,
To find the material classes ,use the table KSSK.Here klart = '001' for material classes.KSSK-OBJEK is the material no.KSSK-CLINT is the internal class no which you have to pass in table KLAH to get he class detais. To get characteristics use the tables CABN,KSML.
‎2007 Jul 25 10:07 AM
Hi,
you find these in MARA table:
MTART---- Material type
MATKL---- Material group
<b><i>regards
Debjani
Rewards point for helpful answer</i></b>
‎2007 Jul 25 10:13 AM
Hi
AUSP table stores the Material Characteristic Values
classification data check the following tables
KLAH,KSSK,KSML,CABN,CAWN and CAWNT
better to use the following bapi or fun module to fetch them
BAPI_OBJCL_GETDETAIL
or use the fun module:
CLAF_CLASSIFICATION_OF_OBJECTS.
<b>Reward points for useful Answers</b>
Regards
Anji
‎2010 Jan 28 2:38 PM
Hello,
Is there any way I can join material doc.master tables (MKPF, MSEG,MARA etc) with AUSP and other characteristics table.
Idea is to collect the 201 movements and analysis the Charaterisitcs. I have created few thickness specific characterisitics and want to know the total consumption against each characteristics.
Please suggest.
regards,
JPS
‎2010 Jan 28 5:51 PM