EGERH SAP (Historical Data of ISU Device Master Record) Table details

Dictionary Type: Table
Description: Historical Data of ISU Device Master Record




ABAP Code to SELECT data from EGERH
Related tables to EGERH
Access table EGERH




Table field list including key, data, relationships and ABAP select examples

EGERH is a standard SAP Table which is used to store Historical Data of ISU Device Master Record data and is available within R/3 SAP systems depending on the version and release level.

The EGERH table consists of various fields, each holding specific information or linking keys about Historical Data of ISU Device Master Record data available in SAP. These include EQUNR (Equipment Number), BIS (Date at Which a Time Slice Expires), AB (Date from which time slice is valid), KOMBINAT (Combination of a device category).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EGERH table 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
MANDTClient MANDTCLNT3T000MANDT
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
BISDate at Which a Time Slice Expires BISZEITSCHDATS8DATUM
ABDate from which time slice is valid ABZEITSCHDATS8DATUM
KOMBINATCombination of a device category KOMBINATCHAR8KOMBINAT
LOGIKNRLogical device number LOGIKNRNUMC18LOGIKNR
ZWGRUPPERegister Group E_ZWGRUPPECHAR8ALPHAGEGSTEZGEZWG
EINBDATInstallation date EINBDATDATS8DATUM
AUSBDATDevice removal date AUSBDATDATS8DATUM
GERWECHSActivity reason GERWECHSCHAR2TE401GERWECHS
DEVLOCDevice Location DEVLOCCHAR30Assigned to domainTPLNRTPLNRGEPEGPL
DEVGRPDevice group DEVGRPCHAR8Assigned to domainALPHADEVGRPDGP
WGRUPPEWinding group WGRUPPECHAR8ALPHAGEGSTEWK
PPM_METERPrepayment Meter PPM_METERNUMC2Assigned to domainPPM_METER
PRIMWNR1Winding number of active primary winding PRIMWNRNUMC2LFDNR2
SEKWNR1Winding number of active secondary winding SEKWNRNUMC2LFDNR2
PRIMWNR2Winding number of active primary winding PRIMWNRNUMC2LFDNR2
SEKWNR2Winding number of active secondary winding SEKWNRNUMC2LFDNR2
LOSSDTGROUPLoss Determination Group E_LOSSDTGROUPCHAR8TE1001E_LOSSDTGROUP
RATINGPower Transformer: Rating E_RATINGCHAR11Assigned to domainRAT11E_RATING_CHAR
P_VOLTAGEPower Transformer: Primary Voltage E_P_VOLTAGECHAR8Assigned to domainPVOLTE_P_VOLTAGE_CHAR
S_VOLTAGEPower Transformer: Secondary Voltage E_S_VOLTAGECHAR8Assigned to domainSVOLTE_S_VOLTAGE_CHAR
AMSAdvanced Metering System E_AMI_AMSCHAR4Assigned to domainE_AMI_AMS
AMCG_CAP_GRPAdvanced Meter Capability Group (AMCG) E_AMI_AMCG_CAP_GRPNUMC4E_AMI_CAP_GRP
MSG_ATTR_IDMessage Attribute E_AMI_MSG_ATTR_IDNUMC4Assigned to domainE_AMI_MSG_ATTR_ID
CAP_ACT_GRPActivation Group for AMI Capabilities (AMICAG) E_AMI_CAP_ACT_GRPNUMC4Assigned to domainE_AMI_CAPACT_GRP

Key field Non-key field



How do I retrieve data from SAP table EGERH using ABAP code

The following ABAP code Example will allow you to do a basic selection on EGERH to SELECT all data from the table
DATA: WA_EGERH TYPE EGERH.

SELECT SINGLE *
FROM EGERH
INTO CORRESPONDING FIELDS OF WA_EGERH
WHERE...

How to access SAP table EGERH

Within an ECC or HANA version of SAP you can also view further information about EGERH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!