SAP Table EMG_EANL

IS-U Mig: Struct. for Mig. Object INSTLN data

EMG_EANL (IS-U Mig: Struct. for Mig. Object INSTLN data) 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 EMG_EANL to other SAP tables.

EMG_EANL table fields

Field Data element Checktable Datatype Length Decimals
SPARTE Division SPARTE CHAR 2 0
VSTELLE Premise VSTELLE CHAR 10 0
ABLSPERR Reason for blocking meter reading ABLSPERR CHAR 2 0
BAPERTYP Base period category BAPERTYP CHAR 1 0
NULL Previous period
X Period of previous year
ANSCHREI Notification control for MR announcement/request ANSCHREI CHAR 10 0
SPEBENE Voltage Level SPEBENE CHAR 2 0
DRCKSTUF Gas Pressure Level at Installation Level (Grid) DRCKSTUF_GRID TE696 CHAR 2 0
ANLART Installation type ANLART CHAR 4 0
BEZUG Reference BEZUG CHAR 1 0
NULL Field inactive
X Field active
ABLESARTST Control of perm. number of cust. MRs and autom. estimations ABLESARTST CHAR 8 0
NODISCONCT Reason for guarantee of supply NODISCONCT CHAR 4 0
SERVICE Service Type SERCODE CHAR 4 0
DEREGSTAT Deregulation status DEREGSTAT CHAR 2 0
INFOREL Release Status for Installation Data INFOREL CHAR 2 0
ETIMEZONE Time Zone for EDM Objects EDM_TIMEZONE CHAR 6 0
OUCONT Outline Contract OUCONT CHAR 1 0
NULL Field inactive
X Field active
HOLICALID Public Holiday Calendar HOLICALID CHAR 2 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
TARIFTYP Rate category TARIFTYP_ANL CHAR 10 0
ANLSTAT Installation Status ANLSTAT CHAR 2 0
KONZBEFR Exempt from franchise fee KONZBEFR CHAR 1 0
NULL Field inactive
X Franchise fee exemption for customer
Y Franchise fee exemption for utility company
Z Franchise fee exemption for customer and utility company
PAUSCHAL Device allocation is not possible E_PAUSCHAL CHAR 1 0
NULL Field inactive
X Field active
BRANCHE Industry BU_IND_SECTOR TB038A CHAR 10 0
AKLASSE Billing class AKLASSE CHAR 4 0
ABLEINH Meter Reading Unit ABLEINHEIT CHAR 8 0
TEMP_AREA Temperature area TEMP_AREA CHAR 8 0
KONZVER Franchise contract KONZVER CHAR 10 0
BILLING_PARTY Service Provider that Bills the Installation BILLING_PARTY CHAR 10 0
INVOICING_PARTY Service Provider That Invoices the Contract INVOICING_PARTY CHAR 10 0
PROV_LAST_RES Obligation to Supply PROV_LAST_RESSORT CHAR 10 0
MAININST Key of Primary Installation MAININST EANL CHAR 10 0
INSTROLE Role of an Installation Within the Installation Group INSTROLE TE673 CHAR 4 0
INSTGRTYPE Grouping Type for Installation Group INSTGRTYPE TE672 CHAR 4 0
ISTYPE Industry System BU_ISTYPE TB038 CHAR 4 0
HIGHLEVINST Higher-Level Installation HIGHLEVINST EANL CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No

EMG_EANL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EMG_EANL BRANCHE EMG_EANL BRANCHE TB038A BP Industry Key IND_SECTOR
EMG_EANL BRANCHE SYST MANDT TB038A BP Industry Key CLIENT
EMG_EANL BRANCHE EMG_EANL ISTYPE TB038A BP Industry Key ISTYPE
EMG_EANL DRCKSTUF EMG_EANL DRCKSTUF TE696 Gas Pressure Level at Installation Level (Grid) DRUCKSTUF
EMG_EANL DRCKSTUF SYST MANDT TE696 Gas Pressure Level at Installation Level (Grid) MANDT
EMG_EANL HIGHLEVINST SYST MANDT EANL Installation .INCLUDE
EMG_EANL HIGHLEVINST EMG_EANL HIGHLEVINST EANL Installation MANDT
EMG_EANL INSTGRTYPE SYST MANDT TE672 Grouping Types of Installation Groups MANDT
EMG_EANL INSTGRTYPE EMG_EANL INSTGRTYPE TE672 Grouping Types of Installation Groups INSTGRTYPE
EMG_EANL INSTROLE SYST MANDT TE673 Installation Roles in an Installation Group MANDT
EMG_EANL INSTROLE EMG_EANL INSTROLE TE673 Installation Roles in an Installation Group INSTROLE
EMG_EANL ISTYPE SYST MANDT TB038 BP Industry Key Systems CLIENT
EMG_EANL ISTYPE EMG_EANL ISTYPE TB038 BP Industry Key Systems ISTYPE
EMG_EANL MAININST EMG_EANL MAININST EANL Installation MANDT
EMG_EANL MAININST SYST MANDT EANL Installation .INCLUDE