Skip to Content
avatar image
Former Member

Loading Interval Reads: IS-U Emigall Object for loading Interval Reads

Hi SAP Gurus,

We have a requirement to load13 months of historical interval reads data into Profiles. There are various approaches to acheive this. For other objects like loading Basic reads we have a EMIGALL object.

But i need to know why there is no standard SAP object for loading interval reads via EMIGALL for ELEC and GAS.

Alsi if it is not possible to load through EMIGALL can you all please suggest what would be the best approach to load 13 months of historical interval reads to Profiles in SAP EDM.

1) Through ABAP (customized ABAP code to load 13 months of reads to EDM)

2) Since we receive files for the interval reads in csv format we need to build a adapter in XI/PI to read .csv format and convert it to xml format and via XI/PI generate IDOC's and post it in SAP IS-U

If you all have any other best approach please do let me know.

Hope to get quick suggestiongs from all the IS-U gurus.

Thanks,

Mayuresh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 16, 2010 at 02:18 PM

    Have you thought about creating a BDC object in Emigall? It's really easy to create one, and there's good documentation on creating one in the User Handbook in Emigall. I was a bit intimidated by the thought of creating a new one until I actually did it, and realized SAP makes it really simple (for simple transactions, of course).

    The only problem I've had with it is that in some transactions it won't allow you to use KSM for the processing type, you have to actually have the SAP key. And the error message that you get makes it sound like the transaction itself can't be loaded with the BDC, when really it just doesn't know what to do with the KSM processing type.

    Hope this helps.

    CN

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      The 'Meter Read' object in EMIGALL is used for loading Basic Meter reads and not for Interval reads.

      I guess there is no EMIGALL object that loads Interval Meter reads as such because we can receive 5 min, 10 min, 15 min, 30 min intreval reads for Electricity and again various possible for Gas. It would be difficult to have these fields and timestamps to be maintained in EMIGALL.

      example: Say for Profile 100 which is a Measured Electricity Profile we receive 15 minutes interval reads data for 26/07/2010:

      Date Time Read

      26/07/2010 00:00:00 10

      26/07/2010 00:15:00 20

      26/07/2010 00:30:00 30

      26/07/2010 00:45:00 40

      26/07/2010 01:00:00 50

      and so on.......

      In total we will have 96 reads received per day and these will be difficult to capture in EMIGALL. Hence i think there is no standard SAP EMIGALL object for loading interval reads.

      Please note there is one standard SAP transaction 'EEDMIMP0' to upload Profile Values (Interval Reads) through PoD and i tried loading one file but it didn't worked for me. Can anyone please help me with this transaction if they have used this.

      There is one standard BAPI to handle this called 'BAPI_ISUPROFILE_UPLOAD' and this could be acheived by using this BAPI. I havent tried this but i need to do that.

      Please do let me know if anyone comes accross any other solution.

      Regards,

      Mayuresh.