Skip to Content
0
Former Member
Nov 12, 2012 at 10:57 AM

Extract Classification Data from Mara

312 Views

Hi I've literally just joined the SAP community and I'm desperately trying to find a solution quickly so please excuse my lack of protocol.

I''m trying to retrieve the classification data for specific part numbers found in Mara.

My end goal will be to use vba to extract the data using a rather nifty db I've already built.

I've found numerous posts on the subject but nothing that has provided a result. Let me explain why.

First I'll define where the data is in SAP.

I go into zpp02

Enter the material Number: 049382268

Specify Classification from the views

Class Type is YHW

Class: ZKAAA123

I have 3 tabs underneath, General, Technic, TecDoc

Tecnic has a list of classification values. It's this data I'm trying to retrieve.

I know that MARA contains the part numbers.

I've also found data in a number of other tables should allow me to extract what I'm after. Namely INOB, KSSK AUSP

However....

Lets say I'm after a material MATNR = 000123450-0000-00

Table:INOB - The MATNR is blank.

All other references to fields seem to store Int Class Number, Class No and numerous other fields that never let me link back the the MATNR no.

All help appreciated.

Thanks

Darren