Material Characteristics

[Murali_Shanmu]

Hi

I have already posted this doubt. In MM03 if i go to Material Classification, i get a list of description based on the Class. Now as an ABAPer i need to get the Description. I dont know the Tables.

I used the FM 'QMSP_MATERIAL_BATCH_CLASS_READ' to get the Class of a Material by passing the material. Now how do i get the Characteristics description from the tables.

Please let me know.

[Former Member]

Hi,

You can try the BAPI_CHARACT_GETDETAIL. Pass it the characteristic name, and it will get you the corresponding details.

Sudha

[Murali_Shanmu]

My question is from where do i get Characteristic details using the Class of a Material. Pls help

[Former Member]

If you want the select for these values, try this:

SELECT p~objek

n~atnam

p~atwrt

n~atinn

FROM ausp AS p

INNER JOIN cabn AS n

ON p_{atinn = n}atinn AND

p_{adzhl = n}adzhl

INTO TABLE itab

WHERE p~objek = <Material number> AND

p~mafid = <Class/Object indicator> AND

p~klart = <Class> AND

n~atnam = <Material characterstic>.

Pass the Material number to OBJEK, and the indicator for Class/Object (field MAFID in table AUSP)to MAFID.

KLART specifies which class the characteristic belongs to (Material, Equipment, etc). This can be got from table TCLA.

ATNAM is the name of the charateristic you want the description for.

Sudha

[Murali_Shanmu]

Thanks Sudha Mohan. I am able to see the Characteristic Desc ription for say material R90061. But when i go to AUSp table i am not able to see R90061 in the field OBJEK.

Should i look in some other table.

[Former Member]

Are you talking abt the values that you see in the tab 'Classification' in MM02?

If not, can you please describe how you are seeing the charateristic description for the material?

Or are you looking for the description of the Class itself? In that case, you can go to table KLAH and give the name of the class in the CLASS field.

Sudha

Message was edited by: Sudha Mohan

[Murali_Shanmu]

I am looking for the values in Classification Tab only.

[Former Member]

Can you give me some more details? Try this:

Go to the KLAH table and ensure that the Class exists there.

Then check in CABN for the characteristic (field CABN) and ensure that exists too.

If you able to see the characteristics using MM02, it should exist in AUSP. MAke sure that the material number you enter for selection is converted internally (ie, material 100 should be given as 000000000000000100 - 18 chars).

Sudha

[Murali_Shanmu]

Data does exist in CABN and KALH table for Characteristics and Class respectively. Thats fine. I checked the AUSP table thoroughly. I am not having that material entry out there. I am new to ABAP and that why i am struggling here for this.

[Former Member]

Did you convert the MM number into 18-char?

That seems to be only thing I can think of..

Sudha

[Former Member]

Hi,

Use function CLFM_SELECT_AUSP to read AUSP data for a material..

DATA: t_ausp LIKE ausp OCCURS 0 WITH HEADER LINE.

CALL FUNCTION 'CLFM_SELECT_AUSP'

EXPORTING

mafid = 'O'

classtype = '001' "For Materials

object = <Your Material Here>

• FEATURE =

• CLEAR_BUFFER = ' '

• KEY_DATE =

• WITH_CHANGE_NUMBER = ' '

• TABLE =

• I_ATZHL_SAME_INI = ' '

• I_AENNR = ' '

TABLES

EXP_AUSP = t_ausp[]

EXCEPTIONS

NO_VALUES = 1

OTHERS = 2.

IF sy-subrc EQ 1.

****No Characteristic Values for the Material

ELSE.

ENDIF.

Also if you want the description of a characteristic then you can get it from CABNT..

ATINN = Internal characteristic number, SPRAS = sy-langu,

ATBEZ is the characteristic description..

Also, AUSP will contain values only if they are maintained in the classification tab of the material,

If just characteristics are visible with no values that means no entries in AUSP..

Hope this helps..

Sri

Message was edited by: Srikanth Pinnamaneni

Message was edited by: Srikanth Pinnamaneni

[former_member182371]

Hi,

please do have a look at FM '<b>CLAF_OBJECTS_OF_CLASS</b>'

Best regards