What is Master Data?

Data stored in SAP R/3 is categorized as

  1. Master Data and
  2. Transactional Data.

Master data is the core data that is used as a base for any transaction. If you are producing, transferring stock, selling, purchasing, doing physical inventory, whatever your activity may be, it requires certain master data to be maintained.

Example of Master Data

  • Material master data
  • Customer master data
  • Vendor master data
  • Pricing/conditions master data
  • Warehouse management master data (storage bin master data)

The ones we will focus in MM module are material master and purchase info record.

Material Master: What you should know about material master?

Material in SAP is a logical representation of certain goods or service that is an object of production, sales, purchasing, inventory management etc. It can be a car, a car part, gasoline, transportation service or consulting service, for example.

In All the information for all materials on their potential use and characteristics in SAP are called material master. This is considered to be the most important master data in SAP (there are also customer master data, vendor master data, conditions/pricing master data etc), and all the processing of the materials are influenced by material master. That is why it’s crucial to have a precise and well maintained material master.

In order to be confident in your actions you need to understand material master views and its implications on processes in other modules, business transactions and a few more helpful information like tables that store material master data, transactions for mass material maintenance (for changing certain characteristics for a large number of materials at once).

Material types

In SAP ERP, every material has a characteristic called “material type” which is used throughout the system for various purposes.

Why is it essential to differentiate between material types and what does that characteristic represent?

  1. It can represent a type of origin and usage – like a finished product (produced goods ready for sale), semifinished product (used as a part of a finished product), trading goods (for resale), raw materials (used for production of semifinished and finished products) etc. These are some of the predefined SAP material types among others like food, beverages, service and many others.
  2. We can define our custom material types if any of standard ones doesn’t fulfill our need.

What can be configured on material type level (possible differences between types)?

  1. Material master views: It defines the views associated with a Material Type. For example, if we have a material type “FERT” assigned to our material Product 1000 – we don’t want to have Purchasing based views for that material because we don’t need to purchase our own product – it is configured on material type level.
  2. Default price control: we can set this control to standard or moving average price (covered later in detail), but this can be changed in material master to override the default settings.
  3. Default Item category group: used to determine item category in sales documents. It can be changed in material master to override the default settings.
  4. internal/external purchase orders, special material types indicators, and few more.

So material type is assigned to materials that have the same basic settings for material master views, price control, item category group and few other. Material Type can be assigned during the creation of the material in t-code MM01 (covered in detail later)

Where can we find a complete list of materials with their respective material type?

There are numerous transactions for this. The raw data itself is stored in MARA table

(you can view table contents with t-code SE16 or SE16N – newest version of the transaction), but in some systems these t-codes aren’t allowed for a standard user. In such cases, we can easily acquire the list with t-code MM60 (Material list). MM60 is used particularly often as it displays a lot of basic material characteristics.

Selection screen – you can enter only the material number:

We can see that material 10410446 in plant AR01 is of type FERT (finished product).

Using the toolbar button highlighted on screen, we can export the list of materials we have selected on screen.

Material group

Another characteristic SAP material is assigned during it’s creation is “material group”, which can represent a group or subgroup of materials based on certain criteria.

Which criteria can be used to create material groups?

Any criteria that suit your needs for reporting purposes is right for your system. You may group materials by the type of raw material used to produce it (different kinds of plastics used in the production process), or you can divide all services into consulting services (with different materials for SAP consulting, IT consulting, financial consulting etc), transportation services (internal transport, international transport), you can also group by production technique (materials created by welding, materials created by extrusion, materials created by injection etc). Grouping depends mainly on the approach your management chooses as appropriate, and it’s mainly done during the implementation, rarely changes in a productive environment.

In addition, there is a material hierarchy (used mostly in sales & distribution) that can also be used for grouping, but it’s defined almost always according to sales needs as it is used for defining sales conditions (standard discounts for customers, additional discounts, special offers).

On the other hand, material group is mainly used in PP and MM module.

If you need to display material groups for multiple materials, you can use already mentioned t-code MM60. You just need to select more materials in selection criteria.

Material group is easily subject to mass maintenance via transaction MM17. More on that in the material master editing section.

Introduction to Master Data in SAP
Tagged on:         

31 thoughts on “Introduction to Master Data in SAP

  • Pingback:Overview of SAP MM module – Leijingwei's

  • Pingback:SAP MM (Material Management) Training Tutorial – Leijingwei's

  • 2019-05-03 at 01:23
    Permalink

    I do accept as true with all the ideas you have introduced to your post.
    They are really convincing and will certainly work. Still,
    the posts are very quick for beginners. Could you please extend them
    a bit from subsequent time? Thanks for the post.

    Reply
  • 2019-05-05 at 02:47
    Permalink

    When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each
    time a comment is added I get four emails with the same comment.
    Is there any way you can remove me from that
    service? Thanks!

    Reply
  • 2019-05-06 at 16:15
    Permalink

    Pretty section of content. I simply stumbled upon your weblog and in accession capital to assert that I acquire
    actually loved account your weblog posts. Anyway I’ll be subscribing in your feeds or even I fulfillment you get right of entry to constantly rapidly.

    Reply
  • 2019-05-06 at 17:25
    Permalink

    Hi there! I could have sworn I’ve been to this blog before but after reading through some of the post I
    realized it’s new to me. Nonetheless, I’m definitely delighted I found
    it and I’ll be bookmarking and checking back frequently!

    Reply
  • 2019-05-08 at 21:32
    Permalink

    Wow, marvelous blog layout! How long have you been blogging for?

    you make blogging look easy. The overall look of your web site
    is magnificent, let alone the content!

    Reply
  • 2019-05-08 at 22:08
    Permalink

    Makasi, infonya sangat bermanfaat. Saya pembaca setia di blog
    ini. Kontennya bener-bener joss…

    Reply
  • 2019-05-09 at 05:29
    Permalink

    When someone writes an article he/she retains the image of a
    user in his/her brain that how a user can know it.

    Therefore that’s why this post is outstdanding. Thanks!

    Reply
  • 2019-05-09 at 05:44
    Permalink

    Hello just wanted to give you a quick heads up.
    The words in your content seem to be running off the screen in Opera.
    I’m not sure if this is a formatting issue or something to
    do with web browser compatibility but I thought I’d post
    to let you know. The design look great though! Hope you get
    the issue fixed soon. Kudos

    Reply
  • 2019-05-10 at 04:52
    Permalink

    Hello there, I discovered your site by the use of Google while
    looking for a comparable matter, your site came up, it seems to
    be great. I have bookmarked it in my google bookmarks.
    Hello there, just turned into aware of your blog through Google, and found that it is really informative.
    I am going to be careful for brussels. I will be grateful in case you
    continue this in future. Numerous people shall be benefited out of your writing.

    Cheers!

    Reply
  • 2019-05-10 at 08:00
    Permalink

    I am extremely impressed with your writing
    skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself?

    Either way keep up the excellent quality writing, it’s rare
    to see a nice blog like this one today.

    Reply
  • 2019-05-10 at 17:24
    Permalink

    Mampir disini karena ada temen share postingan ini.
    Dan emang keren, memberi pencerahan min hehe.

    Reply
  • 2019-05-11 at 00:46
    Permalink

    What’s Happening i’m new to this, I stumbled upon this I have
    found It positively helpful and it has aided me out loads.
    I am hoping to contribute & assist different users like its aided me.
    Great job.

    Reply
  • 2019-05-12 at 00:11
    Permalink

    I know this web site offers quality based content and extra information, is there
    any other web page which provides these data
    in quality?

    Reply
  • 2019-05-12 at 21:45
    Permalink

    I do consider all of the concepts you have introduced to your post.
    They are really convincing and will definitely work.

    Nonetheless, the posts are too short for starters. May
    just you please lengthen them a bit from next time?

    Thanks for the post.

    Reply
  • 2019-05-13 at 01:42
    Permalink

    Really no matter if someone doesn’t understand afterward its up to other people that they will help,
    so here it takes place.

    Reply
  • 2019-05-13 at 07:16
    Permalink

    Very nice article, exactly what I was looking for.

    Reply
  • 2019-05-13 at 07:32
    Permalink

    Nice post. I was checking continuously this blog and I’m inspired!
    Very useful information specially the ultimate phase 🙂 I handle such info
    a lot. I used to be seeking this particular info for a very lengthy time.

    Thanks and best of luck.

    Reply
  • 2019-05-14 at 08:09
    Permalink

    Hi there to all, the contents present at this web page
    are truly awesome for people knowledge, well, keep up the nice work fellows.

    Reply
  • 2019-05-15 at 20:03
    Permalink

    Today, I went to the beach with my children. I found
    a sea shell and gave it to my 4 year old daughter and said
    “You can hear the ocean if you put this to your ear.” She placed the shell
    to her ear and screamed. There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

    Reply
  • 2019-05-16 at 17:52
    Permalink

    I love your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you?
    Plz respond as I’m looking to create my own blog and would like to find out where u got this from.
    cheers

    Reply
  • 2019-05-16 at 20:45
    Permalink

    I enjoy what you guys are usually up too. This type of clever work and coverage!
    Keep up the terrific works guys I’ve incorporated you guys to blogroll.

    Reply
  • 2019-05-17 at 09:48
    Permalink

    I have read so many content regarding the
    blogger lovers except this paragraph is really a pleasant paragraph, keep it up.

    Reply
  • 2019-05-17 at 19:20
    Permalink

    My brother recommended I may like this website. He was once
    totally right. This submit actually made my day. You can not imagine simply how so much time I had spent
    for this information! Thank you!

    Reply
  • 2019-05-18 at 02:44
    Permalink

    Pretty nice post. I just stumbled upon your weblog and wished to say that I’ve really
    enjoyed browsing your blog posts. After all I will be subscribing for your feed and I hope you write once more very soon!

    Reply
  • 2019-05-19 at 21:02
    Permalink

    Hey! Do you use Twitter? I’d like to follow you if that would
    be okay. I’m absolutely enjoying your blog and look forward to
    new updates.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *