2009 Apr 22 6:51 AM
Hi,
I have a requirement that i want to know about the tables containing the Material Classification Data (in MM03) and its linking with material
please help me to solve this
Regards
Nausal
Thanks for All
2009 Apr 22 6:55 AM
HI Nausal,
check with the table AUSP with the filed ATINN and ATNAM.
and also check with the FM CLAF_CLASSIFICATION_OF_OBJECTS,
pass material number to 'OBJECT'
and OBJECTTABLE = 'MARA'
Thanks!
2009 Apr 22 7:00 AM
hi,
For every classified material, there is a field CUOBF in MARA pass this field into FM "VC_I_GET_CONFIGURATION_IBASE' u ll get all the characteristics value
Regards
Varun
2009 Apr 22 7:01 AM
Hi,
check in table.
kssk
pass material number in objek.
Rgds
Siva.
Edited by: siva prasad on Apr 22, 2009 8:03 AM
2009 Apr 22 7:11 AM
2009 Apr 22 7:12 AM
Hi Nausal,
Check my Program which gets Classification texts-In Original language and sy-langu...
Also Classification Details.
TYPES : BEGIN OF TY_KLAH ,
CLASS TYPE KLAH-CLASS,
KLART TYPE KSSK-KLART,
CLINT TYPE KSSK-CLINT,
END OF TY_KLAH.
TYPES : BEGIN OF TY_SWOR ,
CLINT TYPE SWOR-CLINT,
SPRAS TYPE SWOR-SPRAS,
KLPOS TYPE SWOR-KLPOS,
KSCHL TYPE SWOR-KSCHL,
END OF TY_SWOR.
DATA: BEGIN OF T_TEMP OCCURS 0,
CLASS LIKE KLAH-CLASS, "Class number
KLART LIKE KLAH-KLART, "Class type
CLINT LIKE KLAH-CLINT, "Internal class number
END OF T_TEMP.
DATA : IT_SWOR TYPE TABLE OF TY_SWOR, WA_SWOR LIKE LINE OF IT_SWOR.
DATA : IT_KLAH TYPE TABLE OF TY_KLAH, WA_KLAH LIKE LINE OF IT_KLAH.
Get the classification details KSSK and KLAH.
SELECT SINGLE SCLASS SKLART L~CLINT INTO
(T_TEMP-CLASS, T_TEMP-KLART, T_TEMP-CLINT)
FROM KSSK AS L INNER JOIN KLAH AS S ON SCLINT EQ LCLINT
WHERE L~OBJEK EQ MATNR .
CLEAR :IT_TEXT[],WA_TEXT.
retrieve characteristics info of a class
SELECT * FROM KSML WHERE CLINT = T_TEMP-CLINT
AND KLART = T_TEMP-KLART.
retrieve characteristics value info
SELECT * FROM AUSP WHERE OBJEK = MATNR
AND ATINN = KSML-IMERK
AND KLART = KSML-KLART.
retrieve characteristics info
SELECT SINGLE * FROM CABN WHERE ATINN = AUSP-ATINN.
MOVE CABN-ATNAM TO WA_TEXT-ATNAM. "Characteristics desc.
MOVE AUSP-ATWRT TO WA_TEXT-ATWRT. "Characteristics Value
MOVE CABN-ATINN TO WA_TEXT-ATINN.
APPEND WA_TEXT TO IT_TEXT.
CLEAR: WA_TEXT.
ENDSELECT. "ausp
ENDSELECT.
DELETE IT_TEXT WHERE ATWRT IS INITIAL.
LOOP AT IT_TEXT INTO WA_TEXT.
SELECT SINGLE ATBEZ INTO WA_TEXT-ATBEZ FROM CABNT
WHERE ATINN = WA_TEXT-ATINN AND SPRAS = 'EN' . "SY-LANGU.
MODIFY IT_TEXT FROM WA_TEXT.
CLEAR WA_TEXT.
ENDLOOP.
IT_TEXT Contains Your requirement.
Thanks & Regards,
Dileep .C
2009 Apr 22 12:02 PM
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |