SAP table EANL (Installation)

SAP table EANL has 2 primary key fields being MANDT,ANLAGE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ANLAGE Installation CHAR 10 0 * ANLAGE
SPARTE Division CHAR 2 0 TESPT SPARTE
VSTELLE Premise CHAR 10 0 EVBS VSTELLE
ABLSPERR Reason for blocking meter reading CHAR 2 0 TE119 ABLSPERR
BAPERTYP Base period category CHAR 1 0 BAPERTYP
Previous period
X Period of previous year
ANSCHREI Notification control for MR announcement/request CHAR 10 0 * ANSCHREI
SPEBENE Voltage Level CHAR 2 0 TE369 SPEBENE
DRCKSTUF Gas Pressure Level at Installation Level (Grid) CHAR 2 0 TE696 DRCKSTUF_GRID
ANLART Installation type CHAR 4 0 TE439 ANLART
BEZUG Purchase CHAR 1 0 BEZUG
ABLESARTST Control of perm. number of cust. MRs and autom. estimations CHAR 8 0 TE438 ABLESARTST
NODISCONCT Reason for guarantee of supply CHAR 4 0 TE759 NODISCONCT
SERVICE Service Type CHAR 4 0 TECDE SERCODE
DEREGSTAT Deregulation status CHAR 2 0 TEDEREGSTAT DEREGSTAT
INFOREL Release Status for Installation Data CHAR 2 0 TEINFOREL INFOREL
ETIMEZONE Time Zone for EDM Objects CHAR 6 0 TTZZ EDM_TIMEZONE
OUCONT Outline Contract CHAR 1 0 OUCONT
HOLICALID Public Holiday Calendar CHAR 2 0 * HOLICALID
DUMMY_UTILSINST_INCL_EEW_PS UTILSINST Dummy Data Element for Extensibility CHAR 1 0 E_UTILSINST_INCL_EEW
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM
COLOGRP_INST Colocation group for Installation CHAR 12 0 E_COLOGRP_INST

EANL foreign key relationships

Table Field Check Table Check Field
0 EANL ABLESARTST TE438 Control of MR Type for which MR orders are created MANDT
1 EANL ABLSPERR TE119 MR Block. Reasons MANDT
1 EANL ABLSPERR TE119 MR Block. Reasons ABLSPERR
0 EANL ANLART TE439 Installation Type MANDT
0 EANL ANLART TE439 Installation Type ANLART
1 EANL DEREGSTAT TEDEREGSTAT Deregulation status MANDT
1 EANL DEREGSTAT TEDEREGSTAT Deregulation status DEREGSTAT
0 EANL DRCKSTUF TE696 Gas Pressure Level for Installation (Grid Pressure Level) MANDT
0 EANL DRCKSTUF TE696 Gas Pressure Level for Installation (Grid Pressure Level) DRUCKSTUF
1 EANL ETIMEZONE TTZZ Time zones TZONE
0 EANL INFOREL TEINFOREL Release Status for Installations MANDT
0 EANL INFOREL TEINFOREL Release Status for Installations INFOREL
1 EANL MANDT T000 Clients MANDT
0 EANL NODISCONCT TE759 Reason for Supply Guarantee MANDT
0 EANL NODISCONCT TE759 Reason for Supply Guarantee NODISCONCT
1 EANL SERVICE TECDE Service Types MANDT
0 EANL SPARTE TESPT Alloc. of Div. Cat. to Div. MANDT
1 EANL SPEBENE TE369 Voltage Level MANDT
1 EANL SPEBENE TE369 Voltage Level SPEBENE
0 EANL VSTELLE EVBS Premise MANDT
0 EANL VSTELLE EVBS Premise VSTELLE