MM Basics for ABAP Consultants Basics of Material Management in SAP, useful t-codes, tables of MM for ABAP Consultants
Creating a Material in SAP Step by step tutorial to create materials in SAP, MM basics for SAP ABAP consultants
Useful T-codes related to material master 1. Change MMR - MM02 2. Display MMR- MM03 3. Materials List - MM60 4. Schedule changes - MM14 5. Display changes -- MM04 6. Change material type - MMAM 7. Mass maintenance - MM17 8. Flag for deletion - MM06 9. Maintain storage locations - MMSC. 10. Extend Material views - MM50
Creating a material in SAP We use MM01 T-code to create a material in SAP, the material contains different views like basic view(Contains material basic information), Sales View(contains sales information), Classification(Characteristic information), Sales General/Plant data(contains sales and plant information), MRP(contains MRP information) etc, based on the material type and the available information the material will be created....In the below example we are going to create a material with basic details, plant details etc. Go to T-code MM01 (Create Material), provide material number, industry sector, material type and press enter.
A pop up will open, select basic data1, basic data2, Sales:general/plant data views and press enter.
Provide plant(list of plants are available in T001W table), Sales Org (list of sales organizations are available in TVKO table), Distribution Channel( all the distribution channels are available in TVTW table) and press enter.
Provide material description(Mandatory), Base Unit of Measure(mandatory) and other optional fields like material group(all material groups are available in T023 table), Division(all divisions are available in TSPA table) etc.
Go to Sales: sales Org. 1 view and enter required fields.
Go to sales text view and provide some sales text (optional)
As per the requirement fill the fields and save, material is created. To display created material Go to MM03, provide material no TESTMAT001, display. To change material go to MM)2, provide material no TESTMAT001, enter, select view to change data.
MM Transaction Codes Below are the t-codes related to Material Management(MM) module in SAP. Content
T-code
MATERIAL MASTER DATA Create Material Master
MM01
Maintaining Material Master
MM02
Display Material Master
MM03
Changing Material Type
MMAM
Flagging a Material for Deletion
MM06
Schedule Material for Deletion
MM16
VENDOR MASTER DATA INVENTORY VENDOR MASTER DATA: Create, Change Display Vendor Master- Centrally/Purchasing and Accounting/Company
XK01/XK02/XK03
NON-INVENTORY VENDOR MASTER DATA: Create a Non-PO related/One time/Employee Vendor Master
FK01
Maintain a Non-PO related / One time/ Employee Vendor Master
FK02
Display a Non-PO related / One time/ Employee Vendor Master
FK03
Invoice Items Release- Block/Unblock
MR02
Create a Non-Inventory PO Vendor Master (Centrally)
XK01
PROCUREMENT MASTER DATA
Content
T-code
SOURCE LIST: Create /Display / Maintain /Delete Source List
ME01
PURCHASING INFO. RECORDS: Create / Change / Display Info Records
ME11
PROCUREMENT Display Purchase Req. with ref to Mat Master
ME53
Create Purchase Order
ME21
Change Purchase Order
ME22
Print PO for Stock Item
ME90
Create/ Change/ Display Shipping Notification
VL31
Execute List Display/Open PO Report
ME2L
Create,Change, Print Purch Requisition w/o Material Master; Assign Sources
ME51/ ME56/ME57
Executing a List Display of Purchase requisition
ME5A
Purchase Req- Collective Release
ME55
Purchase Req- Individual Release
ME54
Display vendor line items
FBL1
Display Reqs by Acct Assignment
ME5K
Create/Change/Display/Print Goods receipt ; perform adjustment; return delivery
MB01/MB02/MB03
Create/ Change/ Display Shipping Notification
VL31/VL32/VL33
Content
T-code
CYCLE COUNT/PHYSICAL INVENTORY: Create cycle count documents
LX26
Print count documents
LI04
Enter counts
LI11/ MI04
Create Recount Request
MI11
Enter Recounts
LI14
Generate List of Qty/Val differences
MI20
Post Differences in WM / IM
LI21 / MI07
EXCESS, OBSOLETE, SCRAP: Create/Reverse Financial Reserve
FB01
Change Material Status
MB1B
Scrapping Material
MB1A
INVOICE VERIFICATION Processing Inventory Invoice Receipts
MRHR
Reverse/Cancel Invoice Receipt
MR08
Credit Memo (PO related)
MRHG
Release Blocked Invoices
MR02
MM Tables List of the tables used in MM(Material Management) in SAP, useful t-codes for ABAP consultants related to MM The below are the list of tables related to Material Management(MM) in SAP, which we mostly use
Materials DBVM - MRP Planning File Entry: MRP Area DVER - Material Master: Consumption (MRP Area) EBEW - Valuation of sales order stock MAKT - Material Master: Description MAPE - Material master: Export control file MAPR - Material Master: Forecast MARA - Material Master: General data MARC - Material master: Plant data MARD - Material master: Storage location MARM - Material Master: Unit of Measure MAST - Material link to BOM MBEW - Material valuation MCH1 - Material Master: X Plant Batches MCHA - Material Master: Batches MCHB - Material Master: Batch Stock MDIP - Material: MRP profiles (field contents) MDMA - MRP Area data MKOP - Consignment price segment (old versions of SAP) MLAN - Material Master: Tax indicator MLGN - Material Master: WM Inventory MLGT - Material Master: WM Inventory type MOFF - Outstanding Material Master Records (Maintenance status) MVER - Material Master: Consumption (Plant) MVKE - Material Master: Sales (Sales Org, Distr Ch) QBEW - Valuation of project stock
Vendors LFA1 - Vendor Master: General data LFB1 - Vendor Master: Company data
LFM1 - Vendor Master: Purchasing Data (Purchasing organization) LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range) WYT3 - Vendor Partner Functions
External Service Management ASMD - Service Master: Basic Data ASMDT - Service Short Texts ESKL - Account assignment specification for service line ESKN - Account assignment in service package ESLH - Service package header data ESLL - Lines in service package ESSR - Service entry sheet header data ESUC - MM-SRV: Unplanned limits for contract item ESUH - MM-SRV: unplanned service limits header data ESUP - MM-SRV: unplanned limits for service packages ESUS - MM-SRV: Unplanned limits for service types
Purchasing EBAN - Purchase requisition: items EBKN - Purchase Requisition: account assignment EINA - Purchase Info Record: General EINE - Purchasing info record: purchasing organization data EIPA - Order price history record EKAB - Release documentation EKBE - Purchasing document history EKBZ - Purchasing document history: delivery costs EKET - Purchasing Document: Delivery Schedules EKKN - Account assignment in purchasing document EKKO - Purchasing document header EKPO - Purchasing Document: Item EKPB - Material to be provided item in purchasing document EORD - Purchasing Source List KONH - Condition Header KONP - Condition Item MDBS - Material View of Order Item/Schedule LineSTXH - SAPScript Text Header STXL - SAPScript Text Lines
Inventory Management ISEG - Physical inventory document items MKPF - Material document: Header MSEG - Material document: item RESB - Reservation: Item RKPF - Reservation: Header
Invoice Verification BSIM - Secondary index: documents for material MYMFT - FIFO results table MYML - LIFO material layer MYMLM - LIFO material layer (monthly) MYMP - LIFO period stocks, single material MYMP1 - Receipt data LIFO/FIFO valuation MYPL - LIFO pool layer MYPLM - LIFO pool layer monthlyRBCO - Document item, incoming invoice account assignment RBDIFFKO - Invoice Verification: conditions RBDIFFME - Invoice Verification: quantity differences RBDRSEG - Invoice Verification batch: invoice document items RBKP - Document header: incoming invoice RBKPB - Invoice document header (batch) RBTX - Taxes:incoming invoice RBVD - Invoice document: summarization data RBVDMAT - Invoice Verification: summarization data, material RBWT - Withholding tax:incoming invoice RKWA - Consignment withdrawals RSEG - Document item, incoming invoice
Customizing AGR_USERS - Assignment of roles to users AUSP - Release Procedure: Strategy values (cl20n, cl24n) CDHDR and CDPOS - Change history of master data and documents EDID4 - EDI information MDLG - MRP Areas - Storage Locations MDLL - MRP Areas - Subcontractor MDLV - MRP Areas MDLW - MRP Areas - Plants NAST - Message status
T023 - Material Groups T024 - Purchasing groups T030 - Standard Accounts Table (Automatic Account Determination) T156 - Movement Type T156T - Movement Type: Text T16FC - Release Codes T16FD - Description of Release Codes T16FK - Release Statuses T16FS - Release Strategies T16FT - Descriptions of Release Strategies T16FV - Release Prerequisites TSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93 TSTCT - Transaction codes TEXT