SAP MM : A Few tables for reference

Material Master Tables

General Material Data – MARA
Material Descriptions – MAKT
Plant Data for Material – MARC
Material Valuation – MBEW
Storage Location Data for Material – MARD
Units of Measure for Material – MARM
Sales Data for Material – MVKE
Forecast Parameters – MPOP
Planning Data – MPGD_MASS
Tax Classification for Material – MLAN
Material Data for Each Warehouse Number – MLGN
Material Data for Each Storage Type – MLGT
Vendor Master Tables:
Description – Table
Vendor Master (General Section) – LFA1
Vendor Master (Company Code) – LFB1
Vendor master (VAT registration numbers general section) – LFAS
Vendor master (dunning data) – LFB5
Vendor Master (Bank Details) – LFBK
Vendor master record (withholding tax types) X – LFBW
Vendor master record purchasing organization data – LFM1
Vendor Master Record: Purchasing Data – LFM2
Vendor Subrange – WYT1
Vendor Sub-Range Description – WYT1T
Partner Functions - WYT3
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
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)

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
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
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:
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
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

Comments

Post a Comment

Popular posts from this blog

MATERIAL YOU MUST STUDY FOR ESTABLISHING YOUR SAP CAREER !!

Image
Important Tips for Interview for SAP SD Let me share some important tips for interview for SAP SD : 1. Please be through with the projects you have mentioned in your resume.  2. Remember all the versions you have worked upon.  3. If your projects are in Indian scenario be thorough with CIN/Excise VAT and pricing procedure.  4  For offshore client specially in Europe and NASA prepare yourself for Warehouse/Lean warehouse  5. Third party billing / Intercompany / Make to order are important topics.  6. Cost booking that is accounting enteries after PGI and Billing should be known to you.  7. Mug up all the determinations.  8. Remember your last ticket.  9. Have general awareness about ALE/EDI/IDOC, as this provides added advantage. (not very tough)  10. Please be through with your basics, the process, the pricing and the master data.  11. People who are thorough with route, transportation, shipping always have an added advantage. The MOST IMPORTANT THING: Do not try to f
Read more

SAP Note 11162 - Invoice split criteria in billing document .

Symptom From a number of deliveries or sales orders more than one billing document is created. Cause and prerequisites The invoice split may have been carried out for the following reasons: a) Explicit setting in Customizing b) Different header partners c) Different header fields d) The billing date of all documents is equated in a data transfer routine (for example, by VBRK-FKDAT = SY-DATUM). This works when you are billing using VF01; a single billing document is generated. However, if you use VF04 or in case of a batch, several billing documents might be generated. Solution Please check the causes mentioned above: 1. Explicit setting in Customizing: On the detail screen of the document flow table (TVCPF) in the entry field 'DATEN VBRK/VBRP' (as of Rel.2.2..: 'Data transfer') the routine '003' (single invoice) was entered and thus an invoice split was created. 2. Different header partners The header partners in the billing documents created
Read more

TAX determination in SD

Define Tax Determination Rules You specify the valid tax types in transaction OVK1. More than one tax type can be defined for a country by defining the sequence. The SAP System determines the taxes automatically within pricing. In the standard SAP R/3 System, the elements of tax calculation are predefined (for example, tax condition type "MWST" for taxes on sales and purchases). Assign the plant for Tax Determination in OX10, using the country key, the SAP System recognizes which tax type is valid for a plant and thus which taxes are relevant when creating an SD document. Define the Customer Taxes in OVK3, you will maintain the tax code in Customer Master. Define the Material Taxes in OVK4, which will then be maintain in Material Master. For example :- MWST GST 0 Tax Exempt MWST GST 1 Liable for Taxes Now, you define the Tax Determination in VK12. VK12 - Domestic Taxes/Export Taxes Condition Type MWST Customer Ta
Read more