SAP Table TE809D

Interface MRU meter reading unit

TE809D (Interface MRU meter reading unit) 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 TE809D to other SAP tables.

TE809D table fields

Field Data element Checktable Datatype Length Decimals
ANLAGE Installation ANLAGE EANL CHAR 10 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
ABLEINH Meter reading unit (old value) ABLEALT TE422 CHAR 8 0
MRU_NEW Meter reading unit (new value) ABLENEU TE422 CHAR 8 0
MRU_REG Meter reading unit (from regional structure) ABLEREG TE422 CHAR 8 0
SPARTE Division SPARTE TSPA CHAR 2 0
AKLASSE Billing class AKLASSE EAKLASSE CHAR 4 0
XMRORDER Indicator: meter reading order exists for installation E_XMRORDER CHAR 1 0
NULL No
X Yes
PORTION Portion PORTION TE420 CHAR 8 0
XCONTRACTS Several contracts allocated to installation E_XCONTRACTS CHAR 1 0
NULL No
X Yes
VERTRAG Contract VERTRAG EVER CHAR 10 0
PORTIONABW Alternative portion PORTIONABW TE420 CHAR 8 0
PYPLT Payment plan type E_PYPLT TE015 CHAR 4 0
EINZDAT Move-In Date EINZDAT DATS 8 0
AUSZDAT Move-Out Date AUSZDAT DATS 8 0
VSTELLE Premise VSTELLE EVBS CHAR 10 0
HAUS Connection Object HAUS IFLOT CHAR 30 0
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
CITY_CODE City code for city/street file AD_CITYNUM ADRCITY CHAR 12 0
STREETCODE Street Number for City/Street File AD_STRNUM ADRSTREET CHAR 12 0
HOUSE_NUM House number (numerical part) HOUSENUM NUMC 10 0
HOUSE_SUPP House number affix HSN_SUPP CHAR 4 0
ADRESSLINE Address line ADRESSLINE CHAR 80 0

TE809D foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TE809D ABLEINH TE809D ABLEINH TE422 Schedule Master Data for Meter Reading Unit TERMSCHL
TE809D ABLEINH SYST MANDT TE422 Schedule Master Data for Meter Reading Unit MANDT
TE809D ADRNR '00010101' ADRC Addresses (Business Address Services) DATE_FROM
TE809D ADRNR ' ' ADRC Addresses (Business Address Services) NATION
TE809D ADRNR SYST MANDT ADRC Addresses (Business Address Services) CLIENT
TE809D ADRNR TE809D ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
TE809D AKLASSE SYST MANDT EAKLASSE IS-U Billing Classes MANDT
TE809D AKLASSE TE809D AKLASSE EAKLASSE IS-U Billing Classes AKLASSE
TE809D ANLAGE TE809D ANLAGE EANL Installation MANDT
TE809D ANLAGE SYST MANDT EANL Installation .INCLUDE
TE809D CITY_CODE SYST MANDT ADRCITY Postal cities CLIENT
TE809D CITY_CODE TE809D COUNTRY ADRCITY Postal cities COUNTRY
TE809D CITY_CODE TE809D CITY_CODE ADRCITY Postal cities CITY_CODE
TE809D COUNTRY SYST MANDT T005 Countries MANDT
TE809D COUNTRY TE809D COUNTRY T005 Countries LAND1
TE809D HAUS SYST MANDT IFLOT Functional Location (Table) MANDT
TE809D HAUS TE809D HAUS IFLOT Functional Location (Table) TPLNR
TE809D MRU_NEW SYST MANDT TE422 Schedule Master Data for Meter Reading Unit MANDT
TE809D MRU_NEW TE809D MRU_NEW TE422 Schedule Master Data for Meter Reading Unit TERMSCHL
TE809D MRU_REG SYST MANDT TE422 Schedule Master Data for Meter Reading Unit MANDT
TE809D MRU_REG TE809D MRU_REG TE422 Schedule Master Data for Meter Reading Unit TERMSCHL
TE809D PORTION SYST MANDT TE420 Sch. Mast. Data: Portion MANDT
TE809D PORTION TE809D PORTION TE420 Sch. Mast. Data: Portion TERMSCHL
TE809D PORTIONABW SYST MANDT TE420 Sch. Mast. Data: Portion MANDT
TE809D PORTIONABW TE809D PORTIONABW TE420 Sch. Mast. Data: Portion TERMSCHL
TE809D PYPLT SYST MANDT TE015 Payment plan type for category AMB/BBP MANDT
TE809D PYPLT TE809D PYPLT TE015 Payment plan type for category AMB/BBP PYPLT
TE809D SPARTE SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
TE809D SPARTE TE809D SPARTE TSPA Organizational Unit: Sales Divisions SPART
TE809D STREETCODE TE809D COUNTRY ADRSTREET Streets COUNTRY
TE809D STREETCODE TE809D STREETCODE ADRSTREET Streets STRT_CODE
TE809D STREETCODE SYST MANDT ADRSTREET Streets CLIENT
TE809D VERTRAG SYST MANDT EVER IS-U Cont. MANDT
TE809D VERTRAG TE809D VERTRAG EVER IS-U Cont. VERTRAG
TE809D VSTELLE SYST MANDT EVBS Premise MANDT
TE809D VSTELLE TE809D VSTELLE EVBS Premise VSTELLE