SAP ABAP Table ALEQUI (Fields Relevant for Change Documents for Equip. (Action Log))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-WOC-MH (Application Component) Maintenance History
     ⤷ IWO2 (Package) Application Development R/3 Plant Maintenance Order History

Basic Data

Table Category	INTTAB	Structure
Structure	ALEQUI	Table Relationship Diagram
Short Description	Fields Relevant for Change Documents for Equip. (Action Log)

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	*
2	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	*
3	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	*
4	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
5	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
6	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
7	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
8	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
9	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
10	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
11	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	*
12	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
13	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
14	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	*
15	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
16	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
17	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
18	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
19	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
20	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
21	INBDT	☐	INBDT	DATUM	DATS	8	0	First start-up date
22	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
24	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
25	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
26	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
27	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
28	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	*
29	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	*
30	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	*
31	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
32	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	*
33	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
34	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	*
35	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
36	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	*
37	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	*
38	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
39	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
40	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	*
41	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	*
42	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
43	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	*
44	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
45	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
46	.INCLUDE	☐				0	0	ILOA Fields Relevant for Changes (Action Log)
47	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
48	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
49	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	*
50	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
51	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	*
52	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
53	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
54	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	*
55	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	*
56	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
57	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
58	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
59	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
60	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
61	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
62	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
63	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	*
64	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
65	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
66	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
67	.INCLUDE	☐				0	0	Identification Fields for a Fleet Object
68	FLEET_NUM	☐	FLEET_NUM	FLEET_NUM	CHAR	18	0	Identification number for fleet object
69	FLEET_VIN	☐	FLEET_VIN	FLEET_VIN	CHAR	30	0	Manufacturer Vehicle Identification Number for Fleet Object
70	CHASSIS_NUM	☐	CHASSIS_NUM	CHASSIS_NUM	CHAR	30	0	Chassis number
71	LICENSE_NUM	☐	LICENSE_NUM	LICENSE_NUM	CHAR	15	0	License plate number
72	EXPIRY_DATE	☐	EXPIRY_DATE	DATUM	DATS	8	0	Validity end date
73	.INCLUDE	☐				0	0	Fleet Attributes
74	FLEET_HGT	☐	FLEET_HGT	MENG13	QUAN	13	3	Maximum fleet object height
75	FLEET_WID	☐	FLEET_WID	MENG13	QUAN	13	3	Width of fleet object
76	FLEET_LEN	☐	FLEET_LEN	MENG13	QUAN	13	3	Maximum fleet object length
77	DIM_UNIT	☐	DIM_UNIT	MEINS	UNIT	3	0	Unit of length	T006
78	PRI_CALC	☐	PRI_CALC	PRI_CALC	CHAR	1	0	Indicator to determine the calculation method f. consumption	T370CLC
79	REPLA_DATE	☐	REPLA_DATE	DATUM	DATS	8	0	Date on which the object should be replaced
80	REPLA_ODOM	☐	REPLA_ODOM	FLTP_INOUT	CHAR	22	0	Odometer reading at replacement
81	REPLA_OPH	☐	REPLA_OPH	FLTP_INOUT	CHAR	22	0	Hour meter reading at replacement
82	NUM_AXLE	☐	NUM_AXLE	NUM2	NUMC	2	0	Number of Axles in Fleet Object
83	MAX_OCCUPANTS	☐	MAX_OCCUPANTS	NUM4	NUMC	4	0	Maximum number of occupants
84	CARD_NUM	☐	CARD_NUM	CHAR30	CHAR	30	0	Fuel card number
85	KEY_NUM	☐	KEY_NUM	CHAR20	CHAR	20	0	Key number of vehicle
86	FLEET_USE	☐	FLEET_USE	FLEET_USE	CHAR	1	0	Usage indicator	T370USG
87	ENGINE_TYPE	☐	ENGINE_TYPE	ENGINE_TYPE	CHAR	10	0	Engine type	T370ENG
88	ENGINE_POWER	☐	ENGINE_POWER	MENG13	QUAN	13	3	Power at specific number of revolutions per minute
89	UNIT_POWER	☐	UNIT_POWER	MEINS	UNIT	3	0	Power unit	T006
90	REVOLUTIONS	☐	REVOLUTIONS	NUM7	NUMC	7	0	Revolutions per minute
91	ENGINE_CYL	☐	ENGINE_CYL	NUM2	NUMC	2	0	Number of cylinders
92	ENGINE_CAP	☐	ENGINE_CAP	MENG13	QUAN	13	3	Engine capacity
93	UNIT_CAP	☐	UNIT_CAP	MEINS	UNIT	3	0	Unit for engine capacity measurement	T006
94	ENGINE_SNR	☐	ENGINE_SNR	CHAR30	CHAR	30	0	Engine serial number of manufacturer
95	FUEL_PRI	☐	FUEL_PRI	FLUID_TYPE	CHAR	12	0	Consumable Type of Primary Fuel	T370FLD
96	FUEL_SEC	☐	FUEL_SEC	FLUID_TYPE	CHAR	12	0	Consumable type of secondary fuel	T370FLD
97	OIL_TYPE	☐	FLTOIL_TYPE	FLUID_TYPE	CHAR	12	0	Consumable type of oil	T370FLD
98	GROSS_WGT	☐	GROSS_WGT	MENG13	QUAN	13	3	Total Weight Allowed
99	LOAD_WGT	☐	LOAD_WGT	MENG13	QUAN	13	3	Maximum load weight
100	WGT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	*
101	LOAD_HGT	☐	LOAD_HGT	MENG13	QUAN	13	3	Load height
102	LOAD_WID	☐	LOAD_WID	MENG13	QUAN	13	3	Load width
103	LOAD_LEN	☐	LOAD_LEN	MENG13	QUAN	13	3	Load length
104	LOAD_DIM_UNIT	☐	LOAD_DIM_UNIT	MEINS	UNIT	3	0	Unit for freight dimensions	T006
105	LOAD_VOL	☐	LOAD_VOL	MENG13	QUAN	13	3	Load volume
106	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
107	NO_COMPART	☐	NO_COMPART	NUM2	NUMC	2	0	NUmber of compartments
108	SPEED_MAX	☐	SPEED_MAX	MENG9	QUAN	9	3	Maximum Fleet Object Speed
109	SPEED_UNIT	☐	SPEED_UNIT	MEINS	UNIT	3	0	Speed Unit	T006
110	CONSUMP_TOL	☐	CONSUMP_TOL	CHAR1	CHAR	1	0	Indicator Consumption Recording: Permitted Tolerances
111	CONSUMP_MOVE	☐	CONSUMP_MOVE	CHAR1	CHAR	1	0	Indicator Consumption Recording: Material Movement
112	.INCLUDE	☐				0	0
113	.INCLU--AP	☐				0	0	Extension of Fleet Master for DSD
114	.INCLUDE	☐				0	0	Extension of Fleet Master for DSD
115	/DSD/RP_EIGEN	☐	/BEV1/RPEIGEN	/BEV1/RPEIGEN	CHAR	1	0	Indicator for Own (X) or External Vehicle
116	/DSD/RP_AHLAST	☐	/BEV1/RPAHLAST	MENG13	QUAN	13	3	Trailer Load
117	/DSD/RP_AHLAST_U	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
118	/DSD/RP_VARKAP	☐	/BEV1/RPVARKAP	/BEV1/RPVARKAP	QUAN	7	2	Free Capacity Field with Variable Unit of Measure
119	/DSD/RP_KAPUNIT	☐	/BEV1/RPKAPUNIT	MEINS	UNIT	3	0	Unit of Measure for Var. Capacity Field	T006
120	/BEV1/LULEINH	☐	/BEV1/LULEINH	/BEV1/LULEINH	NUMC	8	0	Loading Units
121	.INCLUDE	☐				0	0	Extension of Fleet Master with VSO Fleet Type
122	/VSO/M_VSO_FTYPE	☐	/VSO/M_VSO_FLT_TYPE	/VSO/M_VSO_FLT_TYPE	CHAR	10	0	Vehicle Type for Vehicle Space Optimation	/VSO/B_FLEET
123	.INCLUDE	☐				0	0	Action Log Change Documents Warranty Assignment
124	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
125	GWLEN	☐	GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
126	MGANR	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	*
127	GAERB	☐	GAERB	GAERB	CHAR	1	0	Indicator: Pass on Warranty
128	WAGET	☐	WAGET	GAERB	CHAR	1	0	Indicator, Whether Technical Object Should Inherit Warranty
129	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ALEQUI	/DSD/RP_AHLAST_U	T006	MSEHI
2	ALEQUI	/DSD/RP_KAPUNIT	T006	MSEHI
3	ALEQUI	/VSO/M_VSO_FTYPE	/VSO/B_FLEET	VSO_FTYPE
4	ALEQUI	DIM_UNIT	T006	MSEHI	KEY	1	CN
5	ALEQUI	ENGINE_TYPE	T370ENG	ENGINE_TYPE	KEY	1	CN
6	ALEQUI	FLEET_USE	T370USG	FLEET_USE	KEY	1	CN
7	ALEQUI	FUEL_PRI	T370FLD	FLUID_TYPE	KEY	1	CN
8	ALEQUI	FUEL_SEC	T370FLD	FLUID_TYPE	KEY	1	CN
9	ALEQUI	LOAD_DIM_UNIT	T006	MSEHI	KEY	1	CN
10	ALEQUI	OIL_TYPE	T370FLD	FLUID_TYPE	KEY	1	CN
11	ALEQUI	PRI_CALC	T370CLC	CALC_KEY	KEY	1	CN
12	ALEQUI	SPEED_UNIT	T006	MSEHI	KEY	1	CN
13	ALEQUI	UNIT_CAP	T006	MSEHI	KEY	1	CN
14	ALEQUI	UNIT_POWER	T006	MSEHI	KEY	1	CN
15	ALEQUI	VOL_UNIT	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in