topic Re: Material Characteristics in Application Development and Automation Discussions

Material Characteristics

Murali_Shanmu — Sat, 22 Oct 2005 06:38:12 GMT

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.

Re: Material Characteristics

Former Member — Sat, 22 Oct 2005 06:44:44 GMT

Hi,

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

Sudha

Re: Material Characteristics

Murali_Shanmu — Sat, 22 Oct 2005 06:51:17 GMT

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

Re: Material Characteristics

Former Member — Sat, 22 Oct 2005 07:03:20 GMT

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

Re: Material Characteristics

Murali_Shanmu — Sat, 22 Oct 2005 07:19:30 GMT

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.

Re: Material Characteristics

Former Member — Sat, 22 Oct 2005 07:28:31 GMT

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

Re: Material Characteristics

Murali_Shanmu — Sat, 22 Oct 2005 08:06:36 GMT

I am looking for the values in Classification Tab only.

Re: Material Characteristics

Former Member — Sat, 22 Oct 2005 08:16:05 GMT

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

Re: Material Characteristics

Murali_Shanmu — Sat, 22 Oct 2005 08:46:05 GMT

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.

Re: Material Characteristics

Former Member — Sat, 22 Oct 2005 08:52:10 GMT

Did you convert the MM number into 18-char?

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

Sudha

Re: Material Characteristics

Former Member — Sat, 22 Oct 2005 08:54:02 GMT

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

Re: Material Characteristics

former_member182371 — Sat, 22 Oct 2005 15:57:30 GMT

Hi,

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

Best regards