Material Characteristics

[Former Member]

Hi,

I have class details & batch no. of a material.But i am not getting characteristics values of each material.

Which table contains these information.How can i relate class with characteristics?

[Former Member]

MARA or MM03

[Former Member]

hi

i didnt get wat data ur asking abt meterial

try mseg, mkpf, mara, marc, mard, makt

these are the main tables for materials

shiva

[Former Member]

AUSP and CABN

eg,

TYPES: BEGIN OF tp_kssk_klah,

objek LIKE kssk-objek, " Key of object to be classified

mafid LIKE kssk-mafid, " Indicator: Object/Class

klart LIKE kssk-klart, " Class Type

clint LIKE kssk-clint, " Internal Class Number

adzhl LIKE kssk-adzhl, " Internal counter for archiving objects via engin. chg. mgmt

aennr LIKE kssk-aennr, " Change Number

class LIKE klah-class, " Class number

END OF tp_kssk_klah.

TYPES: BEGIN OF tp_kssk_ksml,

objek TYPE kssk-objek,

klart TYPE kssk-klart,

clint TYPE kssk-clint,

atnam TYPE cabn-atnam,

mafid TYPE kssk-mafid,

posnr TYPE ksml-posnr,

adzhl TYPE kssk-adzhl,

imerk TYPE ksml-imerk,

END OF tp_kssk_ksml.

DATA : ig_kssk_klah TYPE STANDARD TABLE OF tp_kssk_klah WITH HEADER LINE,

ig_kssk_ksml TYPE STANDARD TABLE OF tp_kssk_ksml WITH HEADER LINE.

SELECT a_{objek a}mafid a_{klart a}clint a_{adzhl a}aennr

b~class

INTO TABLE fp_ig_kssk_klah

FROM kssk AS a JOIN klah AS b

ON a_{klart EQ b}klart

AND a_{clint EQ b}clint

FOR ALL ENTRIES IN it_matnr

WHERE a~objek EQ it_matnr-matnr

AND b~klart IN s_klart

AND b~class IN s_class.

SELECT a_{objek a}klart a_{clint c}atnam a_{mafid b}posnr a_{adzhl b}imerk

INTO TABLE fp_ig_kssk_ksml

FROM kssk AS a JOIN ksml AS b

ON a_{clint EQ b}clint

AND a_{klart EQ b}klart

JOIN cabn AS c

ON b_{imerk EQ c}atinn

FOR ALL ENTRIES IN fp_ig_kssk_klah

WHERE objek EQ fp_ig_kssk_klah-objek

AND a~clint EQ fp_ig_kssk_klah-clint

AND a~klart IN s_klart.

[Former Member]

Use the function module VC_I_GET_CONFIGURATION.

Find the below example prog. which give you an idea of how to use the Fn module VC_I_GET_CONFIGURATION.

v_config = wa_vbap-cuobj.
if v_config is not initial.
	CALL FUNCTION 'VC_I_GET_CONFIGURATION'
	 EXPORTING
	  INSTANCE = v_config
	 TABLES
	  CONFIGURATION = i_configuration.
               IF SY-SUBRC <> 0.
                * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
                * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
              ENDIF.
loop at i_configuration into wa_configuration.
	if wa_configuration-ATNAM = 'A_THICK_MM'.
		v_thick = wa_configuration-atwtb.
	endif.
	if wa_configuration-ATNAM = 'A_WIDTH_MM'.
		v_width = wa_configuration-atwtb.
	endif.
endloop.
endif.

[Former Member]

Hi

From Table aufm get charg as batch no. then get atinn from table ausp. then pass atinn in table cawn get atwrt as charecteristic value.

It will be helpfull.

Regards

Srimanta

[Former Member]

Hi,

I am getting the field OBJEK from table KSSK.but it is displayed in number.How can i convert to text to see the value?

[Former Member]

Thanks