SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables… SAP Device Management Tables, SAP ISU Tables for Scheduling.
“SAP IS-U is a sales and information system that supports utility and waste disposal companies.
SAP IS-U supports business functions such as meter reading, meter data management, scheduling, billing, invoicing, accounting, customer service, and integration to customer relations management.”
(source: wikipedia)
The IS-U master data model can be categorized in to two main groups
- Business Data
- Technical Data
Table of Contents
SAP ISU Tables for Technical master data
“Any master data that is used for actually providing the services are grouped under Technical Data. For e.g., a device or a meter that is installed in a customer location.” (source: SAP IS-U data model)
| Tables | SAP ISU Tables for Master Data |
|---|---|
| EKUN | ISU business partner data |
| BUT050 | Business partner relationships |
| BUT100 | Business partner roles |
| BUT020 | Business partner address |
| ADRC | Addresses |
| BUT000 | Business partner |
| DFKKLOCKS | Business locks |
| FKKVKP | Contract account for partner |
| FKKVK | Contract account |
SAP ISU Tables for Billing Master Data
| Tables | Billing Master Data ISU Tables |
|---|---|
| ETTA | Rate category |
| ETTAF | Rate category facts |
| TE221 | Operands |
| ETRF | Rates |
| EKDI | Rate facts |
| ESCHS | Billing schema steps |
| ESCHS | Billing schema header |
| EPREIH | Price history |
| EPREI | Prices header |
| TE069 | Rate types |
| ETTIF/ETTIFN/ETTIFB | Installation facts |
| ERTFND | Rate determination |
SAP ISU Billing and invoicing Tables
Billing and Invoicing module explain the process that starts with Billing and Invoicing and finishes with Bill print out. (source)
Billing Cycle in ISU perspective starts with the creation of the Meter Reading Orders (MRO) and ends in the creation of the respective invoices ( also, called as Print Document). (source)
| Tables | SAP ISU Billing and invoicing Tables |
|---|---|
| ERDK | Print doc header |
| ERDO | Outsorting Table for Invoicing |
| ERDB | CA document for print document |
| ERCHO | Outsorting Table for billing document |
| ERCHC | Invoicing reversal history |
| ERCH | Billing doc header |
| DBERCHZ | Individual Line Items |
| DBERDL | Print doc lines |
| DBERDLB | Billing doc-print doc line reference |
SAP ISU Tables for Technical master Data
| Tables | SAP ISU Tables for Technical master data |
|---|---|
| EANL | Installation |
| EVBS | Premise |
| EHAUISU | Connection object |
| EANLH | Installation time slice |
| EGPLTX | Device locations |
| EUI | HEAD PoDs |
| EUITRANS | PoD internal to external Ids |
SAP Device Management Tables
Device Management manages technical data, installations, meter readings, and the inspection of devices.
| Tables | SAP Device Management Tables |
|---|---|
| ETDZ | Registers |
| EPROFASS | Registers-profiles |
| EASTI | Register relationships |
| EUILZW | Register- Pod |
| EASTS | Installation-register |
| EADZ | Multiple installation billing data registers |
| EZWD | Register Groups |
| EZUZ | Device allocation for registers |
| EGERH | Historical device data |
| EGERS | Master device data |
| EGERR | Device info for Pod |
| EUILNR | Device Pod |
| ETYP | Device category- material data |
| EZUG | Device allocation for device |
SAP ISU Tables for Scheduling
Scheduling groups the sub-division of the service territory into portions (billing units) and meter reading units in the system, and generates dates for the following functions:
- Meter reading
- Billing
- Creation of budget billing amounts (source)
| Tables | SAP ISU Tables for Scheduling |
|---|---|
| TE422 | Meter reading units |
| TE418 | Schedule records- meter reading units |
| TE420 | Portions |
| TE419 | Parameter records |
| TE417 | Schedule records for portion |
| ETRG | Billing orders |
| EABL | Meter reading document |
| EABLG | Meter reading reasons |
