EABL

Transparent Table Application Table
86 Fields 2 CDS Views

MR Document

EABL is an SAP database table in S/4HANA. MR Document. It contains 86 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CRMS4_IU_I_MRD view_entity inner Utilities Meter Reading Document
I_MeterReadingDocument view from BASIC Meter Reading Document

Fields (86)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ablbelnr ABLBELNR Int. MR doc. ID
gernr GERAET Device
equnr EQUNR Equipment
zwnummer E_ZWNUMMER Register
adat ADAT MR date
atim ATIM MR time
v_zwstand V_ZWSTAND Predec. Places in MR
n_zwstand N_ZWSTAND Dec. Places in MR
v_zwstndab V_ZWSTNDAB Predec. Billed MR
n_zwstndab N_ZWSTNDAB DP Billed MR
massread E_MASSREAD MeasUnit for MR
massbill E_MASSBILL Billing MUnit
stanzvor STANZVORE Predec. places
stanznac STANZNACE Decimal places
schaever SCHAEVER Estimat.proced.
schaegr SCHAEGR Estimat. reason
aktiv E_AKTIV MR active
adatsoll ADATSOLL Scheduled MRD
adatmax ADATMAX Date of max. MR
atimmax ATIMMAX Time of max. MR
adattats ADATTATS Actual MR date
atimtats ATIMTATS Actual MR time
adaterz ADATERZ IR date
atimerz ATIMERZ MR time of IR
adatprog ADATPROG Forecast date
atimprog ATIMPROG Forecast time
zuorddat E_ZUORDDAT MR alloc. date
thgdatum THGDATUM Gas alloc. date
pruefzahl PRUEFZAHL Check number
bapertyp BAPERTYP Base per. cat.
ablstat ABLSTAT MR Status
pruefpkt PRUEFPKT Indep. valid.
popcode POPCODE Dep. validation
prueftyp PRUEFTYP Validation cat.
ablhinw ABLHINW MR note
stablhw STABLHW MR note control
kontrvrf KONTRVRF Control proced.
ablesart GEPLABL Scheduled MRC
ableser ABLESER Meter reader
nacherf NACHERF Subseq. entry
mdenr MDENR MDE number
mdeupl MDEDOWN Order output
e_zeitvbl E_ZEITVBL Multiple MROC
e_zvlzuord E_ZVLZUORD Multiple alloc.
steuergrp STEUERGRP Control Group
arbauf ARBAUF MROrder Printed
kstatus E_KSTATUS Monit. status
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
entrynumb ENTRYNUMB Entry number
actor HROBJEC_14 Org Management obj.
istablart ISTABLART MR type
ablestyp ABLESTYP MR category
e_zvbl_bezdat E_ZVBL_BEZDAT Ref. MR date
sm_aufnr PM_SVCNR Order/notific.
doc_type KZ_SM_DOC_TYPE Document categ.
adatreal ADATREAL [JBP]MRDate
atimreal ATIMREAL [JBP] MR Time
s_istablart S_ISTABLART [JBP]MR Type
s_aktiv S_AKTIV [JBP] OrigMRAct
s_ablstat S_ABLSTAT [JBP]OrigMRStat
s_v_zwstand S_V_ZWSTAND [JBP]Dec.PlOrig
s_n_zwstand S_N_ZWSTAND [JBP] D Orig.
s_v_zwstndab S_V_ZWSTNDAB [JBP] PDBO
s_n_zwstndab S_N_ZWSTNDAB [JBP]DBillOrig
removed REMOVED [JBP] Obselete
bp BP Billing Period
rem_ablbelnr REM_ABLBELNR [JBP]Suppr.MRDocNo
rem_ableser R_ABLESER Meter Reader
s_adatsoll ADATSOLL Scheduled MRD
s_zvbl_bezdat E_ZVBL_BEZDAT Ref. MR date
zznote ZZ_NOTE
zzdown MDEDOWN Order output
zzprnt MDEDOWN Order output
ams E_AMI_AMS AMS
transstat E_AMI_MR_TRANSSTAT TransStatusCode
tranststamp TIMESTAMPL Time Stamp
sourcesyst E_AMI_SOURCESYST Source System
qnt E_QD_QNT Qty from MR
qdstat E_QD_STAT Qty.Determ.Stat
qdproc E_QD_PROC_MR Qty Det.Proced.
prev_mrdoc E_QD_PREV_MRDOC Int.ID PrMRRstD
cologrp E_COLOGRP_MR Coloc. grp MR

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- MR Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EABL (
    MANDT,          -- Client [MANDT]
    ABLBELNR,       -- Int. MR doc. ID [ABLBELNR]
    GERNR,          -- Device [GERAET]
    EQUNR,          -- Equipment [EQUNR]
    ZWNUMMER,       -- Register [E_ZWNUMMER]
    ADAT,           -- MR date [ADAT]
    ATIM,           -- MR time [ATIM]
    V_ZWSTAND,      -- Predec. Places in MR [V_ZWSTAND]
    N_ZWSTAND,      -- Dec. Places in MR [N_ZWSTAND]
    V_ZWSTNDAB,     -- Predec. Billed MR [V_ZWSTNDAB]
    N_ZWSTNDAB,     -- DP Billed MR [N_ZWSTNDAB]
    MASSREAD,       -- MeasUnit for MR [E_MASSREAD]
    MASSBILL,       -- Billing MUnit [E_MASSBILL]
    STANZVOR,       -- Predec. places [STANZVORE]
    STANZNAC,       -- Decimal places [STANZNACE]
    SCHAEVER,       -- Estimat.proced. [SCHAEVER]
    SCHAEGR,        -- Estimat. reason [SCHAEGR]
    AKTIV,          -- MR active [E_AKTIV]
    ADATSOLL,       -- Scheduled MRD [ADATSOLL]
    ADATMAX,        -- Date of max. MR [ADATMAX]
    ATIMMAX,        -- Time of max. MR [ATIMMAX]
    ADATTATS,       -- Actual MR date [ADATTATS]
    ATIMTATS,       -- Actual MR time [ATIMTATS]
    ADATERZ,        -- IR date [ADATERZ]
    ATIMERZ,        -- MR time of IR [ATIMERZ]
    ADATPROG,       -- Forecast date [ADATPROG]
    ATIMPROG,       -- Forecast time [ATIMPROG]
    ZUORDDAT,       -- MR alloc. date [E_ZUORDDAT]
    THGDATUM,       -- Gas alloc. date [THGDATUM]
    PRUEFZAHL,      -- Check number [PRUEFZAHL]
    BAPERTYP,       -- Base per. cat. [BAPERTYP]
    ABLSTAT,        -- MR Status [ABLSTAT]
    PRUEFPKT,       -- Indep. valid. [PRUEFPKT]
    POPCODE,        -- Dep. validation [POPCODE]
    PRUEFTYP,       -- Validation cat. [PRUEFTYP]
    ABLHINW,        -- MR note [ABLHINW]
    STABLHW,        -- MR note control [STABLHW]
    KONTRVRF,       -- Control proced. [KONTRVRF]
    ABLESART,       -- Scheduled MRC [GEPLABL]
    ABLESER,        -- Meter reader [ABLESER]
    NACHERF,        -- Subseq. entry [NACHERF]
    MDENR,          -- MDE number [MDENR]
    MDEUPL,         -- Order output [MDEDOWN]
    E_ZEITVBL,      -- Multiple MROC [E_ZEITVBL]
    E_ZVLZUORD,     -- Multiple alloc. [E_ZVLZUORD]
    STEUERGRP,      -- Control Group [STEUERGRP]
    ARBAUF,         -- MROrder Printed [ARBAUF]
    KSTATUS,        -- Monit. status [E_KSTATUS]
    ERDAT,          -- Created On [ERDAT]
    ERNAM,          -- Created By [ERNAM]
    AEDAT,          -- Changed On [AEDAT]
    AENAM,          -- Changed By [AENAM]
    ENTRYNUMB,      -- Entry number [ENTRYNUMB]
    ACTOR,          -- Org Management obj. [HROBJEC_14]
    ISTABLART,      -- MR type [ISTABLART]
    ABLESTYP,       -- MR category [ABLESTYP]
    E_ZVBL_BEZDAT,  -- Ref. MR date [E_ZVBL_BEZDAT]
    SM_AUFNR,       -- Order/notific. [PM_SVCNR]
    DOC_TYPE,       -- Document categ. [KZ_SM_DOC_TYPE]
    ADATREAL,       -- [JBP]MRDate [ADATREAL]
    ATIMREAL,       -- [JBP] MR Time [ATIMREAL]
    S_ISTABLART,    -- [JBP]MR Type [S_ISTABLART]
    S_AKTIV,        -- [JBP] OrigMRAct [S_AKTIV]
    S_ABLSTAT,      -- [JBP]OrigMRStat [S_ABLSTAT]
    S_V_ZWSTAND,    -- [JBP]Dec.PlOrig [S_V_ZWSTAND]
    S_N_ZWSTAND,    -- [JBP] D Orig. [S_N_ZWSTAND]
    S_V_ZWSTNDAB,   -- [JBP] PDBO [S_V_ZWSTNDAB]
    S_N_ZWSTNDAB,   -- [JBP]DBillOrig [S_N_ZWSTNDAB]
    REMOVED,        -- [JBP] Obselete [REMOVED]
    BP,             -- Billing Period [BP]
    REM_ABLBELNR,   -- [JBP]Suppr.MRDocNo [REM_ABLBELNR]
    REM_ABLESER,    -- Meter Reader [R_ABLESER]
    S_ADATSOLL,     -- Scheduled MRD [ADATSOLL]
    S_ZVBL_BEZDAT,  -- Ref. MR date [E_ZVBL_BEZDAT]
    ZZNOTE,         -- ZZ_NOTE
    ZZDOWN,         -- Order output [MDEDOWN]
    ZZPRNT,         -- Order output [MDEDOWN]
    AMS,            -- AMS [E_AMI_AMS]
    TRANSSTAT,      -- TransStatusCode [E_AMI_MR_TRANSSTAT]
    TRANSTSTAMP,    -- Time Stamp [TIMESTAMPL]
    SOURCESYST,     -- Source System [E_AMI_SOURCESYST]
    QNT,            -- Qty from MR [E_QD_QNT]
    QDSTAT,         -- Qty.Determ.Stat [E_QD_STAT]
    QDPROC,         -- Qty Det.Proced. [E_QD_PROC_MR]
    PREV_MRDOC,     -- Int.ID PrMRRstD [E_QD_PREV_MRDOC]
    COLOGRP,        -- Coloc. grp MR [E_COLOGRP_MR]
    PRIMARY KEY (MANDT, ABLBELNR)
);

Learn More