1. Home
  2. Resources
  3. SAP Tables
  4. ALM_ME_EQUIPMENT_LIST - Equipment list

SAP Table ALM_ME_EQUIPMENT_LIST

Equipment list

ALM_ME_EQUIPMENT_LIST (Equipment list) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ALM_ME_EQUIPMENT_LIST to other SAP tables.

ALM_ME_EQUIPMENT_LIST table fields

Field Data element Checktable Datatype Length Decimals
EQUIPMENT Equipment Number EQUNR EQUI CHAR 18 0
LANGU Language Key SPRAS T002 LANG 1 0
LANGU_ISO 2-Character SAP Language Code LAISO CHAR 2 0
EQUIDESCR Description of technical object KTX01 CHAR 40 0
EQUICATGRY Equipment category EQTYP T370T CHAR 1 0
PLANPLANT Maintenance Planning Plant IWERK T001W CHAR 4 0
MAINTPLANT Maintenance plant SWERK T001W CHAR 4 0
LOCATION Asset location STORT T499S CHAR 10 0
MAINTROOM Room RAUMNR CHAR 8 0
PLSECTN Plant section BEBER T357 CHAR 3 0
ABCINDIC ABC indicator for technical object ABCKZ T370C CHAR 1 0
SORTFIELD Sort field EQFNR CHAR 30 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
ASSET_NO Main Asset Number ANLN1 ANLH CHAR 12 0
SUB_NUMBER Asset Subnumber ANLN2 ANLA CHAR 4 0
BUS_AREA Business Area GSBER TGSB CHAR 4 0
COSTCENTER Cost Center KOSTL CHAR 10 0
STDGORD Standing order number DAUFN AUFK CHAR 12 0
ORDERID Order Number AUFNR AUFK CHAR 12 0
FUNCTLOC Functional Location Label ILOM_STRNO CHAR 40 0
TECHID Technical identification number TIDNR CHAR 25 0
SUPEREQUI Superordinate Equipment HEQUI EQUI CHAR 18 0
POSEQUI Equipment position at InstallLoc (Superior Equip./FunctLoc) HEQNR CHAR 4 0
CONSTTYPE Construction type material of the object SUBMT MARA CHAR 18 0
SERIALNO Serial Number GERNR CHAR 18 0
MANPARNO Manufacturer part number MAPAR CHAR 30 0
PLANGROUP Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
VENDOR Vendor number ELIEF LFA1 CHAR 10 0
ACQUISVAL Acquisition Value ANSWT CURR 13 2
REFERENCE Referenced Configuration KRFKZ CHAR 1 0
X Yes
NULL No
CURRENCY Currency Key WAERS CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
INVENTORY Inventory number INVNR CHAR 25 0
INV_SIZE Size/dimension GROSS CHAR 18 0
GROSS_WT Gross Weight BRGEW QUAN 13 3
CONSTYR Year of construction BAUJJ CHAR 4 0
CONSTMTH Month of construction BAUMM CHAR 2 0
00
MANFACTURE Manufacturer of asset HERST CHAR 30 0
MANCOUNTRY Country of manufacture HERLD CHAR 3 0
MANCOUNTRY_ISO Country key in ISO code LAND1_ISO CHAR 2 0
DRAWING Manufacturer drawing number HZEIN CHAR 30 0
SERNO Manufacturer serial number SERGE CHAR 30 0
CUSTOMER Customer number KUND1 CHAR 10 0
ENDCUSTOM End customer number KUND2 CHAR 10 0
OPERATOR Operator KUND3 CHAR 10 0
LICENSE Equipment license number LIZNR CHAR 20 0
WORK_CNTR Work center ARBPL CHAR 8 0
MN_WK_CTR Main work center for maintenance tasks GEWRK CHAR 8 0
CREATED_ON Date on Which Record Was Created ERDAT DATS 8 0
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
CH_ON Changed On AEDAT DATS 8 0
CHANGED_BY Name of Person Who Changed Object AENAM CHAR 12 0
VALID_FROM Valid-From Date DATAB DATS 8 0
AUTHGRP Technical object authorization group IAUTG CHAR 4 0
CONFIGBMAT Configurable Material KMATN CHAR 18 0
MATERIAL Material Number MATNR CHAR 18 0
PLANT Plant WERKS_D CHAR 4 0
MANMODEL Manufacturer model number TYPBZ CHAR 20 0
STGE_LOC Storage Location LGORT_D CHAR 4 0
BATCH Batch Number CHARG_D CHAR 10 0
SERIAL_CUSTOMER Customer to Whom Serial Number was Delivered KUNDSE CHAR 10 0
VALID_TO Valid-to Date IDATBI DATS 8 0
S_STATUS System status line J_STEXT CHAR 40 0
LOC_ACC Location and account assignment for technical object ILOAN CHAR 12 0
U_STATUS User Status Line J_ATEXT CHAR 40 0
OBJECT_NO Object number J_OBJNR CHAR 22 0
CATPROFILE Catalog Profile RBNR CHAR 9 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
EQUITYPE Type of Technical Object EQART CHAR 10 0
ACQDATE Acquisition date ANDTI DATS 8 0
SALESORG Sales Organization VKORG CHAR 4 0
DISTR_CHAN Distribution Channel VTWEG CHAR 2 0
DIVISION Division SPART CHAR 2 0
ADDR_NO Addresses: Address Number CADNR CHAR 10 0
CLIENT Client MANDT CLNT 3 0
LIST_NAME Name for list displays I_NAME_LST CHAR 35 0
TEL1_NUMBR First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
POSTL_COD1 City postal code AD_PSTCD1 CHAR 10 0
CITY City AD_CITY1 CHAR 40 0
DISTRICT District AD_CITY2 CHAR 40 0
COUNTRY Country Key LAND1 CHAR 3 0
COUNTRY_ISO Country key in ISO code LAND1_ISO CHAR 2 0
REGION Region (State, Province, County) REGIO CHAR 3 0
STREET Street AD_STREET CHAR 60 0
PROFIT_SEGM_NO Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
INT_OBJ_NO Configuration (internal object number) CUOBJ NUMC 18 0
UNIT_OF_WT Weight Unit GEWEI UNIT 3 0
UNIT_OF_WT_ISO Base unit of measure in ISO code MEINS_ISO CHAR 3 0
CO_AREA Controlling Area KOKRS CHAR 4 0
DELDATE First delivery date of the equipment AULDT DATS 8 0
DATE_OF_FIRST_RUN First start-up date INBDT DATS 8 0
CONSECNO Consecutive numbering of EquipUsagePeriods on same day EQLFN NUMC 3 0
CONSTTYPE_2 Construction Type Description SUBMTKTX CHAR 40 0
STOCK_TYPE Stock Type of Goods Movement (Primary Posting) LBBSA CHAR 2 0
SPEC_STOCK Special Stock Indicator SOBKZ CHAR 1 0
CUSTOMER_2 Account Number of Customer EKUNN CHAR 10 0
VENDOR_2 Vendor Account Number ELIFN CHAR 10 0
SALES_ORD Sales Order Number KDAUF CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
WBS_ELEMENT_SER Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
BATCH_2 Batch Number B_CHARGE CHAR 10 0
TIME Equipment usage period time stamp TIMBI TIMS 6 0
MATL_DESC Material Description (Short Text) MAKTX CHAR 40 0
FUNCLDESCR Description of functional location PLTXT CHAR 40 0
CUSTOMER_WAR_DATE Customer Warranty Start IGWLDT_K DATS 8 0
CUSTOMER_WARRANTY Warranty End for Customer IGWLEN_K DATS 8 0
CUSTOMER_MSTR_WRTY Master Warranty Number for Customer IMGANR_K CHAR 20 0
CUSTOMER_WARRANTY_TEXT Customer Warranty Description IGARTXL_K CHAR 40 0
VENDOR_WAR_DATE Vendor Warranty Start IGWLDT_L DATS 8 0
VENDOR_WARRANTY Warranty End for Vendor IGWLEN_L DATS 8 0
VENDOR_MSTR_WRTY Master Warranty Number for Vendor IMGANR_L CHAR 20 0
WARRANTY_TEXT Vendor Warranty Description IGARTXL_L CHAR 40 0
LONG_TEXT Indicator: Long text exists ILOM_KZLTX CHAR 1 0
X Yes
NULL No
TS_CREATED Date on Which Record Was Created ERDAT DATS 8 0
DATE_CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
DATE_CH_ON Changed On AEDAT DATS 8 0
DATE_CHANGED_BY Name of Person Who Changed Object AENAM CHAR 12 0

ALM_ME_EQUIPMENT_LIST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ALM_ME_EQUIPMENT_LIST ABCINDIC ALM_ME_EQUIPMENT_LIST CLIENT T370C ABC indicator for technical objects MANDT
ALM_ME_EQUIPMENT_LIST ABCINDIC ALM_ME_EQUIPMENT_LIST ABCINDIC T370C ABC indicator for technical objects ABCKZ
ALM_ME_EQUIPMENT_LIST ASSET_NO ALM_ME_EQUIPMENT_LIST CLIENT ANLH Main asset number MANDT
ALM_ME_EQUIPMENT_LIST ASSET_NO ALM_ME_EQUIPMENT_LIST COMP_CODE ANLH Main asset number BUKRS
ALM_ME_EQUIPMENT_LIST ASSET_NO ALM_ME_EQUIPMENT_LIST ASSET_NO ANLH Main asset number ANLN1
ALM_ME_EQUIPMENT_LIST BUS_AREA ALM_ME_EQUIPMENT_LIST CLIENT TGSB Business Areas MANDT
ALM_ME_EQUIPMENT_LIST BUS_AREA ALM_ME_EQUIPMENT_LIST BUS_AREA TGSB Business Areas GSBER
ALM_ME_EQUIPMENT_LIST COMP_CODE ALM_ME_EQUIPMENT_LIST CLIENT T001 Company Codes MANDT
ALM_ME_EQUIPMENT_LIST COMP_CODE ALM_ME_EQUIPMENT_LIST COMP_CODE T001 Company Codes BUKRS
ALM_ME_EQUIPMENT_LIST CONSTTYPE ALM_ME_EQUIPMENT_LIST CONSTTYPE MARA General Material Data MATNR
ALM_ME_EQUIPMENT_LIST CONSTTYPE ALM_ME_EQUIPMENT_LIST CLIENT MARA General Material Data MANDT
ALM_ME_EQUIPMENT_LIST EQUICATGRY ALM_ME_EQUIPMENT_LIST CLIENT T370T Equipment categories MANDT
ALM_ME_EQUIPMENT_LIST EQUICATGRY ALM_ME_EQUIPMENT_LIST EQUICATGRY T370T Equipment categories EQTYP
ALM_ME_EQUIPMENT_LIST EQUIPMENT ALM_ME_EQUIPMENT_LIST EQUIPMENT EQUI Equipment master data EQUNR
ALM_ME_EQUIPMENT_LIST EQUIPMENT ALM_ME_EQUIPMENT_LIST CLIENT EQUI Equipment master data MANDT
ALM_ME_EQUIPMENT_LIST LANGU ALM_ME_EQUIPMENT_LIST LANGU T002 Language Keys (Component BC-I18) SPRAS
ALM_ME_EQUIPMENT_LIST LOCATION ALM_ME_EQUIPMENT_LIST CLIENT T499S Location MANDT
ALM_ME_EQUIPMENT_LIST LOCATION ALM_ME_EQUIPMENT_LIST MAINTPLANT T499S Location WERKS
ALM_ME_EQUIPMENT_LIST LOCATION ALM_ME_EQUIPMENT_LIST LOCATION T499S Location STAND
ALM_ME_EQUIPMENT_LIST MAINTPLANT ALM_ME_EQUIPMENT_LIST CLIENT T001W Plants/Branches MANDT
ALM_ME_EQUIPMENT_LIST MAINTPLANT ALM_ME_EQUIPMENT_LIST MAINTPLANT T001W Plants/Branches WERKS
ALM_ME_EQUIPMENT_LIST ORDERID ALM_ME_EQUIPMENT_LIST CLIENT AUFK Order master data MANDT
ALM_ME_EQUIPMENT_LIST ORDERID ALM_ME_EQUIPMENT_LIST ORDERID AUFK Order master data AUFNR
ALM_ME_EQUIPMENT_LIST PLANGROUP ALM_ME_EQUIPMENT_LIST PLANGROUP T024I Maintenance planner groups INGRP
ALM_ME_EQUIPMENT_LIST PLANGROUP ALM_ME_EQUIPMENT_LIST CLIENT T024I Maintenance planner groups MANDT
ALM_ME_EQUIPMENT_LIST PLANGROUP ALM_ME_EQUIPMENT_LIST MAINTPLANT T024I Maintenance planner groups IWERK
ALM_ME_EQUIPMENT_LIST PLANPLANT ALM_ME_EQUIPMENT_LIST CLIENT T001W Plants/Branches MANDT
ALM_ME_EQUIPMENT_LIST PLANPLANT ALM_ME_EQUIPMENT_LIST PLANPLANT T001W Plants/Branches WERKS
ALM_ME_EQUIPMENT_LIST PLSECTN ALM_ME_EQUIPMENT_LIST CLIENT T357 Plant Section MANDT
ALM_ME_EQUIPMENT_LIST PLSECTN ALM_ME_EQUIPMENT_LIST MAINTPLANT T357 Plant Section WERKS
ALM_ME_EQUIPMENT_LIST PLSECTN ALM_ME_EQUIPMENT_LIST PLSECTN T357 Plant Section BEBER
ALM_ME_EQUIPMENT_LIST STDGORD ALM_ME_EQUIPMENT_LIST CLIENT AUFK Order master data MANDT
ALM_ME_EQUIPMENT_LIST STDGORD ALM_ME_EQUIPMENT_LIST STDGORD AUFK Order master data AUFNR
ALM_ME_EQUIPMENT_LIST SUB_NUMBER ALM_ME_EQUIPMENT_LIST ASSET_NO ANLA Asset Master Record Segment ANLN1
ALM_ME_EQUIPMENT_LIST SUB_NUMBER ALM_ME_EQUIPMENT_LIST SUB_NUMBER ANLA Asset Master Record Segment ANLN2
ALM_ME_EQUIPMENT_LIST SUB_NUMBER ALM_ME_EQUIPMENT_LIST CLIENT ANLA Asset Master Record Segment MANDT
ALM_ME_EQUIPMENT_LIST SUB_NUMBER ALM_ME_EQUIPMENT_LIST COMP_CODE ANLA Asset Master Record Segment BUKRS
ALM_ME_EQUIPMENT_LIST SUPEREQUI ALM_ME_EQUIPMENT_LIST CLIENT EQUI Equipment master data MANDT
ALM_ME_EQUIPMENT_LIST SUPEREQUI ALM_ME_EQUIPMENT_LIST SUPEREQUI EQUI Equipment master data EQUNR
ALM_ME_EQUIPMENT_LIST VENDOR ALM_ME_EQUIPMENT_LIST CLIENT LFA1 Vendor Master (General Section) MANDT
ALM_ME_EQUIPMENT_LIST VENDOR ALM_ME_EQUIPMENT_LIST VENDOR LFA1 Vendor Master (General Section) LIFNR