SAP ABAP Table DIEQUIX (Equipment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ ILOM (Package) Application Development R/3 Location Management

Basic Data

Table Category	INTTAB	Structure
Structure	DIEQUIX	Table Relationship Diagram
Short Description	Equipment

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	.INCLUDE	☐				0	0	Equipment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
4	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	EQASP	☐	EQASP	SPRAS	LANG	1	0	Language in which the piece of equipment was entered	T002
7	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
8	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
10	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
11	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
12	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
13	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
14	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
15	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
16	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
17	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
18	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
21	.INCLUDE	☐				0	0	Warranty Data for Technical Object List EditingPM/SM
22	GWLDT_K	☐	IGWLDT_K	DATUM	DATS	8	0	Customer Warranty Start
23	GWLEN_K	☐	IGWLEN_K	DATUM	DATS	8	0	Warranty End for Customer
24	MGANR_K	☐	IMGANR_K	MGANR	CHAR	20	0	Master Warranty Number for Customer	*
25	GARTX_K	☐	IGARTXL_K	TXT40	CHAR	40	0	Customer Warranty Description
26	GWLDT_L	☐	IGWLDT_L	DATUM	DATS	8	0	Vendor Warranty Start
27	GWLEN_L	☐	IGWLEN_L	DATUM	DATS	8	0	Warranty End for Vendor
28	MGANR_L	☐	IMGANR_L	MGANR	CHAR	20	0	Master Warranty Number for Vendor	*
29	GARTX_L	☐	IGARTXL_L	TXT40	CHAR	40	0	Vendor Warranty Description
30	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
31	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
32	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
33	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
34	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
35	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
36	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
37	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
38	APLKZ	☐	APLKZ	APLKZ	CHAR	1	0	Indicator: Task List Exists
39	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
40	INBDT	☐	INBDT	DATUM	DATS	8	0	First start-up date
41	TXASP	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
42	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
43	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
44	EQDAT	☐	EQDAT	DATUM	DATS	8	0	Date
45	EQBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
46	EQNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
47	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
48	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number	EQSE
49	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
50	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
51	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	MARA
52	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
53	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
54	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
55	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
56	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
57	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	KNA1
58	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
59	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
60	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
61	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
62	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
63	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
64	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
65	KZLTX	☐	KZLTX	XFELD	CHAR	1	0	Indicator: More long text exists
66	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in