SAP ABAP Table EQUI (Equipment master data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IEQM (Package) Application Develoment R/3 Equipment Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EQUI	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	T000
2	EQUNR	☑	EQUNR	EQUNR	CHAR	18	0	Equipment Number
3	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	EQASP	☐	EQASP	SPRAS	LANG	1	0	Language in which the piece of equipment was entered	T002
6	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
9	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
10	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
11	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
12	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
13	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
14	BRGEW	☐	OBJ_WEIGHT	MENG13	QUAN	13	3	Weight of object
15	GEWEI	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
16	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
17	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
20	GWLEN	☐	GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
21	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
22	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
23	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
24	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
25	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
26	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
27	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
28	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
29	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
30	APLKZ	☐	APLKZ	APLKZ	CHAR	1	0	Indicator: Task List Exists
31	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
32	INBDT	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
33	GERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
34	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
35	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
36	EQDAT	☐	EQDAT	DATUM	DATS	8	0	Date
37	EQBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
38	EQNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
39	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
40	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number	EQSE
41	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
42	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
43	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	MARA
44	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
45	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
46	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
47	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
48	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
49	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	KNA1
50	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
51	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
52	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
53	MGANR	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	BGMK
54	BEGRUI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
55	S_EQUI	☐	EQUIP_KNZ	X	CHAR	1	0	Equipment
56	S_SERIAL	☐	KZKSD	X	CHAR	1	0	Serial data when maintaining equipment
57	S_KONFI	☐	KONFKNZ	XFELD	CHAR	1	0	Configuration supported
58	S_SALE	☐	SDKNZ	XFELD	CHAR	1	0	Sales equipment
59	S_FHM	☐	FHMKZ	XFLAG	CHAR	1	0	Equip. category relevant to production resources and tools
60	S_ELSE	☐	ELSE_KNZ	X	CHAR	1	0	Indicator: Other Data Active
61	S_ISU	☐	ISU_KNZ	X	CHAR	1	0	IS-U data
62	S_EQBS	☐	KZEQBS	KZEQBS	CHAR	1	0	EQSI Exists
63	S_FLEET	☐	FLEET_KNZ	X	CHAR	1	0	Indicator: Fleet object active
64	BSTVP	☐	BSTVP	BSTVP	CHAR	1	0	Stock Check for Serial Numbers
65	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
66	HANDLE	☐	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
67	TSEGTP	☐	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)	*
68	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
69	ACT_CHANGE_AA	☐	AAPM_ACT_CHANGE_AA	AAPM_ACT	CHAR	1	0	Change Equipment Master when Changing Asset
70	S_CC	☐	CCC_KNZ	X	CHAR	1	0	Configuration Control Data
71	DATLWB	☐	DATLWB	DATS	DATS	8	0	Date of Last Goods Movement
72	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
73	IUID_TYPE	☐	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII	TIUID_TYPE
74	UII_PLANT	☐	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII	*
75	.INCLUDE	☐				0	0
76	.INCLU--AP	☐				0	0	Equipment Add On for Bw SDP
77	EQEXT_ACTIVE	☐	/ISDFPS/DE_LM_DB_EQEXT_ACTIVE	XFELD	CHAR	1	0	Backpack Table /isdfps/lmeqext Active
78	.INCLU--AP	☐				0	0	Enhancements to Shift Note/Report
79	EQUI_SRTYPE	☐	COCF_SR_SRTYPE		CHAR	10	0	Shift Report Type	COCF_CU_SRTYPE
80	EQUI_SNTYPE	☐	COCF_SN_SNTYPE	QMART	CHAR	2	0	Shift Note Type	TQ80
81	.INCLU--AP	☐				0	0	Logbook Equi Append
82	EQLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
83	EQLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EQUI	BEGRU	T370B	BEGRU	REF	C	CN
2	EQUI	CHARGE	MCH1	CHARG
3	EQUI	ELIEF	LFA1	LIFNR	REF	1	CN
4	EQUI	EQART	T370K	EQART	REF	C	CN
5	EQUI	EQASP	T002	SPRAS	KEY	1	CN
6	EQUI	EQSNR	EQSE	EQSNR	KEY	1	C
7	EQUI	EQTYP	T370T	EQTYP	REF	1	CN
8	EQUI	EQUI_SNTYPE	TQ80	QMART	KEY	1	CN
9	EQUI	EQUI_SRTYPE	COCF_CU_SRTYPE	SRTYPE	KEY	1	CN
10	EQUI	GEWEI	T006	MSEHI	REF	1	CN
11	EQUI	HERLD	T005	LAND1	REF	1	CN
12	EQUI	IMRC_POINT	IMPTT	POINT
13	EQUI	IUID_TYPE	TIUID_TYPE	IUID_TYPE
14	EQUI	KMATN	MARA	MATNR	REF	1	CN
15	EQUI	KUNDE	KNA1	KUNNR
16	EQUI	LAGER	T001L	LGORT
17	EQUI	MANDT	T000	MANDT	KEY	1	CN
18	EQUI	MATNR	MARA	MATNR
19	EQUI	MGANR	BGMK	MGANR
20	EQUI	SPARTE	TSPA	SPART	KEY	1	CN
21	EQUI	WAERS	TCURC	WAERS	REF	1	CN
22	EQUI	WARPL	MPLA	WARPL
23	EQUI	WERK	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in