Download / upload attachments Fiori DMS - wrong file extension is downloaded

[oertera]

Dear all,

I have a problem when trying to download .xlsm file extension in FIORI DMS transactions.
I have configured workstation application XLS for file formats *.xls,*.xlsx, and *.xlsm.
MIME-TYPE is configured as: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

When I now try to open an original with file extension .XLSM in FIORI DMS transaction, the system downloads the respective file with wrong file extension .XLSX and file can not be opened. In SAP GUI or ECTR everything works perfectly fine.

What can I do to get it working also in SAP FIORI? Do I need to configure an own workstations application type for each file extension (.xls. .xlsx, .xlsm), or is there any other solution available?

Any hint is highly appreciated. Thank you,
Arnd

[christoph_hopf]

Hi Arnd,

I your question and please check that the workstation application has maintained the mime-type for format *.XLSM which would be application/vnd.ms-excel.sheet.macroenabled.12.

Based on similar situations in the past please ensure that you have a workstation application for XLSM which has the correct mime-type maintained. This should be the same mime-type as visible in table SDOKMIME. In our internal system I can see the following configuration for it:

Se16
Table SDOKMIME

Extension

.xlsm -> application/vnd.ms-excel.sheet.macroenabled.12
.xlsx -> application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Please read also the information at https://help.sap.com/docs/SUPPORT_CONTENT/sapdms/3363504677.html .

Also note that there is a different behavior with the apps which is due to the fact that only "Manage Documents" is a real Fiori app and the other two tiles are embedded transactions which use the SAPGUI for HTML (ITS) mode. For this the design is slightly different and information on trouble shooting can be found at

3520958            Webgui FSM and HTML Viewer: File downloaded without extension
2424875            ITS HTML Control and FSM: document display problems

The difference between "Manage Documents" (Fiori) and "Display Documents" (GUI for HTML) is that following coding call of function module 'CV120_DOC_CHECKOUT_VIEW' that does not happen in the Fiori app:

SAPLCV110                      / LCV110F32
FORM            / KPRO_FILE_DISPLAY

  IF gs_frontend-winsys = 'ITS'.
    ls_cout_def-content_provide = 'ITS'.
*    ls_cout_def-content_provide = 'WGUI'.
    CALL FUNCTION 'CV120_SPLIT_PATH'        "Note 3026896
      EXPORTING
        pf_path        = ls_phio-filename
     IMPORTING
       pfx_file       = ls_doc_file-filename. " Note 3026896
    CLEAR lf_check_file.
  ENDIF.

  CALL FUNCTION 'CV120_DOC_CHECKOUT_VIEW'
       EXPORTING: ps_cout_def   = ls_cout_def
                  pf_tcode      = gf_transaction
                  ps_doc_file   = ls_doc_file
                  ps_draw       = gs_draw
                  ps_phio       = ls_phio
                  ps_frontend   = gs_frontend
      IMPORTING:  pfx_file      = ls_doc_file-filename
                  pfx_url       = ls_doc_file-url
                  pfx_use_last  = lf_use_last
      TABLES:     pt_components = lt_components
      EXCEPTIONS: error         = 1
                  OTHERS        = 2.
  IF sy-subrc <> 0.
    PERFORM sys_message_info. EXIT.
  ENDIF.

The function module is called here with the parameter values

LS_COUT_DEF-CONTENT_PROVIDE    ITS
GS_FRONTEND-WINSYS                    ITS

which is specifically telling the system that this is a WebGUI (SAP GUI for HTML) scenario and so it is also different to the pure SAP GUI for Windows scenario. 

Best regards,
Christoph