1. Home
  2. Resources
  3. SAP Tables
  4. ISUMI_DEVICE_AUTO - IS-U Migration: Automation Data for DEVICE

SAP Table ISUMI_DEVICE_AUTO

IS-U Migration: Automation Data for DEVICE

ISUMI_DEVICE_AUTO (IS-U Migration: Automation Data for DEVICE) 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 ISUMI_DEVICE_AUTO to other SAP tables.

ISUMI_DEVICE_AUTO table fields

Field Data element Checktable Datatype Length Decimals
V_EQUI V_EQUI STRU 0 0
MANDT Client MANDT CLNT 3 0
EQUNR Equipment Number EQUNR CHAR 18 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
EQASP Language in Which the Piece of Equipment was Entered EQASP LANG 1 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Technical object authorization group IAUTG CHAR 4 0
EQTYP Equipment category EQTYP CHAR 1 0
EQART Type of Technical Object EQART CHAR 10 0
LVORM SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
INVNR Inventory number INVNR CHAR 25 0
GROES Size/dimension GROSS CHAR 18 0
BRGEW Weight of object OBJ_WEIGHT QUAN 13 3
GEWEI Unit of weight WEIGHT_UNIT UNIT 3 0
ANSDT Acquisition date ANDTI DATS 8 0
ANSWT Acquisition Value ANSWT CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
ELIEF Vendor number ELIEF CHAR 10 0
GWLEN Date on which the warranty ends GWLEN DATS 8 0
GWLDT Warranty Date GWLDT DATS 8 0
WDBWT Equipment replacement value WDBWT CURR 13 2
HERST Manufacturer of asset HERST CHAR 30 0
HERLD Country of manufacture HERLD CHAR 3 0
HZEIN Manufacturer drawing number HZEIN CHAR 30 0
SERGE Manufacturer serial number SERGE CHAR 30 0
TYPBZ Manufacturer model number TYPBZ CHAR 20 0
BAUJJ Year of construction BAUJJ CHAR 4 0
BAUMM Month of construction BAUMM CHAR 2 0
00
APLKZ Indicator: Task List Exists APLKZ CHAR 1 0
AULDT First delivery date of the equipment AULDT DATS 8 0
INBDT Start-up Date of the Technical Object ILOM_DATAB DATS 8 0
GERNR Serial Number GERNR CHAR 18 0
GWLDV Warranty date for Sales and Distribution GWLDV DATS 8 0
EQDAT Date, intended for SAP internal use EQDAT DATS 8 0
EQBER Technical information, intended for SAP internal use EQBER CHAR 30 0
EQNUM Numerical field, intended for SAP internal use EQNUM NUMC 9 0
OBJNR Object number J_OBJNR CHAR 22 0
EQSNR EQSE Number EQSNR CHAR 18 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
KRFKZ Referenced Configuration KRFKZ CHAR 1 0
X Yes
NULL No
KMATN Configurable Material KMATN CHAR 18 0
MATNR Material Number MATNR CHAR 18 0
SERNR Serial Number GERNR CHAR 18 0
WERK Plant WERKS_D CHAR 4 0
LAGER Storage Location LGORT_D CHAR 4 0
CHARGE Batch Number CHARG_D CHAR 10 0
KUNDE Customer to Whom Serial Number was Delivered KUNDSE CHAR 10 0
WARPL Maintenance Plan WARPL CHAR 12 0
IMRC_POINT Measuring Point IMRC_POINT CHAR 12 0
REVLV Revision Level REVLV CHAR 2 0
MGANR Master warranty number MGANR CHAR 20 0
BEGRUI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
S_EQUI Equipment data exists EQUIP_KNZ CHAR 1 0
X Yes
NULL No
S_SERIAL Serial data when maintaining equipment KZKSD CHAR 1 0
X Yes
NULL No
S_KONFI Configuration supported KONFKNZ CHAR 1 0
X Yes
NULL No
S_SALE Sales equipment SDKNZ CHAR 1 0
X Yes
NULL No
S_FHM Equip. category relevant to production resources and tools FHMKZ CHAR 1 0
NULL Blank
. Radio button
X Selection
S_ELSE Indicator: Other Data Active ELSE_KNZ CHAR 1 0
X Yes
NULL No
S_ISU IS-U data ISU_KNZ CHAR 1 0
X Yes
NULL No
S_EQBS EQSI Exists KZEQBS CHAR 1 0
S_FLEET Indicator: Fleet object active FLEET_KNZ CHAR 1 0
X Yes
NULL No
BSTVP Stock Check for Serial Numbers BSTVP CHAR 1 0
NULL No stock validation
1 Inconsistencies in stock data -> Warning
2 Inconsistencies in stock data -> Error
SPARTE Division SPARTE CHAR 2 0
HANDLE SAP Development Reserve: Integration of Date Segment (Key) ITOBTMP_TSEGGUID CHAR 22 0
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) ITOBTMP_TSEGTEMPLA CHAR 10 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
ACT_CHANGE_AA Change Equipment Master when Changing Asset AAPM_ACT_CHANGE_AA CHAR 1 0
NULL No synchronization
1 Saving triggers a workflow
2 Direct synchronization after saving
3 Direct synchronization plus workflow
S_CC Configuration Control Data CCC_KNZ CHAR 1 0
X Yes
NULL No
DATLWB Date of Last Goods Movement DATLWB DATS 8 0
UII Unique Item Identifier UII_CHAR72 CHAR 72 0
IUID_TYPE Structure Type of UII IUID_TYPE CHAR 10 0
UII_PLANT Plant Responsible for UII UII_PLANT CHAR 4 0
/GEP/PASSENGER Number of Passengers /GEP/FLEET_D_PASSENGER NUMC 2 0
/GEP/AUTOM Vehicle Equipment: Automatic Transmission /GEP/FLEET_D_AUTOM CHAR 1 0
X Yes
NULL No
/GEP/KLIMA Vehicle Equipment: Air Conditioning /GEP/FLEET_D_KLIMA CHAR 1 0
X Yes
NULL No
/GEP/DACHG Vehicle Equipment: Roof Rack /GEP/FLEET_D_DACHG CHAR 1 0
X Yes
NULL No
/GEP/SCHNEEK Vehicle Equipment: Snow Chains /GEP/FLEET_D_SCHNEEK CHAR 1 0
X Yes
NULL No
/GEP/WINTERR Vehicle Equipment: Snow Tyres /GEP/FLEET_D_WINTERR CHAR 1 0
X Yes
NULL No
/GEP/VHCAT Vehicle Type /GEP/FLEET_D_VHCAT CHAR 2 0
EQEXT_ACTIVE Backpack Table /isdfps/lmeqext Active /ISDFPS/DE_LM_DB_EQEXT_ACTIVE CHAR 1 0
X Yes
NULL No
/MRSS/ID_PROFILE Requirements Profile Was Changed Manually /MRSS/T_REQU_UPD CHAR 1 0
NULL FALSE
X TRUE
/MRSS/PROF_GUID GUID /MRSS/T_RSG_GUID RAW 16 0
/MRSS/PROF_KEY Profile Key /MRSS/T_RSG_REQUID CHAR 10 0
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EQUI_SRTYPE Shift Report Type COCF_SR_SRTYPE CHAR 10 0
EQUI_SNTYPE Shift Note Type COCF_SN_SNTYPE CHAR 2 0
EQLB_DUTY Logbook Duty DIACL_DUTY CHAR 1 0
NULL Blank
. Radio button
X Selection
EQLB_HIDE Hide Logbook Display DIACL_HIDE CHAR 1 0
NULL Blank
. Radio button
X Selection
DATBI Valid To Date DATBI DATS 8 0
EQLFN Consecutive numbering of EquipUsagePeriods on same day EQLFN NUMC 3 0
EQUZN Number of next EquipUsagePeriod on same day EQNNR NUMC 3 0
TIMBI Equipment usage period time stamp TIMBI TIMS 6 0
ESTAI SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
ESTAE SAP Development reserve: Format CHAR, length 4 RESERVE_CHAR_004 CHAR 4 0
STNAM SAP Development Reserve: Format CHAR, Length 12 RESERVE_CHAR_012 CHAR 12 0
DATAB Valid-From Date DATAB DATS 8 0
IWERK Maintenance Planning Plant IWERK CHAR 4 0
IWERKI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SUBMT Construction type material of the object SUBMT CHAR 18 0
MAPAR Manufacturer part number MAPAR CHAR 30 0
HEQUI Superordinate Equipment HEQUI CHAR 18 0
HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc) HEQNR CHAR 4 0
INGRP Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
INGRPI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PM_OBJTY Object Type of CIM Resources for Work Center PM_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
GEWRK Object ID of the Work Center LGWID NUMC 8 0
GEWRKI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
TIDNR Technical identification number TIDNR CHAR 25 0
TIDNRI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ILOAN Location and account assignment for technical object ILOAN CHAR 12 0
KUND1 Customer number KUND1 CHAR 10 0
KUND2 End customer number KUND2 CHAR 10 0
KUND3 Operator KUND3 CHAR 10 0
LIZNR Equipment license number LIZNR CHAR 20 0
RBNR Catalog Profile RBNR CHAR 9 0
EZDAT Date, intended for SAP internal use EQDAT DATS 8 0
EZBER Technical information, intended for SAP internal use EQBER CHAR 30 0
EZNUM Numerical field, intended for SAP internal use EQNUM NUMC 9 0
RBNR_I Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IBLNR Physical Inventory Document IBLNR CHAR 10 0
BLDAT Document Date in Document BLDAT DATS 8 0
PVS_FOCUS Internal Identification for PVS Objects PVS_GUID_CCC RAW 16 0
PPEGUID Internal Identification for PVS Objects PVS_GUID_CCC RAW 16 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
FUNCID Function Identifier CCC_FUNCID CHAR 40 0
FRCFIT Indicator: Forced Installation/Dismantling CCC_FRCFIT CHAR 1 0
X Entry Exists
NULL Entry Does Not Exist
FRCRMV Force Dismantling Flag CCC_FRCRMV CHAR 1 0
X Entry Exists
NULL Entry Does Not Exist
SPRAS Language Key SPRAS LANG 1 0
EQKTX Description of technical object KTX01 CHAR 40 0
KZLTX Long Text Indicator KZLTA CHAR 1 0
X Yes
NULL No
TXASP Primary language indicator for text segment KZMLA CHAR 1 0
EQKTU Equipment description in capital letters EQKTU CHAR 40 0
TPLNR Functional Location TPLNR CHAR 30 0
ABCKZ ABC indicator for technical object ABCKZ CHAR 1 0
ABCKZI Data origin for ABC indicator field INH_ABCKZI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EQFNR Sort field EQFNR CHAR 30 0
EQFNRI Data origin for sort field INH_EQFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SWERK Maintenance plant SWERK CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
STORT Location of maintenance object PMLOC CHAR 10 0
STORTI Data origin for location field INH_STORTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MSGRP Room RAUMNR CHAR 8 0
MSGRPI Data origin for room number field INH_MSGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BEBER Plant section BEBER CHAR 3 0
BEBERI Data origin for plant section field INH_BEBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
CR_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
PPSID Object ID of PP work center PPSID NUMC 8 0
PPSIDI Data origin for PP work center field INH_PPSIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
GSBER Business Area GSBER CHAR 4 0
GSBERI Data origin for business area field INH_GSBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOKRS Controlling Area KOKRS CHAR 4 0
KOKRSI Data origin for controlling area field INH_KOKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOSTL Cost Center KOSTL CHAR 10 0
KOSTLI Data origin for cost center field INH_KOSTLI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PROIDI Data origin for WBS element field INH_PROIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLNR Main Asset Number ANLN1 CHAR 12 0
ANLNRI Data origin for asset main no./sub-no. fields INH_ANLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLUN Asset Subnumber ANLN2 CHAR 4 0
ANLUNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
DAUFN Standing order number DAUFN CHAR 12 0
DAUFNI Data origin of standing order number field INH_DAUFNI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
AUFNR Settlement order ILOM_ORDST CHAR 12 0
AUFNRI Data origin for settlement order field INH_AUFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
TPLNRI Data origin for functional location field INH_TPLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VKORG Sales Organization VKORG CHAR 4 0
VKORGI Data origin for sales organization field INH_VKORGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VTWEG Distribution Channel VTWEG CHAR 2 0
VTWEGI Data origin of distribution channel field INH_VTWEGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SPART Division SPART CHAR 2 0
SPARTI Data origin for division field INH_SPARTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADRNR Address number AD_ADDRNUM CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
OWNER Object reference indicator ILOM_OWNER CHAR 1 0
NULL Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
LVORZ SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
ERNAZ Name of Person who Created the Object ERNAM CHAR 12 0
ERDAZ Date on Which Record Was Created ERDAT DATS 8 0
AENAZ Name of Person Who Changed Object AENAM CHAR 12 0
AEDAZ Changed On AEDAT DATS 8 0
EGERS EGERS STRU 0 0
MANDT Client MANDT CLNT 3 0
EQUNR Equipment Number EQUNR CHAR 18 0
EAGRUPPE Input/output group EAGRUPPE CHAR 8 0
KOMGRP ARCR Command Group KOMGRP CHAR 8 0
LOS Sample lot LOS CHAR 8 0
MESSDRCK Measured Pressure (Outlet Pressure) in Bars MESSDRCK DEC 7 4
UEBERVER Transformation ratio UEBERVER DEC 10 3
BESITZ Inspection relevance of device BESITZ NUMC 2 0
BGLJAHR Certification Year BGLJAHR NUMC 4 0
WECHSEL Advance replacement year WECHSEL NUMC 4 0
BGLSTAT Certification status BGLSTAT CHAR 1 0
NULL No restriction
1 No lot allocation possible
2 No certification possible at present
3 Certification no longer valid
KZSTICH Status of sample device KZSTICH CHAR 1 0
SCHWGRAD Difficulty level: Factor for meter reader payment SCHWGRAD DEC 3 1
PLOMBDAT Date of last lead sealing PLOMBDAT DATS 8 0
BGLART Type of certification BGLART CHAR 2 0
BGLNUM Certification number BGLNUM CHAR 15 0
UMBAUDAT Modification date UMBAUDAT DATS 8 0
UMBAUGR Modification reason UMBAUGR CHAR 2 0
EICHFAEL Use calibration validity EICHFAEL CHAR 1 0
NULL Field inactive
X Field active
PARAMETR Parametrization PARAMETR CHAR 8 0
PLOMBE Seal code PLOMBE CHAR 2 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
ZSPANNS Register factor: secondary transformer voltage E_ZSPANNS DEC 4 1
ZSTROMS Register factor: secondary transformer current E_ZSTROMS DEC 5 2
ZSPANNP Register factor: primary transformer voltage E_ZSPANNP DEC 6 0
ZSTROMP Register factor: primary transformer current E_ZSTROMP DEC 5 1
PRGRUPPE Inspection point group PRGRUPPE CHAR 8 0
BGLNETZ Certify installed devices BGLNETZ CHAR 1 0
NULL Field inactive
X Field active
ORDER_CODE Special Order Code for Dev./Dev. Category in Replacement ORDERCODE2 CHAR 4 0
APPROVALNR Device inspection number APPROVALNR CHAR 15 0
VLZEIT_DEV Individual cal. validity (years) of dev. subject to certif. VLZEIT_DEV DEC 2 0
NOTIF_CODE Notification code NOTIF_CODE CHAR 4 0
EGERH EGERH STRU 0 0
MANDT Client MANDT CLNT 3 0
EQUNR Equipment Number EQUNR CHAR 18 0
BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
KOMBINAT Combination of a device category KOMBINAT CHAR 8 0
LOGIKNR Logical device number LOGIKNR NUMC 18 0
ZWGRUPPE Register Group E_ZWGRUPPE CHAR 8 0
EINBDAT Installation date EINBDAT DATS 8 0
AUSBDAT Device removal date AUSBDAT DATS 8 0
GERWECHS Activity reason GERWECHS CHAR 2 0
DEVLOC Device Location DEVLOC CHAR 30 0
DEVGRP Device group DEVGRP CHAR 8 0
WGRUPPE Winding group WGRUPPE CHAR 8 0
PPM_METER Prepayment Meter PPM_METER NUMC 2 0
PRIMWNR1 Winding number of active primary winding PRIMWNR NUMC 2 0
SEKWNR1 Winding number of active secondary winding SEKWNR NUMC 2 0
PRIMWNR2 Winding number of active primary winding PRIMWNR NUMC 2 0
SEKWNR2 Winding number of active secondary winding SEKWNR NUMC 2 0
LOSSDTGROUP Loss Determination Group E_LOSSDTGROUP CHAR 8 0
RATING Power Transformer: Rating E_RATING CHAR 11 0
P_VOLTAGE Power Transformer: Primary Voltage E_P_VOLTAGE CHAR 8 0
S_VOLTAGE Power Transformer: Secondary Voltage E_S_VOLTAGE CHAR 8 0
AMS Advanced Metering System E_AMI_AMS CHAR 4 0
AMCG_CAP_GRP Advanced Meter Capability Group (AMCG) E_AMI_AMCG_CAP_GRP NUMC 4 0
MSG_ATTR_ID Message Attribute E_AMI_MSG_ATTR_ID NUMC 4 0
CAP_ACT_GRP Activation Group for AMI Capabilities (AMICAG) E_AMI_CAP_ACT_GRP NUMC 4 0
CLSHEAD EMG_CLSHEAD STRU 0 0
CLASS Class number KLASSE_D CHAR 18 0
CLASSTYPE Class Type KLASSENART CHAR 3 0
CLASS_STDFLAG Yes/No (X/ ) OAX CHAR 1 0
X Yes
NULL No
CLSDATA EMG_CLSDATA TTYP 0 0
CONTR EMG_CONTR STRU 0 0
CONV CHAR 1 0
INDIV CHAR 1 0
UPDATE CHAR 1 0
COMMIT CHAR 1 0
DIRECT CHAR 1 0