0% found this document useful (0 votes)
16 views17 pages

SAP MM Tables Overview and Descriptions

Uploaded by

shruti
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
0% found this document useful (0 votes)
16 views17 pages

SAP MM Tables Overview and Descriptions

Uploaded by

shruti
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 MM TABLES

[Link] Master Tables

SR NO. Table Name Description

IL
1 MARA General Material Data

H
2 MAKT Material Descriptions

A
S WAR
3 MARM Units of Measure for Material

4 MARC Plant Data for Material

BE
5 MBEW Material Valuation

A B
6 MVKE Sales Data for Material

P
7 MLAN Tax Classification for Material

8 MPOP Forecast Parameters

9 MLGN Warehouse Number Data

10 MLGT Storage Type Data for Material

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
2. Vendor Master Tables

SR NO. Table Name Description

IL
1 LFA1 Vendor Master (General Data)

AH
2 LFB1 Vendor Master (Company Code Data)

S WAR
3 LFM1 Vendor Master (Purchasing Data)

E
4 LFBK Vendor Bank Details

B
5 LFC1 Vendor Transaction Figures

PA B
Like , Comment & Follow SAHIL PABBEWAR
sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
3. Purchasing Tables

SR NO. Table Name Description

IL
1 EKKO Purchasing Document Header

AH
2 EKPO Purchasing Document Item

S WAR
3 EKBE History per Purchasing Document

4 EKET Schedule Lines for Purchasing Document

BE
5 EKKN Account Assignment in Purchasing Document

A B
6 EINE Purchasing Info Record (Org. Data)

P
7 EINA Purchasing Info Record (General Data)

8 T024 Purchasing Groups

9 T024E Purchasing Organizations

10 EBAN Purchase Requisition Header

11 EBKN Purchase Requisition Account Assignment

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
4. Inventory Management Tables

SR NO. Table Name Description

H IL
1 MKPF Material Document Header

A
S WAR
2 MSEG Material Document Items

3 MARD Storage Location Data for Material

E
4 MCHB Batch Stocks

B B
5 MSSL Total Special Stocks for Material

PA
6 MSLB Valuated Special Stock with Vendor

7 MSKU Special Stocks with Customer

8 MSKA Sales Order Stock

9 RESB Reservation/dependent requirements

10 T159N IM Print Settings

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
5. Valuation and Account Determination

SR
Table Name Description

L
NO.

H I
1 MBEWH Material Valuation History

A
2 T025 Valuation Classes

S WAR
3 T030 Standard Accounts Table

E
4 T159L Inventory Management - Stock Types

B B
5 BSIM Secondary Index: Documents for Material

PA
6. Source Determination & Info Records

SR NO. Table Name Description

1 EORD Source List

2 EIPA Info Record: Plant-Specific Data

Info Record (obsolete, replaced by


3 INFREC
EINA/EINE)

4 A017 Vendor/Material Conditions

5 A018 Vendor-Material-Plant

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
7. Invoice Verification Tables

SR NO. Table Name Description

IL
1 RBKP Invoice Document Header

AH
S WAR
2 RSEG Invoice Document Items

3 RBVD Invoice Verification Tax Data

BE
8. Service Procurement

A B
SR Table Name Description

P
NO.

1 ASMD Service Master

2 ESLL Service Line Data

3 ESLH Service Package Header

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
9. Batch Management Tables

SR NO. Table Name Description

IL
1 MCH1 Batch Master (General Data)

AH
S WAR
2 MCHA Batches

3 MCHB Batch Stocks

B BE
10. Material Requirements Planning (MRP)

A
P
SR NO. Table Name Description

1 MDKP Header Data for MRP Document

2 MDTB MRP Table

3 MDTB_NEW MRP Table (S/4HANA optimized)

4 T439A Control Parameters for MRP

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
11. Pricing Conditions Tables

SR NO. Table Name Description

IL
1 KONV Conditions (Transaction Data)

AH
S WAR
2 A016 Info Record Conditions

3 A017 Vendor/Material Conditions

E
4 A018 Vendor/Material/Plant

A B B
12. Customizing & Configuration Tables

P
SR NO.

1
Table Name

T161
Description

Purchasing Document Types

2 T163 Item Categories in Purchasing

3 T162 Field Selection for Purchasing Document

4 T160 Control Data for Purchasing

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
13. Warehouse Management (if integrated with MM)

SR NO. Table Name Description

IL
1 LAGP Storage Bin Master

AH
2 LQUA Quants in Storage Bin

S WAR
3 LTAK Transfer Order Header

E
4 LTAP Transfer Order Items

B B
14. CDS Views / New Data Models (S/4HANA Specific)

PA
SR NO.

1
Table/View Name

I_MATERIAL
Description

CDS View: Material Master

2 I_MATERIALSTOCK CDS View: Material Stock

3 I_PURCHASEORDER CDS View: Purchase Order Header

4 I_PURCHASEORDERITEM CDS View: Purchase Order Items

5 I_BATCH CDS View: Batch Data

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
SR NO. Table Name Description

1 MARA General Material Data

IL
2 MAKT Material Descriptions

AH
3 MARC Plant Data for Material

S WAR
4 MARD Storage Location Data for Material

5 MBEW Material Valuation

BE
6 MKPF Material Document Header

A B
7 MSEG Material Document Segment

P
8 EBAN Purchase Requisition

9 EKKO Purchasing Document Header

10 EKPO Purchasing Document Item

11 EKBE History per Purchasing Document

12 EKET Scheduling Agreement Schedule Lines

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
Purchasing Info Record: Purchasing Organization
13 EINE
Data

L
14 EINA Purchasing Info Record: General Data

H I
15 EKKN Account Assignment in Purchasing Document

A
S WAR
16 EKUB Index for Stock Transport Orders for Material

17 EKPV Shipping Data for Purchasing Document

BE
18 EKES Confirmation of Scheduling Agreement

A B
19 RESB Reservation/dependent requirements

P
20 T024 Purchasing Groups

21 T024E Purchasing Organizations

22 T161 Purchasing Document Types

23 T161T Texts for Purchasing Document Types

24 T163 Item Categories in Purchasing Document

25 T163T Texts for Item Categories

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
26 T149 Valuation Types

27 T149T Valuation Type Descriptions

H IL
28 T001W Plants/Branches

A
S WAR
29 T001L Storage Locations

30 LFA1 Vendor Master (General Section)

BE
31 LFB1 Vendor Master (Company Code)

A B
32 LFM1 Vendor Master (Purchasing Organization)

P
33 T006 Units of Measure

34 T023 Material Groups

35 T023T Material Group Descriptions

36 T134 Material Types

37 T134T Material Type Descriptions

38 MLGN Material Master: WM Inventory

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
39 MLGT Material Master: WM Inventory Type

40 T156 Movement Type

IL
41 T156T Movement Type Descriptions

AH
42 MVER Material Consumption

S WAR
43 MVKE Sales Data for Material

E
44 MLAN Tax Classification for Material

B
45 MPOP Forecast Parameters

A B
46 T438M Control Parameters for MRP

P
47 T438T MRP Description

48 MAST Material to BOM Link

49 STPO BOM item

50 STKO BOM Header

51 QBEW Project Stock Valuation

52 OBEW Sales Order Stock Valuation

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
53 VISE Vendor Info Record History

54 VIBDPR Condition Contract Determination

IL
55 VIBDBILL Settlement Document Header

AH
S WAR
56 VIBDHEAD Condition Contract Header

57 MCHB Batch Stocks

E
58 MCHA Batches

B B
59 T159L Inventory Management: Display Rules

PA
60 T159N Invent. Mgmt Print Control

61 T159P Parameters for Inventory Management

62 T159Q Inventory Management Print Functions

63 T159R Inventory Mgmt: Reasons for Movement

64 T159T Inv. Mgmt: Text Table for Movement Reasons

65 T134K Configurable Material Types

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
66 T137 Industries for Material Master

67 T137T Industry Descriptions

H IL
68 T001K Valuation Area

A
S WAR
69 T030 Automatic Postings

70 T024D Purchasing Group Descriptions

BE
71 T024L Storage Location Descriptions

A B
72 T438A Control Table for MRP

P
73 T439A Control Profile for MRP

74 T440P Forecast Profile

75 T441T Forecast Model Descriptions

76 T460A Special Procurement Key

77 T460C Special Procurement Type Descriptions

78 T460D Order Type Dependent Parameters

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
79 T460T Order Type Descriptions

80 T461S Planning Strategies

IL
81 T461T Planning Strategy Descriptions

AH
82 T024Z MRP Controller

S WAR
83 T438S MRP Group

84 T438X Control Parameters for MRP

BE
85 T457T Description of MRP Groups

A B
86 T457A MRP Group Data

P
87 T438U Control Table for Material Type and MRP

88 T024E_T Purchasing Organization Texts

89 T460F MRP Types

90 T024W Storage Location Control

91 T458A MRP Type Parameters

92 T458B Descriptions of MRP Types

93 T459A Reorder Point Planning

Like , Comment & Follow SAHIL PABBEWAR


sahil27pab@[Link] I +91-8408051323 I [Link]
SAP MM TABLES
94 T459K Planning Types

L
95 T459S MRP Planning File Entries

H I
96 T460W MRP Lot-Sizing Procedure

A
S WAR
97 T460X Text for Lot-Sizing Procedure

98 T023Z Material Group Hierarchies

BE
99 T132 Screen Sequences

PA B
100 T132T Screen Sequence Descriptions

Like , Comment & Follow SAHIL PABBEWAR


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

You might also like