SAP ABAP Table MCIEQUI (PMIS: PM equipment master)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-IS-REP (Application Component) Reporting
     ⤷ MCI (Package) R/3 appl. development: Plant Maintenance Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCIEQUI	Table Relationship Diagram
Short Description	PMIS: PM equipment master

Delivery and Maintenance

Pool/cluster
Delivery Class
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	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
2	BEGRU	☐	EAUTG	IAUTG	CHAR	4	0	PMIS: Authorization group for equipment	T370B
3	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
4	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
5	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
6	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
7	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
8	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
9	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
10	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
11	GERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
12	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
13	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
14	SDATE	☐	DATUM	DATUM	DATS	8	0	Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCIEQUI	BEGRU	T370B	BEGRU
2	MCIEQUI	ELIEF	LFA1	LIFNR
3	MCIEQUI	EQART	T370K	EQART
4	MCIEQUI	EQTYP	T370T	EQTYP
5	MCIEQUI	EQUNR	EQUI	EQUNR

History

Last changed by/on	SAP	20020219
SAP Release Created in	470