ALEQUI SAP (Fields Relevant for Change Documents for Equip. (Action Log)) Structure details
Description: Fields Relevant for Change Documents for Equip. (Action Log)
Structure field list including key, data, relationships and ABAP select examples
ALEQUI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Fields Relevant for Change Documents for Equip. (Action Log)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ALEQUI TYPE ALEQUI.
The ALEQUI table consists of various fields, each holding specific information or linking keys about Fields Relevant for Change Documents for Equip. (Action Log) data available in SAP. These include EQTYP (Equipment category), EQART (Type of Technical Object), INVNR (Inventory number), GROES (Size/dimension).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ALEQUI structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | Assigned to domain | IAUTG | |||
EQTYP | Equipment category | EQTYP | CHAR | 1 | Assigned to domain | EQTYP | EQT | ||
EQART | Type of Technical Object | EQART | CHAR | 10 | Assigned to domain | EQART | |||
INVNR | Inventory number | INVNR | CHAR | 25 | INVNR_ANLA | ||||
GROES | Size/dimension | GROSS | CHAR | 18 | GROES | ||||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ANSDT | Acquisition date | ANDTI | DATS | 8 | DATUM | ||||
ANSWT | Acquisition Value | ANSWT | CURR | 13(2) | WERT | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ELIEF | Vendor number | ELIEF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
WDBWT | Equipment replacement value | WDBWT | CURR | 13(2) | WERT | ||||
HERST | Manufacturer of asset | HERST | CHAR | 30 | TEXT30 | ||||
HERLD | Country of manufacture | HERLD | CHAR | 3 | Assigned to domain | LAND1 | |||
HZEIN | Manufacturer drawing number | HZEIN | CHAR | 30 | HZEIN | ||||
SERGE | Manufacturer serial number | SERGE | CHAR | 30 | CHAR30 | ||||
TYPBZ | Manufacturer model number | TYPBZ | CHAR | 20 | TYPBZ | ||||
BAUJJ | Year of construction | BAUJJ | CHAR | 4 | GJAHR | CJAHR | |||
BAUMM | Month of construction | BAUMM | CHAR | 2 | BAUMM | ||||
AULDT | First delivery date of the equipment | AULDT | DATS | 8 | DATUM | ||||
INBDT | First start-up date | INBDT | DATS | 8 | DATUM | ||||
GWLDV | Warranty date for Sales and Distribution | GWLDV | DATS | 8 | DATUM | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
SERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
WERK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LAGER | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
CHARGE | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
KUNDE | Customer to Whom Serial Number was Delivered | KUNDSE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | Assigned to domain | ALPHA | WARPL | MPL | MPLAL |
IMRC_POINT | Measuring Point | IMRC_POINT | CHAR | 12 | Assigned to domain | ALPHA | IMRC_POINT | IPT | IMPM |
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | Assigned to domain | WERKS | IWK | ||
SUBMT | Construction type material of the object | SUBMT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MAPAR | Manufacturer part number | MAPAR | CHAR | 30 | MAPAR | ||||
HEQUI | Superordinate Equipment | HEQUI | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | ||
HEQNR | Equipment position at InstallLoc (Superior Equip./FunctLoc) | HEQNR | CHAR | 4 | CHAR4 | ||||
INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | Assigned to domain | INGRP | IHG | ||
GEWRK | Object ID of the Work Center | LGWID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
TIDNR | Technical identification number | TIDNR | CHAR | 25 | TIDNR | ||||
KUND1 | Customer number | KUND1 | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KUND2 | End customer number | KUND2 | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KUND3 | Operator | KUND3 | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
LIZNR | Equipment license number | LIZNR | CHAR | 20 | CHAR20 | ||||
RBNR | Catalog Profile | RBNR | CHAR | 9 | Assigned to domain | RBNR | |||
EQKTX | Description of technical object | KTX01 | CHAR | 40 | TEXT40 | ||||
PARNR | Number of contact person | PARNR | NUMC | 10 | PARNR | VPA | |||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | Assigned to domain | ILOAN | |||
TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | Assigned to domain | ABCKZ | |||
EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
SWERK | Maintenance plant | SWERK | CHAR | 4 | Assigned to domain | WERKS | SWK | ||
STORT | Location of maintenance object | PMLOC | CHAR | 10 | Assigned to domain | AP_STAND | |||
MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
BEBER | Plant section | BEBER | CHAR | 3 | Assigned to domain | BEBER | BBE | ||
PPSID | Object ID of PP work center | PPSID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
AUFNR | Settlement order | ILOM_ORDST | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ORDE | |
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
FLEET_NUM | Identification number for fleet object | FLEET_NUM | CHAR | 18 | FLEET_NUM | ||||
FLEET_VIN | Manufacturer Vehicle Identification Number for Fleet Object | FLEET_VIN | CHAR | 30 | FLEET_VIN | ||||
CHASSIS_NUM | Chassis number | CHASSIS_NUM | CHAR | 30 | CHASSIS_NUM | ||||
LICENSE_NUM | License plate number | LICENSE_NUM | CHAR | 15 | LICENSE_NUM | ||||
EXPIRY_DATE | Validity end date | EXPIRY_DATE | DATS | 8 | DATUM | ||||
FLEET_HGT | Maximum fleet object height | FLEET_HGT | QUAN | 13(3) | MENG13 | ||||
FLEET_WID | Width of fleet object | FLEET_WID | QUAN | 13(3) | MENG13 | ||||
FLEET_LEN | Maximum fleet object length | FLEET_LEN | QUAN | 13(3) | MENG13 | ||||
DIM_UNIT | Unit of length | DIM_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRI_CALC | Indicator to determine the calculation method f. consumption | PRI_CALC | CHAR | 1 | T370CLC | PRI_CALC | |||
REPLA_DATE | Date on which the object should be replaced | REPLA_DATE | DATS | 8 | DATUM | ||||
REPLA_ODOM | Odometer reading at replacement | REPLA_ODOM | CHAR | 22 | FLTP_INOUT | ||||
REPLA_OPH | Hour meter reading at replacement | REPLA_OPH | CHAR | 22 | FLTP_INOUT | ||||
NUM_AXLE | Number of Axles in Fleet Object | NUM_AXLE | NUMC | 2 | NUM2 | ||||
MAX_OCCUPANTS | Maximum number of occupants | MAX_OCCUPANTS | NUMC | 4 | NUM4 | ||||
CARD_NUM | Fuel card number | CARD_NUM | CHAR | 30 | CHAR30 | ||||
KEY_NUM | Key number of vehicle | KEY_NUM | CHAR | 20 | CHAR20 | ||||
FLEET_USE | Usage indicator | FLEET_USE | CHAR | 1 | T370USG | FLEET_USE | |||
ENGINE_TYPE | Engine type | ENGINE_TYPE | CHAR | 10 | T370ENG | ENGINE_TYPE | |||
ENGINE_POWER | Power at specific number of revolutions per minute | ENGINE_POWER | QUAN | 13(3) | MENG13 | ||||
UNIT_POWER | Power unit | UNIT_POWER | UNIT | 3 | T006 | CUNIT | MEINS | ||
REVOLUTIONS | Revolutions per minute | REVOLUTIONS | NUMC | 7 | NUM7 | ||||
ENGINE_CYL | Number of cylinders | ENGINE_CYL | NUMC | 2 | NUM2 | ||||
ENGINE_CAP | Engine capacity | ENGINE_CAP | QUAN | 13(3) | MENG13 | ||||
UNIT_CAP | Unit for engine capacity measurement | UNIT_CAP | UNIT | 3 | T006 | CUNIT | MEINS | ||
ENGINE_SNR | Engine serial number of manufacturer | ENGINE_SNR | CHAR | 30 | CHAR30 | ||||
FUEL_PRI | Consumable Type of Primary Fuel | FUEL_PRI | CHAR | 12 | T370FLD | FLUID_TYPE | |||
FUEL_SEC | Consumable type of secondary fuel | FUEL_SEC | CHAR | 12 | T370FLD | FLUID_TYPE | |||
OIL_TYPE | Consumable type of oil | FLTOIL_TYPE | CHAR | 12 | T370FLD | FLUID_TYPE | |||
GROSS_WGT | Total Weight Allowed | GROSS_WGT | QUAN | 13(3) | MENG13 | ||||
LOAD_WGT | Maximum load weight | LOAD_WGT | QUAN | 13(3) | MENG13 | ||||
WGT_UNIT | Unit of weight | WEIGHT_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LOAD_HGT | Load height | LOAD_HGT | QUAN | 13(3) | MENG13 | ||||
LOAD_WID | Load width | LOAD_WID | QUAN | 13(3) | MENG13 | ||||
LOAD_LEN | Load length | LOAD_LEN | QUAN | 13(3) | MENG13 | ||||
LOAD_DIM_UNIT | Unit for freight dimensions | LOAD_DIM_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
LOAD_VOL | Load volume | LOAD_VOL | QUAN | 13(3) | MENG13 | ||||
VOL_UNIT | Volume unit | VOL_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
NO_COMPART | NUmber of compartments | NO_COMPART | NUMC | 2 | NUM2 | ||||
SPEED_MAX | Maximum Fleet Object Speed | SPEED_MAX | QUAN | 9(3) | MENG9 | ||||
SPEED_UNIT | Speed Unit | SPEED_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
CONSUMP_TOL | Indicator Consumption Recording: Permitted Tolerances | CONSUMP_TOL | CHAR | 1 | CHAR1 | ||||
CONSUMP_MOVE | Indicator Consumption Recording: Material Movement | CONSUMP_MOVE | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
/DSD/RP_EIGEN | Indicator for Own (X) or External Vehicle | /BEV1/RPEIGEN | CHAR | 1 | /BEV1/RPEIGEN | ||||
/DSD/RP_AHLAST | Trailer Load | /BEV1/RPAHLAST | QUAN | 13(3) | MENG13 | ||||
/DSD/RP_AHLAST_U | Unit of weight | WEIGHT_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
/DSD/RP_VARKAP | Free Capacity Field with Variable Unit of Measure | /BEV1/RPVARKAP | QUAN | 7(2) | /BEV1/RPVARKAP | ||||
/DSD/RP_KAPUNIT | Unit of Measure for Var. Capacity Field | /BEV1/RPKAPUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
/BEV1/LULEINH | Loading Units | /BEV1/LULEINH | NUMC | 8 | /BEV1/LULEINH | ||||
/VSO/M_VSO_FTYPE | Vehicle Type for Vehicle Space Optimation | /VSO/M_VSO_FLT_TYPE | CHAR | 10 | /VSO/B_FLEET | /VSO/M_VSO_FLT_TYPE | |||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
GWLEN | Date on which the warranty ends | GWLEN | DATS | 8 | DATUM | ||||
MGANR | Master warranty number | MGANR | CHAR | 20 | Assigned to domain | ALPHA | MGANR | GAM | |
GAERB | Indicator: Pass on Warranty | GAERB | CHAR | 1 | GAERB | ||||
WAGET | Indicator, Whether Technical Object Should Inherit Warranty | WAGET | CHAR | 1 | GAERB |
Key field | Non-key field |
How do I retrieve data from SAP structure ALEQUI using ABAP code?
As ALEQUI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ALEQUI as there is no data to select.How to access SAP table ALEQUI
Within an ECC or HANA version of SAP you can also view further information about ALEQUI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects