SAP table EABL (MR Document)

SAP table EABL has 2 primary key fields being MANDT,ABLBELNR.

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
ABLBELNR Internal ID for meter reading document CHAR 20 0 ABLBELNR
GERNR Device CHAR 18 0 GERAET
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
ZWNUMMER Register NUMC 3 0 E_ZWNUMMER
ADAT Meter reading date relevant to billing DATS 8 0 ADAT
ATIM Meter reading time (relevant to billing) CHAR 4 0 ATIM
V_ZWSTAND Places Before Decimal Point in Meter Reading DEC 17 0 V_ZWSTAND
N_ZWSTAND Places After Decimal Point in the Meter Reading DEC 14 14 N_ZWSTAND
V_ZWSTNDAB Predecimal Places in Billed Meter Reading DEC 17 0 V_ZWSTNDAB
N_ZWSTNDAB Decimal Places in the Billed Meter Reading DEC 14 14 N_ZWSTNDAB
MASSREAD Unit of measurement for meter reading UNIT 3 0 T006 E_MASSREAD
MASSBILL Unit of measurement for billing UNIT 3 0 T006 E_MASSBILL
STANZVOR Number of predecimal places for register NUMC 2 0 STANZVORE
STANZNAC Number of decimal places for register NUMC 2 0 STANZNACE
SCHAEVER Estimation procedure CHAR 2 0 SCHAEVER
01 Automatic estimation without adjustment of meter reading
02 Estimation by clerk
03 Automatic estimation with adjustment of meter reading
SCHAEGR Estimation reason CHAR 2 0 TE567 SCHAEGR
AKTIV Meter reading active CHAR 1 0 E_AKTIV
0 Not Active
1 Active
2 For demand only: only active in current period
3 For demand only: not active - info lines written
ADATSOLL Scheduled meter reading date DATS 8 0 ADATSOLL
ADATMAX Date of maximum meter reading DATS 8 0 ADATMAX
ATIMMAX Time of maximum meter reading CHAR 4 0 ATIMMAX
ADATTATS Actual meter reading date DATS 8 0 ADATTATS
ATIMTATS Actual meter reading time CHAR 4 0 ATIMTATS
ADATERZ Meter reading date of implausible meter reading result DATS 8 0 ADATERZ
ATIMERZ Meter reading time of implausible meter reading result CHAR 4 0 ATIMERZ
ADATPROG Meter reading date from which forecast is made DATS 8 0 ADATPROG
ATIMPROG Meter reading time from which consumption is determined CHAR 4 0 ATIMPROG
ZUORDDAT Meter reading allocation date DATS 8 0 E_ZUORDDAT
THGDATUM Gas allocation date DATS 8 0 THGDATUM
PRUEFZAHL Check number NUMC 2 0 PRUEFZAHL
BAPERTYP Base period category CHAR 1 0 BAPERTYP
Previous period
X Period of previous year
ABLSTAT Meter Reading Status CHAR 1 0 ABLSTAT
* Partially Billed
0 Meter reading order created
1 Billable
2 Automatically Locked
3 Locked by Agent
4 Released by Agent
5 Checked Independently
7 Billed
PRUEFPKT Independent validation CHAR 2 0 TE218 PRUEFPKT
POPCODE Dependent validation CHAR 2 0 TE625 POPCODE
PRUEFTYP Validation category for meter readings CHAR 1 0 PRUEFTYP
B Usage hour check (measured demand)
C Cosine phi check for demand
G Check against contract demand limit
H Serial switching check
K Check against control meter
L Totals check of all demand meters
M Check of multi-rate meters
O Cosine phi check for energy
S Consumption totals check
V Usage hour check (contract demand)
X Usage hour check at the device level (measured demand)
ABLHINW Note from meter reader CHAR 4 0 TE259 ABLHINW
STABLHW Control of follow-up action for MR result with MR note CHAR 2 0 STABLHW
01 Automatically estimate meter reading result
02 Reset meter reading
03 Accept meter reading without check
04 Card stored for meter reading by customer
05 Device replacement
KONTRVRF Indicator: dummy record from automatic control procedure CHAR 1 0 KONTRVRF
ABLESART Scheduled meter reading category CHAR 2 0 TE614 GEPLABL
ABLESER Meter reader number CHAR 3 0 TE115 ABLESER
NACHERF Meter reading result inserted or modified CHAR 1 0 NACHERF
MDENR Number for mobile data entry (MDE) NUMC 3 0 MDENR
MDEUPL Order has been output CHAR 1 0 MDEDOWN
E_ZEITVBL Multiple meter reading order creation CHAR 1 0 E_ZEITVBL
E_ZVLZUORD Multiple allocation NUMC 3 0 E_ZVLZUORD
STEUERGRP Control group for multiple meter reading order creation CHAR 4 0 TE629 STEUERGRP
ARBAUF Control Meter Reading Order ID Printed CHAR 1 0 ARBAUF
KSTATUS Status for automatic monitoring of meter reading order CHAR 1 0 E_KSTATUS
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
ENTRYNUMB Entry number for fast entry NUMC 8 0 ENTRYNUMB
ACTOR Concatinated Identification (Type and ID) of Org. Objects CHAR 14 0 HROBJEC_14
ISTABLART Meter reading type CHAR 2 0 TE436 ISTABLART
ABLESTYP Meter reading category CHAR 2 0 TE614 ABLESTYP
E_ZVBL_BEZDAT Scheduled meter reading date for base meter reading DATS 8 0 E_ZVBL_BEZDAT
SM_AUFNR Service order or notification CHAR 12 0 PM_SVCNR
DOC_TYPE Document category for plant maintenance and customer service CHAR 1 0 KZ_SM_DOC_TYPE
N Notifications
O Orders
ADATREAL [JBP] Real Meter Reading Date DATS 8 0 ADATREAL
ATIMREAL [JBP] Real Meter Reading Time CHAR 4 0 ATIMREAL
S_ISTABLART [JBP] Meter Reading Type for Original Meter Reading CHAR 2 0 S_ISTABLART
S_AKTIV [JBP] Orig. Meter Reading: Meter Reading Active CHAR 1 0 S_AKTIV
S_ABLSTAT [JBP] Original Meter Reading Status CHAR 1 0 S_ABLSTAT
S_V_ZWSTAND [JBP] Orig. MR: Decimal Places Before Meter reading DEC 17 0 S_V_ZWSTAND
S_N_ZWSTAND [JBP] Decimal Places of Meter Readings for Original MR DEC 14 14 S_N_ZWSTAND
S_V_ZWSTNDAB [JBP] Predecimal Places of Billed MR for Original MR DEC 17 0 S_V_ZWSTNDAB
S_N_ZWSTNDAB [JBP] Decimal Places of Billed Orginal Meter Reading DEC 14 14 S_N_ZWSTNDAB
REMOVED [JBP] Status Indicator: MR Result Suppressed CHAR 1 0 REMOVED
Meter Reading Result: NORMAL
X Meter Reading Result: OBSELETE
BP Selection of Billing Period: Standard or JBP CHAR 1 0 BP
Standard
J Japanese
REM_ABLBELNR [JBP] Suppressed MR Document Number CHAR 20 0 REM_ABLBELNR
REM_ABLESER Meter Reader Number of Suppressed Meter Reading CHAR 3 0 * R_ABLESER
S_ADATSOLL Scheduled meter reading date DATS 8 0 ADATSOLL
S_ZVBL_BEZDAT Scheduled meter reading date for base meter reading DATS 8 0 E_ZVBL_BEZDAT
AMS Advanced Metering System CHAR 4 0 TEAMI_AMS E_AMI_AMS
TRANSSTAT Transfer Status Code CHAR 5 0 ISU_F4_AMITRSTAT E_AMI_MR_TRANSSTAT
TRANSTSTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
SOURCESYST Source System From Which Data is Requested NUMC 1 0 E_AMI_SOURCESYST
QNT Quantity Determined from Meter Reading in Internal Format DEC 31 14 E_QD_QNT
QDSTAT Status of Quantity Determination CHAR 2 0 E_QD_STAT
No Action
1 Quantity Determination Not Necessary
2 Quantity Determination Performed Successfully
3 Quantity Determination Trigger Generated
QDPROC Qty Determination Procedure During Meter Reading / Billing NUMC 2 0 E_QD_PROC_MR
00 Quantity Determination During Billing
03 Quantity Determination During Meter Reading
PREV_MRDOC Internal ID of Previous Meter Reading Result Document CHAR 20 0 E_QD_PREV_MRDOC
COLOGRP Colocation group for Meter Reading CHAR 12 0 E_COLOGRP_MR

EABL foreign key relationships

Table Field Check Table Check Field
0 EABL ABLESART TE614 MR Types: Categorization of Meter Reading Type MANDT
0 EABL ABLESART TE614 MR Types: Categorization of Meter Reading Type ABLESART
1 EABL ABLESER TE115 Meter Reader MANDT
0 EABL ABLESTYP TE614 MR Types: Categorization of Meter Reading Type MANDT
0 EABL ABLESTYP TE614 MR Types: Categorization of Meter Reading Type ABLESART
1 EABL ABLHINW TE259 Notes from Meter Rdr MANDT
0 EABL AMS TEAMI_AMS Advanced Metering System MANDT
0 EABL AMS TEAMI_AMS Advanced Metering System FROM_DATE
1 EABL EQUNR EQUI Equipment master data MANDT
0 EABL ISTABLART TE436 User-defined Meter Reading Type for Entry MANDT
0 EABL ISTABLART TE436 User-defined Meter Reading Type for Entry ISTABLART
1 EABL MANDT T000 Clients MANDT
0 EABL MASSBILL T006 Units of Measurement MANDT
1 EABL MASSREAD T006 Units of Measurement MANDT
1 EABL MASSREAD T006 Units of Measurement MSEHI
0 EABL POPCODE TE625 Multiple Register Validations (Value Tables) POPCODE
1 EABL PRUEFPKT TE218 Independent Validations (Value Table) PRUEFPKT
0 EABL SCHAEGR TE567 Est. Reasons MANDT
0 EABL SCHAEGR TE567 Est. Reasons SCHAEGR
1 EABL STEUERGRP TE629 Control of Variable Scheduled Meter Reading Dates MANDT
1 EABL STEUERGRP TE629 Control of Variable Scheduled Meter Reading Dates STEUERGRP
0 EABL TRANSSTAT ISU_F4_AMITRSTAT Generated Table for View TRANSSTAT
0 EABL TRANSSTAT ISU_F4_AMITRSTAT Generated Table for View SPRAS