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: 

Profile Data Import-EDM

Former Member
0 Kudos
1,217

Hi,

I could not able to perform the profile data import through Bapi:BAPI_ISUPROFILE_IMPORT.I have given the input parameters as specified in below in the bapi are:

1.Profile Number

2.Data From

3.Time from

4.Date to

5.Profile value

6.status as UI12

7.UOM as KWH

Do i require to still fill any data in the bapi for uplaod.

I have maintained the time as UTC+50 in the profile header.I have maintained the same import time format (system) and date format (system) same as in the profile format.

But eventhough it is not getting updated.

The system throws the below error:

Error occurred during update in profile

Profile 000000000000000002 could not be processed

Profile 000000000000000002 from 00.00.0000 to 00.00.0000 was already billed in this period

Profile 000000000000000002 not imported due to error - check the log

Profile 000000000000000002 could not be processed

Upload of profile values for profile 000000000000000002 was canceled

Can any one suggest the solution.

Thanks.

-Sasi.

1 ACCEPTED SOLUTION

Former Member
505

hi Santhosh,

Can you please tell the input values you gave for the input parameters you mentioned.

with BAPI_ISUPROFILE_IMPORT I give the following input values and it works.

1.Profile Number 18 chars eg 100000000000000007

2.Data From 8chars eg 20110101 date format is yyyymmdd

3.Time from 6chars eg 000000 time format is hhmmss

4. Offset 3 chars eg +05

5.Date to 8chars eg 20110101 date format is yyyymmdd

6.Profile value 31chars eg 5679

7.status 4 chars eg EX01 here you need to use the external status which you maintained in the customizing

SAP Utilities->EDM->Interface to External Systems->Define Status Conversion

I have customized EX01 = IU012.

8.UOM 3chars eg khw

I have created a zprogram which uploads the profiles and then downloads a copy of it for future reference in a csv file.

The data looks like this.

10000000000000000720110101000000052011010100150005 5679 EX01KWH

<profile number><date from><time from><offset><dateto><timeto><offset><value><status><uom>

I hope you might now solve your issue.

Please revert back for any further clarifications.

regards,

Rakesh..

View solution in original post

7 REPLIES 7

Former Member
506

hi Santhosh,

Can you please tell the input values you gave for the input parameters you mentioned.

with BAPI_ISUPROFILE_IMPORT I give the following input values and it works.

1.Profile Number 18 chars eg 100000000000000007

2.Data From 8chars eg 20110101 date format is yyyymmdd

3.Time from 6chars eg 000000 time format is hhmmss

4. Offset 3 chars eg +05

5.Date to 8chars eg 20110101 date format is yyyymmdd

6.Profile value 31chars eg 5679

7.status 4 chars eg EX01 here you need to use the external status which you maintained in the customizing

SAP Utilities->EDM->Interface to External Systems->Define Status Conversion

I have customized EX01 = IU012.

8.UOM 3chars eg khw

I have created a zprogram which uploads the profiles and then downloads a copy of it for future reference in a csv file.

The data looks like this.

10000000000000000720110101000000052011010100150005 5679 EX01KWH

<profile number><date from><time from><offset><dateto><timeto><offset><value><status><uom>

I hope you might now solve your issue.

Please revert back for any further clarifications.

regards,

Rakesh..

0 Kudos
505

Hi,

Please try BAPI_ISUPROFILE_UPLOAD too.

Regards,

Avinash

0 Kudos
505

Thanks Rakesh.I have done the same as u said.But i am getting the below error:

"Interval size of the transferred values does not correspond to profile".

Can you pls suggest the solution.

-Santosh.

0 Kudos
505

Hi Santosh,

Please check the interval length maintained in profile header level and values which you are passing in BAPI function module.

Regards,

Avinash

0 Kudos
505

Hi Avinash,

I have maintained the same interval in both profile header and in the BAPI too.

Thanks.

-Santhosh

0 Kudos
505

Hi Santhosh,

Can you please give the message number of the message.

Also make sure that the time from and time to is compatible to the time interval you have given.

Eg if time interval is 15 min then at the end of the calculation while calculating the last profile value entry time left shouldn't be 10min(say).It should be 15min.

Hope this helps.

Cheers,

Rakesh..

0 Kudos
505

Thanks Rakesh.The problem resolved.