MATERIAL and CLASS NUMBER

[Former Member]

Hi all,

Is it possible to get MATERIAL info and CHARATERISTIC VAULES using CLASS NUMBER? I tried some BAPI FMs and also looked at tables like AUSP, KLAH, etc but didnt work out.

I am new to this, any kind of help will be greatly appreciated

Thanks

[Former Member]

hi,

Check the CABN table also.

Regards

Subramanian

[Former Member]

HI,

Welcome to SDN

there is a way if u know the class of the material.

give class in AUSP-KLART field in AUSP table.

collect all OBJEK's and ATINN's for that class.

then go to table INOB, select objek from inob into itab where cuobj = ausp-objek.

INOB-OBJEK gives u a combination of material number and batch number for that material number. ( there might be different batches for one material).

so collect inob-objek and split into matnr and batch.

there u get all materials according to ur characteristic

and also collect those objeks where ur matnr is there.

and regarding to that matnr and batch in MSEG table u can do rest of the stuff....

reward if it helps

Regards

SAB

[Former Member]

hi SAB,

Thanks a lot for your reply.

I did tried ur way but if I understand right the types/values of INOB-CUOBJ and ASUP-OBJECT do not match so it returned no result in my case.

If fact all I have are the CLASS TYPE (KLART), TABLE("MARA") and the last 4 digits of CLASS NUMBER (of type KLAH-CLASS), and I wonder if it is possible to get corresponding MATNR or even Characteristic Values

FM BAPI_OBJCL_GETCLASSES can get CLASS NUMBER using MATNR, but I dont find another FM to do the reverse thing.

Thanks again for all the help above.

[Former Member]

Hi,

Go to AUSP table, pass the material number as the OBJEK.

You will get a list of all the classifications that are assiged.

ATINN is the classification number,

Use this in CAWN to get the ATWRT field.

CABNT has the description.

Always check the tables AUSP, CABN, CAWN and CABNT when your requirement is related to classifications, either material, or equipment or functional location.

Regards

Subramanian

[Former Member]

OK now I am doing it this way:

use CLASS TYPE and CLASS NUMBER to get CLINT from KLAH

use CLINT to get ATINN from KSML

and use this ATINN to get the OBJEK and ATWRT from AUSP.

Please let me know if this if correct....

Thanks

[Former Member]

This is totally wrong but I know how to do this now.

Thanks everyone!

[Former Member]

Hi Rick,

How do you do this?