DMS file opening problem for docx & xlsx files.

[Former Member]

Hi All,

while opening docx & xlsx files data is getting truncated when they are transmited as external attachments from SRM with ERP PO mail through DMS.

I feel there should be some problem with DMS itself as file format doc, xls are opening correctly as they were mapped with work station type DOC & XLS.

Need your iputs to rectify the problem.

Thanks,

Ramakrishna

[alisonv]

DATA: lt_access_info       TYPE TABLE OF sdokfilaci,
      lt_ascii_content     TYPE TABLE OF sdokcntasc,
      lt_binary_content    TYPE TABLE OF sdokcntbin.
DATA:  lv_doc_lenght        TYPE i,
       lv_qty_lines         TYPE i,
       lv_xstring           TYPE xstring.

CALL FUNCTION 'SDOK_PHIO_LOAD_CONTENT'
          EXPORTING
            object_id           = w_object_id
            raw_mode            = 'X'
          TABLES
            file_access_info    = lt_access_info
            file_content_ascii  = lt_ascii_content
            file_content_binary = lt_binary_content
          EXCEPTIONS
            not_existing        = 1
            not_authorized      = 2
            no_content          = 3
            bad_storage_type    = 4
            OTHERS              = 5.

 IF sy-subrc <> 0.
    RETURN.
 ENDIF.

  FIELD-SYMBOLS: <lt_access_info> LIKE LINE OF lt_access_info.
  READ TABLE lt_access_info ASSIGNING <lt_access_info> INDEX 1.
  IF sy-subrc IS INITIAL AND <lt_access_info>-file_size IS NOT INITIAL.
     lv_doc_lenght = <lt_access_info>-file_size.
  ELSE.
     lv_qty_lines  = lines( lt_binary_content ).
     lv_doc_lenght = lv_qty_lines * 1022.
  ENDIF.

[Former Member]

Hi Ramakrishna,

Kindly maintain the settings in SPRO->Document Management->General Data->Define Workstation Application (DC30).

For XLS application define file format as *.xlsx and DOC application maintain file format as *docx.

Hope this might resolve ur issue.

Regards

Bhanu

[Former Member]

Hi,

Unfortunately, it is not possible to change the structure of SOOD; so

the file type will still be restricted to three characters. However SAP provide an option to set a file name for the

document/attachment with an unlimited extension.

Please refer to this note.

Note 1459896 - BCS: Support for four-digit file name extensions

Hope this will solve your problem.

Keerthi

[Former Member]

Hi Ramakrishna,

You need to maintain the file formats in DC30 for solving the problem. In DC30 maintain the suffix as .dox.xlx..etc. as there is three character limit. And define the MIME type of .docx..xlsx..etc. The mime types are different than .doc,xls..etc.

MIME types you can get in google search also.

Hope this will resolve the query.

Regards,

Ravindra