Find a material classification in SAP



Material classification in SAP

SAP’s Material Master classification view (Fig 1) is very particular.

It does not contain direct values from one or more tables, but it have values from several tables linked together.

Even if the general links are quickly explained online[1], it may be useful to learn how to navigate in these tables, this in order to identify particuliar values, and find out easily these values for a group of materials.

Starting point is of course the classification view (Fig 1) of a material (for example TEST_MAT on classification 001).

By browsing the INOB table, “Link between Internal Number and Object”, via SE16N transaction, lookup data with your material number as value for field OBJEKicon.

You’ll get then a value in CUOBJ. Be careful, this value may be displayed, as it is for me, without leading zeros. In my example, displayed CUOBJ is 92286 (Fig 2), while its real value, necessary for the next step, is 000000000000092286.

To get the real value, you simply have, in SE16N, to export results, and then display them in a spreadsheet (Fig 3). It is now possible to copy the complete CUOBJ value.


Go then in table AUSP (Fig 4), “Characteristic values”, with the value found previously, with which you can fill the OBJEK field.

Take care to fill in the KLART field as well with the classification type, 001 in my exampleicon.

You will get, for your object, values ATINN and ATZHL (Fig 4), that you can then re use in table CAWNT.

Finally, by filling these values in CAWNT (Fig 5), “Value Texts”, you will find values assigned to your material (Fig 6).

Classification view Of Material Master | SAP MM

S/4HANA SAP Materials Management Introduction video training



New Simple As Possible ERP
About the author - New Simple As Possible ERP
He is an international SAP ERP implementation facilitator. He worked more than 10 years in international ERP project management, global supply chain perfection, financial optimization, and SAP ERP project deployment. He made business transformation possible in various industries, such as Logistics, Cosmetics, Consumer Goods, Beauty Care, or Fashion, in many countries around the globe.
 


Comments (11)

 2018-08-19  Terry Kelly
สวัสดีฉันเห็นบทความของคุณและช่วยให้ฉันแก้ปัญหาได้ขอบคุณมาก
 2018-08-19  Michelle White
Ótima informação, obrigado por compartilhar
 2018-08-19  NinjaTrevor
Bonne information, merci pour le partage
 2018-08-19  Brilliantap
Tolle Seite, bitte mach weiter
 2018-08-19  Uyacewa5
私は最終的に解決策を見つけたと信じられない、これは長い時間の悪夢だった今解決された
 2018-08-19  Sautlecat5
این برای من خوب بود، نیازی به نگاه کردن به هیچ چیز دیگری نبود
 2018-08-19  toutsjeG
ਹਾਂ, ਮੈਨੂੰ ਇਸ ਦੀ ਲੋੜ ਸੀ
 2018-08-19  OffenthalI
ਹੈਲੋ, ਮੈਂ ਤੁਹਾਡਾ ਲੇਖ ਦੇਖਿਆ ਅਤੇ ਇਸ ਨੇ ਮੇਰੀ ਸਮੱਸਿਆ ਦਾ ਹੱਲ ਕਰਨ ਵਿੱਚ ਸਹਾਇਤਾ ਕੀਤੀ ਹੈ, ਬਹੁਤ ਧੰਨਵਾਦ
 2018-08-19  CefrascoT
ਧੰਨਵਾਦ ਕਰਨਾ ਨਹੀਂ ਜਾਣਦੇ ਕਿ ਤੁਸੀਂ ਕਿਸ ਤਰ੍ਹਾਂ ਦਾ ਧੰਨਵਾਦ ਕਰਦੇ ਹੋ, ਪਰ ਇਹ ਸ਼ੁੱਧ ਪ੍ਰਤਿਭਾ ਹੈ, ਧੰਨਵਾਦ
MARA-MATNR and INOB-OBJEK were not able to connect in query. Illegal joint conditions. Same goes with INOB-CUOBJ and AUSP-OBJEK.

Leave a comment