SAP ABAP Table SMOEQUI (Equipment master data)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOEQUI	Table Relationship Diagram
Short Description	Equipment master data

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAEQUI	☑	SMO_SFAEQI	SMO_GUID	CHAR	32	0	SFA Key of Equipment (EQUI)
3	SFAMARA	☐	SMO_SFAMAR	SMO_GUID	CHAR	32	0	SFA Key of Material
4	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
5	EQUNR	☐	SMO3EQUNR	SMO3EQUNR	CHAR	18	0	Equipment number
6	ERDAT	☐	SMO3ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	ERNAM	☐	SMO3ERNAM	USNAM	CHAR	12	0	Name of person who created the object
8	EQASP	☐	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
9	AEDAT	☐	SMO3AEDAT	DATUM	DATS	8	0	Last changed on
10	AENAM	☐	SMO3AENAM	USNAM	CHAR	12	0	Name of person who changed object
11	EQTYP	☐	SMO3EQTYP	SMO3EQTYP	CHAR	1	0	Equipment category
12	EQART	☐	SMO3EQART	SMO3EQART	CHAR	10	0	Type of technical object
13	GROES	☐	SMO3GROSS	SMO3GROES	CHAR	18	0	Size/dimension
14	BRGEW	☐	SMO3BRGEW	MENG13	QUAN	13	3	Gross weight
15	GEWEI	☐	SMO3GEWEI	MEINS	UNIT	3	0	Weight Unit	*
16	ANSDT	☐	SMO3ANDTI	DATUM	DATS	8	0	Acquisition date
17	ANSWT	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
18	WAERS	☐	SMO3WAERS	WAERS	CUKY	5	0	Currency key	*
19	GWLEN	☐	SMO3GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
20	GWLDT	☐	SMO3GWLDT	DATUM	DATS	8	0	Guarantee date
21	HERST	☐	SMO3HERST	TEXT30	CHAR	30	0	Manufacturer of asset
22	HERLD	☐	SMO3HERLD	LAND1	CHAR	3	0	Country of manufacture	*
23	SERGE	☐	SMO3SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
24	TYPBZ	☐	SMO3TYPBZ	SMO3TYPBZ	CHAR	20	0	Manufacturer model number
25	BAUJJ	☐	SMO3BAUJJ	CJAHR	CHAR	4	0	Year of construction
26	BAUMM	☐	SMO3BAUMM	SMO3BAUMM	CHAR	2	0	Month of construction
27	AULDT	☐	SMO3AULDT	DATUM	DATS	8	0	First delivery date of the equipment
28	INBDT	☐	SMO3INBDT	DATUM	DATS	8	0	First start-up date
29	EQLFN	☐	SMO3EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
30	EQBER	☐	SMO3EQBER	CHAR30	CHAR	30	0	Text for notes
31	OBJNR	☐	SMO3J_OBJ	SMO3J_OBJ	CHAR	22	0	Object number
32	CONFIG_ID	☐	SMO_CONFID	SMO_CONFID	CHAR	8	0	Identity code for configuration
33	INST_ID	☐	SMO_INSCID	SMO_TXT8	CHAR	8	0	SCE Instance ID
34	ROOT_ID	☐	SMO_ROOTID	SMO_CONFID	CHAR	8	0	Configuration Root ID
35	CUOBJ	☐	SMO3CUOBJ	SMO3CUOBJ	NUMC	18	0	Configuration (internal object number)
36	KRFKZ	☐	SMO3KRFKZ	X	CHAR	1	0	Referenced Configuration
37	MATNR	☐	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
38	SERNR	☐	SMO3GERNR	SMO3GERNR	CHAR	18	0	Serial number
39	WERK	☐	SMO3WERKS	SMO3WERKS	CHAR	4	0	Plant
40	KUNDE	☐	SMO3KUNDS	SMO3KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered
41	EQP_STATUS	☐	SMO_EQSTAT	SMO_ST2	CHAR	2	0	Equipment Status
42	KV_BEDPOT	☐	SMO_BEDPOT	SMO_TXT10	CHAR	10	0	Potential of beds (pharmaceutical)
43	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
44	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
45	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
46	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
47	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
48	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
49	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
50	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

History

Last changed by/on	SAP	20110908
SAP Release Created in