SAP ABAP View V_FLEETEQBSIFLOS (PM Technical Objects (EQUI, Fleet Data) Including EQBS (Old))
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   PM-EQM-SF-MPC (Application Component) Measuring Points and Counters
     ITOBFLTCON (Package) PM Technische Objekte: Verbrauchssteuerung
Basic Data
View Type D Database View 
Database View V_FLEETEQBSIFLOS  
Short Description PM Technical Objects (EQUI, Fleet Data) Including EQBS (Old)    
Root table FLEET   Fleet Attributes 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 FLEET FLEET
2 EQUI  
3 EQUZ  
4 EQKT  
5 ILOA  
6 EQBS  
7 IFLOS  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 FLEET MANDT JL EQ 0 0
2 EQUI MANDT JR EQ AND 0 0
3 FLEET OBJNR JL EQ 0 0
4 EQUI OBJNR JR EQ AND 0 0
5 EQUI MANDT JL EQ 0 0
6 EQUZ MANDT JR EQ AND 0 0
7 EQUI EQUNR JL EQ 0 0
8 EQUZ EQUNR JR EQ AND 0 0
9 EQUI MANDT JL EQ 0 0
10 EQKT MANDT JR EQ AND 0 0
11 EQUI EQUNR JL EQ 0 0
12 EQKT EQUNR JR EQ AND 0 0
13 ILOA MANDT JL EQ 0 0
14 EQUZ MANDT JR EQ AND 0 0
15 ILOA ILOAN JL EQ 0 0
16 EQUZ ILOAN JR EQ AND 0 0
17 EQBS MANDT JL EQ 0 0
18 EQUI MANDT JR EQ AND 0 0
19 EQBS EQUNR JL EQ 0 0
20 EQUI EQUNR JR EQ AND 0 0
21 IFLOS MANDT JL EQ 0 0
22 ILOA MANDT JR EQ AND 0 0
23 IFLOS TPLNR JL EQ 0 0
24 ILOA TPLNR JR EQ AND 0 0
25 IFLOS ACTVS EQ 'X' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 * FLEET *    
2 MANDT FLEET MANDT   MANDT Client
3 OBJNR FLEET OBJNR   J_OBJNR Object number
4 OBJECT_GRP FLEET OBJECT_GRP   ITOBGROUP Grouping of technical objects in Plant Maintenance
5 FLEET_CAT FLEET FLEET_CAT   FLEET_CAT Vehicle Type
6 FLEET_NUM FLEET FLEET_NUM   FLEET_NUM Identification number for fleet object
7 FLEET_VIN FLEET FLEET_VIN   FLEET_VIN Manufacturer Vehicle Identification Number for Fleet Object
8 CHASSIS_NUM FLEET CHASSIS_NUM   CHASSIS_NUM Chassis number
9 LICENSE_NUM FLEET LICENSE_NUM   LICENSE_NUM License plate number
10 EXPIRY_DATE FLEET EXPIRY_DATE   EXPIRY_DATE Validity end date
11 FLEET_HGT FLEET FLEET_HGT   FLEET_HGT Maximum fleet object height
12 FLEET_WID FLEET FLEET_WID   FLEET_WID Width of fleet object
13 FLEET_LEN FLEET FLEET_LEN   FLEET_LEN Maximum fleet object length
14 DIM_UNIT FLEET DIM_UNIT   DIM_UNIT Unit of length
15 PRI_CALC FLEET PRI_CALC   PRI_CALC Indicator to determine the calculation method f. consumption
16 REPLA_DATE FLEET REPLA_DATE   REPLA_DATE Date on which the object should be replaced
17 REPLA_ODOM FLEET REPLA_ODOM   REPLA_ODOM Odometer reading at replacement
18 REPLA_OPH FLEET REPLA_OPH   REPLA_OPH Hour meter reading at replacement
19 NUM_AXLE FLEET NUM_AXLE   NUM_AXLE Number of Axles in Fleet Object
20 MAX_OCCUPANTS FLEET MAX_OCCUPANTS   MAX_OCCUPANTS Maximum number of occupants
21 CARD_NUM FLEET CARD_NUM   CARD_NUM Fuel card number
22 KEY_NUM FLEET KEY_NUM   KEY_NUM Key number of vehicle
23 FLEET_USE FLEET FLEET_USE   FLEET_USE Usage indicator
24 ENGINE_TYPE FLEET ENGINE_TYPE   ENGINE_TYPE Engine type
25 ENGINE_POWER FLEET ENGINE_POWER   ENGINE_POWER Power at specific number of revolutions per minute
26 UNIT_POWER FLEET UNIT_POWER   UNIT_POWER Power unit
27 REVOLUTIONS FLEET REVOLUTIONS   REVOLUTIONS Revolutions per minute
28 ENGINE_CYL FLEET ENGINE_CYL   ENGINE_CYL Number of cylinders
29 ENGINE_CAP FLEET ENGINE_CAP   ENGINE_CAP Engine capacity
30 UNIT_CAP FLEET UNIT_CAP   UNIT_CAP Unit for engine capacity measurement
31 ENGINE_SNR FLEET ENGINE_SNR   ENGINE_SNR Engine serial number of manufacturer
32 FUEL_PRI FLEET FUEL_PRI   FUEL_PRI Consumable Type of Primary Fuel
33 FUEL_SEC FLEET FUEL_SEC   FUEL_SEC Consumable type of secondary fuel
34 OIL_TYPE FLEET OIL_TYPE   FLTOIL_TYPE Consumable type of oil
35 GROSS_WGT FLEET GROSS_WGT   GROSS_WGT Total Weight Allowed
36 LOAD_WGT FLEET LOAD_WGT   LOAD_WGT Maximum load weight
37 WGT_UNIT FLEET WGT_UNIT   WEIGHT_UNIT Unit of weight
38 LOAD_HGT FLEET LOAD_HGT   LOAD_HGT Load height
39 LOAD_WID FLEET LOAD_WID   LOAD_WID Load width
40 LOAD_LEN FLEET LOAD_LEN   LOAD_LEN Load length
41 LOAD_DIM_UNIT FLEET LOAD_DIM_UNIT   LOAD_DIM_UNIT Unit for freight dimensions
42 LOAD_VOL FLEET LOAD_VOL   LOAD_VOL Load volume
43 VOL_UNIT FLEET VOL_UNIT   VOL_UNIT Volume unit
44 NO_COMPART FLEET NO_COMPART   NO_COMPART NUmber of compartments
45 SPEED_MAX FLEET SPEED_MAX   SPEED_MAX Maximum Fleet Object Speed
46 SPEED_UNIT FLEET SPEED_UNIT   SPEED_UNIT Speed Unit
47 CONSUMP_TOL FLEET CONSUMP_TOL   CONSUMP_TOL Indicator Consumption Recording: Permitted Tolerances
48 CONSUMP_MOVE FLEET CONSUMP_MOVE   CONSUMP_MOVE Indicator Consumption Recording: Material Movement
49 /DSD/RP_EIGEN FLEET /DSD/RP_EIGEN   /BEV1/RPEIGEN Indicator for Own (X) or External Vehicle
50 /DSD/RP_AHLAST FLEET /DSD/RP_AHLAST   /BEV1/RPAHLAST Trailer Load
51 /DSD/RP_AHLAST_U FLEET /DSD/RP_AHLAST_U   WEIGHT_UNIT Unit of weight
52 /DSD/RP_VARKAP FLEET /DSD/RP_VARKAP   /BEV1/RPVARKAP Free Capacity Field with Variable Unit of Measure
53 /DSD/RP_KAPUNIT FLEET /DSD/RP_KAPUNIT   /BEV1/RPKAPUNIT Unit of Measure for Var. Capacity Field
54 /BEV1/LULEINH FLEET /BEV1/LULEINH   /BEV1/LULEINH Loading Units
55 /VSO/M_VSO_FTYPE FLEET /VSO/M_VSO_FTYPE   /VSO/M_VSO_FLT_TYPE Vehicle Type for Vehicle Space Optimation
56 IS_SI_UNIT FLEET IS_SI_UNIT   IS_SI_UNIT PM: Vehicle Data in SI Unit (e.g. Dimensions)
57 * EQUI *    
58 - EQUI MANDT   MANDT Client
59 EQUNR EQUI EQUNR   EQUNR Equipment Number
60 ERDAT EQUI ERDAT   ERDAT Date on which the record was created
61 ERNAM EQUI ERNAM   ERNAM Name of Person who Created the Object
62 EQASP EQUI EQASP   EQASP Language in which the piece of equipment was entered
63 AEDAT EQUI AEDAT   AEDAT Last Changed On
64 AENAM EQUI AENAM   AENAM Name of Person Who Changed Object
65 BEGRU EQUI BEGRU   IAUTG Authorization Group for Technical Object
66 EQTYP EQUI EQTYP   EQTYP Equipment Category
67 EQART EQUI EQART   EQART Type of Technical Object
68 LVORM EQUI LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
69 INVNR EQUI INVNR   INVNR Inventory number
70 GROES EQUI GROES   GROSS Size/dimension
71 BRGEW EQUI BRGEW   OBJ_WEIGHT Weight of object
72 GEWEI EQUI GEWEI   WEIGHT_UNIT Unit of weight
73 ANSDT EQUI ANSDT   ANDTI Acquisition date
74 ANSWT EQUI ANSWT   ANSWT Acquisition Value
75 WAERS EQUI WAERS   WAERS Currency Key
76 ELIEF EQUI ELIEF   ELIEF Vendor number
77 GWLEN EQUI GWLEN   GWLEN Date on which the warranty ends
78 GWLDT EQUI GWLDT   GWLDT Guarantee date
79 WDBWT EQUI WDBWT   WDBWT Equipment replacement value
80 HERST EQUI HERST   HERST Manufacturer of asset
81 HERLD EQUI HERLD   HERLD Country of manufacture
82 HZEIN EQUI HZEIN   HZEIN Manufacturer drawing number
83 SERGE EQUI SERGE   SERGE Manufacturer serial number
84 TYPBZ EQUI TYPBZ   TYPBZ Manufacturer model number
85 BAUJJ EQUI BAUJJ   BAUJJ Year of construction
86 BAUMM EQUI BAUMM   BAUMM Month of construction
87 APLKZ EQUI APLKZ   APLKZ Indicator: Task List Exists
88 AULDT EQUI AULDT   AULDT First delivery date of the equipment
89 INBDT EQUI INBDT   ILOM_DATAB Start-up Date of the Technical Object
90 GERNR EQUI GERNR   GERNR Serial Number
91 - EQUI EQLFN   EQLFN Consecutive numbering of EquipUsagePeriods on same day
92 GWLDV EQUI GWLDV   GWLDV Warranty date for Sales and Distribution
93 EQDAT EQUI EQDAT   EQDAT Date
94 EQBER EQUI EQBER   EQBER Text for Notes
95 EQNUM EQUI EQNUM   EQNUM Numerical Field
96 - EQUI OBJNR   J_OBJNR Object number
97 EQSNR EQUI EQSNR   EQSNR EQSE Number
98 CUOBJ EQUI CUOBJ   CUOBJ Configuration (internal object number)
99 KRFKZ EQUI KRFKZ   KRFKZ Referenced Configuration
100 KMATN EQUI KMATN   KMATN Configurable Material
101 MATNR EQUI MATNR   MATNR Material Number
102 SERNR EQUI SERNR   GERNR Serial Number
103 WERK EQUI WERK   WERKS_D Plant
104 LAGER EQUI LAGER   LGORT_D Storage location
105 CHARGE EQUI CHARGE   CHARG_D Batch Number
106 KUNDE EQUI KUNDE   KUNDSE Customer to Whom Serial Number was Delivered
107 WARPL EQUI WARPL   WARPL Maintenance Plan
108 IMRC_POINT EQUI IMRC_POINT   IMRC_POINT Measuring Point
109 REVLV EQUI REVLV   REVLV Revision level
110 MGANR EQUI MGANR   MGANR Master warranty number
111 BEGRUI EQUI BEGRUI   INH_BEGRUI Data origin for authorization group field
112 S_EQUI EQUI S_EQUI   EQUIP_KNZ Equipment
113 S_SERIAL EQUI S_SERIAL   KZKSD Serial data when maintaining equipment
114 S_KONFI EQUI S_KONFI   KONFKNZ Configuration supported
115 S_SALE EQUI S_SALE   SDKNZ Sales equipment
116 S_FHM EQUI S_FHM   FHMKZ Equip. category relevant to production resources and tools
117 S_ELSE EQUI S_ELSE   ELSE_KNZ Indicator: Other Data Active
118 S_ISU EQUI S_ISU   ISU_KNZ IS-U data
119 S_EQBS EQUI S_EQBS   KZEQBS EQSI Exists
120 S_FLEET EQUI S_FLEET   FLEET_KNZ Indicator: Fleet object active
121 BSTVP EQUI BSTVP   BSTVP Stock Check for Serial Numbers
122 SPARTE EQUI SPARTE   SPARTE Division
123 HANDLE EQUI HANDLE   ITOBTMP_TSEGGUID SAP Development Reserve: Integration of Date Segment (Key)
124 TSEGTP EQUI TSEGTP   ITOBTMP_TSEGTEMPLA SAP Development Reserve: Integration Date Segment (Template)
125 EMATN EQUI EMATN   EMATN Material number corresponding to manufacturer part number
126 ACT_CHANGE_AA EQUI ACT_CHANGE_AA   AAPM_ACT_CHANGE_AA Change Equipment Master when Changing Asset
127 S_CC EQUI S_CC   CCC_KNZ Configuration Control Data
128 DATLWB EQUI DATLWB   DATLWB Date of Last Goods Movement
129 UII EQUI UII   UII_CHAR72 Unique Item Identifier
130 IUID_TYPE EQUI IUID_TYPE   IUID_TYPE Structure Type of UII
131 UII_PLANT EQUI UII_PLANT   UII_PLANT Plant Responsible for UII
132 EQEXT_ACTIVE EQUI EQEXT_ACTIVE   /ISDFPS/DE_LM_DB_EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active
133 EQUI_SRTYPE EQUI EQUI_SRTYPE   COCF_SR_SRTYPE Shift Report Type
134 EQUI_SNTYPE EQUI EQUI_SNTYPE   COCF_SN_SNTYPE Shift Note Type
135 EQLB_DUTY EQUI EQLB_DUTY   DIACL_DUTY Logbook Duty
136 EQLB_HIDE EQUI EQLB_HIDE   DIACL_HIDE Hide Logbook Display
137 * EQUZ *    
138 - EQUZ MANDT   MANDT Client
139 - EQUZ EQUNR   EQUNR Equipment Number
140 DATBI EQUZ DATBI   DATBI Valid To Date
141 EQLFN EQUZ EQLFN   EQLFN Consecutive numbering of EquipUsagePeriods on same day
142 EQUZN EQUZ EQUZN   EQNNR Number of next EquipUsagePeriod on same day
143 TIMBI EQUZ TIMBI   TIMBI Equipment usage period time stamp
144 ESTAI EQUZ ESTAI   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
145 ESTAE EQUZ ESTAE   RESERVE_CHAR_004 SAP Development reserve: Format CHAR, length 4
146 STNAM EQUZ STNAM   RESERVE_CHAR_012 SAP Development Reserve: Format CHAR, Length 12
147 DATAB EQUZ DATAB   DATAB Valid-From Date
148 IWERK EQUZ IWERK   IWERK Maintenance Planning Plant
149 IWERKI EQUZ IWERKI   INHER Data origin indicator
150 SUBMT EQUZ SUBMT   SUBMT Construction Type Material of the Object
151 MAPAR EQUZ MAPAR   MAPAR Manufacturer part number
152 HEQUI EQUZ HEQUI   HEQUI Superordinate Equipment
153 HEQNR EQUZ HEQNR   HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc)
154 INGRP EQUZ INGRP   INGRP Planner Group for Customer Service and Plant Maintenance
155 INGRPI EQUZ INGRPI   INHER Data origin indicator
156 PM_OBJTY EQUZ PM_OBJTY   PM_OBJTY Object Type of CIM Resources for Work Center
157 GEWRK EQUZ GEWRK   LGWID Object ID of the Work Center
158 GEWRKI EQUZ GEWRKI   INHER Data origin indicator
159 TIDNR EQUZ TIDNR   TIDNR Technical identification number
160 TIDNRI EQUZ TIDNRI   INHER Data origin indicator
161 ILOAN EQUZ ILOAN   ILOAN Location and account assignment for technical object
162 KUND1 EQUZ KUND1   KUND1 Customer No.
163 KUND2 EQUZ KUND2   KUND2 End customer number
164 KUND3 EQUZ KUND3   KUND3 Operator
165 LIZNR EQUZ LIZNR   LIZNR Equipment license number
166 RBNR EQUZ RBNR   RBNR Report layout
167 EZDAT EQUZ EZDAT   EQDAT Date
168 EZBER EQUZ EZBER   EQBER Text for Notes
169 EZNUM EQUZ EZNUM   EQNUM Numerical Field
170 RBNR_I EQUZ RBNR_I   INHER Data origin indicator
171 IBLNR EQUZ IBLNR   IBLNR Physical inventory document
172 BLDAT EQUZ BLDAT   BLDAT Document Date in Document
173 PVS_FOCUS EQUZ PVS_FOCUS   PVS_GUID_CCC Internal Identification for PVS Objects
174 PPEGUID EQUZ PPEGUID   PVS_GUID_CCC Internal Identification for PVS Objects
175 TECHS EQUZ TECHS   TECHS Parameter Variant/Standard Variant
176 FUNCID EQUZ FUNCID   CCC_FUNCID Function Identifier
177 FRCFIT EQUZ FRCFIT   CCC_FRCFIT Indicator: Forced Installation/Dismantling
178 FRCRMV EQUZ FRCRMV   CCC_FRCRMV Force Dismantling Flag
179 * EQKT *    
180 - EQKT MANDT   MANDT Client
181 - EQKT EQUNR   EQUNR Equipment Number
182 SPRAS EQKT SPRAS   SPRAS Language Key
183 EQKTX EQKT EQKTX   KTX01 Description of technical object
184 KZLTX EQKT KZLTX   KZLTA Long Text Indicator
185 TXASP EQKT TXASP   KZMLA Primary language indicator for text segment
186 EQKTU EQKT EQKTU   EQKTU Equipment description in capital letters
187 * ILOA *    
188 - ILOA MANDT   MANDT Client
189 - ILOA ILOAN   ILOAN Location and account assignment for technical object
190 - ILOA TPLNR   TPLNR Functional Location
191 ABCKZ ILOA ABCKZ   ABCKZ ABC Indicator for Technical Object
192 ABCKZI ILOA ABCKZI   INH_ABCKZI Data origin for ABC indicator field
193 EQFNR ILOA EQFNR   EQFNR Sort Field
194 EQFNRI ILOA EQFNRI   INH_EQFNRI Data origin for sort field
195 SWERK ILOA SWERK   SWERK Maintenance Plant
196 SWERKI ILOA SWERKI   INH_SWERKI Data origin for maintenance plant field
197 STORT ILOA STORT   PMLOC Location of maintenance object
198 STORTI ILOA STORTI   INH_STORTI Data origin for location field
199 MSGRP ILOA MSGRP   RAUMNR Room
200 MSGRPI ILOA MSGRPI   INH_MSGRPI Data origin for room number field
201 BEBER ILOA BEBER   BEBER Organizational Area
202 BEBERI ILOA BEBERI   INH_BEBERI Data origin for company area field
203 CR_OBJTY ILOA CR_OBJTY   CR_OBJTY Object types of the CIM resource
204 PPSID ILOA PPSID   PPSID Object ID of PP work center
205 PPSIDI ILOA PPSIDI   INH_PPSIDI Data origin for PP work center field
206 GSBER ILOA GSBER   GSBER Business Area
207 GSBERI ILOA GSBERI   INH_GSBERI Data origin for business area field
208 KOKRS ILOA KOKRS   KOKRS Controlling Area
209 KOKRSI ILOA KOKRSI   INH_KOKRSI Data origin for controlling area field
210 KOSTL ILOA KOSTL   KOSTL Cost Center
211 KOSTLI ILOA KOSTLI   INH_KOSTLI Data origin for cost center field
212 PROID ILOA PROID   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
213 PROIDI ILOA PROIDI   INH_PROIDI Data origin for WBS element field
214 BUKRS ILOA BUKRS   BUKRS Company Code
215 BUKRSI ILOA BUKRSI   INH_BUKRSI Data origin for company code field
216 ANLNR ILOA ANLNR   ANLN1 Main Asset Number
217 ANLNRI ILOA ANLNRI   INH_ANLNRI Data origin for asset main no./sub-no. fields
218 ANLUN ILOA ANLUN   ANLN2 Asset Subnumber
219 ANLUNI ILOA ANLUNI   INHER Data origin indicator
220 DAUFN ILOA DAUFN   DAUFN Standing order number
221 DAUFNI ILOA DAUFNI   INH_DAUFNI Data origin of standing order number field
222 AUFNR ILOA AUFNR   ILOM_ORDST Settlement order
223 AUFNRI ILOA AUFNRI   INH_AUFNRI Data origin for settlement order field
224 TPLNRI ILOA TPLNRI   INH_TPLNRI Data origin for functional location field
225 VKORG ILOA VKORG   VKORG Sales Organization
226 VKORGI ILOA VKORGI   INH_VKORGI Data origin for sales organization field
227 VTWEG ILOA VTWEG   VTWEG Distribution Channel
228 VTWEGI ILOA VTWEGI   INH_VTWEGI Data origin of distribution channel field
229 SPART ILOA SPART   SPART Division
230 SPARTI ILOA SPARTI   INH_SPARTI Data origin for division field
231 ADRNR ILOA ADRNR   AD_ADDRNUM Address number
232 ADRNRI ILOA ADRNRI   INH_ADRNRI Data origin for address field
233 OWNER ILOA OWNER   ILOM_OWNER Object reference indicator
234 VKBUR ILOA VKBUR   VKBUR Sales office
235 VKGRP ILOA VKGRP   VKGRP Sales group
236 * EQBS *    
237 - EQBS MANDT   MANDT Client
238 - EQBS EQUNR   EQUNR Equipment Number
239 LBBSA EQBS LBBSA   LBBSA Stock Type of Goods Movement (Primary Posting)
240 B_WERK EQBS B_WERK   WERKS_D Plant
241 B_LAGER EQBS B_LAGER   LGORT_D Storage location
242 B_CHARGE EQBS B_CHARGE   B_CHARGE Batch Number
243 SOBKZ EQBS SOBKZ   SOBKZ Special Stock Indicator
244 KUNNR EQBS KUNNR   B_KUNNR Customer account number
245 LIFNR EQBS LIFNR   B_LIFNR Account number of the vendor
246 KDAUF EQBS KDAUF   KDAUF Sales Order Number
247 KDPOS EQBS KDPOS   KDPOS Item number in Sales Order
248 PS_PSP_PNR EQBS PS_PSP_PNR   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
249 LVORZ EQUZ LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
250 ERNAZ EQUZ ERNAM   ERNAM Name of Person who Created the Object
251 ERDAZ EQUZ ERDAT   ERDAT Date on which the record was created
252 AENAZ EQUZ AENAM   AENAM Name of Person Who Changed Object
253 AEDAZ EQUZ AEDAT   AEDAT Last Changed On
254 TPLNR IFLOS STRNO   ILOM_STRNO Functional location label
255 ALKEY IFLOS ALKEY   ILOM_ALKEY Labeling system for functional locations
256 VERSN IFLOS VERSN   ILOM_VERSN Version of functional location label
257 TPLNR_INT IFLOS TPLNR   TPLNR Functional Location
                 
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 110