SAP ABAP Table SMOT134 (Material Types)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOT134	Table Relationship Diagram
Short Description	Material Types

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAT134	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	MTART	☐	SMO3MTART	SMO3MTART	CHAR	20	0	Material type
4	MTREF	☐	SMO3MTREF	SMO3MAREF	CHAR	4	0	Reference material type
5	MBREF	☐	SMO3MBREF	SMO3MAREF	CHAR	4	0	Screen reference depending on the material type
6	FLREF	☐	SMO3FLREF	SMO3FLREF	CHAR	4	0	Field reference for material master
7	NUMKI	☐	SMO3NUMKR	CHAR2	CHAR	2	0	Number range
8	NUMKE	☐	SMO3NUMKR	CHAR2	CHAR	2	0	Number range
9	ENVOP	☐	SMO3ENVOP	XFELD	CHAR	1	0	External Number Assignment Without Validation
10	BSEXT	☐	SMO3BSEXT	SMO3BSEXT	CHAR	1	0	External purchase orders allowed
11	BSINT	☐	SMO3BSINT	SMO3BSINT	CHAR	1	0	Internal purchase orders allowed
12	PSTAT	☐	SMO3PSTAT	PSTAT	CHAR	15	0	Maintenance status
13	KKREF	☐	SMO3KKREF	SMO3KKREF	CHAR	4	0	Account category reference
14	VPRSV	☐	SMO3VPRSV	SMO3VPRSV	CHAR	1	0	Price control indicator
15	KZVPR	☐	SMO3KZVPR	XFELD	CHAR	1	0	Price Control Mandatory
16	VMTPO	☐	SMO3VMTPO	SMO3MTPOS	CHAR	4	0	Default value for material item category group
17	EKALR	☐	SMO3CK_EK	XFELD	CHAR	1	0	Material is costed with quantity structure
18	KZGRP	☐	SMO3KZGRP	SMO3KZGRP	CHAR	1	0	Grouping indicator
19	KZKFG	☐	SMO3KZKFG	XFELD	CHAR	1	0	Configurable Material
20	BEGRU	☐	SMO3BEGRU	SMO3BEGRU	CHAR	4	0	Authorization group
21	KZPRC	☐	SMO3KZPRC	XFELD	CHAR	1	0	Material Master Record for a Process
22	KZPIP	☐	SMO3KZPIP	XFELD	CHAR	1	0	Pipeline Handling Mandatory
23	PRDRU	☐	SMO3POSPR	XFELD	CHAR	1	0	Display price on cash register display and print on receipt
24	ARANZ	☐	SMO3POSAR1	XFELD	CHAR	1	0	Display material on cash register display
25	WMAKG	☐	SMO3WMAK	SMO3WMAK	CHAR	1	0	Material type ID
26	IZUST	☐	SMO3IZUST	SMO3IZUST	CHAR	1	0	Initial status of a new batch
27	ARDEL	☐	SMO3ARDEL	NUM4	NUMC	4	0	Time in days until a material is deleted
28	KZMPN	☐	SMO3MPNMT	XFELD	CHAR	1	0	Manufacturer Part
29	MSTAE	☐	SMO3MSTAE	SMO3MMSTA	CHAR	2	0	Cross-Plant Material Status
30	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
31	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
32	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
33	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
34	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
35	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
36	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
37	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

History

Last changed by/on	SAP	20030214
SAP Release Created in