IS
IS
IS
SAP IS-U
SAP IS-Utilities
SAP for Utilities
SAP Industry Specific Solution for Utilities
Introduction
A public utility (usually just utility) is an organization that maintains the
infrastructurefor a public service.
State provision of utility services (like electricity, gas, water, district heating,
waste management etc.) often resulted in inefficiency and poor service quality.
Trend towards liberalization, deregulation and privatization of public utilities
encouraging competition among private players.
Business benefits of SAP for Utilities
Enhances Efficiency of business processes
mass processing of consumption and customer-related financial data
efficient and automated exchange of data (deregulation processes)with market
participants, enabling supplier switching as well as payment and settlement
processes
Increased Asset Usage and Reliability
integrates information and processes from finance, procurement, maintenance,
operational safety, and workforce management
integrates SAP solutions, legacy systems, plant and geographic information
systems, outage management systems, and automated meter-reading systems
Optimized procurement reduced material inventory and efficient collaboration
with contractors and suppliers
Improved Customer Relationship Management
delivers personalized services
effective tools for designing and executing marketing campaigns
Useful Transactions
EASY - Searches Transaction Codes in IS-U.
EC20 - Front Office
EC25 - Data Environment
EPRODCUST - Master Data Template
ECRMREPL - IS-U Contract Error Monitor
EMMACL - Clarification Case List (EMMA Case)
EMIGALL - IS-U Migration: Workbench (Data Migration Tool; Conversion)
EQ81 - IS-U Migration Workbench: User Handbook
=DBUG - Debugging for 'Mass' Transactions
FB* - IS-U FIGL (General Ledger)
FP* - IS-U FICA
EA* - Billing
EL* - Meter Reading
EG* - Device
IQ01,2,3 - Create, Change, Display Material Serial No.
Fields:
PARTNER(10)
Contract Account
A contract account groups together all of a business partners contracts to which
the same payment and dunning data applies. It is an account through which the
financial transactions between a customer and a utility company are managed
(stores payment transaction data).
T-codes:
CAA1/2/3 - Create/Change/Display
Tables:
FKKVK, FKKVKP
Fields:
VKONT(12)
Contract
A contract is an agreement between a utility company and a business partner
relating to a utility service. It forms the basis for billing. Created during move-in
process. It is specific to one Division.
T-codes:
ES20/21/22 - Create/Change/Display
ES27/8 - Change/Display Contracts for Contract Account
Tables:
EVER
Fields:
VERTRAG(10)
Move-in
T-codes:
ES60/1/2 - Create/Change/Display
Tables:
EVBS
Fields:
VSTELLE(10)
Installation
T-codes:
EEDMIDESERVPROV01/2/3 - Service Provider Create/Change/Display
IW52/3/4 - Service Notification Change/Display/Create
EDATEXMON01 - Monitoring of Data Exchange Tasks
ESWTMON01 - Monitoring of Switch Documents
WEDI - SAP Easy Access IDoc and EDI Basis
Useful Tables
Address: ADR*
Business Partner: BUT*
Device: EGER*
POD: EUI* (EUITRANS, EUIINSTLN)
Rate: ETR*, ETT*, EKDI, ERTFND
Meter Reading Doc.: EABL*
Billing Schema: ESCH*
Price: EPRE*
IDOC: EDI*
Data Exchange Process
Classes:
CL_ISU_DATEX_PROCESS - ISU Data Exchange Process (Abstract)
CL_ISU_DATEX_CONTROLLER - Connection and Control of Data Exchange Processes
DATEX Task
EDEXTASK*
Service
ESERVICE*
Service Provider
ESERVPROV*
Device
Register
T-codes:
Tables:
ETDZ-ZWNUMMER (3)
Tables:
ETRG
Meter Reading Results
T-codes:
EL27 - Execute Correct Implausible MRR
EL28 - Execute Single Entry
EL29 - Execute Correct Plausible MRR
EL30 - Estimate MRR
EL31 - Monitoring of MR Data
EL32 - Automatic Monitoring of MRR
Tables:
EABL (Meter Reading Documents)
Billing and Invoicing
Billing vs. Invoicing
Billing:
Consumption and bill amount calculation process
Performed at Contract level
Determine billing periods
Determine tariff (rate) data
Invoicing:
Process contract billing to contract account receivable and prepare printout
Performed at Contract Account level
Consolidate energy and non-energy charges, e.g. late payment fee
Consolidate all items from different contracts to be invoiced under the same
contract account
T-codes:
EASIBI
EAMABI
Tables:
Billing Document
T-codes:
EA22
Tables:
ERCH-BELNR(12)
Print Document
T-codes:
EA40
Tables:
ERDK-OPBEL(12)
Simulation
T-codes:
EASISI - Individual Simulation
EAMASI - Mass Simulation via Installation Intervals
Billing Procedure
Period End Billing etc.
Create Meter Reading Order, Enter Meter Readings, Billing, Invoicing, Printing
Billing Order, Billing Document, Print Document
Billing Master Data
Installation
Tables:
ETTIF/ETTIFN/ETTIFB (Installation Facts)
Billing Class
T-codes:
Tables:
EAKLASSE, EAKLASSET-AKLASSE(4)
Rate
T-codes:
EA30/1/2 (Create, Change, Display)
Tables:
ETRF-TARIFNR(10), EKDI (Rate Facts)
Billing Schema
T-codes:
EA35/6/7 (Create, Change, Display)
Tables:
ESCH-SCHEMANR (10), ESCHS (steps)
Operand
T-codes:
EA50/1/2 (Create, Change, Display)
Tables:
TE221-OPERAND(10)
Rate Category
T-codes:
EA53/4/5 (Create, Change, Display)
Tables:
ETTA-TARIFTYP(10), ETTAF (Rate Cat. Facts)
Rate Type
T-codes:
EA56
Tables:
TE069-TARIFART(8)
Rate Determination
T-codes:
EA87
Tables:
ERTFND-TARIFNR(10)
Variant Program
T-codes:
EA88 (Maintain Variant), EA99 (List of Variants)
Tables:
Price
T-codes:
EA89,90,91(Create, Change, Display)
Tables:
EPREI, EPREIH-PREIS(10)
Fact Group
T-codes:
Tables:
TE067-KONDIGR(10)
Reversal and Adjustment
T-codes:
EA13
EA14
EA15
EA20
EA21
Outsorted Billing/Invoice Docs
T-codes:
EA05
FICA
T-codes:
FPL9 - Account Display: Initial Screen
FP05 - Payment Lot: Initial Screen
FP09 - Returns (Lot): Request Screen
FP25 - Check Lot: Initial Screen
FPVA - Dunning Proposal
FPVB - Dunning Activity Run
Tables:
Your +mention will add people to this post and send an email.
SAP - Excellence
Classic
Classic
Flipcard
Magazine
Mosaic
Sidebar
Snapshot
Timeslide
Dec
27
sap isu
Top of
Form
Bottom
of Form
IS-Utilities
SAP IS-U
SAP IS-Utilities
SAP for Utilities
SAP Industry Specific Solution for Utilities
Introduction
A public utility (usually just utility) is an organization that maintains the
infrastructurefor a public service.
Move-out
EVBS
Fields:
VSTELLE(10)
Installation
Tables:
EGPLT, EGPLTX
Fields:
DEVLOC(30)
Device
Devices are physical objects. E.g. Counting Device (meter), controlling
device (ripple control receiver), data processing device (converter),
device with protective or adjustive functions (pressure controller) etc.
T-codes:
EG41,2/3/4 - Device Modification/Display /Create
Tables:
EGERS
Fields:
GERAET(18)
Point of Delivery
T-codes:
EEDM09/10/11 - Point of Delivery Create/Change/Display
Tables:
EUITRANS, EUIINSTLN
Fields:
INT_UI(22), EXT_UI(50) - POD ID
CL_ISU_SWITCHDOC
Tables:
EIDESWT*
EIDESWTDOC - Division Category - Switch Document Header
EIDESWTMSGDATA - Message Data for Switch Document
Function Modules
ISU_DB_EVER_SINGLE - Read Contract data
ISU_DB_EANLS_SINGLE - Read installation data
ISU_INT_UI_DETERMINE - Read Contract, Installation, Internal and External
PoD
ISU_S_NBSERVICE_CREATE - Create a non-billable service
ISU_DB_ESERVICE_FORALL_POD - Read services associated with a POD
ISU_DB_TECDE_SINGLE - Get Division for service Type
Device Management
Device Category
Device Category corresponds to material in the Materials Management
(MM) application component.
T-codes:
EG01/2/3 (Create, Change, Display)
Tables:
ETYP-MATNR
Register Group
T-codes:
EG04/5/6 (Create, Change, Display)
Tables:
Device
Register
T-codes:
Tables:
ETDZ-ZWNUMMER (3)
ETRG
Meter Reading Results
T-codes:
EL27 - Execute Correct Implausible MRR
EL28 - Execute Single Entry
EL29 - Execute Correct Plausible MRR
EL30 - Estimate MRR
EL31 - Monitoring of MR Data
EL32 - Automatic Monitoring of MRR
Tables:
EABL (Meter Reading Documents)
Billing and Invoicing
Billing vs. Invoicing
Billing:
Consumption and bill amount calculation process
Performed at Contract level
Determine billing periods
Determine tariff (rate) data
Invoicing:
Process contract billing to contract account receivable and prepare
printout
Performed at Contract Account level
Consolidate energy and non-energy charges, e.g. late payment fee
Consolidate all items from different contracts to be invoiced under the
same contract account
T-codes:
EASIBI
EAMABI
Tables:
Billing Document
T-codes:
EA22
Tables:
ERCH-BELNR(12)
Print Document
T-codes:
EA40
Tables:
ERDK-OPBEL(12)
Simulation
T-codes:
EASISI - Individual Simulation
EAMASI - Mass Simulation via Installation Intervals
Billing Procedure
Period End Billing etc.
Create Meter Reading Order, Enter Meter Readings, Billing, Invoicing,
Printing
Billing Order, Billing Document, Print Document
Billing Master Data
Installation
Tables:
ETTIF/ETTIFN/ETTIFB (Installation Facts)
Billing Class
T-codes:
Tables:
EAKLASSE, EAKLASSET-AKLASSE(4)
Rate
T-codes:
EA30/1/2 (Create, Change, Display)
Tables:
ETRF-TARIFNR(10), EKDI (Rate Facts)
Billing Schema
T-codes:
EA35/6/7 (Create, Change, Display)
Tables:
ESCH-SCHEMANR (10), ESCHS (steps)
Operand
T-codes:
EA50/1/2 (Create, Change, Display)
Tables:
TE221-OPERAND(10)
Rate Category
T-codes:
EA53/4/5 (Create, Change, Display)
Tables:
ETTA-TARIFTYP(10), ETTAF (Rate Cat. Facts)
Rate Type
T-codes:
EA56
Tables:
TE069-TARIFART(8)
Rate Determination
T-codes:
EA87
Tables:
ERTFND-TARIFNR(10)
Variant Program
T-codes:
EA88 (Maintain Variant), EA99 (List of Variants)
Tables:
Price
T-codes:
EA89,90,91(Create, Change, Display)
Tables:
EPREI, EPREIH-PREIS(10)
Fact Group
T-codes:
Tables:
TE067-KONDIGR(10)
Reversal and Adjustment
T-codes:
EA13
EA14
EA15
EA20
EA21
Outsorted Billing/Invoice Docs
T-codes:
EA05
FICA
T-codes:
FPL9 - Account Display: Initial Screen
FP05 - Payment Lot: Initial Screen
FP09 - Returns (Lot): Request Screen
FP25 - Check Lot: Initial Screen
FPVA - Dunning Proposal
FPVB - Dunning Activity Run
Tables:
Your +mention will add people to this post and send an email.
Dec
22
INCLUDE ZZUSEREXIT.......
ENDFORM.
User exits can be found in the following ways:
Go to Object Navigator (SE80), select Package and put VMOD (Application
development R/3 SD customer modification) and press enter. You will find all the
includes for user exits in SD. You will get User exits for Sales order, Delivery, Billing,
Pricing etc. Most of the time documentation is maintained for each subroutine which
helps developer for better understanding of the subroutine. Select the subroutine
according to the requirement and start coding within the subroutine.
Examples:
- In User exits MV45AFZZ(Sales Order Exit), we have subroutine
USEREXIT_PRICING_PREPARE_TKOMK
USEREXIT_PRICING_PREPARE_TKOMP
This user exit can be used to move additional fields into the communication table
which is used for pricing. TKOMK for header fields and TKOMG for item fields. The
fields which are not in either of the two tables KOMK and KOMP cannot be used in
pricing.
After User exits using: Error comes for any Country code like 'IN'. Only permissible
country code is 'US'.
2. Screen Exits:
Allow customer to add fields to a screen via a sub screen in an SAP program. The
sub screen is called within the standard screen's flow logic.
Format: CALL CUSTOMER-SUBSCREEN CUSTSCR1
3. Menu exits:
Menu exits allow you to add your own functionality to menus. Menu exits are
implemented by SAP and are reserved menu entries in the GUI interface. The
developer can add his/her own text and logic for the menu.
Function codes for menu exits all start with "+".
Format: +CUS (additional item in GUI status)
Methods to find out customer Exits:
There are numbers of way by using we can find out Customer Exits.
Find(Cntrl+F)
Then use Call customer and select in main program radio button tab and press
Enter.
We can find out all the possible Customer exits based on this transaction.
Method # 2: SMOD
Go to Transaction SMOD (SAP Enhancement).
We can find out all the possible Enhancement (Customer exits) based on this
package.
Method # 3: SE84
Go to Transaction SE84.
Select Enhancements -> Customer Exits -> Enhancements
Give Package and Execute. We can find out all the possible Enhancement (Customer
exits) based on this Package.
Method # 4: SE81
Go to Transaction SE81.
Method # 5: ST05
Go to Transaction ST05. Select Table Buffer Trace & Activate Trace.
Then go to the transaction, based on which you want to see the customer exits.
Come back to ST05, Deactivate Trace & display Trace.
Then go to FIND & write text EXIT_ & press ENTER.
We can find out all the possible Enhancement (Customer exits) based on this
Transaction .This is not good technique to find out customer exits because all the
possible exits may not be find out using this technique.
If you Double click on TEST button, you will get below screen.
From the above screen shot we can say that the Function Exit is already
implemented (Green light) but in Inactive stage (Red light).
Project Creation (CMOD):
This Transaction is used to create a project. Project is also a container, which holds
several Enhancements. If we identify the User Exits and write down the code only
within it, then the functionality will not be worked. That is why we require adding
the enhancement into a project & making it active.
CMOD Transaction is used to create a project.
Select Enhancement assignments and you add your Enhancement in this project.
You can add multiple Enhancements in one project. But you can't add one
enhancement in multiple projects. Then error message will be generated.
From screen short no: 2 of CMOD description, if we click on Components, we will get
the list of Customer exits belongs to these enhancements.
Both green light shows that the exit is already implemented & is Active stage.
Jul
25
SAP- ISU
INDUSTRIAL SERVICE UTILITIES IS-U:
The SAP Utilities (IS-U) component is a sales and information system that supports
all business processes and utility services of a utility company. You can use IS-U for
managing and billing residential, commercial and industrial, and prospective
customers. This component also allows you to manage and bill customers who
receive services, purchase goods, or pay fees and taxes.
The IS-U master data model can be categorized in to two main groups
flow of isu ;-
1.Business Data: Any master data that is used for billing a customer for the services
provided is grouped under Business data. For e.g., a business partner who is a
person or an organization.
As you can see real life objects has been modeled as IS-U Master Data.
Connection Object = building
Premise = Apartment
Device Location = The location where a device is installed (e.g. Hall, Basement)
Meters = Meters
Installation = this is an object without real life correspondence and it is used for
billing purposes
Contract = a contract for a specific type of utility
Contract Account = grouping of one or more contracts under the same umbrella for
financial transactions
Business Partner = the customer
Lets see what kind of data are stored at each master data level.
Business Partner ISU_ADDRESS_PROVIDE
A business partner can have multiple roles within the SAP IS-U:
Contract partner
Installer
Prospect
Contact person
Addresses
- Standard addresses
- P.O Box addresses
- Other addresses
Communication
- Telephone
- Fax
- Extension
- Internet
- E-mail
Payment Transaction
- Bank
- Bank Account
Biller Direct
Relationships
- Hierarchical
- Equal
- Connected
Additional Data
- Status
- Identification Number
- Register entry
..........ISU_FINDER ---> TOJTB is the table name for object type. for
bp ---> ISUPARTNER
CA ---> ISU ACCOUNT
CONTRACT --> ISU CONTRACT
ADDRESS ---> ISU ADDRESS.
ES60,ES61,ES62.
b.CONNECTION OBJECT ANLAGE EANL
ES55,ES56,ES57.
c.UTILITY INSTALLATION TPLNR IFLOT
ES30,ES31,ES32.
d.DEVICE LOCATION DEVLOC IFLOT
ES65,ES66,ES67.
FIELD NAMES FOR THE TMD : GIVEN ...as FIELD NAME and TABLE NAME......
3.
a.MOVE -IN PROCESS --------> move in date [EVER]
METER READING , MOVE IN DOCUMENT
b.MOVE-OUT PROCESS-------> move out date
METER READING, MOVE OUT DOCUMENT
c.DISCONNECTION PROCESS-> EDISCOBJ
d.RECONNECTION PROCESS-> EDISCACT.
4.
a.SERVICE ORDER [MRO meter reading order, billing order,invoicing], --> IW31.
b.SERVICE NOTIFICATION --->IW58.
5.DEVICE MANAGEMENT:a. device category,
b. device.
4. Reversal.
a. MRU METER READING UNIT : ABLEINH {Ttable name}----> EABL {FIELD NAME}
MRU generates the dates for taking meter results [periodic or inter meter reading]
7. ESTIMATE METER READING RESULTS :8. PERIODIC METER REPLACEMENT :DEVICE MANAGEMENT :
REGISTERS and REGISTER GROUP,
COMMAND GROUP,
WINDING GROUP.
PRICE,
AMOUNT .
http://help.sap.com/saphelp_utilities472/helpdata/en/c6/4dc622eafc11d18a030000e
829fbbd/frameset.htm
connection object : as b
premise : 000002
premise type ---may be apartment , r groups r individual r ...etc.
installation
billing data ----> billing class , rate category.
INSTALLATION: 0000008
TECHNICAL MASTER DATA
DEVICE LOCATION: ANN
DEVICE MANAGEMENT
DEVICE CATEGORY
REGISTER GROUP
BUSINESS PARTNER :
TYPES OF BUSINESS PARTNER ---> PERSON, GROUP, ORGANIZATION.
CONTRACT ACCOUNT----> CAA1
FULL INSTALLATION.
EL01 ----> CREATE MRU AND UPLOADING SINGLE ENTRY [MEATER READING ORDER]
EL06 ------> METER READING ENTRIES
EL28 ------> MASS DATA ENRY
EL31 -------> MONITORING OF METER READING
EASIBI -----> SINGLE DATA ENTRY and
BILLING [ERCH] AND INVOICING [ERDK],
EAMABI ----> FOR MASS BILLING
SERVICE ORDER :- AUFK
IW31 ----> CREATION OF SERVICE ORDER,
IW32 -----> CHANGE SERVICE ORDER,
IW33 -----> FOR DISPLAY.
ALM_ME_ORDER_HEADER_GET_DETAIL ----> TO GET DETAILS OF PERTICULAR
CREATED ORDER.
REVERSALS :EA13, EA14, EA15 ----> BILLING DOCUMENT
Sep
29
EG08
EG09
EG14
EG15
EG16
EG17
EG18
EG19
EG27
EG28
EG29
EG30
EG31
EG32
EG33
EG34
EG35
EG36
EG41
Sep
29
Classes
CL_GUI_ALV_GRID
CL_SALV_TABLE
Posted 29th September 2011 by narasimha KOTA
0
Add a comment
Sep
29
Transaction Codes
Device Management Transaction codes
Sep
29
ISU_DB_EABL_SINGLE
ISU_DB_EABL_UPDATE