topic Re: Creating EDM profile values in Application Development and Automation Discussions

Creating EDM profile values

Former Member — Mon, 14 Sep 2015 07:02:39 GMT

Hello everybody!

For test purposes, I want to fill some EDM profiles with generated values (Excel). Since the upload for some reason doesn´t work, I tried to use a report:


DATA PROFVAL TYPE EPROFVALUE.
DATA PROFVALTAB TYPE TEPROFVALUES_SORTED.

 START-OF-SELECTION.

 PROFVAL-PROF_DATE  = '20150101'.
 PROFVAL-PROF_TIME  = '000000'.
 PROFVAL-PROF_VALUE = '15.123456'.
 APPEND PROFVAL TO PROFVALTAB.
 PROFVAL-PROF_DATE  = '20150101'.
 PROFVAL-PROF_TIME  = '000100'.
 PROFVAL-PROF_VALUE = '16.123456'.
 APPEND PROFVAL TO PROFVALTAB.

 CALL FUNCTION 'ISU_PROFILE_PUT_EPROFVAL60'
   EXPORTING
     X_PROFILENR     = '10001283'
     X_DATE_FROM     = '20150101'
     X_TIME_FROM     = '000000'
     X_DATE_TO       = '99993112'
     X_TIME_TO       = '000000'
     X_UPD_MODE      = 'I'
     X_INTSIZEID     = '60'
     X_UPD_ONLINE    = ''
     X_VALUES        = PROFVALTAB
     X_UPD_TMP_DATA  = ''
   CHANGING
     XY_REF_DATA_DB     =
     XY_REF_DATA_UPDATE =
     XY_REF_DATA_INSERT =
     XY_REF_DATA_DELETE =
   EXCEPTIONS
     NOT_CUSTOMIZED  = 1
     OTHERS          = 2.

 END-OF-SELECTION.

Would this approach be the best way? What do I have to assign to the changing parameters?

Any help would be great...

Re: Creating EDM profile values

Former Member — Mon, 14 Sep 2015 20:38:43 GMT

...my problem are the field symbols (CHANGING).





XY_REF_DATA_DB 
= ?



XY_REF_DATA_UPDATE = ?
XY_REF_DATA_INSERT = ?
XY_REF_DATA_DELETE = ?

Does anybody know, what to assign to them?

Re: Creating EDM profile values

Former Member — Tue, 15 Sep 2015 07:02:04 GMT

You can use the FUBAs BAPI_ISUPROFILE_UPLOAD if you want to upload the values with the pointofdelivery or you can use BAPI_ISUPROFILE_IMPORT if you upload the values with the profile number. In your SAP-system you have to example reports from SAP: REEDMPROFILEIMP, REEDMPROFILEIMP01.

yours sincerely,

Armin

Re: Creating EDM profile values

Former Member — Tue, 15 Sep 2015 07:55:51 GMT

Hello,

I found out that there is another function for updating EDM profiles - ''ISU_DB_EPROFVAL60_UPDATE". It seems to be much more simple.


DATA PROFTAB TYPE IEPROFVAL60.
 DATA PROFLINE  TYPE EPROFVAL60.

 START-OF-SELECTION.

 PROFLINE-PROFILE   = '10001283'.
 PROFLINE-VALUEDAY  = '20150101'.
 PROFLINE-VAL0000   = '7.210000000000000'.
 PROFLINE-VAL0100   = '10000000000000.89'.
 PROFLINE-VAL0200   = '5.9300'.
 PROFLINE-VAL0300   = '9.9800'.
 PROFLINE-VAL0400   = '1.4800'.
 PROFLINE-VAL0500   = '12.8400'.
 PROFLINE-VAL0600   = '12.2500'.
 PROFLINE-VAL0700   = '11.4600'.
 PROFLINE-VAL0800   = '5.6300'.
 PROFLINE-VAL0900   = '9.78'.
 PROFLINE-VAL1000   = '2.37'.
 PROFLINE-VAL1100   = '4.45'.
 PROFLINE-VAL1200   = '11.26'.
 PROFLINE-VAL1300   = '13.83'.
 PROFLINE-VAL1400   = '11.16'.
 PROFLINE-VAL1500   = '5.53'.
 PROFLINE-VAL1600   = '11.75'.
 PROFLINE-VAL1700   = '11.06'.
 PROFLINE-VAL1800   = '0.99'.
 PROFLINE-VAL1900   = '10.17'.
 PROFLINE-VAL2000   = '8.89'.
 PROFLINE-VAL2100   = '5.43'.
 PROFLINE-VAL2200   = '12.25'.
 PROFLINE-VAL2300   = '16.59'.
 APPEND PROFLINE TO PROFTAB.

 CALL FUNCTION 'ISU_DB_EPROFVAL60_UPDATE'
   EXPORTING
     X_UPD_MODE      = 'I'
     X_PROFVAL       = PROFTAB
     X_PROFILENR   = '10001283'
     X_DATE_FROM  = '20150101'
     X_DATE_TO  = '99991231'.

 END-OF-SELECTION.

The only problem is, that the decimal values are not stored correctly. Instead of 5.93 it stores 6. The profile is declared with 2 decimals. Also it occurs that the first hour is empty.

Could anybody please help with that issue?

Re: Creating EDM profile values

Former Member — Tue, 15 Sep 2015 08:28:04 GMT

i would use one of the FUBAs. The reason is: the values in the tables are stored in UTC time. The parameter of the FUBA contains a field for the offset. For example UTC time +02 Offset woulb be summer time CET. Another advantage of the FUBA is that it knows which table to choose from the profile value tables (EPROFVAL15 for 15 minutes values, EPROFVAL30 for 30 minutes values,....)