topic Re: MATERIAL and CLASS NUMBER in Application Development and Automation Discussions

MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 01:58:02 GMT

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

Re: MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 02:39:28 GMT

hi,

Check the CABN table also.

Regards

Subramanian

Re: MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 02:58:08 GMT

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

Re: MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 17:36:10 GMT

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.

Re: MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 17:54:09 GMT

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

Re: MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 18:32:26 GMT

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

Re: MATERIAL and CLASS NUMBER

Former Member — Thu, 08 Feb 2007 23:57:37 GMT

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

Thanks everyone!

Re: MATERIAL and CLASS NUMBER

Former Member — Tue, 13 Jul 2010 17:28:00 GMT

Hi Rick,

How do you do this?