Phase 4: Device Management & AMI/EDM Preparation
Prerequisite Check: Phases 1–3 must be complete. We need: Company Code
AEP1with IS-U/EDM active (Phase 2), PlantAEP1(Phase 3), Installation Types with EDM Relevance flag (Phase 3), Rate Categories for TOU billing (Phase 3), and verified Units of MeasurementKWH/KW(Phase 1, Step 1.11). This phase builds the smart meter infrastructure, configures Business Partner and Contract Account master data, and establishes the EDM profiles for 15-minute interval TOU billing.
Section A: Business Master Data Foundation
Step 4.1 — Define Business Partner Roles
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → Cross-Application Components → SAP Business Partner → Business Partner → Basic Settings → Business Partner Roles → Define BP Roles |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — BP Roles: Table View
SAP displays existing BP roles (SAP delivers many standard roles).
- Click New Entries.
Screen 3 — New Entry: BP Role Details
For each custom role, fill in:
| Field | Value (Example: ISU001) | Notes |
|---|---|---|
| BP Role | ISU001 | 6-character key |
| Title | Utility Contract Partner | |
| BP Role Category | BUP001 | BUP001 = General business partner |
| BP Role Type | Person and Organization | Can be assigned to both person and org |
| Data Set Relevance | IS-U | Determines which data screens appear in the BP transaction |
| Partner Category | (leave default) | |
| Standard | ✓ (checked) | This role can be used as default |
- Click Save (
Ctrl+S). - Repeat New Entries for each additional role:
Complete Business Partner Roles
| BP Role | Title | BP Role Category | Role Type | Data Set | Use Case |
|---|---|---|---|---|---|
BUP001 | Customer (General) | BUP001 | Person / Org | General | (SAP standard — may already exist) Any entity that can hold a Contract Account |
ISU001 | Utility Contract Partner | BUP001 | Person / Org | IS-U | Customer who holds an active utility contract |
ISU002 | Point of Delivery Partner | BUP001 | Organization | IS-U | Entity at delivery point (reserved for CRES deregulation) |
ISU003 | Meter Operator | BUP001 | Organization | IS-U | AMI head-end / meter management entity (AEP itself) |
ISU004 | Landlord | BUP001 | Person / Org | IS-U | Property owner for landlord/tenant scenarios |
ISU005 | Guarantor | BUP001 | Person / Org | IS-U | Co-signer or guarantor for deposit waiver |
Why This Step
Business Partner (BP) is the universal customer master in S/4HANA. Unlike the legacy Customer Master (KNA1/KNB1), the BP is a single, role-based object that can simultaneously serve as a customer in FI-CA, a contract partner in IS-U, and a vendor in MM. Roles define what the BP can do:
ISU001(Contract Partner) is required to create a utility Contract — without this role, theES25Contract creation screen will not function.ISU003(Meter Operator) identifies who manages the physical meter devices — critical for AMI device assignment.
Key Configuration Notes
- ⚠️ In S/4HANA, the BP transaction (
BP) replaces legacyXD01/FD01. The Business Partner is integrated with the Customer/Vendor Integration (CVI) layer. - BP Grouping (from Phase 2, Step 2.2.3) assigns the number range
01to all partner roles. - At runtime, create a new Business Partner via T-Code
BP:- Screen 1: Select BP Role → Enter name/address → Save.
- Screen 2: Navigate to IS-U Data tab → Assign Company Code
AEP1→ Enter dunning data, payment method.
Step 4.2 — Define Contract Account Categories
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Contract Account → Define Contract Account Categories |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Contract Account Categories: Table View
- Click New Entries.
Screen 3 — New Entry: CA Category — General Tab
| Field | Value (Example: 01) | Notes |
|---|---|---|
| CA Category | 01 | 2-character key |
| Description | Residential Account | |
| Number Range | 01 | (created in Phase 2, Step 2.2.1) |
| Application Area | R | (pre-delivered) |
Screen 4 — CA Category — Control Flags Tab
| Field | Checkbox / Value | Notes |
|---|---|---|
| Dunning Relevant | ✓ | Enable dunning for this category |
| Interest Calculation | ✓ | Enable late fee calculation |
| Budget Billing Eligible | ✓ (for residential) | Allow budget billing plans |
| Correspondence Variant | 01 | 01 = Email + Print |
| Credit Exposure Check | ✓ | Enable credit verification |
| Default Payment Method | E | ACH / Electronic Funds Transfer |
| Dunning Procedure | ZAEP | (created in Phase 2, Step 2.7) |
| Tolerance Group | (blank) | Uses default tolerance |
- Click Save (
Ctrl+S). - Repeat for each CA Category:
Complete Contract Account Categories
| CA Cat | Description | No Range | Dunning | Interest | Budget Bill | Default Payment | Correspondence |
|---|---|---|---|---|---|---|---|
01 | Residential Account | 01 | ✓ | ✓ | ✓ | E (ACH) | Email + Print |
02 | Commercial Account | 02 | ✓ | ✓ | ☐ | E (ACH) | Email + Print |
03 | Industrial Account | 03 | ✓ | ✓ | ☐ | W (Wire) | Email only |
04 | Municipal Account | 02 | ✓ | ✓ | ☐ | E (ACH) | Email + Print |
05 | Prepayment Account | 01 | ☐ | ☐ | ☐ | R (Credit Card) | Email only |
At runtime, Contract Accounts are created via T-Code
CAA1: Screen 1: Enter Contract Account Category → Enter Business Partner number → Save.
Why This Step
The Contract Account is the financial container that groups all receivables for a customer at a specific Company Code. It sits between the Business Partner (who the customer is) and the Contract (what service they receive).
Step 4.3 — Define Contract Types
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Customer Service → Contract → Define Contract Types |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Contract Types: Table View
- Click New Entries.
Screen 3 — New Entry: Contract Type Details
| Field | Value (Example: E-RES) | Notes |
|---|---|---|
| Contract Type | E-RES | Alphanumeric key (up to 4 chars) |
| Description | Electric Residential | |
| Division | 01 | (created in Phase 3, Step 3.8) |
| Installation Types | E1, E2 | Which installation types can link to this contract type |
| Billing Relevant | ✓ | This contract generates bills |
| Contract Account Required | ✓ | A Contract Account must exist before a contract can be created |
| Device Required | ✓ | A meter must be installed before billing can start |
| Start Date Rule | Current Date | Default contract start = today |
| End Date Rule | Open-ended | No fixed end date (continuous service) |
- Click Save (
Ctrl+S). - Repeat for each contract type:
Complete Contract Types
| Contract Type | Description | Division | Installation Types | Billing | Device Req |
|---|---|---|---|---|---|
E-RES | Electric Residential | 01 | E1, E2 | ✓ | ✓ |
E-COM | Electric Commercial | 01 | E3, E4 | ✓ | ✓ |
E-IND | Electric Industrial | 01 | E5 | ✓ | ✓ |
E-MUN | Electric Municipal | 01 | E6 | ✓ | ✓ |
E-AGR | Electric Agricultural | 01 | E7 | ✓ | ✓ |
E-CMN | Electric Common Area | 01 | EC | ✓ | ✓ |
At runtime, Contracts are created via T-Code
ES25: Screen 1: Enter Installation number → Select Contract Type → Enter Contract Account → Assign rate → Save.
Why This Step
The Contract is the legal agreement between the utility and the customer for service delivery at a specific installation. It is the activating bridge — without a Contract, an Installation is “dark” (no billing, no service).
Section B: Device Management — AMI Smart Meters
Step 4.4 — Define Device Categories
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Device Management → Devices → Define Device Categories |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Device Categories: Table View
- Click New Entries.
Screen 3 — New Entry: Device Category — General Tab
| Field | Value (Example: EAMI-1P) | Notes |
|---|---|---|
| Device Category | EAMI-1P | Alphanumeric key |
| Description | AMI Smart Meter — 1-Phase (Residential) | |
| Device Type | E | E = Electric Meter |
| Plant | AEP1 | (created in Phase 3, Step 3.4) |
| Material Type | ZMAT01 | For inventory tracking in MM (optional — can define later) |
| Serial Number Profile | (as required) | Controls serial number assignment rules |
Screen 4 — Device Category — Control Flags Tab
⚠️ Critical AMI configuration flags:
| Field | Checkbox | Notes |
|---|---|---|
| Interval Data Capable | ✓ | ⚠️ Key AMI flag — marks the device as producing time-series data |
| Remote Disconnect Capable | ✓ | AMI meters support remote service switches |
| Remote Read Capable | ✓ | AMI meters are read remotely via head-end |
| Manual Read Relevant | ☐ (unchecked) | ⚠️ Explicitly disabled — no manual reads |
| Communication Module | ✓ | AMI meters have integrated communication (RF Mesh / Cellular) |
| EDM Profile Enabled | ✓ | Links device data output to EDM processing |
| Meter Exchange Relevant | ✓ | Enables meter swap workflows |
| Outage Detection | ✓ | AMI meters can report last-gasp outage signals |
- Click Save (
Ctrl+S). - Repeat for each device category:
Complete Device Categories
| Device Cat | Description | Type | Plant | Interval | Remote Disc | Remote Read | Manual Read | EDM |
|---|---|---|---|---|---|---|---|---|
EAMI-1P | AMI Smart Meter — 1-Phase (Residential) | E | AEP1 | ✓ | ✓ | ✓ | ☐ | ✓ |
EAMI-3P | AMI Smart Meter — 3-Phase (Commercial) | E | AEP1 | ✓ | ✓ | ✓ | ☐ | ✓ |
EAMI-CT | AMI CT-Rated Meter (Industrial) | E | AEP1 | ✓ | ✓ | ✓ | ☐ | ✓ |
EAMI-NM | AMI Net Meter (Solar/DER) | E | AEP1 | ✓ | ✓ | ✓ | ☐ | ✓ |
At runtime, devices are created via T-Code
EG51(Create Device): Screen 1: Enter Device Category → Serial Number → Save. Devices are installed at an installation via T-CodeEG31Ior through the Installation management screen.
Why This Step
The Device Category is the template for physical meter hardware. Every meter installed in the Columbus grid must be assigned to a Device Category. For an AMI-only utility:
- The
Interval Data Capableflag is the most critical setting — it tells the system that this meter produces time-series data (not single scalar reads). Manual Read Relevant = uncheckedensures that no Meter Reading Order processes are triggered for these devices.
Step 4.5 — Define Register Groups (Interval Data Structure)
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Device Management → Register → Define Register Groups |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Register Groups: Table View
- Click New Entries.
Screen 3 — New Entry: Register Group Header
| Field | Value (Example: RG-AMI-R) | Notes |
|---|---|---|
| Register Group | RG-AMI-R | Alphanumeric key |
| Description | AMI Residential Register Set |
- Click Save (
Ctrl+S). - Double-click on the new register group to define individual registers.
Screen 4 — Register Group Details: Register Lines
- Click New Entries to add registers within the group:
Registers for RG-AMI-R (Residential)
| Register | Description | UoM | Reading Type | Interval | Decimal Places |
|---|---|---|---|---|---|
R01 | Total Active Energy (Delivered) | KWH | I (Interval) | 15 min | 3 |
R02 | Total Active Energy (Received) | KWH | I (Interval) | 15 min | 3 |
R03 | Maximum Demand | KW | D (Demand) | 15 min | 3 |
- Click Save (
Ctrl+S). - Repeat the entire process for each register group:
Registers for RG-AMI-C (Commercial)
| Register | Description | UoM | Reading Type | Interval |
|---|---|---|---|---|
R01 | Total Active Energy (Delivered) | KWH | I | 15 min |
R02 | Total Active Energy (Received) | KWH | I | 15 min |
R03 | Maximum Demand | KW | D | 15 min |
R04 | Reactive Energy | KVARH | I | 15 min |
R05 | Power Factor | — | C (Calculated) | 15 min |
Registers for RG-AMI-I (Industrial)
| Register | Description | UoM | Reading Type | Interval |
|---|---|---|---|---|
R01 | Total Active Energy (Delivered) | KWH | I | 15 min |
R02 | Total Active Energy (Received) | KWH | I | 15 min |
R03 | Maximum Demand | KW | D | 15 min |
R04 | Reactive Energy | KVARH | I | 15 min |
R05 | Power Factor | — | C | 15 min |
R06 | Coincident Peak Demand | KW | D | 15 min |
R07 | Voltage (Phase A) | V | I | 15 min |
Registers for RG-AMI-N (Net Metering)
| Register | Description | UoM | Reading Type | Interval |
|---|---|---|---|---|
R01 | Total Active Energy (Delivered) | KWH | I | 15 min |
R02 | Total Active Energy (Received — Solar Export) | KWH | I | 15 min |
R03 | Net Energy | KWH | C | 15 min |
R04 | Maximum Demand | KW | D | 15 min |
Why This Step
Register Groups define the data structure of what each meter records. In an AMI system, registers store 15-minute interval time series — this is a fundamentally different data model from traditional scalar cumulative reads.
Key Configuration Notes
- ⚠️ All registers use 15-minute intervals to align with PUCO reporting requirements and PJM Interconnection wholesale settlement periods.
- The Reactive Energy (KVARH) and Power Factor registers on commercial/industrial meters are required for power factor penalty calculations.
- Coincident Peak Demand (R06) on industrial meters is used for PJM capacity obligation cost allocation (the 4-CP or 5-CP method).
Step 4.6 — Define Device Number Ranges
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Device Management → Devices → Define Number Ranges for Devices |
| T-Code | EG30 |
SAP Screen Flow
Screen 1 — Number Range Maintenance: Initial Screen
When you execute EG30, SAP prompts:
| Field | Value |
|---|---|
| Plant | AEP1 |
- Press Enter.
Screen 2 — Number Range Maintenance: Devices
- Click Change Intervals (pencil icon 📝).
Screen 3 — Maintain Intervals
- Click Insert Interval (➕):
| Field | Value | Notes |
|---|---|---|
| No | 01 | Number range identifier |
| From No. | 000000000001 | 12-digit device numbers |
| To Number | 000009999999 | |
| NR Status | (leave blank) | |
| Ext | ✓ (checked) | ⚠️ External numbering — user provides the number |
- Click Save (💾).
Why External Numbering?
Unlike other master data objects, meters use external numbering because each physical device arrives from the manufacturer with a pre-assigned serial number. The system must accept the manufacturer’s serial as the SAP device number to maintain traceability across the AMI head-end system, the warehouse, and the field workforce management system. Setting Ext = ✓ means the user (or integration) must supply the device number during creation rather than SAP auto-assigning one.
Section C: Energy Data Management (EDM) — The AMI Billing Engine
⚠️ This is the most architecturally significant section of the entire configuration. EDM is what makes AMI billing possible. Without EDM, 15-minute interval data has no path from the meter to the billing engine. Without EDM profiles, TOU billing is impossible.
Step 4.7 — Define EDM Profile Types
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Energy Data Management → Basic Settings → Define EDM Profile Types |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — EDM Profile Types: Table View
- Click New Entries.
Screen 3 — New Entry: Profile Type Details
For each profile type:
| Field | Value (Example: LOAD) | Notes |
|---|---|---|
| Profile Type | LOAD | Key identifying the profile data type |
| Description | Load Profile | |
| Data Category | Consumption | What kind of time-series data this stores |
| UoM | KWH | Default unit of measurement for values |
| Interval Length | 15 | 15-minute intervals |
| Interval UoM | MIN | Minutes |
| Storage Type | Time Series | Database storage method |
| Validation Active | ✓ | Apply validation rules on data receipt |
| Replacement Active | ✓ | Apply replacement value procedures for gaps |
- Click Save (
Ctrl+S). - Repeat for all profile types:
Complete EDM Profile Types
| Profile Type | Description | Data Category | UoM | Interval | Validation | Replacement |
|---|---|---|---|---|---|---|
LOAD | Load Profile | Consumption | KWH | 15 min | ✓ | ✓ |
DEMA | Demand Profile | Demand | KW | 15 min | ✓ | ✓ |
TOU | Time-of-Use Profile | Bucketed Consumption | KWH | 15 min | ✓ | ✓ |
SYNTH | Synthetic Load Profile | Estimated Consumption | KWH | 15 min | ✓ | ☐ |
RECV | Received Energy Profile | Reverse-Flow | KWH | 15 min | ✓ | ✓ |
Why This Step
EDM Profile Types are the classification templates for the time-series data managed by the Energy Data Management engine. Each profile type tells EDM:
- What kind of data to expect (consumption, demand, reactive, etc.)
- How to validate the incoming data
- Which replacement value procedures to apply when data is missing
- How to store the data in the time-series database
Step 4.8 — Define Time-of-Use (TOU) Period Definitions
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Energy Data Management → Profile Management → Time-of-Use → Define TOU Rate Periods |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — TOU Rate Periods: Table View
- Click New Entries.
Screen 3 — New Entry: TOU Period Definition
For each TOU period:
| Field | Value (Example: PEAK) | Notes |
|---|---|---|
| TOU Period Code | PEAK | Key identifying the time-of-use bucket |
| Description | On-Peak | |
| Period Priority | 01 | Higher number = higher priority overlay (CRIT overrides PEAK) |
| Price Relevant | ✓ | This period drives a distinct price in the billing schema |
- Click Save (
Ctrl+S). - Repeat for all TOU periods:
Complete TOU Periods
| TOU Period | Code | Description | Priority | Price Relevant |
|---|---|---|---|---|
| On-Peak | PEAK | Peak demand hours | 01 | ✓ |
| Off-Peak | OFFP | Standard hours | 02 | ✓ |
| Super Off-Peak | SOFF | Overnight discount hours | 03 | ✓ |
| Critical Peak | CRIT | Emergency pricing event | 04 (highest) | ✓ |
Part B: Define Season Calendars
SPRO Path: SPRO → SAP Utilities → Energy Data Management → Profile Management → Time-of-Use → Define Season Calendar
- Click New Entries.
| Field | Value | Notes |
|---|---|---|
| Season Code | SUM | Summer |
| Description | Summer Season | |
| Start Date | 06/01 | June 1 |
| End Date | 09/30 | September 30 |
- Repeat for Winter:
| Field | Value |
|---|---|
| Season Code | WIN |
| Description | Winter Season |
| Start Date | 10/01 |
| End Date | 05/31 |
- Click Save (
Ctrl+S).
Part C: Define Day Types
SPRO Path: SPRO → SAP Utilities → Energy Data Management → Profile Management → Time-of-Use → Define Day Types
- Click New Entries and define:
| Day Type Code | Description | Days |
|---|---|---|
WD | Weekday | Monday–Friday (non-holiday) |
WE | Weekend | Saturday & Sunday |
HD | Holiday | PUCO-recognized holidays |
- Click Save (
Ctrl+S).
Part D: Define Holiday Calendar
SPRO Path: SPRO → SAP Utilities → Energy Data Management → Profile Management → Time-of-Use → Define Holiday Calendar for TOU
- Click New Entries.
| Field | Value |
|---|---|
| Calendar ID | OH_PUCO |
| Description | Ohio PUCO / PJM Holiday Calendar |
- Double-click on
OH_PUCOto add individual holiday entries:
| Holiday | Date Rule |
|---|---|
| New Year’s Day | January 1 |
| Martin Luther King Jr. Day | 3rd Monday in January |
| Presidents’ Day | 3rd Monday in February |
| Memorial Day | Last Monday in May |
| Independence Day | July 4 |
| Labor Day | 1st Monday in September |
| Columbus Day | 2nd Monday in October |
| Veterans Day | November 11 |
| Thanksgiving Day | 4th Thursday in November |
| Christmas Day | December 25 |
- Click Save (
Ctrl+S).
Part E: Define TOU Time Assignments (Period → Season → Day Type → Hours)
SPRO Path: SPRO → SAP Utilities → Energy Data Management → Profile Management → Time-of-Use → Define TOU Time Assignments
- Click New Entries. This is the master mapping table that ties it all together:
| Season | Day Type | From Time | To Time | → TOU Period |
|---|---|---|---|---|
| SUM | WD | 00:00 | 04:59 | SOFF |
| SUM | WD | 05:00 | 14:59 | OFFP |
| SUM | WD | 15:00 | 18:59 | PEAK |
| SUM | WD | 19:00 | 22:59 | OFFP |
| SUM | WD | 23:00 | 23:59 | SOFF |
| SUM | WE | 00:00 | 23:59 | OFFP |
| SUM | HD | 00:00 | 23:59 | OFFP |
| WIN | WD | 00:00 | 04:59 | SOFF |
| WIN | WD | 05:00 | 06:59 | OFFP |
| WIN | WD | 07:00 | 10:59 | PEAK |
| WIN | WD | 11:00 | 22:59 | OFFP |
| WIN | WD | 23:00 | 23:59 | SOFF |
| WIN | WE | 00:00 | 23:59 | OFFP |
| WIN | HD | 00:00 | 23:59 | OFFP |
- Click Save (
Ctrl+S).
Note:
CRIT(Critical Peak) is not mapped to fixed time slots — it is activated as a dynamic overlay via event declaration. When AEP signals a Critical Peak event through the head-end system, EDM overrides the normal period assignment for the declared hours.
Why This Step
TOU periods are the heart of interval-based billing. EDM takes the raw 15-minute load profile data and overlays the TOU period definitions to produce time-bucketed consumption totals:
Raw Load Profile (96 intervals/day × 30 days = 2,880 data points)
↓ EDM TOU Processing
Bucketed Output:
PEAK: 450 KWH
OFFP: 820 KWH
SOFF: 230 KWH
CRIT: 0 KWH (no event declared)
TOTAL: 1,500 KWHThe billing engine then applies different prices to each bucket:
PEAK: 450 KWH × $0.12/KWH = $54.00
OFFP: 820 KWH × $0.08/KWH = $65.60
SOFF: 230 KWH × $0.05/KWH = $11.50
Bill Total (Energy Charges): $131.10Step 4.9 — Define EDM Replacement Value Procedures
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Energy Data Management → Data Validation and Correction → Define Replacement Value Procedures |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Replacement Value Procedures: Table View
- Click New Entries.
Screen 3 — New Entry: Procedure Details
| Field | Value (Example: LINT) | Notes |
|---|---|---|
| Procedure Code | LINT | Key |
| Description | Linear Interpolation | |
| Method | Mathematical | Algorithm type |
| Max Gap Size | 16 intervals | = 4 hours (16 × 15 min). Gaps larger than this fall to next procedure |
| Priority | 01 | Applied first — highest priority |
| Auto-Apply | ✓ | System applies automatically without analyst intervention |
- Click Save (
Ctrl+S). - Repeat for all procedures:
Complete Replacement Value Procedures
| Code | Description | Method | Max Gap | Priority | Auto-Apply |
|---|---|---|---|---|---|
LINT | Linear Interpolation | Mathematical | 4 hours | 01 | ✓ |
HAVG | Historical Average | Statistical (same DOW, 4 weeks) | 24 hours | 02 | ✓ |
SYNT | Synthetic Profile | Profile-based (rate category) | Unlimited | 03 | ✓ |
MANU | Manual Override | Manual analyst entry | N/A | 99 | ☐ |
Part B: Define Validation Rules
SPRO Path: SPRO → SAP Utilities → Energy Data Management → Data Validation and Correction → Define Validation Rules
- Click New Entries for each validation rule:
| Rule Code | Description | Condition | Action | Auto |
|---|---|---|---|---|
V01 | Missing Data Check | Any 15-min interval is missing | Flag + Auto-Replace (LINT) | ✓ |
V02 | Spike Detection | Interval > 3× rolling 7-day avg | Flag for analyst review | ☐ |
V03 | Negative Value Check | Value < 0 (except RECV register) | Reject | ✓ |
V04 | Zero Value Sustained | 96+ consecutive zero intervals (24h) | Flag for meter malfunction | ☐ |
V05 | Checksum Validation | Sum of intervals ≠ scalar total (±2%) | Flag for review | ☐ |
- Click Save (
Ctrl+S).
Why This Step
AMI systems are not perfect — communication failures, head-end outages, and meter malfunctions can create gaps in the 15-minute interval stream. EDM Replacement Value Procedures are the data quality safety net.
Key Configuration Notes
- ⚠️ PUCO regulations require that estimated readings be clearly identified on the customer’s bill. When a replacement procedure fills data, the billing document must carry an estimation indicator.
- The Spike Detection rule (
V02) is critical for preventing billing complaints — a single anomalous 15-minute interval of 500 KWH (vs. a normal 0.5 KWH) could inflate a bill by thousands of dollars.
Step 4.10 — Define EDM Profile Allocation to Installations
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Energy Data Management → Profile Management → Profile Allocation → Define Profile Allocation for Installations |
| T-Code | EDMPRO (to verify allocation at runtime) |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Profile Allocation Rules: Table View
- Click New Entries.
Screen 3 — New Entry: Allocation Rule
For each combination of Installation Type and required EDM Profile:
| Field | Value (Example) | Notes |
|---|---|---|
| Installation Type | E2 | Residential TOU |
| Profile Type | LOAD | Which EDM profile to allocate |
| Mandatory | ✓ | This profile must exist before billing can run |
| Auto-Create | ✓ | Automatically create profile when device is installed |
| Priority | 01 | Processing order |
- Click Save (
Ctrl+S). - Repeat for every Installation Type / Profile Type combination:
Profile Allocation Matrix
| Installation Type | LOAD | DEMA | TOU | RECV |
|---|---|---|---|---|
E1 (Res Standard) | ✓ Mandatory | — | — | — |
E2 (Res TOU) | ✓ Mandatory | ✓ Mandatory | ✓ Mandatory | — |
E3 (Com Standard) | ✓ Mandatory | ✓ Mandatory | — | — |
E4 (Com TOU) | ✓ Mandatory | ✓ Mandatory | ✓ Mandatory | — |
E5 (Ind TOU) | ✓ Mandatory | ✓ Mandatory | ✓ Mandatory | — |
E6 (Municipal) | ✓ Mandatory | — | — | — |
E7 (Agricultural) | ✓ Mandatory | — | — | — |
EC (Common Area) | ✓ Mandatory | — | — | — |
| Net Metering | ✓ Mandatory | ✓ Mandatory | ✓ Mandatory | ✓ Mandatory |
Why This Step
Profile Allocation is the critical linkage between the physical installation, its meter data, and the billing engine.
Without this allocation:
- The Load Profile data arriving from the AMI head-end would be stored but never processed into TOU buckets.
- The billing engine, when it processes a TOU Rate Category, would search for a TOU Profile, find nothing, and abort the billing order with error
EDM 501(“No EDM profile found for installation”).
Key Configuration Notes
- E1 (Residential Standard) gets only a LOAD profile because flat-rate customers do not need TOU bucketing — the billing engine simply sums all 15-minute intervals to get total KWH consumed.
- E2/E4/E5 (TOU variants) get LOAD + DEMA + TOU profiles because the billing engine needs:
- Raw interval data (LOAD) for audit trail
- Peak demand (DEMA) for demand charges
- Time-bucketed consumption (TOU) for time-differentiated energy charges
- Net Metering additionally gets a RECV profile to track solar export (energy flowing back to the grid).
Step 4.11 — Configure AMI Head-End Interface (Inbound Data Channel)
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Energy Data Management → Data Exchange → Define Inbound Processing for Meter Data |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Inbound Processing Configuration
- Click New Entries.
Screen 3 — New Entry: Inbound Channel Details
| Field | Value | Notes |
|---|---|---|
| Channel ID | AMI_01 | Identifier for this inbound feed |
| Description | AEP AMI Head-End Inbound | |
| Interface Type | Smart Meter Gateway | LAN/WAN connection type |
| Data Format | MSCONS | EDIFACT MSCONS format (or proprietary AMI XML) |
| Processing Mode | Near Real-time | Batch ingestion every 4 hours |
| Target Profile Type | LOAD | Raw data lands in LOAD profiles first |
| Auto-Validation | ✓ | Apply rules V01–V05 on ingest |
| Auto-Replacement | ✓ | Apply LINT for gaps ≤ 4 hours |
| Error Queue | EDEX | Failed records route to EDM exception worklist |
| Processing Frequency | 4 hours | 96 intervals per batch per meter |
- Click Save (
Ctrl+S).
Data Flow Architecture
AMI Head-End System (Itron/Landis+Gyr/Sensus)
│
│ 15-minute interval data (MSCONS / XML)
│ Frequency: Every 4 hours (96 intervals/batch per meter)
▼
SAP EDM Inbound Processor
│
├── Validation Engine (V01–V05)
│ ├── Pass → Store in LOAD Profile
│ └── Fail → Exception Worklist (EDEX)
│
├── Replacement Value Processor (LINT/HAVG/SYNT)
│ └── Fill gaps in LOAD Profile
│
├── TOU Processor
│ └── Apply TOU Period Definitions → Generate TOU Profile
│
└── Demand Calculator
└── Extract peak demand values → Generate DEMA ProfileWhy This Step
This step defines how the raw 15-minute interval data physically enters SAP from the AMI head-end system. Without this configuration:
- There is no landing zone for meter data
- EDM profiles remain empty
- Billing has no consumption data to calculate against
Key Configuration Notes
- The actual middleware integration (SAP CPI / PI/PO / RFC) is a separate technical workstream, but the EDM inbound configuration must be defined first so that the middleware team knows which target structures to map to.
- Near real-time processing (every 4 hours) is the standard for billing-grade data. Real-time (per-interval) processing is reserved for operational use cases like outage detection and power quality monitoring.
Step 4.12 — Define Device/Register to Installation Assignment Rules
| Attribute | Value |
|---|---|
| SPRO Path | SPRO → SAP Utilities → Device Management → Device Installation → Define Installation Rules |
| T-Code | SPRO |
SAP Screen Flow
Screen 1 — IMG Navigation
- Navigate to the SPRO path above → click Execute (⏩).
Screen 2 — Installation Rules: Table View
- Click New Entries.
Screen 3 — New Entry: Compatibility Rule
| Field | Value (Example) | Notes |
|---|---|---|
| Device Category | EAMI-1P | Which device type |
| Installation Type | E1 | Which installation type it can be installed at |
| Compatibility | ✓ (allowed) | If unchecked, this combination is blocked |
| Register Group | RG-AMI-R | Auto-assigns this register group when device is installed |
| Auto-Profile Allocation | ✓ | Automatically allocate EDM profiles per Step 4.10 matrix |
- Click Save (
Ctrl+S). - Repeat for all combinations:
Complete Compatibility Matrix
| Device Category | Installation Types | Register Group | Auto-Profile |
|---|---|---|---|
EAMI-1P | E1, E2 | RG-AMI-R | ✓ |
EAMI-3P | E3, E4, EC | RG-AMI-C | ✓ |
EAMI-CT | E5 | RG-AMI-I | ✓ |
EAMI-NM | Any (with RECV profile) | RG-AMI-N | ✓ |
Why This Step
This configuration ensures that when a field technician installs an AMI meter at a premise, the system automatically:
- Validates that the meter type is compatible with the installation type
- Assigns the correct register group to the device
- Allocates the required EDM profiles for interval data processing
- The installation is immediately ready for billing — no manual intervention required
Section D: End-to-End Process Validation
Step 4.13 — Verify the Complete Data Chain
This is not a configuration step but a validation exercise. Before declaring Phase 4 complete, trace the full data chain from meter to bill:
1. AMI Meter (EAMI-1P, Serial: 100001)
└── Device Category: EAMI-1P
└── Register Group: RG-AMI-R
├── R01: Total Active Energy (KWH, 15-min interval)
├── R02: Received Energy (KWH, 15-min interval)
└── R03: Max Demand (KW, 15-min interval)
2. Installed at Installation (Type: E2 — Residential TOU)
└── Premise (Type: 01 — Residential Unit)
└── Connection Object (Type: 01 — Single Family)
└── Address: 123 High St, Columbus, OH 43215
3. EDM Profile Allocation (auto-triggered on install):
├── LOAD Profile → receives raw 15-min KWH data
├── DEMA Profile → receives peak KW demand
└── TOU Profile → receives time-bucketed consumption:
├── PEAK: Σ intervals during 3PM–7PM (Mon–Fri, Summer)
├── OFFP: Σ intervals during off-peak hours
└── SOFF: Σ intervals during 11PM–5AM
4. Contract:
└── Contract Type: E-RES
└── Rate Category: RES-TOU
└── Billing Schema: applies TOU prices to PEAK/OFFP/SOFF buckets
5. Contract Account (Category: 01 — Residential)
└── Business Partner (Role: ISU001 — Contract Partner)
└── Name: John Q. Customer
└── BP Number: 0000000001
6. Billing Output:
└── Invoice:
├── PEAK: 450 KWH × $0.12 = $54.00
├── OFFP: 820 KWH × $0.08 = $65.60
├── SOFF: 230 KWH × $0.05 = $11.50
├── Demand: 8.5 KW × $3.50 = $29.75
├── Customer Charge: $8.50
└── TOTAL: $169.35
└── Posted to FI-CA Subledger (Doc Type: ZI)
└── Periodic G/L Transfer via Recon Key 0001 (T-Code: FPG1)
└── FI-GL Document (Doc Type: ZC, Number Range 19)
└── Debit: 1200000000 (AR)
└── Credit: 4100000000 (Revenue–Residential)Runtime T-Code Quick Reference for Validation
| Action | T-Code | Notes |
|---|---|---|
| Create Connection Object | ES51 | Enter address → select CO Type → Save |
| Create Premise | ES52 | Enter CO number → select Premise Type → Save |
| Create Installation | ES53 | Enter Premise → select Inst Type → Save |
| Create Business Partner | BP | Enter name/address → assign ISU001 role → Save |
| Create Contract Account | CAA1 | Enter BP → select CA Category → Save |
| Create Contract | ES25 | Enter Installation → select Contract Type → Enter CA → Save |
| Create Device | EG51 | Enter serial → select Device Category → Save |
| Install Device | EG31I | Enter Installation → enter Device → Save |
| View EDM Profiles | EDMPRO | Enter Installation → view allocated profiles |
| Run Billing | EA00 | Enter Company Code → Enter posting date → Execute |
| View FI-CA Document | FPL9 | Enter Contract Account → display open items |
| Transfer to G/L | FPG1 | Enter Recon Key → Execute |
Phase 4 — Completion Checklist
| # | Object | T-Code | ID/Value | Status |
|---|---|---|---|---|
| Section A: Business Master Data | ||||
| 4.1 | Business Partner Roles | SPRO | BUP001, ISU001–ISU005 | ☐ |
| 4.2 | Contract Account Categories | SPRO | 01–05 with control flags | ☐ |
| 4.3 | Contract Types | SPRO | E-RES through E-CMN | ☐ |
| Section B: Device Management | ||||
| 4.4 | Device Categories | SPRO | EAMI-1P, -3P, -CT, -NM (all AMI flags ✓) | ☐ |
| 4.5 | Register Groups | SPRO | RG-AMI-R, -C, -I, -N (15-min intervals) | ☐ |
| 4.6 | Device Number Ranges | EG30 | 01: External, 12-digit | ☐ |
| Section C: EDM Configuration | ||||
| 4.7 | EDM Profile Types | SPRO | LOAD, DEMA, TOU, SYNTH, RECV | ☐ |
| 4.8 | TOU Period Definitions | SPRO | PEAK/OFFP/SOFF/CRIT + seasons + holidays | ☐ |
| 4.9 | Replacement Value Procedures | SPRO | LINT, HAVG, SYNT, MANU + 5 validation rules | ☐ |
| 4.10 | EDM Profile Allocation | SPRO / EDMPRO | Installation Type → Profile matrix complete | ☐ |
| 4.11 | AMI Inbound Interface | SPRO | Channel AMI_01, MSCONS format, 4-hour cycle | ☐ |
| 4.12 | Device-Installation Rules | SPRO | Compatibility + register group + auto-profile | ☐ |
| 4.13 | End-to-End Validation | multiple | Full data chain: Meter → EDM → Billing → FI-CA → G/L | ☐ |
What Comes Next?
With Phases 1–4 complete, the utility’s system has:
✅ A fully functional FI/CO enterprise foundation
✅ An IS-U industry layer with FI-CA subledger integration
✅ A regional structure modeling the Columbus metropolitan grid
✅ AMI-ready device management with interval data register groups
✅ A complete EDM profile allocation for 15-minute TOU billing
Next Phases
| Phase | Description |
|---|---|
| Phase 5 | Billing & Tariff Foundation — EDM transfer profiles, formula profiles, operands, rates, billing schemas, simulation (EA16), and test billing (EA00) |
| Phase 6 | Invoicing & Print Formatting — Account determination posting areas, EA19 invoicing, due dates, late penalties, PUCO-compliant bill forms |
| Phase 7 | Customer Service — CIC agent desktop, Move-In (EC50E) with AMI activation, Move-Out (EC53E) with final billing |
| Phase 8 | Advanced FI-CA — Payment runs (FPY1), returns processing, dunning automation, Reconciliation Keys, mass batch scheduling |
🔗 Proceed to Phase 5: Billing & Tariff Foundation to build the billing engine.