SAP ABAP Table V_EQUI_S (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EQUI_S	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	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
4	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
5	EQLFN	☑	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	EQASP	☐	EQASP	SPRAS	LANG	1	0	Language in which the piece of equipment was entered	T002
9	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
12	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
13	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
14	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
15	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
16	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
17	BRGEW	☐	OBJ_WEIGHT	MENG13	QUAN	13	3	Weight of object
18	GEWEI	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
19	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
20	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
21	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
22	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
23	GWLEN	☐	GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
24	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
25	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
26	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
27	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
28	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
29	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
30	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
31	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
32	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
33	APLKZ	☐	APLKZ	APLKZ	CHAR	1	0	Indicator: Task List Exists
34	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
35	INBDT	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
36	GERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
37	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
38	EQDAT	☐	EQDAT	DATUM	DATS	8	0	Date
39	EQBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
40	EQNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
41	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
42	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number	EQSE
43	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
44	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
45	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	MARA
46	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
47	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
48	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
49	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
50	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
51	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	KNA1
52	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
53	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
54	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
55	MGANR	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	BGMK
56	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
57	KZLTX	☐	KZLTA	XFELD	CHAR	1	0	Long Text Indicator
58	TXASP	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
59	EQKTU	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
60	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
61	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
62	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	V_EQUI_S	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
2	V_EQUI_S	BEGRU	T370B	BEGRU	REF	C	CN
3	V_EQUI_S	CHARGE	MCH1	CHARG
4	V_EQUI_S	ELIEF	LFA1	LIFNR	REF	1	CN
5	V_EQUI_S	EQART	T370K	EQART	REF	C	CN
6	V_EQUI_S	EQASP	T002	SPRAS	KEY	1	CN
7	V_EQUI_S	EQSNR	EQSE	EQSNR	KEY	1	C
8	V_EQUI_S	EQTYP	T370T	EQTYP	REF	1	CN
9	V_EQUI_S	GEWEI	T006	MSEHI	REF	1	CN
10	V_EQUI_S	HERLD	T005	LAND1	REF	1	CN
11	V_EQUI_S	IMRC_POINT	IMPTT	POINT
12	V_EQUI_S	KMATN	MARA	MATNR	REF	1	CN
13	V_EQUI_S	KUNDE	KNA1	KUNNR
14	V_EQUI_S	LAGER	T001L	LGORT
15	V_EQUI_S	MANDT	T000	MANDT	KEY	1	CN
16	V_EQUI_S	MATNR	MARA	MATNR
17	V_EQUI_S	MGANR	BGMK	MGANR
18	V_EQUI_S	SPRAS	T002	SPRAS	KEY	1	CN
19	V_EQUI_S	WAERS	TCURC	WAERS	REF	1	CN
20	V_EQUI_S	WARPL	MPLA	WARPL
21	V_EQUI_S	WERK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in