SAP MSIT_MATVIEWS Material header data Table data and field list

MSIT_MATVIEWS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Material header data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MSIT_MATVIEWS TYPE MSIT_MATVIEWS.

The MSIT_MATVIEWS table consists of various fields, each holding specific information or linking keys about Material header data data available in SAP. These include FUNCTION (Function of BAPI), MATERIAL (Material Number), IND_SECTOR (Industry sector), MATL_TYPE (Material Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MSIT_MATVIEWS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP MSIT_MATVIEWS structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MSIT_MATVIEWS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
HEADER				0
FUNCTION	Function of BAPI	BAPIFN	CHAR	3			BAPIFN
MATERIAL	Material Number	MATNR	CHAR	18		MATN1	MATNR	MAT	S_MAT1
IND_SECTOR	Industry sector	MBRSH	CHAR	1			MBRSH	MTP
MATL_TYPE	Material Type	MTART	CHAR	4			MTART	MTA
BASIC_VIEW	Basic Data View	SICHT_K	CHAR	1			XFELD
SALES_VIEW	Sales View	SICHT_V	CHAR	1			XFELD
PURCHASE_VIEW	Purchasing View	SICHT_E	CHAR	1			XFELD
MRP_VIEW	Material Requirements Planning (MRP) View	SICHT_D	CHAR	1			XFELD
FORECAST_VIEW	Forecasting View	SICHT__P	CHAR	1			XFELD
WORK_SCHED_VIEW	Work Scheduling View	SICHT_A	CHAR	1			XFELD
PRT_VIEW	Production Resources/Tools (PRT) View	SICHT_F	CHAR	1			XFELD
STORAGE_VIEW	Storage View	SICHT_L	CHAR	1			XFELD
WAREHOUSE_VIEW	Warehouse Management View	SICHT_S	CHAR	1			XFELD
QUALITY_VIEW	Quality Management View	SICHT_Q	CHAR	1			XFELD
ACCOUNT_VIEW	Accounting View	SICHT_B	CHAR	1			XFELD
COST_VIEW	Costing View	SICHT_G	CHAR	1			XFELD
MATERIAL_EXTERNAL	Long Material Number for MATERIAL Field	MGV_MATERIAL_EXTERNAL	CHAR	40			MATNR_EXT
MATERIAL_GUID	External GUID for MATERIAL Field	MGV_MATERIAL_GUID	CHAR	32			MATNR_EGUID
MATERIAL_VERSION	Version Number for MATERIAL Field	MGV_MATERIAL_VERSION	CHAR	10		MATNW	MATNR_VERS
UPDATE_TYPE	Type of Change	UPDATE_TYPE	CHAR	1			UPDATE_TYPE

Key field

Non-key field

< MSIT_MATUOM_L - Material Master UOM - Data type MSIT_MGRBASIC - Material Groups: General Data >

How do I retrieve data from SAP structure MSIT_MATVIEWS using ABAP code?

As MSIT_MATVIEWS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MSIT_MATVIEWS as there is no data to select.

How to access SAP table MSIT_MATVIEWS

Within an ECC or HANA version of SAP you can also view further information about MSIT_MATVIEWS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).