Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Creating EDM profile values

Former Member
0 Likes
1,638

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...

4 REPLIES 4
Read only

Former Member
0 Likes
1,184

...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?

Read only

0 Likes
1,184

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

Read only

0 Likes
1,184

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?

Read only

0 Likes
1,184

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,....)