SAP table FLEET (Fleet Attributes)

SAP table FLEET has 2 primary key fields being MANDT,OBJNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
OBJECT_GRP Grouping of technical objects in Plant Maintenance CHAR 2 0 ITOBGROUP
01 Functional location
02 Equipment/serial number
FLEET_CAT Fleet Object Type CHAR 10 0 T370FLT FLEET_CAT
FLEET_NUM Identification number for fleet object CHAR 18 0 FLEET_NUM
FLEET_VIN Manufacturer Vehicle Identification Number for Fleet Object CHAR 30 0 FLEET_VIN
CHASSIS_NUM Chassis number CHAR 30 0 CHASSIS_NUM
LICENSE_NUM License plate number CHAR 15 0 LICENSE_NUM
EXPIRY_DATE Validity end date DATS 8 0 EXPIRY_DATE
FLEET_HGT Maximum fleet object height QUAN 13 3 FLEET_HGT
FLEET_WID Width of fleet object QUAN 13 3 FLEET_WID
FLEET_LEN Maximum fleet object length QUAN 13 3 FLEET_LEN
DIM_UNIT Unit of length UNIT 3 0 T006 DIM_UNIT
PRI_CALC Indicator to determine the calculation method f. consumption CHAR 1 0 T370CLC PRI_CALC
REPLA_DATE Date on which the object should be replaced DATS 8 0 REPLA_DATE
REPLA_ODOM Odometer reading at replacement CHAR 22 0 REPLA_ODOM
REPLA_OPH Hour meter reading at replacement CHAR 22 0 REPLA_OPH
NUM_AXLE Number of Axles in Fleet Object NUMC 2 0 NUM_AXLE
MAX_OCCUPANTS Maximum number of occupants NUMC 4 0 MAX_OCCUPANTS
CARD_NUM Fuel card number CHAR 30 0 CARD_NUM
KEY_NUM Key number of vehicle CHAR 20 0 KEY_NUM
FLEET_USE Usage indicator CHAR 1 0 T370USG FLEET_USE
ENGINE_TYPE Engine type CHAR 10 0 T370ENG ENGINE_TYPE
ENGINE_POWER Power at specific number of revolutions per minute QUAN 13 3 ENGINE_POWER
UNIT_POWER Power unit UNIT 3 0 T006 UNIT_POWER
REVOLUTIONS Revolutions per minute NUMC 7 0 REVOLUTIONS
ENGINE_CYL Number of cylinders NUMC 2 0 ENGINE_CYL
ENGINE_CAP Engine capacity QUAN 13 3 ENGINE_CAP
UNIT_CAP Unit for engine capacity measurement UNIT 3 0 T006 UNIT_CAP
ENGINE_SNR Engine serial number of manufacturer CHAR 30 0 ENGINE_SNR
FUEL_PRI Consumable Type of Primary Fuel CHAR 12 0 T370FLD FUEL_PRI
FUEL_SEC Consumable type of secondary fuel CHAR 12 0 T370FLD FUEL_SEC
OIL_TYPE Consumable type of oil CHAR 12 0 T370FLD FLTOIL_TYPE
GROSS_WGT Total Weight Allowed QUAN 13 3 GROSS_WGT
LOAD_WGT Maximum load weight QUAN 13 3 LOAD_WGT
WGT_UNIT Unit of weight UNIT 3 0 * WEIGHT_UNIT
LOAD_HGT Load height QUAN 13 3 LOAD_HGT
LOAD_WID Load width QUAN 13 3 LOAD_WID
LOAD_LEN Load length QUAN 13 3 LOAD_LEN
LOAD_DIM_UNIT Unit for freight dimensions UNIT 3 0 T006 LOAD_DIM_UNIT
LOAD_VOL Load volume QUAN 13 3 LOAD_VOL
VOL_UNIT Volume unit UNIT 3 0 T006 VOL_UNIT
NO_COMPART NUmber of compartments NUMC 2 0 NO_COMPART
SPEED_MAX Maximum Fleet Object Speed QUAN 9 3 SPEED_MAX
SPEED_UNIT Speed Unit UNIT 3 0 T006 SPEED_UNIT
CONSUMP_TOL Indicator Consumption Recording: Permitted Tolerances CHAR 1 0 CONSUMP_TOL
CONSUMP_MOVE Indicator Consumption Recording: Material Movement CHAR 1 0 CONSUMP_MOVE
/DSD/RP_EIGEN Indicator for Own (X) or External Vehicle CHAR 1 0 /BEV1/RPEIGEN
External
X Own
/DSD/RP_AHLAST Trailer Load QUAN 13 3 /BEV1/RPAHLAST
/DSD/RP_AHLAST_U Unit of weight UNIT 3 0 T006 WEIGHT_UNIT
/DSD/RP_VARKAP Free Capacity Field with Variable Unit of Measure QUAN 7 2 /BEV1/RPVARKAP
/DSD/RP_KAPUNIT Unit of Measure for Var. Capacity Field UNIT 3 0 T006 /BEV1/RPKAPUNIT
/BEV1/LULEINH Loading Units NUMC 8 0 /BEV1/LULEINH
/VSO/M_VSO_FTYPE Vehicle Type for Vehicle Space Optimation CHAR 10 0 /VSO/B_FLEET /VSO/M_VSO_FLT_TYPE
IS_SI_UNIT PM: Vehicle Data in SI Unit (e.g. Dimensions) CHAR 1 0 IS_SI_UNIT
Not in SI/DB Unit
E SI Unit set individually (old)
F DB Unit set individually (new)
X SI Unit set through (old)
Y DB Unit set through (new)

FLEET foreign key relationships

Table Field Check Table Check Field
0 FLEET /DSD/RP_AHLAST_U T006 Units of Measurement MANDT
0 FLEET /DSD/RP_AHLAST_U T006 Units of Measurement MSEHI
1 FLEET /DSD/RP_KAPUNIT T006 Units of Measurement MANDT
1 FLEET /DSD/RP_KAPUNIT T006 Units of Measurement MSEHI
0 FLEET DIM_UNIT T006 Units of Measurement MANDT
0 FLEET DIM_UNIT T006 Units of Measurement MSEHI
1 FLEET ENGINE_TYPE T370ENG Engine Type MANDT
1 FLEET ENGINE_TYPE T370ENG Engine Type ENGINE_TYPE
0 FLEET FLEET_CAT T370FLT Fleet Types MANDT
1 FLEET FLEET_USE T370USG Fleet Usage MANDT
0 FLEET FUEL_PRI T370FLD Fluid Types MANDT
0 FLEET FUEL_PRI T370FLD Fluid Types FLUID_TYPE
1 FLEET FUEL_SEC T370FLD Fluid Types MANDT
1 FLEET FUEL_SEC T370FLD Fluid Types FLUID_TYPE
0 FLEET LOAD_DIM_UNIT T006 Units of Measurement MANDT
0 FLEET LOAD_DIM_UNIT T006 Units of Measurement MSEHI
1 FLEET MANDT T000 Clients MANDT
0 FLEET OBJNR ONR00 General Object Number MANDT
1 FLEET OIL_TYPE T370FLD Fluid Types MANDT
1 FLEET OIL_TYPE T370FLD Fluid Types FLUID_TYPE
0 FLEET PRI_CALC T370CLC Fleet Consumption Calculation Keys MANDT
1 FLEET SPEED_UNIT T006 Units of Measurement MANDT
1 FLEET SPEED_UNIT T006 Units of Measurement MSEHI
0 FLEET UNIT_CAP T006 Units of Measurement MANDT
0 FLEET UNIT_CAP T006 Units of Measurement MSEHI
1 FLEET UNIT_POWER T006 Units of Measurement MANDT
1 FLEET UNIT_POWER T006 Units of Measurement MSEHI
0 FLEET VOL_UNIT T006 Units of Measurement MANDT
0 FLEET VOL_UNIT T006 Units of Measurement MSEHI