SAP ABAP Table VEQUI (Change document structure; generated by RSSCD000)

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	VEQUI	Table Relationship Diagram
Short Description	Change document structure; generated by RSSCD000

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in