Thursday, July 8, 2010

SAP MM Important Tables

Related to Materials:
MARA - Material Master: General data
MAKT - Material Master: Description
MARM - Material Master: Unit of Measure
MAPE - Material master: Export control file 
MARC - Material master: Plant data
MARD - Material master: Storage location 
MAST - Material link to BOM
MBEW - Material valuation
MLGN – Material Master: WM Inventory
MLGT – Material Master: WM Inventory type
MDIP - Material: MRP profiles (field contents) 
MKOP - Consignment price segment (old versions of SAP)
EBEW - Valuation of sales order stock
QBEW - Valuation of project stock
MVER – Material Master: Consumption
DVER – Material Master: Consumption
MVKE – Material Master: Sales
MLAN - Material Master: Tax indicator
MARC - Material Master: Plant data
MAPR – Material Master: Forecast
MARD – Material Master: Storage Location
MCH1 – Material Master: X Plant Batches
MCHA – Material Master: Batches
MCHB – Material Master: Batch Stock
MDMA - MRP Area data
DBVM - MRP Planning File Entry: MRP Area
MOFF - Outstanding Material Master Records (Maintenance status)

MARCH - Material Master C Segment: History
MARDH - Material Master Storage Location Segment: History
MBEWH - Material Valuation: History
MCHBH - Batch Stocks: History
MKOLH - Special Stocks from Vendor: History
MSCAH - Sales Order Stock at Vendor: History
MSKAH - Sales Order Stock: History
MSKUH - Special Stocks at Customer: History
MSLBH - Special Stocks at Vendor: History
MSPRH - Project Stock: History
MSSAH - Total Sales Order Stocks: History
MSSQH - Total Project Stocks: History
MOFF - Outstanding Material Master Records (Views not yet extended)
MSTA - Material Master Status (Views maintained)

Related to 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)
ADR 2 - ADR 6 (Address and Phone details)
WYT1 - Vendor Subrange

Related to Purchasing:
EBAN - Purchase requisition: items
EBKN - Purchase Requisition: account assignment 
STXH - SAPScript Text Header
STXL - SAPScript Text Lines
EKKO - Purchasing document header 
EKPO - Purchasing Document: Item
EKES - Purchasing Document: Confirmations
EKET - Purchasing Document: Delivery Schedules
MDBS - Material View of Order Item/Schedule Line (good to find open PO's)
EKKN - Account assignment in purchasing document 
EORD - Purchasing Source List
EIPA - Order price history record 
EKAB - Release documentation 
EKBE - Purchasing document history 
EKBZ - Purchasing document history: delivery costs 
EKET - Scheduling Agreement Schedule Lines
EKPB - "Material to be provided" item in purchasing document 
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 - External services management: Unplanned limits for contract item 
ESUH - External services management: unplanned service limits header data 
ESUP - External services management: unplanned limits for service packages 
ESUS - External services management: Unplanned limits for service types
EINA - Purchase Info Record: General
EINE - Purchasing info record: purchasing organization data 
KONP - Condition Item
KONH - Condition Header

Related to Inventory Management:
IKPF - PI Header
ISEG - Physical inventory document items
MKPF - Material document: Header
MSEG - Material document: item
RKPF - Reservation: Header
RESB - Reservation: Item

Related to 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 (monthly)
RBCO - 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 invoice verification)
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
EKRS - ERS Procedure: Goods to be invoiced

Related to Customising and Other Master Data:
MDLV - MRP Areas
MDLG - MRP Areas - Storage Locations
MDLW - MRP Areas - Plants
MDLL - MRP Areas - Subcontractor
T023 - Material Groups
T024 - Purchasing groups
T030 - Standard Accounts Table (Automatic Account Determination)
T156 - Movement Type
T156T - Movement Type: Text
AUSP - Release Procedure: Strategy values (cl20n, cl24n)
AGR_USERS - Assignment of roles to users
CDHDR & CDPOS - Change history of master data and documents
EDID4 - EDI information
TSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93
TSTCT - Transaction codes TEXT
NAST - Message status

Related to Address
ADRC - Addresses (Business Address Services)
TWLAD - Determination of Address from Plant and Storage Location

Related to Batch Management
MCHA - Batches
MCH1 - Batches (if Batch Management Cross-Plant)
MCHB - Batch Stocks

Related to Serial Numbers
SER00 - General Header Table for Serial Number Management
SER01 - Document Header for Serial Numbers for Delivery
SER02 - Document Header for Serial Nos for Maint.Contract (SD Order)
SER03 - Document Header for Serial Numbers for Goods Movements
SER04 - Document Header for Serial Numbers for Inspection Lot
SER05 - Document Header for Serial Numbers for PP Order
SER06 - Document Header for Serial Numbers for Handling Unit-Content
SER07 - Document Header for Serial Numbers in Physical Inventory
SER08 - Document Header for Purchase Order Item Serial Numbers

Related to Release Strategy
T16FS - Release Strategies
T16FT - Descriptions of Release Strategies
T16FG - Release Groups
CAWN - Characteristic values
CEBAN - Communication Release Strategy Determination: Requisition
CEKKO - Communication Release Strategy Determination Purch. Document

Related to Classification
KSSK - Allocation Table: Object to Class
KLAS - Sort table - internal class number
KSML - Characteristics of a Class
CABN -Characteristic
CAWN - Characteristic values
AUSP - Characteristic Values
INOB - Link between Internal Number and Object

Related to Oil and Gas
VTTK - Shipment Header
OIO_C1_CNTNR - RLM Oil and gas container master data

Related to BOM
STPO - BOM Item Details
STPU - BOM Sub Items (designators)
STKO - BOM Header Details
MAST - BOM Group to Material
STZU - BOM History Records
STAS - BOM Item Selection
STPF - BOM Explosion Structure

Related to Vendor Evaluation
ELBK - Vendor Evaluation: Header Data
ELBM - Vendor Evaluation: Material-Related Item
ELBP - Main Criterion for Vendor Evaluation
T147 Control Table for Vendor Evaluation
T147A Definition for Main Criteria for Vendor Evaluation
T147B Texts for Main Criteria in Vendor Evaluation
T147C Definition for Subcriteria for Vendor Evaluation
T147D Texts for Subcriteria in Vendor Evaluation

T147E Definition of Weighting Keys by Main Criterion
Main table for Calculating the Scores
T147F Description of Weighting Keys in Vendor Evaluation
T147I Definition for Subcriteria for Main Criterion
T147K Vendor Evaluation: Assignment Percentages - Points Scores

Please check the Program in this there are the function modules lsted whcih are used for Score calculations
SAPMM06L - Module Pool: Vendor Evaluation

ML_VENDOR_MATERIAL_RATING
EVAL_SEMIAUTOMATIC_CRITERIA
EVAL_AUTOMATIC_CRITERIA_S013
EVAL_AUTO_INVOICE_VERIFICATION
EVAL_PRICELEVEL_CRITERIA
EVAL_PRICEHISTORY_CRITERIA
EVAL_SEMIAUTOMATIC_CRITERIA
EVAL_AUTOMATIC_CRITERIA_S013
EVAL_AUTO_INVOICE_VERIFICATION
EVAL_PRICELEVEL_CRITERIA
EVAL_PRICEHISTORY_CRITERIA
EVAL_PROTOCOLS

Additionals
S011 - PURCHIS: Purchasing Group Statistics
S012 - Purchasing
S013 - PURCHIS: Statistics for Vendor Evaluation
S031 - Statistics: Movements for current stocks
S032 - Statistics: Current Stock and Grouping Terms
SO33 - Statistics: Movements for Current Stock (Individual Records)
S034 - INVCO: Movements (Batches)
S035 - Statistics: Batch Stocks

2 comments: