SAP MSIT_MTYBASIC Material Types: General Data Table data and field list

MSIT_MTYBASIC 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 Types: General 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_MTYBASIC TYPE MSIT_MTYBASIC.

The MSIT_MTYBASIC table consists of various fields, each holding specific information or linking keys about Material Types: General Data data available in SAP. These include MANDT (Client), MTART (Material Type), MTREF (Reference material type), MBREF (Screen reference depending on the 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_MTYBASIC structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP MSIT_MTYBASIC 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_MTYBASIC 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
DATA				0
MANDT	Client	MANDT	CLNT	3			MANDT
MTART	Material Type	MTART	CHAR	4			MTART	MTA
MTREF	Reference material type	MTREF	CHAR	4			MAREF
MBREF	Screen reference depending on the material type	MBREF	CHAR	4			MAREF
FLREF	Field reference for material master	FLREF_MG	CHAR	4			FLREF_MG
NUMKI	Number range	NUMKR	CHAR	2			CHAR2
NUMKE	Number range	NUMKR	CHAR	2			CHAR2
ENVOP	External Number Assignment Without Validation	ENVOP	CHAR	1			XFELD
BSEXT	External Purchase Orders Allowed	BSEXT	CHAR	1			BSEXT
BSINT	Internal purchase orders allowed	BSINT	CHAR	1			BSINT
PSTAT	Maintenance status	PSTAT_D	CHAR	15			PSTAT
KKREF	Account category reference	KKREF	CHAR	4			KKREF
VPRSV	Price control indicator	VPRSV	CHAR	1			VPRSV
KZVPR	Price Control Mandatory	KZVPR	CHAR	1			XFELD
VMTPO	Default value for material item category group	VMTPO	CHAR	4			MTPOS
EKALR	Material Is Costed with Quantity Structure	CK_EKALREL	CHAR	1			XFELD
KZGRP	Grouping indicator	KZGRP	CHAR	1			KZGRP
KZKFG	Configurable Material	KZKFG	CHAR	1			XFELD
BEGRU	Authorization group in the material master	BEGRM	CHAR	4			BEGRM
KZPRC	Material Master Record for a Process	KZPRC	CHAR	1			XFELD
KZPIP	Pipeline Handling Mandatory	KZPIP	CHAR	1			XFELD
PRDRU	Display price on cash register display and print on receipt	POSPRDRUCK	CHAR	1			XFELD
ARANZ	Display material on cash register display	POSARTANZ	CHAR	1			XFELD
WMAKG	Material type ID	WMAK	CHAR	1			WMAK
IZUST	Initial status of a new batch	IZUST	CHAR	1			IZUST
ARDEL	Time in days until a material is deleted	ARDEL	NUMC	4			NUM4
KZMPN	Manufacturer Part	MPNMTART	CHAR	1			XFELD
MSTAE	Cross-Plant Material Status	MSTAE	CHAR	2			MMSTA
CCHIS	Control (time) of history requirement: Material	CC_HIST_MAT	CHAR	1			CC_HIST_MAT
CTYPE	Class Type	KLASSENART_M	CHAR	3			KLASSENART	KAR
CLASS	Class number	KLASSE_M	CHAR	18			KLASSE	KLA
CHNEU	Batch Creation Control (Automatic/Manual)	CHNEU	CHAR	1			CHNEU
.INCLU--AP				0
VTYPE	Version Category	VERSIONTYPE	CHAR	10			VERSIONTYPE
VNUMKI	Number range	NUMKR	CHAR	2			CHAR2
VNUMKE	Number range	NUMKR	CHAR	2			CHAR2
.INCLU--AP				0
KZFFF	Indicator: FFF class	KZFFF	CHAR	1			XFELD
.INCLU--AP				0
KZRAC	Returnable Packaging Logistics is mandatory	KZRAC	CHAR	1			XFELD
UPDATE_TYPE	Type of Change	UPDATE_TYPE	CHAR	1			UPDATE_TYPE

Key field

Non-key field

< MSIT_MGRSYNC - Material Groups: Complex Data Structure MSIT_MTYSHORTTXT - Material Types: Structure for the Short Text >

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

As MSIT_MTYBASIC 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_MTYBASIC as there is no data to select.

How to access SAP table MSIT_MTYBASIC

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

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