SAP ABAP View EQUI (Equipment Matchcode Object (Transparent))

Basic Data

View Type
	EQUI
Short Description	Equipment Matchcode Object (Transparent)
Root table	EQUI	Equipment master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EQUI	EQUI
2	EQKT	EQUI	EQUNR	I
3	EQUZ	EQUI	EQUNR	I
4	ILOA	EQUZ	ILOAN	E
5	CRVE_B	EQUI	EQUNR	I
6	CRID	CRVE_B	OBJID	E
7	CRFH	CRID	OBJID	I
8	KNA1	EQUZ	KUND3	E

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EQUI	MANDT		☐	MANDT	☐	Client
2	EQUNR	EQUI	EQUNR		☐	EQUNR	☐	Equipment Number
3	SPRAS	EQKT	SPRAS		☐	SPRAS	☐	Language Key
4	DATBI	EQUZ	DATBI		☐	DATBI	☐	Valid To Date
5	EQLFN	EQUZ	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
6	OBJTY	CRVE_B	OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
7	OBJID	CRVE_B	OBJID		☐	CR_OBJID	☐	Object ID of the resource
8	ZAEHL	CRFH	ZAEHL		☐	CIM_COUNT	☐	Internal counter
9	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
10	ERNAM	EQUI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
11	EQASP	EQUI	EQASP		☐	EQASP	☐	Language in which the piece of equipment was entered
12	AEDAT	EQUI	AEDAT		☐	AEDAT	☐	Last Changed On
13	AENAM	EQUI	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
14	BEGRU	EQUI	BEGRU		☐	IAUTG	☐	Authorization Group for Technical Object
15	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
16	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
17	LVORM	EQUI	LVORM		☐	LVORM	☐	Deletion Indicator
18	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
19	GROES	EQUI	GROES		☐	GROSS	☐	Size/dimension
20	GEWEI	EQUI	GEWEI		☐	GEWEI	☐	Weight Unit
21	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
22	WAERS	EQUI	WAERS		☐	WAERS	☐	Currency Key
23	ELIEF	EQUI	ELIEF		☐	ELIEF	☐	Vendor number
24	GWLEN	EQUI	GWLEN		☐	GWLEN	☐	Date on which the warranty ends
25	GWLDT	EQUI	GWLDT		☐	GWLDT	☐	Guarantee date
26	HERST	EQUI	HERST		☐	HERST	☐	Manufacturer of asset
27	HERLD	EQUI	HERLD		☐	HERLD	☐	Country of manufacture
28	HZEIN	EQUI	HZEIN		☐	HZEIN	☐	Manufacturer drawing number
29	SERGE	EQUI	SERGE		☐	SERGE	☐	Manufacturer serial number
30	TYPBZ	EQUI	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
31	BAUJJ	EQUI	BAUJJ		☐	BAUJJ	☐	Year of construction
32	BAUMM	EQUI	BAUMM		☐	BAUMM	☐	Month of construction
33	APLKZ	EQUI	APLKZ		☐	APLKZ	☐	Indicator: Task List Exists
34	AULDT	EQUI	AULDT		☐	AULDT	☐	First delivery date of the equipment
35	INBDT	EQUI	INBDT		☐	INBDT	☐	First start-up date
36	GERNR	EQUI	GERNR		☐	GERNR	☐	Serial Number
37	EQLFE	EQUI	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
38	GWLDV	EQUI	GWLDV		☐	GWLDV	☐	Warranty date for Sales and Distribution
39	EQDAT	EQUI	EQDAT		☐	EQDAT	☐	Date
40	EQBER	EQUI	EQBER		☐	EQBER	☐	Text for Notes
41	EQNUM	EQUI	EQNUM		☐	EQNUM	☐	Numerical Field
42	OBJNR	EQUI	OBJNR		☐	J_OBJNR	☐	Object number
43	EQSNE	EQUI	EQSNR		☐	EQSNR	☐	EQSE Number
44	EQKTX	EQKT	EQKTX		☐	KTX01	☐	Description of technical object
45	KZLTX	EQKT	KZLTX		☐	KZLTA	☐	Long Text Indicator
46	TXASP	EQKT	TXASP		☐	KZMLA	☐	Primary language indicator for text segment
47	EQUZN	EQUZ	EQUZN		☐	EQNNR	☐	Number of next EquipUsagePeriod on same day
48	ERDAZ	EQUZ	ERDAT		☐	ERDAT	☐	Date on which the record was created
49	ERNAZ	EQUZ	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
50	AEDAZ	EQUZ	AEDAT		☐	AEDAT	☐	Last Changed On
51	AENAZ	EQUZ	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
52	TIMBI	EQUZ	TIMBI		☐	TIMBI	☐	Equipment usage period time stamp
53	ESTAI	EQUZ	ESTAI		☐	ESTAI	☐	Internal equipment status
54	ESTAE	EQUZ	ESTAE		☐	ESTAE	☐	Business transaction
55	STNAM	EQUZ	STNAM		☐	STNAM	☐	Name of the user who maintained the status
56	LVORZ	EQUZ	LVORM		☐	LVORM	☐	Deletion Indicator
57	DATAB	EQUZ	DATAB		☐	DATAB	☐	Valid-From Date
58	IWERK	EQUZ	IWERK		☐	IWERK	☐	Maintenance Planning Plant
59	IWERKI	EQUZ	IWERKI		☐	INHER	☐	Data origin indicator
60	SUBMT	EQUZ	SUBMT		☐	SUBMT	☐	Construction Type Material of the Object
61	MAPAR	EQUZ	MAPAR		☐	MAPAR	☐	Manufacturer part number
62	HEQUI	EQUZ	HEQUI		☐	HEQUI	☐	Superordinate Equipment
63	HEQNR	EQUZ	HEQNR		☐	HEQNR	☐	Equipment position at InstallLoc (Superior Equip./FunctLoc)
64	INGRP	EQUZ	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
65	INGRPI	EQUZ	INGRPI		☐	INHER	☐	Data origin indicator
66	PM_OBJTY	EQUZ	PM_OBJTY		☐	PM_OBJTY	☐	Object Type of CIM Resources for Work Center
67	GEWRK	EQUZ	GEWRK		☐	LGWID	☐	Object ID of the Work Center
68	GEWRKI	EQUZ	GEWRKI		☐	INHER	☐	Data origin indicator
69	TIDNR	EQUZ	TIDNR		☐	TIDNR	☐	Technical identification number
70	TIDNRI	EQUZ	TIDNRI		☐	INHER	☐	Data origin indicator
71	ILOAN	EQUZ	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
72	KUND1	EQUZ	KUND1		☐	KUND1	☐	Customer No.
73	KUND2	EQUZ	KUND2		☐	KUND2	☐	End customer number
74	KUND3	EQUZ	KUND3		☐	KUND3	☐	Operator
75	LIZNR	EQUZ	LIZNR		☐	LIZNR	☐	Equipment license number
76	RBNR	EQUZ	RBNR		☐	RBNR	☐	Report layout
77	EZDAT	EQUZ	EZDAT		☐	EQDAT	☐	Date
78	EZBER	EQUZ	EZBER		☐	EQBER	☐	Text for Notes
79	EZNUM	EQUZ	EZNUM		☐	EQNUM	☐	Numerical Field
80	RBNR_I	EQUZ	RBNR_I		☐	INHER	☐	Data origin indicator
81	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
82	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
83	ABCKZI	ILOA	ABCKZI		☐	INH_ABCKZI	☐	Data origin for ABC indicator field
84	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
85	EQFNRI	ILOA	EQFNRI		☐	INH_EQFNRI	☐	Data origin for sort field
86	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
87	SWERKI	ILOA	SWERKI		☐	INH_SWERKI	☐	Data origin for maintenance plant field
88	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
89	STORTI	ILOA	STORTI		☐	INH_STORTI	☐	Data origin for location field
90	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
91	MSGRPI	ILOA	MSGRPI		☐	INH_MSGRPI	☐	Data origin for room number field
92	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
93	BEBERI	ILOA	BEBERI		☐	INH_BEBERI	☐	Data origin for company area field
94	CR_OBJTY	ILOA	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
95	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
96	PPSIDI	ILOA	PPSIDI		☐	INH_PPSIDI	☐	Data origin for PP work center field
97	GSBER	ILOA	GSBER		☐	GSBER	☐	Business Area
98	GSBERI	ILOA	GSBERI		☐	INH_GSBERI	☐	Data origin for business area field
99	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
100	KOKRSI	ILOA	KOKRSI		☐	INH_KOKRSI	☐	Data origin for controlling area field
101	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
102	KOSTLI	ILOA	KOSTLI		☐	INH_KOSTLI	☐	Data origin for cost center field
103	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
104	PROIDI	ILOA	PROIDI		☐	INH_PROIDI	☐	Data origin for WBS element field
105	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
106	BUKRSI	ILOA	BUKRSI		☐	INH_BUKRSI	☐	Data origin for company code field
107	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
108	ANLNRI	ILOA	ANLNRI		☐	INH_ANLNRI	☐	Data origin for asset main no./sub-no. fields
109	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
110	ANLUNI	ILOA	ANLUNI		☐	INHER	☐	Data origin indicator
111	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
112	DAUFNI	ILOA	DAUFNI		☐	INH_DAUFNI	☐	Data origin of standing order number field
113	AUFNR	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
114	AUFNRI	ILOA	AUFNRI		☐	INH_AUFNRI	☐	Data origin for settlement order field
115	TPLNRI	ILOA	TPLNRI		☐	INH_TPLNRI	☐	Data origin for functional location field
116	FGRU1	CRFH	FGRU1		☐	FGRUA	☐	Grouping key 1 for production resources/tools
117	FGRU2	CRFH	FGRU2		☐	FGRUB	☐	Grouping key 2 for production resources/tools
118	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
119	SERNR	EQUI	SERNR		☐	GERNR	☐	Serial Number
120	CUOBJ	EQUI	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
121	KRFKZ	EQUI	KRFKZ		☐	KRFKZ	☐	Referenced Configuration
122	KMATN	EQUI	KMATN		☐	KMATN	☐	Configurable Material
123	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
124	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
125	CHARGE	EQUI	CHARGE		☐	CHARG_D	☐	Batch Number
126	KUNDE	EQUI	KUNDE		☐	KUNDSE	☐	Customer to Whom Serial Number was Delivered
127	WARPL	EQUI	WARPL		☐	WARPL	☐	Maintenance Plan
128	IMRC_POINT	EQUI	IMRC_POINT		☐	IMRC_POINT	☐	Measuring Point
129	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
130	PSTLZ	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
131	MCDD3	KNA1	MCOD3		☐	MCDD3	☐	Search term for matchcode search
132	MCDD1	KNA1	MCOD1		☐	MCDD1	☐	Search term for matchcode search
133	KUNNR	KNA1	KUNNR		☐	KUNNR	☐	Customer Number
134	EQKTU	EQKT	EQKTU		☐	EQKTU	☐	Equipment description in capital letters
135	MCOD2	KNA1	MCOD2		☐	MCDD2	☐	Search Term for Matchcode Search
136	TELF1	KNA1	TELF1		☐	TELF1	☐	First telephone number
137	STRAS	KNA1	STRAS		☐	STRAS_GP	☐	House number and street
138	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
139	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
140	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
141	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
142	NAME2	KNA1	NAME2		☐	NAME2_GP	☐	Name 2
143	TELF2	KNA1	TELF2		☐	TELF2	☐	Second telephone number
144	DATLT	KNA1	DATLT		☐	DATLT	☐	Data communication line no.
145	TELBX	KNA1	TELBX		☐	TELBX	☐	Telebox number
146	TELFX	KNA1	TELFX		☐	TELFX	☐	Fax Number
147	TELTX	KNA1	TELTX		☐	TELTX	☐	Teletex number
148	TELX1	KNA1	TELX1		☐	TELX1	☐	Telex number
149	COUNC	KNA1	COUNC		☐	COUNC	☐	County Code
150	CITYC	KNA1	CITYC		☐	CITYC	☐	City Code
151	STCD1	KNA1	STCD1		☐	STCD1	☐	Tax Number 1
152	STCD2	KNA1	STCD2		☐	STCD2	☐	Tax Number 2
153	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
154	BBBNR	KNA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
155	BBSNR	KNA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
156	KONZS	KNA1	KONZS		☐	KONZS	☐	Group key
157	VBUND	KNA1	VBUND		☐	RASSC	☐	Company ID of trading partner
158	ORT02	KNA1	ORT02		☐	ORT02_GP	☐	District

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	19980220
SAP Release Created in