How to do mass upload of meter readings in ISU

[Former Member]

Hi,

Could anybody please guide me how to do mass upload of meter readings in ISU?

How to use Transaction code ELEU or ELMU?

Thanks and Regards

Edited by: Akhil Garg on May 1, 2009 11:59 AM

[oliviawalsh]

Hello This information may be of some help as an option for upload:

http://help.sap.com/saphelp_utilities472/helpdata/en/9f/03693582f4db60e10000009b38f889/frameset.htm

Regards

Olivia

[oliviawalsh]

For these transactions...: 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.

[Former Member]

As mentioned by Olivia Above to upload the meter readings, you need to provide the details like meter read document number, reads, read dates , read reasons etc to BAPI_MTRREADDOC_UPLOAD.

A snipet of the code is below :

Part 1 : Filling the internal table to pass to BAPI

Move
        WA_MRUDATA-GERNR      to WA_BAPI_UPD-SERIALNO,
        WA_MRUDATA-ZWNUMMER   to WA_BAPI_UPD-REGISTER,
        WA_MRUDATA-ABLESGR    to WA_BAPI_UPD-MRREASON,
        WA_MRUDATA-ABLBELNR   to WA_BAPI_UPD-MRIDNUMBER,
        WA_MRUDATA-U_READING  to WA_BAPI_UPD-READINGRESULT,
        LV_NOTES              to WA_BAPI_UPD-METERREADINGNOTE,
        WA_MRUDATA-U_M_READER to WA_BAPI_UPD-METERREADER,
        WA_MRUDATA-U_ACT_DATE to WA_BAPI_UPD-ACTUALMRDATE,
        WA_MRUDATA-U_READ_TIME to WA_BAPI_UPD-ACTUALMRTIME.
  append WA_BAPI_UPD to IT_BAPI_UPD.

Part 2 : Call the BAPI

call function 'BAPI_MTRREADDOC_UPLOAD'
    tables
      METERREADINGRESUPDATE = IT_BAPI_UPD
      RETURN                = IT_BAPI_RETURN.
  if not IT_BAPI_RETURN is initial.
    loop at IT_BAPI_RETURN into WA_BAPI_RETURN .
 
      if ( WA_BAPI_RETURN-TYPE eq 'E' or
           WA_BAPI_RETURN-TYPE eq 'A' ).
 
        LV_ERR_FLAG = 1.                       " Errornous record
 
      endif.
 
    endloop.

Hope this is helpfull

[Former Member]

Try ALE_MTRREADDOC_UPLOAD