SAP FC sending task to SAP DM : format of data sent

[Former Member]

Dear SAP specialists,

I'd like to open a discussion regarding several issues I face when sending the data from SAP FC to SAP DM using the RunReportBundle task.

Actually, the exact issue is with the format of data sent, as everything is appearing to come in text format.

To be even more specific, when sending the data in date format (DD/MM/YYYY), the value is not recognized as date, but as text. The same applies when a boolean TRUE/FALSE values are sent, but SAP DM is not able to read them as such.

When playing with Excel formula with converting formats it works only when a datacache receiving chapter is open. I suppose, this triggers the automatic evaluation of excel formulas.

Has anyone already faced these issues

Thank you very much!

Nicolas

[Marc_Kuipers]

Hello Nicolas

This is a bug.

You can use the following workarounds

1. Format the date in BFC

2. Change the format in DM

In the recipient workbook of the DM data cache, insert the following formula; this will automatically convert all short dates (“dd/mm/yy” format) into a proper Excel date:

=IFERROR(DATE(IF(INT(RIGHT(fcdate,2))>50,RIGHT(fcdate,2),INT(RIGHT(fcdate,2))+2000),MID(fcdate,4,2),LEFT(fcdate,2)),"")

Marc

[Former Member]

Hi Marc,

Thanks for providing me with these workaround solutions.

Actually I've already tried them and they seem to work only after running FC task "RunReportBundle" and once SAP DM chapters are updated with import task, the chapter need to be open to have the formula to be computed (to transform date in text format in a date in date format).

Meaning, after each FC Export task, users must open the excel chapters having the dates, to make it work...

I wonder if there is any possibility to have this formula to be computed during the import task execution? Is there any information available on how the data is updated during the import task?

Best regards,

Nicolas