Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

MATERIAL and CLASS NUMBER

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

7 REPLIES 7

Former Member
0 Kudos

hi,

Check the CABN table also.

Regards

Subramanian

Former Member
0 Kudos

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

0 Kudos

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.

0 Kudos

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
0 Kudos

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

0 Kudos

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

Thanks everyone!

0 Kudos

Hi Rick,

How do you do this?