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 |
Possible values
|
||||||
PORTION | Portion | PORTION | TE420 | CHAR | 8 | 0 | ||||||
XCONTRACTS | Several contracts allocated to installation | E_XCONTRACTS | CHAR | 1 | 0 |
Possible values
|
||||||
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 |