topic Re: Convert Binary data to internal table and create file on application server in Application Development and Automation Discussions

Convert Binary data to internal table and create file on application server

arpita_churi3 — Thu, 18 Feb 2016 06:41:01 GMT

Hi All,

I have developed a program which reads file contents of DMS file ( Table DMS_DOC_FILES) using function module SCMS_DOC_READ into internal table it_bin[]

it_bin TYPE STANDARD TABLE OF sdokcntbin.

Now I want to convert this binary data of it_bin to internal table which i can use further to create a file on application server.

Please help.

Thanks,

Arpita

Re: Convert Binary data to internal table and create file on application server

Former Member — Thu, 18 Feb 2016 07:03:35 GMT

You can used SCMS_TEXT_TO_XSTRING.

Re: Convert Binary data to internal table and create file on application server

Former Member — Thu, 18 Feb 2016 09:40:37 GMT

Hi Arpita,

You can use FM : SCMS_BINARY_TO_STRING

if you want the resulting string to be in an itab.

declare a itab type string.

data: stringtab type standard table of string.

append <result string from FM> to stringtab

Please let me know if you need any help in placing a file in Application Server.

Thanks,

Mayuresh

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 03:08:48 GMT

Thanks Mayuresh for input..

I have called FM SCMS_BINARY_TO_STRING

CALL FUNCTION 'SCMS_BINARY_TO_XSTRING'

EXPORTING

input_length = comp_size

IMPORTING

buffer = v_xstring

TABLES

binary_tab = i_bin

EXCEPTIONS

failed = 1

OTHERS = 2.

But Output of this FM is a buffer v_xstring ( Single line).

Can you tell me how to convert this single line of buffer to ITAB.

Thanks,

Arpita

Re: Convert Binary data to internal table and create file on application server

Former Member — Fri, 19 Feb 2016 05:17:57 GMT

if you want the resulting string to be in an itab.

declare a itab type xstring.

data: stringtab type standard table of xstring.

append <result string from FM> to stringtab

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 06:45:06 GMT

Thanks for reply.

now i am trying to create application server file using OPEN DATASET for OUTPUT with data from v_string of following function.

CALL FUNCTION 'SCMS_BINARY_TO_STRING'

EXPORTING

input_length = comp_size

IMPORTING

buffer = v_string

TABLES

binary_tab = i_bin

EXCEPTIONS

failed = 1

OTHERS = 2.

It is creating file but unable to open file. Do you have any idea on how to create similar way?

Thanks,

Arpita

Re: Convert Binary data to internal table and create file on application server

LukaszPegiel — Fri, 19 Feb 2016 06:54:20 GMT

Use SCMS_BINARY_TO_XSTRING as it was mentioned before by , be sure you're passing size of the file to that FM, then use OPEN DATASET FOR OUTPUT IN BINARY MODE, transfer xstring to file, and close dataset.

Re: Convert Binary data to internal table and create file on application server

Former Member — Fri, 19 Feb 2016 07:00:23 GMT

Please check your open dataset statement.

OPEN DATASET statement with IN TEXT MODE

Thanks,

Mayuresh

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 07:50:41 GMT

Thanks

I am using text mode.

Now i am trying to create file in BINARY MODE by passing internal table GT_BIN of

FM 'SCMS_DOC_READ' but now i am getting following error while opening file from AL11

FILE1.PDF is not text file.

Re: Convert Binary data to internal table and create file on application server

Former Member — Fri, 19 Feb 2016 08:47:15 GMT

are you placing the file on Application Server in .PDF format?

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 08:47:21 GMT

Thanks

It is creating file in BINARY MODE but uanble to open file from AL11

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 08:48:21 GMT

File can be in any format

i tried for PDF and DOC.

It is creating file but not able to open

Re: Convert Binary data to internal table and create file on application server

Former Member — Fri, 19 Feb 2016 08:58:50 GMT

Please use Encoding UTF-8 in OPEN DATASET statement as below:

OPEN DATASET FOR OUTPUT IN TEXT MODE ENCODING UTF-8

Regards,

Mayuresh

Re: Convert Binary data to internal table and create file on application server

LukaszPegiel — Fri, 19 Feb 2016 08:59:17 GMT

Have you tried download the file to PC using CG3Y and then opening it from there?

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 09:04:31 GMT

yes. It is giving error : Cannot open file

Re: Convert Binary data to internal table and create file on application server

LukaszPegiel — Fri, 19 Feb 2016 09:17:20 GMT

Well try to post some code, without I cannot help more.

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 09:28:03 GMT

CALL FUNCTION 'SCMS_BINARY_TO_XSTRING'

EXPORTING

input_length = v_info-comp_size

IMPORTING

buffer = v_xstring

TABLES

binary_tab = gt_bin

EXCEPTIONS

failed = 1

OTHERS = 2.

OPEN DATASET p_fname FOR OUTPUT IN BINARY MODE.

TRANSFER lv_xstring TO p_fname.

CLOSE DATASET p_fname.

Above code creating file but not able to open.Please suggest.

Re: Convert Binary data to internal table and create file on application server

Former Member — Fri, 19 Feb 2016 09:49:43 GMT

Please use Encoding UTF-8 in OPEN DATASET statement as below:

OPEN DATASET FOR OUTPUT IN TEXT MODE ENCODING UTF-8

Regards,

Mayuresh

Re: Convert Binary data to internal table and create file on application server

LukaszPegiel — Fri, 19 Feb 2016 09:50:27 GMT

v_xstring or lv_xstring -> type errors only? Is your comp_size filled with file size? Is the size of the file the same in AS after save as in v_info-comp_size?

Re: Convert Binary data to internal table and create file on application server

arpita_churi3 — Fri, 19 Feb 2016 10:19:13 GMT

It is spelling mistake only.

I am trying to check size of file on AP using FM EPS_GET_FILE_ATTRIBUTES

but getting error read_attributes_failed.