SAP ABAP View /DSD/RPVE_V2 (Database View for Search Help for Vehicle from Equipment)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ LE-DSD-RP (Application Component) Transportation Planning
     ⤷ /DSD/RP (Package) Transportation planning

Basic Data

View Type	D	Database View
Database View	/DSD/RPVE_V2
Short Description	Database View for Search Help for Vehicle from Equipment
Root table	EQUI	Equipment master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EQUI	EQUI
2	EQKT
3	FLEET
4	/DSD/RP_MOTRCAT
5	/DSD/RP_FLTTPLST
6	/DSD/RP_FLTLIC

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	EQKT	MANDT	JR	EQ			AND	0	0
3	EQUI	EQUNR	JL	EQ				0	0
4	EQKT	EQUNR	JR	EQ			AND	0	0
5	EQUI	MANDT	JL	EQ				0	0
6	FLEET	MANDT	JR	EQ			AND	0	0
7	EQUI	OBJNR	JL	EQ				0	0
8	FLEET	OBJNR	JR	EQ			AND	0	0
9	EQUI	MANDT	JL	EQ				0	0
10	/DSD/RP_MOTRCAT	MANDT	JR	EQ			AND	0	0
11	EQUI	EQTYP	JL	EQ				0	0
12	/DSD/RP_MOTRCAT	EQTYP	JR	EQ			AND	0	0
13	FLEET	FLEET_CAT	JL	EQ				0	0
14	/DSD/RP_MOTRCAT	FLEET_CAT	JR	EQ			AND	0	0
15	EQUI	MANDT	JL	EQ				0	0
16	/DSD/RP_FLTLIC	MANDT	JR	EQ			AND	0	0
17	EQUI	EQUNR	JL	EQ				0	0
18	/DSD/RP_FLTLIC	EQUNR	JR	EQ			AND	0	0
19	EQUI	MANDT	JL	EQ				0	0
20	/DSD/RP_FLTTPLST	MANDT	JR	EQ			AND	0	0
21	EQUI	EQUNR	JL	EQ				0	0
22	/DSD/RP_FLTTPLST	EQUNR	JR	EQ				0	0

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	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
4	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
5	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
6	GROES	EQUI	GROES		☐	GROSS	☐	Size/dimension
7	BRGEW	EQUI	BRGEW		☐	OBJ_WEIGHT	☐	Weight of object
8	GEWEI	EQUI	GEWEI		☐	WEIGHT_UNIT	☐	Unit of weight
9	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
10	HERST	EQUI	HERST		☐	HERST	☐	Manufacturer of asset
11	TYPBZ	EQUI	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
12	BAUJJ	EQUI	BAUJJ		☐	BAUJJ	☐	Year of construction
13	BAUMM	EQUI	BAUMM		☐	BAUMM	☐	Month of construction
14	GERNR	EQUI	GERNR		☐	GERNR	☐	Serial Number
15	EQLFN	EQUI	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
16	OBJNR	EQUI	OBJNR		☐	J_OBJNR	☐	Object number
17	EQSNR	EQUI	EQSNR		☐	EQSNR	☐	EQSE Number
18	CUOBJ	EQUI	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
19	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
20	SERNR	EQUI	SERNR		☐	GERNR	☐	Serial Number
21	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
22	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
23	S_FLEET	EQUI	S_FLEET		☐	FLEET_KNZ	☐	Indicator: Fleet object active
24	SPARTE	EQUI	SPARTE		☐	SPARTE	☐	Division
25	SPRAS	EQKT	SPRAS		☐	SPRAS	☐	Language Key
26	EQKTX	EQKT	EQKTX		☐	KTX01	☐	Description of technical object
27	FLEET_CAT	FLEET	FLEET_CAT		☐	FLEET_CAT	☐	Vehicle Type
28	FLEET_NUM	FLEET	FLEET_NUM		☐	FLEET_NUM	☐	Identification number for fleet object
29	FLEET_VIN	FLEET	FLEET_VIN		☐	FLEET_VIN	☐	Manufacturer Vehicle Identification Number for Fleet Object
30	CHASSIS_NUM	FLEET	CHASSIS_NUM		☐	CHASSIS_NUM	☐	Chassis number
31	LICENSE_NUM	FLEET	LICENSE_NUM		☐	LICENSE_NUM	☐	License plate number
32	FLEET_HGT	FLEET	FLEET_HGT		☐	FLEET_HGT	☐	Maximum fleet object height
33	FLEET_WID	FLEET	FLEET_WID		☐	FLEET_WID	☐	Width of fleet object
34	FLEET_LEN	FLEET	FLEET_LEN		☐	FLEET_LEN	☐	Maximum fleet object length
35	DIM_UNIT	FLEET	DIM_UNIT		☐	DIM_UNIT	☐	Unit of length
36	REPLA_DATE	FLEET	REPLA_DATE		☐	REPLA_DATE	☐	Date on which the object should be replaced
37	REPLA_ODOM	FLEET	REPLA_ODOM		☐	REPLA_ODOM	☐	Odometer reading at replacement
38	REPLA_OPH	FLEET	REPLA_OPH		☐	REPLA_OPH	☐	Hour meter reading at replacement
39	NUM_AXLE	FLEET	NUM_AXLE		☐	NUM_AXLE	☐	Number of Axles in Fleet Object
40	MAX_OCCUPANTS	FLEET	MAX_OCCUPANTS		☐	MAX_OCCUPANTS	☐	Maximum number of occupants
41	CARD_NUM	FLEET	CARD_NUM		☐	CARD_NUM	☐	Fuel card number
42	KEY_NUM	FLEET	KEY_NUM		☐	KEY_NUM	☐	Key number of vehicle
43	FLEET_USE	FLEET	FLEET_USE		☐	FLEET_USE	☐	Usage indicator
44	ENGINE_TYPE	FLEET	ENGINE_TYPE		☐	ENGINE_TYPE	☐	Engine type
45	ENGINE_POWER	FLEET	ENGINE_POWER		☐	ENGINE_POWER	☐	Power at specific number of revolutions per minute
46	UNIT_POWER	FLEET	UNIT_POWER		☐	UNIT_POWER	☐	Power unit
47	REVOLUTIONS	FLEET	REVOLUTIONS		☐	REVOLUTIONS	☐	Revolutions per minute
48	ENGINE_CYL	FLEET	ENGINE_CYL		☐	ENGINE_CYL	☐	Number of cylinders
49	ENGINE_CAP	FLEET	ENGINE_CAP		☐	ENGINE_CAP	☐	Engine capacity
50	UNIT_CAP	FLEET	UNIT_CAP		☐	UNIT_CAP	☐	Unit for engine capacity measurement
51	ENGINE_SNR	FLEET	ENGINE_SNR		☐	ENGINE_SNR	☐	Engine serial number of manufacturer
52	FUEL_PRI	FLEET	FUEL_PRI		☐	FUEL_PRI	☐	Consumable Type of Primary Fuel
53	FUEL_SEC	FLEET	FUEL_SEC		☐	FUEL_SEC	☐	Consumable type of secondary fuel
54	GROSS_WGT	FLEET	GROSS_WGT		☐	GROSS_WGT	☐	Total Weight Allowed
55	LOAD_WGT	FLEET	LOAD_WGT		☐	LOAD_WGT	☐	Maximum load weight
56	WGT_UNIT	FLEET	WGT_UNIT		☐	WEIGHT_UNIT	☐	Unit of weight
57	LOAD_HGT	FLEET	LOAD_HGT		☐	LOAD_HGT	☐	Load height
58	LOAD_WID	FLEET	LOAD_WID		☐	LOAD_WID	☐	Load width
59	LOAD_LEN	FLEET	LOAD_LEN		☐	LOAD_LEN	☐	Load length
60	LOAD_DIM_UNIT	FLEET	LOAD_DIM_UNIT		☐	LOAD_DIM_UNIT	☐	Unit for freight dimensions
61	LOAD_VOL	FLEET	LOAD_VOL		☐	LOAD_VOL	☐	Load volume
62	VOL_UNIT	FLEET	VOL_UNIT		☐	VOL_UNIT	☐	Volume unit
63	NO_COMPART	FLEET	NO_COMPART		☐	NO_COMPART	☐	NUmber of compartments
64	SPEED_MAX	FLEET	SPEED_MAX		☐	SPEED_MAX	☐	Maximum Fleet Object Speed
65	SPEED_UNIT	FLEET	SPEED_UNIT		☐	SPEED_UNIT	☐	Speed Unit
66	CONSUMP_TOL	FLEET	CONSUMP_TOL		☐	CONSUMP_TOL	☐	Indicator Consumption Recording: Permitted Tolerances
67	CONSUMP_MOVE	FLEET	CONSUMP_MOVE		☐	CONSUMP_MOVE	☐	Indicator Consumption Recording: Material Movement
68	/DSD/RP_EIGEN	FLEET	/DSD/RP_EIGEN		☐	/BEV1/RPEIGEN	☐	Indicator for Own (X) or External Vehicle
69	/DSD/RP_AHLAST	FLEET	/DSD/RP_AHLAST		☐	/BEV1/RPAHLAST	☐	Trailer Load
70	/DSD/RP_AHLAST_U	FLEET	/DSD/RP_AHLAST_U		☐	WEIGHT_UNIT	☐	Unit of weight
71	/DSD/RP_VARKAP	FLEET	/DSD/RP_VARKAP		☐	/BEV1/RPVARKAP	☐	Free Capacity Field with Variable Unit of Measure
72	/DSD/RP_KAPUNIT	FLEET	/DSD/RP_KAPUNIT		☐	/BEV1/RPKAPUNIT	☐	Unit of Measure for Var. Capacity Field
73	/VSO/M_VSO_FTYPE	FLEET	/VSO/M_VSO_FTYPE		☐	/VSO/M_VSO_FLT_TYPE	☐	Vehicle Type for Vehicle Space Optimation
74	LICENSE_CAT	/DSD/RP_FLTLIC	LICENSE_CAT		☐	/DSD/RP_LICENSE_CAT	☐	Driver's License Category
75	TPLST	/DSD/RP_FLTTPLST	TPLST		☐	TPLST	☐	Transportation planning point
76	RP_MOTR_CAT	/DSD/RP_MOTRCAT	RP_MOTR_CAT		☐	/DSD/RP_MOTR_CAT	☐	DSD Means of Transport Type

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