One of the most used tables in the materials master is the one named MARA.
The MARA table It is one of the most important tables in the Material Master in SAP S/4HANA. This table contains general information about materials, such as their description, unit of measure, weight, volume, and other information. The MARA table also contains information related to material classification, such as material type or commodity class.
To view the table within the SAP system, we have to access it with transaction SE16N
Once inside the transaction, we will have to tell the system which tab we want to view:
At the top, we enter the table name. If we have a display option, we indicate it. Finally, we enter the maximum number of hits we want the system to display. The higher the number, the more searches the system must perform.
By indicating the MARA and pressing Enter, we have enabled the fields that contain the table itself.
You can see that we have green fields (due to parameterization in our system, they can be changed color) and these are called Key fields.
This means that when searching our databases, the first fields we see or the system displays are these key fields, so that it works faster. Therefore, it is recommended to fill in these fields when searching for materials, so that the results can be filtered more quickly and do not affect system performance.
Another option that this transaction gives us is to search with multiple fields, if for example we want to see "n" materials, we will have to press the button on the right and enter the materials that we want to consult in the system:
Field names are identified by two different sources: the field name, Client, Material, Created on..., and the technical name SAP uses for that field.
When we run the search we want, it takes us to another screen so we can view the fields in this way:
We can then export this table to Excel, a file, or anything else in case we need to print it or use it in another way. This SAP feature is very useful for running a business.
We indicate that the MARA table is a standard Dictionary table, it is a table that cannot be modified under any circumstances, since it has multiple implications. The information in this table can be managed by transactions such as SE11 or SE80 but they must be carried out by qualified personnel.
Technically, the data is filled in this way by SAP:
Discover our SAP training
Find out everything on our blog and train in SAP with our Sap S/4Hana Finance Official Certificate.
