Scribd
Upload
44 views11 pages

SAP S/4 HANA MM Key Tables Overview

The document provides an overview of key tables related to Material Management (MM) in SAP S/4 HANA, detailing their names, descriptions, and key features or fields. It covers various categories including Material Master Data, Vendor Master Data, Purchasing Tables, Inventory Management Tables, and more. Additionally, it notes the transition to S/4HANA-specific changes and the increased use of CDS Views for analytical purposes.

Uploaded by

selectsatya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
44 views11 pages

SAP S/4 HANA MM Key Tables Overview

The document provides an overview of key tables related to Material Management (MM) in SAP S/4 HANA, detailing their names, descriptions, and key features or fields. It covers various categories including Material Master Data, Vendor Master Data, Purchasing Tables, Inventory Management Tables, and more. Additionally, it notes the transition to S/4HANA-specific changes and the increased use of CDS Views for analytical purposes.

Uploaded by

selectsatya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SAP S/4 HANA Material

Management (MM) Key Tables


Table Name Description Key Features / Fields

Material Number (MATNR),


MARA General Material Data

L
Industry Sector (MTART),

I
Base Unit of Measure (MEINS)

H
Material Number (MATNR),
MAKT Material Descriptions

A
Language (SPRAS), Material
Description (MAKTX)

S AR
Material Number (MATNR),
MVKE Sales Data for Material Sales Org (VKORG),

W
Distribution Channel (VTWEG)

E
Material Number (MATNR),

B
MBEW Material Valuation Valuation Area (BWKEY),

B
Valuation Class (BKLAS),
Standard Price (STPRS)

A
Material Number (MATNR),

P
MARC Plant Data for Material Plant (WERKS), Purchasing
Group (EKGRP)
Material Number (MATNR),
MAST Material to BOM Link BOM Usage (STLAN), Plant
(WERKS)
Purchasing Document (EBELN),
EKKO Purchasing Document Header Vendor (LIFNR), Document
Type (BSART), Company Code
(BUKRS)
Purchase Document (EBELN),
Scheduling Agreement Schedule Item (EBELP), Schedule Line
EKET
Lines (ETENR), Delivery Date
(EINDT)

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
Vendor Master (General Vendor (LIFNR), Name,
LFA1
Section) Address, Country (LAND1)

Vendor (LIFNR), Company Code

IL
LFB1 Vendor Master (Company Code) (BUKRS), Reconciliation
Account (HKONT)

A H
Material Doc (MBLNR),

S R
MKPF Material Document Header Document Date (BUDAT),
Posting Date (BLDAT), User

A
(USNAM)
Material Doc (MBLNR),

W
MSEG Material Document Items Movement Type (BWART),

E
Material (MATNR), Quantity

B
(MENGE)
Reservation (RSNUM), Item

B
Reservation / Dependent
RESB (RSPOS), Material (MATNR),
Requirements

A
Plant (WERKS)

P
Purchasing Group (EKGRP),
T024 Purchasing Groups
Description (EKNAM)

Plant (WERKS), Factory


T001W Plants / Branches
Calendar (FABKL), Name

Document Type (BSART),


T161 Purchasing Document Types Description, Number Range
(NUMKR)

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
Item Category (PSTYP),
T163 Item Categories in Purchasing
Description

L
PR Number (BANFN), Item

I
EBAN Purchase Requisition (BNFPO), Material (MATNR),

H
Quantity (MENGE)

SA R
Purchase Requisition Account PR Number (BANFN), Item
EBKN

A
Assignment (BNFPO), Cost Center (KOSTL)

W
Invoice Doc (BELNR), Vendor

E
RBKP Invoice Document Header (LIFNR), Posting Date

B
(BUDAT)

A B
Invoice Doc (BELNR), Item
RSEG Invoice Document Item (BUZEI), Material (MATNR),

P
Quantity, Amount

Purchasing Document (EBELN),


EKPO Purchasing Document Item Item (EBELP), Material
(MATNR), Quantity (MENGE)

Document Number (BELNR),


EKBE History per Purchasing Document Item (BUZEI), Movement Type
(BWART), Quantity (MENGE)

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Material Master Data Tables
Table
Description Key Fields / Features
Name

IL
Material number, material type,
MARA General Material Data

H
industry sector

A
Material number, language,
MAKT Material Descriptions

S R
material description

A
Material number, plant, MRP type,
MARC Plant-specific Data

W
lot size

E
Material number, valuation area,
MBEW Valuation Data

B
valuation class, standard price

B
Material number, sales org,

A
MVKE Sales Data
distribution channel

P
Material Data for Material number, warehouse
MLGN
Warehouse Management number

Material number, warehouse


MLGT WM Inventory Type
number, storage type

Material number, alternative unit


MARM Units of Measure
of measure

International Article Material number, EAN category,


MEAN
Numbers EAN number

Material number, plant, BOM


MAST Link to BOM
usage

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Vendor Master Data Tables
Table Name Description Key Fields / Features

H IL
LIFNR (Vendor), NAME1,
LFA1 Vendor master (general)
LAND1 (Country)

SA R
Vendor master (company LIFNR, BUKRS (Company
LFB1

A
code) Code), ZTERM (Terms)

W
Vendor master LIFNR, EKORG (Purchasing
LFM1
(purchasing org) Org), WAERS (Currency)

🔹
BBE
Purchase Requisition Tables

P A
Table Name

EBAN
Description

Purchase Requisition Header


Key Fields / Features

PR number, item,
material, quantity

PR number, item, cost


EBKN PR Account Assignment
center, GL account

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Purchasing Tables
Table
Description Key Fields / Features

L
Name

I
Purchasing Document PO number, document type, vendor,

H
EKKO
Header company code

SA
PO number, item number, material,

R
EKPO Purchasing Document Item
quantity

A
PO number, material document,

W
EKBE PO History
movement type, quantity

BE
PO number, item, schedule line,
EKET Schedule Lines
delivery date

A B
PO number, item, account
EKKN Account Assignment

P
assignment category, cost center

PO number, item, confirmation


EKES Confirmations
category

PO number, release strategy,


EKAB Release Documentation
release status

T024 Purchasing Groups Purchasing group code, name

T024E Purchasing Organizations Purchasing org code, name

Document type, description,


T161 Document Types
number range

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Request for Quotation / Source List
Table Name Description Key Fields / Features

IL
RFQ number, vendor,

H
EKKO (RFQ) RFQ Document Header
company code

SA R
RFQ number, item,
EKPO (RFQ) RFQ Item
material, quantity

WA
EINA Info Record - General Material, vendor

BE
Info Record - Purchasing
EINE Purchasing org, conditions
Org

A B
Vendor code, name,
LFA1 Vendor Master - General

P
address

Vendor Master - Company Vendor code, company


LFB1
Code code, reconciliation

Vendor Master - Vendor code, purchasing


LFM1
Purchasing org

LFBK Vendor Bank Details Vendor code, bank account

Material, plant, vendor,


EORD Source List
validity

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Inventory Management Tables
Table Name Description Key Fields / Features

IL
Material Document Document number, year, document

H
MKPF
Header date, posting date

SA
MSEG

AR
Material Document
Item
Document number, item, material,
quantity, movement type

E W
MBEW Valuation Material, valuation area, value

A BB
MSKA Sales Order Stock Material, plant, sales order

P
Special Stock -
MSKU Material, plant, vendor
Consignment

Special Stock -
MSKZ Material, plant, WBS element
Project

Material, plant, storage location,


MARD Storage Location Data
quantity

MCHB Batch Stocks Material, batch number, plant, stock

S031 Stock Data Statistics Material, plant, storage location

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Advanced S/4HANA-Specific Tables
Table Name Description Key Fields / Features

IL
BELNR, MATNR,
Universal journal

H
ACDOCA BUKRS, HKONT (GL),
(FI/CO/MM/SD)

A
Quantity

S R
MATDOC Number,

A
Material documents
MATDOC BWART, MATNR,
(S/4 Simplified)
Quantity

E W
Migration status for Tracks data migration

B
FINS_MIG_STATUS
MM/FI for logistics

🔹
P A B
Reservation and Requirement Tables

Table Name Description Key Fields / Features

Reservation number,
RESB Reservation Item
item, material, quantity

Reservation number,
RKPF Reservation Header movement type,
document date

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Condition and Pricing Tables
Table Name Description Key Fields / Features

H IL
A018 Vendor/Material Material, vendor

SA R
A017 Vendor/Purchasing Org Vendor, purchasing org

A
Conditions (Transaction Document number,

W
KONV
Data) condition type, amount

BE
Condition record,
KONP Condition Items
condition type

A B
KOND Condition Table Names Condition table, name

P
🔹 Organizational Tables
Table Name Description Key Fields / Features

T001 Company Codes Company code, name


T001W Plants Plant, name, location

T001L Storage Locations Plant, storage location

Purchasing Org-Plant
T024W Purchasing org, plant
Assignment

T161T Texts for Document Types Document type, description

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP S/4 HANA Material
Management (MM) Key Tables
🔹 Configuration / Customizing Tables
Table Name Description Key Fields / Features

IL
EKGRP (Purch. Group), EKNAM

H
T024 Purchasing groups
(Name)

SA R
Purchasing
T024E EKORG, ORGTX (Description)

A
organizations

W
WERKS, NAME1 (Name),
T001W Plants

E
BWKEY

B
LGORT, WERKS, LGOBE
T001L Storage locations

B
(Description)

A
BSART (Doc Type), FRGGR

P
T161 PO document types
(Release Group)

PSTYP (Item Cat.), TEXT1


T163 Item categories
(Description)

Notes:
S/4HANA-specific changes: Many tables are unchanged in structure from
ECC, but in S/4HANA, there is more reliance on CDS Views and table
simplification.
ACDOCA is used in place of older finance and controlling tables, but MM
still relies heavily on classical tables like MARA, EKKO, and MSEG.
For analytical purposes, CDS Views are increasingly used instead of direct
table access.

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]

You might also like