SAP ABAP View ITOB (PM technical objects (EQUI, funcational location))
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   PM-EQM (Application Component) Technical Objects
     ITOB (Package) PM: Technical Objects
Basic Data
View Type D Database View 
Database View ITOB  
Short Description PM technical objects (EQUI, funcational location)    
Root table EQUI   Equipment master data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 EQUI EQUI
2 EQUZ  
3 EQKT  
4 IFLOT  
5 IFLOTX  
6 ILOA  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 EQUI MANDT JL EQ 0 0
2 EQUZ MANDT JR EQ AND 0 0
3 EQUI EQUNR JL EQ 0 0
4 EQUZ EQUNR JR EQ AND 0 0
5 EQUI MANDT JL EQ 0 0
6 EQKT MANDT JR EQ AND 0 0
7 EQUI EQUNR JL EQ 0 0
8 EQKT EQUNR JR EQ AND 0 0
9 EQUI MANDT JL EQ 0 0
10 IFLOT MANDT JR EQ AND 0 0
11 EQUI MANDT JL EQ 0 0
12 IFLOTX MANDT JR EQ AND 0 0
13 IFLOT TPLNR JL EQ 0 0
14 IFLOTX TPLNR JR EQ AND 0 0
15 EQKT SPRAS JL EQ 0 0
16 IFLOTX SPRAS JR EQ AND 0 0
17 ILOA MANDT JL EQ 0 0
18 EQUZ MANDT JR EQ AND 0 0
19 ILOA ILOAN JL EQ 0 0
20 EQUZ ILOAN JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 * EQUI *    
2 MANDT EQUI MANDT   MANDT Client
3 EQUNR EQUI EQUNR   EQUNR Equipment Number
4 ERDAT EQUI ERDAT   ERDAT Date on which the record was created
5 ERNAM EQUI ERNAM   ERNAM Name of Person who Created the Object
6 - EQUI EQASP   EQASP Language in which the piece of equipment was entered
7 AEDAT EQUI AEDAT   AEDAT Last Changed On
8 AENAM EQUI AENAM   AENAM Name of Person Who Changed Object
9 BEGRU EQUI BEGRU   IAUTG Authorization Group for Technical Object
10 EQTYP EQUI EQTYP   EQTYP Equipment Category
11 EQART EQUI EQART   EQART Type of Technical Object
12 LVORM EQUI LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
13 INVNR EQUI INVNR   INVNR Inventory number
14 GROES EQUI GROES   GROSS Size/dimension
15 BRGEW EQUI BRGEW   OBJ_WEIGHT Weight of object
16 GEWEI EQUI GEWEI   WEIGHT_UNIT Unit of weight
17 ANSDT EQUI ANSDT   ANDTI Acquisition date
18 ANSWT EQUI ANSWT   ANSWT Acquisition Value
19 WAERS EQUI WAERS   WAERS Currency Key
20 ELIEF EQUI ELIEF   ELIEF Vendor number
21 GWLEN EQUI GWLEN   GWLEN Date on which the warranty ends
22 GWLDT EQUI GWLDT   GWLDT Guarantee date
23 WDBWT EQUI WDBWT   WDBWT Equipment replacement value
24 HERST EQUI HERST   HERST Manufacturer of asset
25 HERLD EQUI HERLD   HERLD Country of manufacture
26 HZEIN EQUI HZEIN   HZEIN Manufacturer drawing number
27 SERGE EQUI SERGE   SERGE Manufacturer serial number
28 TYPBZ EQUI TYPBZ   TYPBZ Manufacturer model number
29 BAUJJ EQUI BAUJJ   BAUJJ Year of construction
30 BAUMM EQUI BAUMM   BAUMM Month of construction
31 APLKZ EQUI APLKZ   APLKZ Indicator: Task List Exists
32 AULDT EQUI AULDT   AULDT First delivery date of the equipment
33 INBDT EQUI INBDT   ILOM_DATAB Start-up Date of the Technical Object
34 - EQUI GERNR   GERNR Serial Number
35 EQLFN EQUI EQLFN   EQLFN Consecutive numbering of EquipUsagePeriods on same day
36 GWLDV EQUI GWLDV   GWLDV Warranty date for Sales and Distribution
37 EQDAT EQUI EQDAT   EQDAT Date
38 EQBER EQUI EQBER   EQBER Text for Notes
39 EQNUM EQUI EQNUM   EQNUM Numerical Field
40 OBJNR EQUI OBJNR   J_OBJNR Object number
41 EQSNR EQUI EQSNR   EQSNR EQSE Number
42 CUOBJ EQUI CUOBJ   CUOBJ Configuration (internal object number)
43 KRFKZ EQUI KRFKZ   KRFKZ Referenced Configuration
44 KMATN EQUI KMATN   KMATN Configurable Material
45 MATNR EQUI MATNR   MATNR Material Number
46 SERNR EQUI SERNR   GERNR Serial Number
47 WERK EQUI WERK   WERKS_D Plant
48 LAGER EQUI LAGER   LGORT_D Storage location
49 CHARGE EQUI CHARGE   CHARG_D Batch Number
50 KUNDE EQUI KUNDE   KUNDSE Customer to Whom Serial Number was Delivered
51 WARPL EQUI WARPL   WARPL Maintenance Plan
52 IMRC_POINT EQUI IMRC_POINT   IMRC_POINT Measuring Point
53 REVLV EQUI REVLV   REVLV Revision level
54 MGANR EQUI MGANR   MGANR Master warranty number
55 BEGRUI EQUI BEGRUI   INH_BEGRUI Data origin for authorization group field
56 S_EQUI EQUI S_EQUI   EQUIP_KNZ Equipment
57 S_SERIAL EQUI S_SERIAL   KZKSD Serial data when maintaining equipment
58 S_KONFI EQUI S_KONFI   KONFKNZ Configuration supported
59 S_SALE EQUI S_SALE   SDKNZ Sales equipment
60 S_FHM EQUI S_FHM   FHMKZ Equip. category relevant to production resources and tools
61 S_ELSE EQUI S_ELSE   ELSE_KNZ Indicator: Other Data Active
62 S_ISU EQUI S_ISU   ISU_KNZ IS-U data
63 S_EQBS EQUI S_EQBS   KZEQBS EQSI Exists
64 S_FLEET EQUI S_FLEET   FLEET_KNZ Indicator: Fleet object active
65 BSTVP EQUI BSTVP   BSTVP Stock Check for Serial Numbers
66 SPARTE EQUI SPARTE   SPARTE Division
67 HANDLE EQUI HANDLE   ITOBTMP_TSEGGUID SAP Development Reserve: Integration of Date Segment (Key)
68 TSEGTP EQUI TSEGTP   ITOBTMP_TSEGTEMPLA SAP Development Reserve: Integration Date Segment (Template)
69 EMATN EQUI EMATN   EMATN Material number corresponding to manufacturer part number
70 ACT_CHANGE_AA EQUI ACT_CHANGE_AA   AAPM_ACT_CHANGE_AA Change Equipment Master when Changing Asset
71 S_CC EQUI S_CC   CCC_KNZ Configuration Control Data
72 DATLWB EQUI DATLWB   DATLWB Date of Last Goods Movement
73 UII EQUI UII   UII_CHAR72 Unique Item Identifier
74 IUID_TYPE EQUI IUID_TYPE   IUID_TYPE Structure Type of UII
75 UII_PLANT EQUI UII_PLANT   UII_PLANT Plant Responsible for UII
76 EQEXT_ACTIVE EQUI EQEXT_ACTIVE   /ISDFPS/DE_LM_DB_EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active
77 EQUI_SRTYPE EQUI EQUI_SRTYPE   COCF_SR_SRTYPE Shift Report Type
78 EQUI_SNTYPE EQUI EQUI_SNTYPE   COCF_SN_SNTYPE Shift Note Type
79 EQLB_DUTY EQUI EQLB_DUTY   DIACL_DUTY Logbook Duty
80 EQLB_HIDE EQUI EQLB_HIDE   DIACL_HIDE Hide Logbook Display
81 * EQUZ *    
82 - EQUZ MANDT   MANDT Client
83 - EQUZ EQUNR   EQUNR Equipment Number
84 DATBI EQUZ DATBI   DATBI Valid To Date
85 - EQUZ EQLFN   EQLFN Consecutive numbering of EquipUsagePeriods on same day
86 EQUZN EQUZ EQUZN   EQNNR Number of next EquipUsagePeriod on same day
87 - EQUZ ERDAT   ERDAT Date on which the record was created
88 - EQUZ ERNAM   ERNAM Name of Person who Created the Object
89 - EQUZ AEDAT   AEDAT Last Changed On
90 - EQUZ AENAM   AENAM Name of Person Who Changed Object
91 TIMBI EQUZ TIMBI   TIMBI Equipment usage period time stamp
92 ESTAI EQUZ ESTAI   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
93 ESTAE EQUZ ESTAE   RESERVE_CHAR_004 SAP Development reserve: Format CHAR, length 4
94 STNAM EQUZ STNAM   RESERVE_CHAR_012 SAP Development Reserve: Format CHAR, Length 12
95 - EQUZ LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
96 DATAB EQUZ DATAB   DATAB Valid-From Date
97 IWERK EQUZ IWERK   IWERK Maintenance Planning Plant
98 IWERKI EQUZ IWERKI   INHER Data origin indicator
99 SUBMT EQUZ SUBMT   SUBMT Construction Type Material of the Object
100 MAPAR EQUZ MAPAR   MAPAR Manufacturer part number
101 HEQUI EQUZ HEQUI   HEQUI Superordinate Equipment
102 - EQUZ HEQNR   HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc)
103 INGRP EQUZ INGRP   INGRP Planner Group for Customer Service and Plant Maintenance
104 INGRPI EQUZ INGRPI   INHER Data origin indicator
105 PM_OBJTY EQUZ PM_OBJTY   PM_OBJTY Object Type of CIM Resources for Work Center
106 TIDNR EQUZ TIDNR   TIDNR Technical identification number
107 TIDNRI EQUZ TIDNRI   INHER Data origin indicator
108 - EQUZ ILOAN   ILOAN Location and account assignment for technical object
109 KUND1 EQUZ KUND1   KUND1 Customer No.
110 KUND2 EQUZ KUND2   KUND2 End customer number
111 KUND3 EQUZ KUND3   KUND3 Operator
112 LIZNR EQUZ LIZNR   LIZNR Equipment license number
113 RBNR EQUZ RBNR   RBNR Report layout
114 EZDAT EQUZ EZDAT   EQDAT Date
115 EZBER EQUZ EZBER   EQBER Text for Notes
116 EZNUM EQUZ EZNUM   EQNUM Numerical Field
117 RBNR_I EQUZ RBNR_I   INHER Data origin indicator
118 IBLNR EQUZ IBLNR   IBLNR Physical inventory document
119 BLDAT EQUZ BLDAT   BLDAT Document Date in Document
120 PVS_FOCUS EQUZ PVS_FOCUS   PVS_GUID_CCC Internal Identification for PVS Objects
121 PPEGUID EQUZ PPEGUID   PVS_GUID_CCC Internal Identification for PVS Objects
122 TECHS EQUZ TECHS   TECHS Parameter Variant/Standard Variant
123 FUNCID EQUZ FUNCID   CCC_FUNCID Function Identifier
124 FRCFIT EQUZ FRCFIT   CCC_FRCFIT Indicator: Forced Installation/Dismantling
125 FRCRMV EQUZ FRCRMV   CCC_FRCRMV Force Dismantling Flag
126 LVORM_Z EQUZ LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
127 EQLFN_Z EQUZ EQLFN   EQLFN Consecutive numbering of EquipUsagePeriods on same day
128 ERDAT_Z EQUZ ERDAT   ERDAT Date on which the record was created
129 ERNAM_Z EQUZ ERNAM   ERNAM Name of Person who Created the Object
130 AEDAT_Z EQUZ AEDAT   AEDAT Last Changed On
131 AENAM_Z EQUZ AENAM   AENAM Name of Person Who Changed Object
132 WKCTR EQUZ GEWRK   LGWID Object ID of the Work Center
133 WKCTRI EQUZ GEWRKI   INHER Data origin indicator
134 * EQKT *    
135 - EQKT MANDT   MANDT Client
136 - EQKT EQUNR   EQUNR Equipment Number
137 SPRAS EQKT SPRAS   SPRAS Language Key
138 KZLTX EQKT KZLTX   KZLTA Long Text Indicator
139 TXASP EQKT TXASP   KZMLA Primary language indicator for text segment
140 - EQKT EQKTU   EQKTU Equipment description in capital letters
141 SHTXT EQKT EQKTX   KTX01 Description of technical object
142 * IFLOT *    
143 - IFLOT MANDT   MANDT Client
144 TPLNR IFLOT TPLNR   TPLNR Functional Location
145 MLANG IFLOT MLANG   MLANG Primary language for object texts
146 TPLKZ IFLOT TPLKZ   TPLKZ Functional location structure indicators
147 FLTYP IFLOT FLTYP   FLTYP Functional Location Category
148 TPLMA IFLOT TPLMA   TPLMA Superior functional location
149 - IFLOT ERDAT   ICRDT Date on Which Object Was Created
150 - IFLOT ERNAM   ICRNA Name of User Who Created the Object
151 - IFLOT AEDAT   IUPDT Date on which the object was last changed
152 - IFLOT AENAM   IUPNA Name of the User Who Last Changed the Object
153 - IFLOT DATAB   ILOM_DATAB Start-up Date of the Technical Object
154 - IFLOT BEGRU   IAUTG Authorization Group for Technical Object
155 TRPNR IFLOT TRPNR   TRPNR Reference functional location
156 PSTAE IFLOT PSTAE   RESERVE_CHAR_004 SAP Development reserve: Format CHAR, length 4
157 - IFLOT STNAM   RESERVE_CHAR_012 SAP Development Reserve: Format CHAR, Length 12
158 - IFLOT LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
159 - IFLOT SUBMT   SUBMT Construction Type Material of the Object
160 SUBMTI IFLOT SUBMTI   INH_SUBMTI Data origin for construction type field
161 - IFLOT MAPAR   MAPAR Manufacturer part number
162 MAPARI IFLOT MAPARI   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
163 IEQUI IFLOT IEQUI   IEQUI Installation of equipment allowed at the functional location
164 IEQUII IFLOT IEQUII   INH_IEQUII Data origin for equip. inst. allowed field
165 EINZL IFLOT EINZL   EINZL Single equipment installation at functional location
166 - IFLOT EINZLI   INH_BEGRUI Data origin for authorization group field
167 - IFLOT IWERK   IWERK Maintenance Planning Plant
168 - IFLOT IWERKI   INH_IWERKI Data origin for planning plant field
169 - IFLOT INGRP   INGRP Planner Group for Customer Service and Plant Maintenance
170 - IFLOT INGRPI   INH_INGRPI Data origin for maintenance planner group field
171 - IFLOT PM_OBJTY   PM_OBJTY Object Type of CIM Resources for Work Center
172 - IFLOT LGWID   LGWID Object ID of the Work Center
173 - IFLOT LGWIDI   INH_LGWIDI Data Origin for the Field 'Work Center'
174 - IFLOT RBNR   RBNR Report layout
175 - IFLOT RBNR_I   INH_RBNR_I Data origin for maintenance catalog field
176 - IFLOT ILOAN   ILOAN Location and account assignment for technical object
177 - IFLOT OBJNR   J_OBJNR Object number
178 POSNR IFLOT POSNR   ILOM_POSNR Position in superior technical object
179 ISTYP IFLOT ISTYP   ILOM_ISTYP Object category for Industry Solutions (IS)
180 PREMS IFLOT PREMS   ILOM_PREMS Premise
181 - IFLOT EQART   EQART Type of Technical Object
182 - IFLOT INVNR   INVNR Inventory number
183 - IFLOT GROES   GROSS Size/dimension
184 - IFLOT BRGEW   BRGEW Gross weight
185 - IFLOT GEWEI   GEWEI Weight Unit
186 - IFLOT ANSWT   ANSWT Acquisition Value
187 - IFLOT WAERS   WAERS Currency Key
188 - IFLOT ANSDT   ANDTI Acquisition date
189 - IFLOT HERST   HERST Manufacturer of asset
190 - IFLOT HERLD   HERLD Country of manufacture
191 - IFLOT BAUJJ   BAUJJ Year of construction
192 - IFLOT BAUMM   BAUMM Month of construction
193 - IFLOT TYPBZ   TYPBZ Manufacturer model number
194 - IFLOT EMATN   EMATN Material number corresponding to manufacturer part number
195 - IFLOT SERGE   SERGE Manufacturer serial number
196 - IFLOT HANDLE   ITOBTMP_TSEGGUID SAP Development Reserve: Integration of Date Segment (Key)
197 - IFLOT TSEGTP   ITOBTMP_TSEGTEMPLA SAP Development Reserve: Integration Date Segment (Template)
198 FLLB_DUTY IFLOT FLLB_DUTY   DIACL_DUTY Logbook Duty
199 FLLB_HIDE IFLOT FLLB_HIDE   DIACL_HIDE Hide Logbook Display
200 IFLOT_SRTYPE IFLOT IFLOT_SRTYPE   ILOM_SR_SRTYPE Shift Report Type for Object
201 IFLOT_SNTYPE IFLOT IFLOT_SNTYPE   ILOM_SN_SNTYPE Notification Type for Shift Note for Object
202 * IFLOTX *    
203 - IFLOTX MANDT   MANDT Client
204 - IFLOTX TPLNR   TPLNR Functional Location
205 - IFLOTX SPRAS   SPRAS Language Key
206 - IFLOTX PLTXT   PLTXT Description of functional location
207 - IFLOTX KZLTX   ILOM_KZLTX Indicator: Long text exists
208 - IFLOTX KZMLA   KZMLA Primary language indicator for text segment
209 - IFLOTX PLTXU   ILOM_PLTXU Description of functional location in capital letters
210 * ILOA *    
211 - ILOA MANDT   MANDT Client
212 ILOAN ILOA ILOAN   ILOAN Location and account assignment for technical object
213 - ILOA TPLNR   TPLNR Functional Location
214 ABCKZ ILOA ABCKZ   ABCKZ ABC Indicator for Technical Object
215 ABCKZI ILOA ABCKZI   INH_ABCKZI Data origin for ABC indicator field
216 EQFNR ILOA EQFNR   EQFNR Sort Field
217 EQFNRI ILOA EQFNRI   INH_EQFNRI Data origin for sort field
218 SWERK ILOA SWERK   SWERK Maintenance Plant
219 SWERKI ILOA SWERKI   INH_SWERKI Data origin for maintenance plant field
220 STORT ILOA STORT   PMLOC Location of maintenance object
221 STORTI ILOA STORTI   INH_STORTI Data origin for location field
222 MSGRP ILOA MSGRP   RAUMNR Room
223 MSGRPI ILOA MSGRPI   INH_MSGRPI Data origin for room number field
224 BEBER ILOA BEBER   BEBER Organizational Area
225 BEBERI ILOA BEBERI   INH_BEBERI Data origin for company area field
226 CR_OBJTY ILOA CR_OBJTY   CR_OBJTY Object types of the CIM resource
227 PPSID ILOA PPSID   PPSID Object ID of PP work center
228 PPSIDI ILOA PPSIDI   INH_PPSIDI Data origin for PP work center field
229 GSBER ILOA GSBER   GSBER Business Area
230 GSBERI ILOA GSBERI   INH_GSBERI Data origin for business area field
231 KOKRS ILOA KOKRS   KOKRS Controlling Area
232 KOKRSI ILOA KOKRSI   INH_KOKRSI Data origin for controlling area field
233 KOSTL ILOA KOSTL   KOSTL Cost Center
234 KOSTLI ILOA KOSTLI   INH_KOSTLI Data origin for cost center field
235 PROID ILOA PROID   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
236 PROIDI ILOA PROIDI   INH_PROIDI Data origin for WBS element field
237 BUKRS ILOA BUKRS   BUKRS Company Code
238 BUKRSI ILOA BUKRSI   INH_BUKRSI Data origin for company code field
239 ANLNR ILOA ANLNR   ANLN1 Main Asset Number
240 ANLNRI ILOA ANLNRI   INH_ANLNRI Data origin for asset main no./sub-no. fields
241 ANLUN ILOA ANLUN   ANLN2 Asset Subnumber
242 ANLUNI ILOA ANLUNI   INHER Data origin indicator
243 DAUFN ILOA DAUFN   DAUFN Standing order number
244 DAUFNI ILOA DAUFNI   INH_DAUFNI Data origin of standing order number field
245 AUFNR ILOA AUFNR   ILOM_ORDST Settlement order
246 AUFNRI ILOA AUFNRI   INH_AUFNRI Data origin for settlement order field
247 TPLNRI ILOA TPLNRI   INH_TPLNRI Data origin for functional location field
248 VKORG ILOA VKORG   VKORG Sales Organization
249 VKORGI ILOA VKORGI   INH_VKORGI Data origin for sales organization field
250 VTWEG ILOA VTWEG   VTWEG Distribution Channel
251 VTWEGI ILOA VTWEGI   INH_VTWEGI Data origin of distribution channel field
252 SPART ILOA SPART   SPART Division
253 SPARTI ILOA SPARTI   INH_SPARTI Data origin for division field
254 ADRNR ILOA ADRNR   AD_ADDRNUM Address number
255 ADRNRI ILOA ADRNRI   INH_ADRNRI Data origin for address field
256 OWNER ILOA OWNER   ILOM_OWNER Object reference indicator
257 VKBUR ILOA VKBUR   VKBUR Sales office
258 VKGRP ILOA VKGRP   VKGRP Sales group
259 - EQUI EQASP   EQASP Language in which the piece of equipment was entered
                 
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  20130529 
SAP Release Created in