04-02-2008 5:03 AM
Hi,
Do we have any program or FM to upload the meter reading values( from a Flatfile ,consisting of millions of values ) .
If so,pls help me to knw how tat program can be handled.
Thanks in advance
04-02-2008 9:23 AM
If meter read order do not exist you can create meter read orders through another bapi before calling the meter read uplaod bapi.
For using meter read upload bapi u nee dto populate the structure METERREADINGRESULTS. with read results and another information.
For idoc processing what you should do is read the data from idoc and then what ever data is required structure METERREADINGRESULTS populate it from idoc.You cannot directly pass idoc number an upload meter read results.
Please read documentation of the meter read upload bapi for its usage.
04-02-2008 6:09 AM
The FM to upload meter read results is BAPI_MTRREADDOC_UPLOAD.
This is documentation for this BAPI:
FU BAPI_MTRREADDOC_UPLOAD
____________________________________________________
Short Text
Upload meter reading results
Functionality
This method imports the meter reading results and additional information from the table of meter reading reading results (METERREADINGRESULTS) into the IS-U/CCS system. For a description of the individual table fields, refer to the documentation for the parameter.
In order to process an uploaded record, a meter reading or a meter reading note must exist.
There are two processing scenarios:
1. A meter reading order exists for the uploaded meter reading result. In this case, the result was previously downloaded to an external system. The records uploaded from this system contain the internal ID number of the meter reading document. The fields for material, serial number, register and meter reading reason can be ignored.
2. No meter reading order exists for the uploaded meter reading result.
In this case, the following fields must be maintained:
a) Serial number, register, meter reading date OR
If the serial number is not unique in the system, a material must also be entered.
b) Point of delivery, register code, meter reading date
An upload without previously creating a meter reading order is only possible for thze following meter reading reasons:
01 Periodic meter reading
Order creation for the meter reading result "Periodic meter reading" is only possible if a corresponding schedule record can be identified. You can define an interval in Customizing that can be used to determine the corresponding schedule record subject to the meter reading date (TE410, Upload interval). It is also possible to enter the scheduled meter reading data during upload. In this case, the interval is not taken into account but the corresponding schedule record is used directly.
08 Meter reading upon technical installation
Meter reading results for technical installation can be uploaded outside of the installation transaction. These meter readings are then added on installation.
09 Interim meter reading without billing
13 Meter reading on disconnection
18 Reconnection meter reading
19 Delivery meter reading
Uploading Customer-Specific Fields:
You have the option to upload customer-specific fields (also see customer enhancement EDMMR001) using table EXTENSIONIN. The customer-specific data is not uploaded along with the standard data but in a separate table, which has the following structure:
Structure
Valuepart1 + Valuepart2 + Valuepart3 + Valuepart4
The valueparts exist of strings of 128 characters where the key data and the customer-specific data is stored. You enter the structure in the STRUCTURE field. (If you use a BAPI to upload meter reading results, there is only one segment and therefore one structure). The structure is BAPI_TE_EABL.
Structure BAPI_TE_EABL contains the following fields:
Material
Serial number
Register
Meter reading reason
Meter reading date
Meter reading document number
Register code
Point of delivery ID
INCLUDE CI_EABL
Notes
Messages are returned in the RETURN parameter.
Parameters
METERREADINGRESULTS
RETURN
EXTENSIONIN
EOSBUPLOADDATA
Exceptions
Function Group
MTRREADDOC
Reward Points if useful
04-02-2008 6:44 AM
thanks pratyasha,
is it possible to create Meter reading order thru idoc..
is it possible to pass idoc number thru this bapi.?
Siva
04-02-2008 9:23 AM
If meter read order do not exist you can create meter read orders through another bapi before calling the meter read uplaod bapi.
For using meter read upload bapi u nee dto populate the structure METERREADINGRESULTS. with read results and another information.
For idoc processing what you should do is read the data from idoc and then what ever data is required structure METERREADINGRESULTS populate it from idoc.You cannot directly pass idoc number an upload meter read results.
Please read documentation of the meter read upload bapi for its usage.