SAP TUTORIALS-
SAP Standard Report Material Master View All Fields-ERP
Introduction-
SAP Standard Report Material Master View All Fields-ERP-
SAP HANA AND ECC 6.0 its all the field data for a report in the material master (MM) in SAP ERP , you can use the following methods...
also is a list of the main master tables and views in SAP that are associated with the Material Master data, along with a clear description of what each one Fields.You can export the data to an Excel sheet for further analysis...
FOLLOW STEPS-
GO TO TCODE SE16N-
SELECT TABLE NAME-EXAMPLE-MARA AND SELECT BUTTON -EXECUTE
ALSO You can export the data to an Excel sheet for further analysis.and you can select deselect fieled name
1)MARA (General Material Data)-
SAP ERP This table contains general data about materials.also in this table Fields include: Material Number, Industry Sector, Material Type, Base Unit of Measure, etc....
2)MARC (Plant Data for Material)-
SAP ERP This table containts plant-specific data for materials.also in this table Fields include: Plant, Storage Location, Purchasing Group, Planned Delivery Time, etc....
3)MARD (Storage Location Data for Material)-
SAP ERP This table This table contains data related to materials at the storage location level.also in this table Fields include: Storage Location, Stock Quantity, Special Stock Indicator, etc....
4)MAKT (Material Descriptions)-
SAP ERP This table stores material descriptions in different languages.also Fields include: Material Number, Language Key, Material Description, etc....
5)MBEW (Material Valuation)-
SAP ERP This table contains data related to the valuation of materials.also Fields include: Valuation Area, Valuation Class, Standard Price, Moving Average Price, etc....
6)MVKE (Sales Data for Material)-
SAP ERP This table contains sales-related data for materials.also Fields include: Sales Organization, Distribution Channel, Sales Unit, Material Group, etc....
7)MLAN (Tax Classification for Material)-
SAP ERP This table contains tax-related data for materials.also Fields include: Material Number, Country, Tax Type, Tax Classification, etc....
8)MKPF (Material Document Header)-
SAP ERP This table contains header data for material documents.also Fields include: Material Document Number, Document Date, Posting Date, etc....
9)MSEG (Document Segment: Material)-
SAP ERP This table contains item-level data for material documents.also Fields include: Material Number, Quantity, Unit of Measure, Batch Number, etc....
10)EINA (Purchasing Info Record - General Data)-
SAP ERP This table contains general data for purchasing info records.also Fields include: Material Number, Vendor, Purchasing Organization, etc....
11)EINE (Purchasing Info Record - Purchasing Organization Data)-
SAP ERP This table contains purchasing organization-specific data for purchasing info records.also Fields include: Purchase Order Price, Planned Delivery Time, Order Unit, etc....
12)AUSP (Characteristic Values for Material)-
SAP ERP This table contains data related to characteristics and their values assigned to materials.also Fields include: Material Number, Characteristic, Value, etc....
13)MAPR (Material Index for Forecast)-
SAP ERP This table contains data related to forecasting for materials.also Fields include: Material Number, Plant, Forecast Requirements, etc....
14)MLGT (Material Master: LIFO/Gross Valuation)-
SAP ERP This table contains data related to LIFO (Last In, First Out) and gross valuation for materials.also Fields include: Valuation Area, Material Number, LIFO Class, etc....
15)MAW1 (Material Master View for Warehouse Management)-
SAP ERP This table contains data related to warehouse management for materials.also Fields include: Material Number, Warehouse Number, Storage Type, etc....
16)MVER (Material Consumption)-
SAP ERP This table contains data related to material consumption.also Fields include: Material Number, Plant, Fiscal Year, Consumption Quantity, etc....
17)MLGN (Material Data for Warehouse Management)-
SAP ERP This table contains warehouse-specific data for materials.also Fields include: Material Number, Warehouse Number, Special Stock, etc....
18)MOFF (Material Master: Fields not Ready for Input)-
SAP ERP This table identifies fields in the material master that are not ready for input.also Fields include: Material Number, Plant, Field Name, etc....
19)MLAN (Tax Classification for Material)-
SAP ERP This table stores the tax classification data of materials.also Fields include: Material Number, Tax Indicator, Country, Tax Category, etc....
20)MARM (Units of Measure for Material)-
SAP ERP This table contains data related to alternative units of measure for materials.also Fields include: Material Number, Alternative Unit of Measure, Conversion Factor, etc....