SAP ABAP Table DIEQUI (Equipment)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in