SAP ABAP Table V_EQUI_SER (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EQUI_SER	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	EQUI
3	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
4	EQLFN	☑	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
5	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
6	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
7	ERDAZ	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	ERNAZ	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	AEDAZ	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	AENAZ	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
12	ESTAI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
13	ESTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
14	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
15	LVORZ	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
16	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
17	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
18	IWERKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
19	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
20	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
21	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	EQUI
22	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
23	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
24	INGRPI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
25	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
26	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
27	GEWRKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
28	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
29	TIDNRI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
30	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
31	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
32	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
33	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
34	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
35	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
36	EZDAT	☐	EQDAT	DATUM	DATS	8	0	Date
37	EZBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
38	EZNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
39	RBNR_I	☐	INHER	INHER	CHAR	1	0	Data origin indicator
40	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
41	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
42	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
43	KZLTX	☐	KZLTA	XFELD	CHAR	1	0	Long Text Indicator
44	TXASP	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
45	EQKTU	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
46	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
47	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
48	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
49	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
50	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
51	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
52	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
53	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
54	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
55	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
56	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
57	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
58	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
59	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
60	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
61	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
62	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
63	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
64	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
65	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
66	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
67	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
68	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
69	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
70	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
71	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
72	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
73	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
74	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
75	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
76	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
77	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
78	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
79	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
80	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
81	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
82	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
83	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
84	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
85	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
86	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
87	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
88	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
89	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_EQUI_SER	ABCKZ	T370C	ABCKZ	REF	C	CN
2	V_EQUI_SER	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	V_EQUI_SER	ANLNR	ANLH	ANLN1	REF	C	CN
4	V_EQUI_SER	ANLUN	ANLA	ANLN2	REF	C	CN
5	V_EQUI_SER	AUFNR	AUFK	AUFNR	REF	C	CN
6	V_EQUI_SER	BEBER	T357	BEBER	REF	C	CN
7	V_EQUI_SER	BUKRS	T001	BUKRS	REF	C	CN
8	V_EQUI_SER	DAUFN	AUFK	AUFNR	REF	C	CN
9	V_EQUI_SER	EQUNR	EQUI	EQUNR	KEY	1	CN
10	V_EQUI_SER	GEWRK	CRID	OBJID	REF	C	CN
11	V_EQUI_SER	GSBER	TGSB	GSBER	REF	C	CN
12	V_EQUI_SER	HEQUI	EQUI	EQUNR	REF	C	CN
13	V_EQUI_SER	ILOAN	ILOA	ILOAN	KEY	1	CN
14	V_EQUI_SER	INGRP	T024I	INGRP	REF	C	CN
15	V_EQUI_SER	IWERK	T399I	IWERK
16	V_EQUI_SER	KOKRS	TKA01	KOKRS	REF	C	CN
17	V_EQUI_SER	KOSTL	CSKS	KOSTL	REF	C	CN
18	V_EQUI_SER	KUND1	KNA1	KUNNR	KEY	1	CN
19	V_EQUI_SER	KUND2	KNA1	KUNNR	KEY	1	CN
20	V_EQUI_SER	KUND3	KNA1	KUNNR	KEY	1	CN
21	V_EQUI_SER	MANDT	T000	MANDT	KEY	1	CN
22	V_EQUI_SER	PPSID	CRID	OBJID	REF	C	CN
23	V_EQUI_SER	PROID	PRPS	PSPNR		C	CN
24	V_EQUI_SER	RBNR	T352B	RBNR	REF	C	CN
25	V_EQUI_SER	SPART	TVTA	SPART	REF	1	CN
26	V_EQUI_SER	SPRAS	T002	SPRAS	KEY	1	CN
27	V_EQUI_SER	STORT	T499S	STAND	REF	C	CN
28	V_EQUI_SER	SUBMT	MARA	MATNR	REF	1	CN
29	V_EQUI_SER	SWERK	T001W	WERKS	REF	1	CN
30	V_EQUI_SER	TPLNR	IFLOT	TPLNR	REF	C	CN
31	V_EQUI_SER	VKORG	TVKO	VKORG	REF	1	CN
32	V_EQUI_SER	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in