Important Tables In Master Data
In this lesson we will cover important tables in master data in sales and distribution module. For this we will split those in categories, customer master data, material master data and customer / material master data tables. They all contain some specific groups of data linked in some way.
In customer master there are several important tables, KNA1 – General Data in Customer Master, KNB1 â€“ Customer master (Company code), KNVK â€“ Customer master Contact Partner, KNVV â€“ Customer master sales data, KNVA â€“ Customer master unloading points, KNVI â€“ Customer master tax indicator, KNVS â€“ Customer master Shipping data, KNVP â€“ Customer master partner functions, KNVD, KNVL, etc.
In material master there are a number of important tables for sales related data. Those are, MARA â€“ General material data, MAKT â€“ Material descriptions, MVKE â€“ Sales data for material, MARC â€“ Plant data for material, MARD â€“ Storage location data for material, MARM â€“ Units of Measure for material, MLAN â€“ Tax classification for material, MBEW â€“ Material valuation, MCHA â€“ Batches and many more.
Table KNMT is used for customer â€“ material info record master data.
You can explore all of these tables by using transaction code SE16 or SE16N (newer version) but in this lesson you will be introduced to the most important tables and their contents.