SAP ABAP Table V_EQUI (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EQUI	Table Relationship Diagram
Short Description	Generated Table for View

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	*
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	GWLDV	☑	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
35	EQDAT	☑	EQDAT	DATUM	DATS	8	0	Date
36	EQBER	☑	EQBER	CHAR30	CHAR	30	0	Text for Notes
37	EQNUM	☑	EQNUM	NUM9	NUMC	9	0	Numerical Field
38	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
39	EQSNR	☑	EQSNR	EQSNR	CHAR	18	0	EQSE Number	EQSE
40	CUOBJ	☑	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
41	KRFKZ	☑	KRFKZ	X	CHAR	1	0	Referenced Configuration
42	KMATN	☑	KMATN	MATNR	CHAR	18	0	Configurable Material	MARA
43	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
44	SERNR	☑	GERNR	GERNR	CHAR	18	0	Serial Number
45	WERK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
46	LAGER	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
47	CHARGE	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
48	KUNDE	☑	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	KNA1
49	WARPL	☑	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
50	IMRC_POINT	☑	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
51	REVLV	☑	REVLV	REVLV	CHAR	2	0	Revision level
52	MGANR	☑	MGANR	MGANR	CHAR	20	0	Master warranty number	BGMK
53	BEGRUI	☑	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
54	S_EQUI	☑	EQUIP_KNZ	X	CHAR	1	0	Equipment
55	S_SERIAL	☑	KZKSD	X	CHAR	1	0	Serial data when maintaining equipment
56	S_KONFI	☑	KONFKNZ	XFELD	CHAR	1	0	Configuration supported
57	S_SALE	☑	SDKNZ	XFELD	CHAR	1	0	Sales equipment
58	S_FHM	☑	FHMKZ	XFLAG	CHAR	1	0	Equip. category relevant to production resources and tools
59	S_ELSE	☑	ELSE_KNZ	X	CHAR	1	0	Indicator: Other Data Active
60	S_ISU	☑	ISU_KNZ	X	CHAR	1	0	IS-U data
61	S_EQBS	☑	KZEQBS	KZEQBS	CHAR	1	0	EQSI Exists
62	S_FLEET	☑	FLEET_KNZ	X	CHAR	1	0	Indicator: Fleet object active
63	BSTVP	☑	BSTVP	BSTVP	CHAR	1	0	Stock Check for Serial Numbers
64	SPARTE	☑	SPARTE	SPART	CHAR	2	0	Division	TSPA
65	HANDLE	☑	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
66	TSEGTP	☑	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)	*
67	EMATN	☑	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
68	ACT_CHANGE_AA	☑	AAPM_ACT_CHANGE_AA	AAPM_ACT	CHAR	1	0	Change Equipment Master when Changing Asset
69	S_CC	☑	CCC_KNZ	X	CHAR	1	0	Configuration Control Data
70	DATLWB	☑	DATLWB	DATS	DATS	8	0	Date of Last Goods Movement
71	UII	☑	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
72	IUID_TYPE	☑	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII	TIUID_TYPE
73	UII_PLANT	☑	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII	*
74	EQEXT_ACTIVE	☑	/ISDFPS/DE_LM_DB_EQEXT_ACTIVE	XFELD	CHAR	1	0	Backpack Table /isdfps/lmeqext Active
75	EQUI_SRTYPE	☑	COCF_SR_SRTYPE		CHAR	10	0	Shift Report Type	COCF_CU_SRTYPE
76	EQUI_SNTYPE	☑	COCF_SN_SNTYPE	QMART	CHAR	2	0	Shift Note Type	TQ80
77	EQLB_DUTY	☑	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
78	EQLB_HIDE	☑	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
79	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
80	EQLFN	☑	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
81	EQUZN	☑	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
82	TIMBI	☑	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
83	ESTAI	☑	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
84	ESTAE	☑	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
85	STNAM	☑	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
86	DATAB	☑	DATAB	DATUM	DATS	8	0	Valid-From Date
87	IWERK	☑	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
88	IWERKI	☑	INHER	INHER	CHAR	1	0	Data origin indicator
89	SUBMT	☑	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
90	MAPAR	☑	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
91	HEQUI	☑	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	EQUI
92	HEQNR	☑	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
93	INGRP	☑	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
94	INGRPI	☑	INHER	INHER	CHAR	1	0	Data origin indicator
95	PM_OBJTY	☑	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
96	GEWRK	☑	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
97	GEWRKI	☑	INHER	INHER	CHAR	1	0	Data origin indicator
98	TIDNR	☑	TIDNR	TIDNR	CHAR	25	0	Technical identification number
99	TIDNRI	☑	INHER	INHER	CHAR	1	0	Data origin indicator
100	ILOAN	☑	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
101	KUND1	☑	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
102	KUND2	☑	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
103	KUND3	☑	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
104	LIZNR	☑	LIZNR	CHAR20	CHAR	20	0	Equipment license number
105	RBNR	☑	RBNR	RBNR	CHAR	9	0	Report layout	T352B
106	EZDAT	☑	EQDAT	DATUM	DATS	8	0	Date
107	EZBER	☑	EQBER	CHAR30	CHAR	30	0	Text for Notes
108	EZNUM	☑	EQNUM	NUM9	NUMC	9	0	Numerical Field
109	RBNR_I	☑	INHER	INHER	CHAR	1	0	Data origin indicator
110	IBLNR	☑	IBLNR	BELNR	CHAR	10	0	Physical inventory document
111	BLDAT	☑	BLDAT	DATUM	DATS	8	0	Document Date in Document
112	PVS_FOCUS	☑	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
113	PPEGUID	☑	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
114	TECHS	☑	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
115	FUNCID	☑	CCC_FUNCID	CHAR40	CHAR	40	0	Function Identifier
116	FRCFIT	☑	CCC_FRCFIT	XCHAR	CHAR	1	0	Indicator: Forced Installation/Dismantling
117	FRCRMV	☑	CCC_FRCRMV	XCHAR	CHAR	1	0	Force Dismantling Flag
118	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
119	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
120	KZLTX	☐	KZLTA	XFELD	CHAR	1	0	Long Text Indicator
121	TXASP	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
122	EQKTU	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
123	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
124	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
125	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
126	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
127	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
128	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
129	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
130	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
131	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
132	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
133	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
134	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
135	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
136	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
137	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
138	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
139	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
140	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
141	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
142	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
143	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
144	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
145	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
146	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
147	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
148	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
149	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
150	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
151	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
152	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
153	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
154	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
155	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
156	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
157	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
158	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
159	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
160	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
161	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
162	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
163	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
164	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
165	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
166	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
167	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
168	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
169	LVORZ	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
170	ERNAZ	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
171	ERDAZ	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
172	AENAZ	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
173	AEDAZ	☐	AEDAT	DATUM	DATS	8	0	Last Changed On

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_EQUI	ABCKZ	T370C	ABCKZ	REF	C	CN
2	V_EQUI	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	V_EQUI	ANLNR	ANLH	ANLN1	REF	C	CN
4	V_EQUI	ANLUN	ANLA	ANLN2	REF	C	CN
5	V_EQUI	AUFNR	AUFK	AUFNR	REF	C	CN
6	V_EQUI	BEBER	T357	BEBER	REF	C	CN
7	V_EQUI	BEGRU	T370B	BEGRU	REF	C	CN
8	V_EQUI	BUKRS	T001	BUKRS	REF	C	CN
9	V_EQUI	CHARGE	MCH1	CHARG
10	V_EQUI	DAUFN	AUFK	AUFNR	REF	C	CN
11	V_EQUI	ELIEF	LFA1	LIFNR	REF	1	CN
12	V_EQUI	EQART	T370K	EQART	REF	C	CN
13	V_EQUI	EQASP	T002	SPRAS	KEY	1	CN
14	V_EQUI	EQSNR	EQSE	EQSNR	KEY	1	C
15	V_EQUI	EQTYP	T370T	EQTYP	REF	1	CN
16	V_EQUI	EQUI_SNTYPE	TQ80	QMART	KEY	1	CN
17	V_EQUI	EQUI_SRTYPE	COCF_CU_SRTYPE	SRTYPE	KEY	1	CN
18	V_EQUI	GEWEI	T006	MSEHI	REF	1	CN
19	V_EQUI	GEWRK	CRID	OBJID	REF	C	CN
20	V_EQUI	GSBER	TGSB	GSBER	REF	C	CN
21	V_EQUI	HEQUI	EQUI	EQUNR	REF	C	CN
22	V_EQUI	HERLD	T005	LAND1	REF	1	CN
23	V_EQUI	ILOAN	ILOA	ILOAN	KEY	1	CN
24	V_EQUI	IMRC_POINT	IMPTT	POINT
25	V_EQUI	INGRP	T024I	INGRP	REF	C	CN
26	V_EQUI	IUID_TYPE	TIUID_TYPE	IUID_TYPE
27	V_EQUI	IWERK	T399I	IWERK
28	V_EQUI	KMATN	MARA	MATNR	REF	1	CN
29	V_EQUI	KOKRS	TKA01	KOKRS	REF	C	CN
30	V_EQUI	KOSTL	CSKS	KOSTL	REF	C	CN
31	V_EQUI	KUND1	KNA1	KUNNR	KEY	1	CN
32	V_EQUI	KUND2	KNA1	KUNNR	KEY	1	CN
33	V_EQUI	KUND3	KNA1	KUNNR	KEY	1	CN
34	V_EQUI	KUNDE	KNA1	KUNNR
35	V_EQUI	LAGER	T001L	LGORT
36	V_EQUI	MANDT	T000	MANDT	KEY	1	CN
37	V_EQUI	MATNR	MARA	MATNR
38	V_EQUI	MGANR	BGMK	MGANR
39	V_EQUI	PPSID	CRID	OBJID	REF	C	CN
40	V_EQUI	PROID	PRPS	PSPNR		C	CN
41	V_EQUI	RBNR	T352B	RBNR	REF	C	CN
42	V_EQUI	SPART	TVTA	SPART	REF	1	CN
43	V_EQUI	SPARTE	TSPA	SPART	KEY	1	CN
44	V_EQUI	SPRAS	T002	SPRAS	KEY	1	CN
45	V_EQUI	STORT	T499S	STAND	REF	C	CN
46	V_EQUI	SUBMT	MARA	MATNR	REF	1	CN
47	V_EQUI	SWERK	T001W	WERKS	REF	1	CN
48	V_EQUI	TPLNR	IFLOT	TPLNR	REF	C	CN
49	V_EQUI	VKBUR	TVKBZ	VKBUR	REF	1	CN
50	V_EQUI	VKGRP	TVBVK	VKGRP	REF	1	CN
51	V_EQUI	VKORG	TVKO	VKORG	REF	1	CN
52	V_EQUI	VTWEG	TVKOV	VTWEG	REF	1	CN
53	V_EQUI	WAERS	TCURC	WAERS	REF	1	CN
54	V_EQUI	WARPL	MPLA	WARPL
55	V_EQUI	WERK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in