SAP table ALM_ME_EQUIPMENT_LIST (Equipment list)

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

ALM_ME_EQUIPMENT_LIST foreign key relationships

Table Field Check Table Check Field
0 ALM_ME_EQUIPMENT_LIST ABCINDIC T370C ABC indicator for technical objects MANDT
1 ALM_ME_EQUIPMENT_LIST ASSET_NO ANLH Main asset number BUKRS
1 ALM_ME_EQUIPMENT_LIST ASSET_NO ANLH Main asset number ANLN1
0 ALM_ME_EQUIPMENT_LIST BUS_AREA TGSB Business Areas MANDT
0 ALM_ME_EQUIPMENT_LIST BUS_AREA TGSB Business Areas GSBER
1 ALM_ME_EQUIPMENT_LIST COMP_CODE T001 Company Codes BUKRS
0 ALM_ME_EQUIPMENT_LIST CONSTTYPE MARA General Material Data MATNR
1 ALM_ME_EQUIPMENT_LIST EQUICATGRY T370T Equipment categories MANDT
1 ALM_ME_EQUIPMENT_LIST EQUICATGRY T370T Equipment categories EQTYP
0 ALM_ME_EQUIPMENT_LIST EQUIPMENT EQUI Equipment master data MANDT
1 ALM_ME_EQUIPMENT_LIST LOCATION T499S Location MANDT
1 ALM_ME_EQUIPMENT_LIST LOCATION T499S Location WERKS
0 ALM_ME_EQUIPMENT_LIST MAINTPLANT T001W Plants/Branches MANDT
0 ALM_ME_EQUIPMENT_LIST MAINTPLANT T001W Plants/Branches WERKS
1 ALM_ME_EQUIPMENT_LIST ORDERID AUFK Order master data AUFNR
0 ALM_ME_EQUIPMENT_LIST PLANGROUP T024I Maintenance planner groups INGRP
1 ALM_ME_EQUIPMENT_LIST PLANPLANT T001W Plants/Branches MANDT
1 ALM_ME_EQUIPMENT_LIST PLANPLANT T001W Plants/Branches WERKS
0 ALM_ME_EQUIPMENT_LIST PLSECTN T357 Plant Section MANDT
0 ALM_ME_EQUIPMENT_LIST PLSECTN T357 Plant Section BEBER
1 ALM_ME_EQUIPMENT_LIST STDGORD AUFK Order master data AUFNR
0 ALM_ME_EQUIPMENT_LIST SUB_NUMBER ANLA Asset Master Record Segment BUKRS
0 ALM_ME_EQUIPMENT_LIST SUB_NUMBER ANLA Asset Master Record Segment ANLN1
0 ALM_ME_EQUIPMENT_LIST SUB_NUMBER ANLA Asset Master Record Segment ANLN2
1 ALM_ME_EQUIPMENT_LIST SUPEREQUI EQUI Equipment master data MANDT
0 ALM_ME_EQUIPMENT_LIST VENDOR LFA1 Supplier Master (General Section) MANDT
0 ALM_ME_EQUIPMENT_LIST VENDOR LFA1 Supplier Master (General Section) LIFNR