SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

upload into IS-U

Former Member
0 Kudos

Hi ,

how to upload meter redaing flat file to IS-u, using BAPI & IDoc.

Thanks

Rahul

4 REPLIES 4

Former Member
0 Kudos

Check the t-codes : ELMU & ELEU.

There are 2 types of meter reading uploads are there.

1) Basic-Meter reading Upload

2) Interval Meter read Upload

You have to create one development for this.

In this development u will create one idoc after this you will execute EL01 t-code to upload Basic meter readings.

For uploading meter reading result you need use IDoc. Some industries(regulated) have the reading uploaded themselves. For ex, field agent with mobile device, this comes into SAP as IDoc and uploaded using BAPI (BAPI_MTRREADDOC_UPLOAD). If the readings are coming from third party meter reading comany as a file then you would need to write a program to process each records in the file , create IDoc and then further uploade readings.

Sap Help for uploading the meter readings.

You can upload meter reading results from external systems (such as MDE devices) using a BAPI or IDoc of type ISU_MR_UPLOAD01 (upload meter reading results). The BAPI method is called MeterReadingDocument.Upload. Corresponding structure BAPIEABLU contains the following fields:

· MATERIAL (material number)

Material/device category

· SERIALNO (device serial number)

· REGISTER (register number)

· MRREASON (meter reading reason)

· MRIDNUMBER (internal meter reading document number)

The meter reading number identifies a meter reading order. A meter reading order is created for each register to be read. The meter reading document number must be downloaded and uploaded from the external system.

· READINGRESULT (meter reading)

The data record is transferred to the system if either a meter reading result or note was provided.

· METERREADINGNOTE (meter reading note)

The data record to be uploaded is transferred if either a meter reading or note was provided. The meter reading note can be assigned to a control function in IS-U. The control function defines follow-up actions.

· ACTUALCUSTOMERMRTYPE (meter reading type)

Describes how the meter reading result was recorded u2013 by a meter reader or by the customer, for example.

· METERREADER (meter reader number)

The meter reader number is used to identify the meter reader. It is used as a default value and can be stored in the schedule record of the meter reading. You can use the Meter reader number field to indicate that the actual meter reader is different from the default meter reader.

· MRDATEFORBILLING (meter reading date)

Billing occurs on this date, which is also the end of the billing period. The end of the billing period is determined.

· MRTIMEFORBILLING (meter reading time)

· ACTUALMRDATE (actual meter reading date)

· ACTUALMRTIME (actual meter reading time)

· MRDATEOFMAXIMUM (date of maximum reading)

· MRTIMEOFMAXIMUM (Time of maximum reading)

· SMORDER (service order number)

· ACTIVE (active indicator)

There are two upload scenarios:

1. Meter reading orders were already created and downloaded in IS-U.

Meter readings are assigned to IS-U orders via the document number when they are uploaded. In this case you do not have to maintain the following fields:

Material number

Device serial number

Register number

Meter reading reason

2. There are no meter reading orders in IS-U/CCS

In this case you have to specify the serial number and the register number to identify the device for which readings are to be entered in IS-U/CCS.

If the serial number is not unique, you also have to provide the material number and device category. You also have to supply the meter reading reason, a meter reading date and a meter reading.

Regards,

Siva

0 Kudos

Hi Siva,

Thanks..but how do I create Idoc for it?

Thanks

rahul

0 Kudos

You can upload meter reading orders through BAPI_MTRREADDOC_UPLOAD function module.

Regards,

Siva

0 Kudos

Hello Gentlemen,

Did the solution suggested by Shiva work? If not what was your solution?

Ta

Bhupen