2007 Feb 08 1:58 AM
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
2007 Feb 08 2:58 AM
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
2007 Feb 08 2:39 AM
2007 Feb 08 2:58 AM
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
2007 Feb 08 5:36 PM
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.
2007 Feb 08 5:54 PM
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
2007 Feb 08 6:32 PM
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
2007 Feb 08 11:57 PM
This is totally wrong but I know how to do this now.
Thanks everyone!
2010 Jul 13 6:28 PM