C
ClearView News

What is the table name for material master in SAP?

Author

Jessica Burns

Published Mar 16, 2026

What is the table name for material master in SAP?

General Material Data Table: MARA. MARA is the SAP Master data Table for Material.

Accordingly, what is MAKT table in SAP?

MAKT (Material Descriptions) is a standard table in SAP R3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue. Additionally we provide an overview of foreign key relationships, if any, that link MAKT to other SAP tables.

Likewise, how do you display material master in SAP? If you want to add a view to an existing material, you can also use transaction MM01. You only have to fill in the material number, material type and industry sector will be selected automatically. The rest is done just like in material creation: you select the view to be created, and the organisational level.

Besides, what is the table name for plant in SAP?

WERKS_D Data Element. WERKS is a standard field within SAP Table t001w that stores Plant information. Key uniquely identifying a plant.

What are the types of master data in SAP?

SAP MM Material Master Data

  • Material master records.
  • Vendor master records.
  • Purchase info records.
  • Source list records.
  • Quota arrangement records.
  • Service master record.
  • Batch master record.
  • Condition record, etc.

What is ekko table in SAP?

EKKO (Purchasing Document Header) is a standard table in SAP R3 ERP systems. A purchasing document has a header and one or more line items. The header is stored in table EKKO the line items are stored in table EKPO. The two tables can be linked together based on the purchasing document number (field EBELN).

What is Mara table?

MARA (General Material Data) is a standard table in SAP R3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue. Additionally we provide an overview of foreign key relationships, if any, that link MARA to other SAP tables.

What is the use of Mara table in SAP?

MARA is a standard SAP Table which is used to store General Material Data data and is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this Table.

What is Marc in SAP?

MARC (Plant Data for Material) is a standard table in SAP R3 ERP systems. Table MARC contains material master data specific to a given plant. In SAP a plant is an organizational unit that an enterprise according to production, procurement, maintenance, and materials planning aspects.

What is material description?

The textual representation of the material. (

Where can I find material description in SAP?

When you display the material with MM03, will be at the top. Or. SE16 table mara field MTART.

To know the material type:

  1. Press F9 and the type will be displayed in subsequent screen.
  2. Click the i (information button)
  3. The material type description can be always displayed below the command bar.

What is t001w table in SAP?

T001W (Plants/Branches) is a standard table in SAP R3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue. Additionally we provide an overview of foreign key relationships, if any, that link T001W to other SAP tables.

What is plant code in SAP?

In SAP, Plant is an independent, physical and highest organizational unit in MM module. Plant is responsible for planning, procurement, distribution of goods & services to customers or other resources of an organization under one company code.

What is company code in SAP?

The company code is the central organizational unit of external accounting within the SAP System. The business transactions relevant for Financial Accounting are entered, saved, and evaluated at company code level. You usually create a legally independent company in the SAP System with one company code.

How do I find the name of a plant in SAP?

Plant table is T001W,"Plants/Branches. To find the table name select the specific field and then do F1. In F1, select the technical information and there you should find the table name.

What is the storage location table in SAP?

T001L

Where can I find plant code in SAP?

Click on the TCode for more details and click on the Functional Area to see all the tcodes specific to that module/sub-module. plant/Val. Area - Divis.

Where can I find sales org for a plant in SAP?

Navigate to the following path in customizing menu: SPRO > Enterprise Structure > Assignment > Sales and Distribution > Assign sales organization – distribution channel – plant. Next, press F5 on the keyboard or button.

What is the Tcode for material master?

SAP Material Master Transaction Codes
#TCODEDescription
1MMNRDefine material master Number Ranges
2MM01Create material &
3MM02Change material &
4MM03Display material &

What is material master sap?

The material master contains information on all the materials that a company procures or produces, stores, and sells. It is the company's central source for retrieving material-specific data. This information is stored in individual material master records.

What is material master views in SAP?

The Accounting view of SAP MM material master holds specific data about the material value and accounting properties. The Plant Data / Storage 1 and 2 views hold all the data necessary information to manage materials in a warehouse.

How do I change material master data in SAP?

Steps
  1. Start Winshuttle Transaction from the desktop shortcut or from the Windows Start menu.
  2. Click New.
  3. Enter transaction code MM02 in the Transaction Code box, and then click Go.
  4. Click the SAP system that you want to use, and then click OK.

How do you check BOM in SAP?

Use T-code: CS15

To view the parent material, input material code. Select direct checkbox and material BOM. Click the Next button at the top of the screen. In the next window, enter the required quantity.

What is material number in SAP?

For every material that your company uses, you must create a material master record in the material master. This record is uniquely identified by a material number. Instead, the system assigns a consecutive number to the material. This number is visible when you maintain the material master record.

How does SAP calculate material cost?

For product costing in SAP first thing is to check whether the costing has already been done or not. This can be checked in T Code – MM03 – Costing 2 view. If cost estimate amount is coming in this tab then Product is already been costed. If value is coming ZERO then Costing required for that material code.

How do I use mm03?

SAP MM03 – Display Material (Initial Screen)

Enter the material number in the Material field. If you do not know the number, click on the Possible Entries icon to perform a search. Use the information you have (for example, vendor or material name) to find the material number. A list of options will appear.

How do I find the vendor material number in SAP?

What is the table to get the Vendor Material Number for the combination of Material and Vendor in SAP?
  1. EINE - Purchasing Info Record: Purchasing Organization Data.
  2. EINA - Purchasing Info Record: General Data.
  3. LFA1-Vendor Master (General Section)
  4. None of the above.

What is BOM in SAP?

A bill of material (BOM) describes the different components that together create a product. The bill of material contains the item number of each component, quantity required in the manufacture of a product and the unit of measure of the item.

How many types of master data are there?

To give a more comprehensive answer to the question of “what is master data?”, we can look at the 6 types of data typically found in corporations: Unstructured Data: Data found in email, white papers, magazine articles, corporate intranet portals, product specifications, marketing collateral and PDF files.

What is an example of master data?

Typical examples of master data include (sourced from Master Data Management by David Loshin): Customers, Employees, Vendors, Suppliers, Parts, Products, Locations, Contact Mechanisms, Profiles, Accounting Items, Contracts, Policies.

What is master data in ERP?

Master data represents "data about the business entities that provide context for business transactions". This arises, for example, where information about master data entities, such as customers or products, is only contained within transactional data such as orders and receipts and is not housed separately.

What is the Tcode for vendor master in SAP?

SAP Vendor Master Transaction Codes
#TCODEDescription
1BBPGETVDTransfer vendor master
2XK99Mass maintenance, vendor master
3XK01Create vendor (Centrally)
4XK02Change vendor (centrally)

What is condition master data in SAP?

Condition master is a master data from pricing. It represents that actual condition value and is stored in a condition key. Condition master data can be maintained by transaction VK11.

What is vendor master data in SAP?

The vendor master database contains information about the vendors that supply an enterprise. This information is stored in individual vendor master records. A vendor master record contains the vendor's name and address, as well as data such as: The currency used for ordering from the vendor.

Why is master data important in SAP?

Master data is the core data that is essential to operations in a specific business or business unit. Master Data in SAP is the foundation on which transactions are executed. Incorrect or incomplete Master Data is having a direct impact on the processes within companies.

How do you make material master?

SAP SD: Create Material Master Data
  1. In T-Code MM01 "Create Material" Enter industry sector and material type.
  2. Now a screen appear for all view(w) in Tab screen. Select Basic Data1 tab.
  3. Select Sales org 1 Tab screen. Base unit of measure will display.
  4. Select Sales General / Plant tab screen.
  5. click on tab list Icon.
  6. Click on save button.

Continue Reading

What is the best Filipino movie?

Is gold loan a secured loan?

Was ist Surface Connect Anschluss?

What is the table name for material master in SAP?