Application Development and Automation 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: 
Read only

MATERIAL and CLASS NUMBER

Former Member
0 Kudos
2,921

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
Read only

Former Member
0 Kudos
1,195

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
Read only

Former Member
0 Kudos
1,195

hi,

Check the CABN table also.

Regards

Subramanian

Read only

Former Member
0 Kudos
1,196

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

Read only

0 Kudos
1,195

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.

Read only

0 Kudos
1,195

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

Read only

Former Member
0 Kudos
1,195

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

Read only

0 Kudos
1,195

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

Thanks everyone!

Read only

0 Kudos
1,195

Hi Rick,

How do you do this?