topic Re: Convert Binary data into readable content in Application Development and Automation Discussions

Convert Binary data into readable content

Former Member — Wed, 24 Dec 2014 21:31:14 GMT

Hi,

Could anyone tell me how i can convert Binary data into a readable content?(.xlsx/.txt)

I tried all the Function modules to convert BINARY_TO_STRING, BINARY_TO_TEXT and also XSTRING to String. But all of them gives data in readable format.

Also, i need to perform this function in background and hence cannot use 'GUI_DOWNLOAD'

Please help me provide the solution.

Thanks,

Deepika

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 04:22:11 GMT

You could try methods of class CL_BCS_CONVERT

Re: Convert Binary data into readable content

archanapawar — Tue, 30 Dec 2014 04:59:51 GMT

Hi Deepika,

Did you try FM SCMS_BINARY_TO_STRING?

If you need to download the file in background, you will need to use open dataset method and write the files on application server. You can't use GUI_DOWNLOAD in background.

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 05:15:02 GMT

Hi Pulkit,

Thanks for your reply. This class doesnt have any method which converts XSTRING data to text. I need to be converted to Text format and create file in AS using background job.

Thanks,

Deepika

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 05:17:27 GMT

Hi Archana,

Thanks for your reply.

I tried FM SCMS_BINARY_TO_STRING, this FM converts to String from Xstring where data is not in readable format.

Thanks,

Deepika

Re: Convert Binary data into readable content

archanapawar — Tue, 30 Dec 2014 05:25:13 GMT

Ok Try SCMS_BINARY_TO_TEXT.

Re: Convert Binary data into readable content

ipravir — Tue, 30 Dec 2014 05:36:49 GMT

Hi Deepika,

How are you getting the binary data? Can you provide some text file which contains the Binary Information?

Regards.

Praveer

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 05:39:51 GMT

the data i am pulling is of Rate table in TM system. There is std FM which will read the table and get the output in XSTRING (Solix) format.

Re: Convert Binary data into readable content

archanapawar — Tue, 30 Dec 2014 05:46:44 GMT

then you should convert xstring to binary first and then convert binary to text.

SCMS_XSTRING_TO_BINARY and SCMS_BINARY_TO_TEXT

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 05:51:25 GMT

I tried all the options. all of them writes data in to a file which has unreadable content. mostly i will see special characters. i can write data in text file or excel.

Re: Convert Binary data into readable content

ipravir — Tue, 30 Dec 2014 05:58:06 GMT

Hi Deepika,

Could you provide a sample text file? so we can try and provide the solution.

Because we don't know what kind of file you have and what kind of data it's contains.

We only can provide you the FM or Class name which are available in SAP system.

May be you are not passing any of the parameters of any of the given FM.

Regards.

Praveer.

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 06:08:50 GMT

HI Deepika,

It does have a method to convert xstring to string

Method XSTRING_TO_STRING

pass your xstring data as parameter IV_XSTR and also pass the xstrlen( xstring variable) to IV_CP

For ex

data: l_xstring type xstring,

l_gui_codepage TYPE cpcodepage.

l_string type string.

l_xstring = <xstring value>

sorry for the wrong sample code earlier.

CALL FUNCTION 'SCP_GET_CODEPAGE_NUMBER'

EXPORTING

database_also = 'X'

IMPORTING

gui_codepage = l_gui_codepage.

l_string = call method CL_BCS_CONVERT=>XSTRING_TO_STRING (

IV_XSTR = l_xstring

IV_CP = l_gui_codepage ).

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 06:11:10 GMT

Hi Praveer,

Here is the sample file. Please remove the file extension (.txt) from file as other extensions are not allowed to be attached in this message

1. From the Table, the std SAP program gets the data in XSTRING,

2. Using OPEN DATASET in BINARY MODE, the contents are written to Binary file in AS

3. I am converting this file to Text or .xlsx file types.

Thanks,

Deepika

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 06:20:01 GMT

I tried that and its of same result as BINARY_TO_STRING. the output has special characters. am i missing anything?

Thanks,

Deepika

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 06:27:50 GMT

The zip file does not seem to have a binary format, it seems a different format.

Whats the standard program/ FM name that returns this file? Is there a documentation supporting it?

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 06:32:46 GMT

Please remove the .txt extension. I had to put this extension as other files are not allowed to attach.

Re: Convert Binary data into readable content

ipravir — Tue, 30 Dec 2014 06:55:40 GMT

Hi Deepika,

The file , what you have provide, it's contains the Excel Information and file format should be xlsx.

Then only you can view the Information.

What is the Extension of this file in AL11? is it xlsx?

if not then try to put an extension and create a copy of the same file, and then open the same file through AL11 and is it displaying the information?

Please check.

If it's displaying the Information in AL11 Screen, then you have to debug the AL11 while displaying the Information and try to get the FM name what SAP is using to displaying the Information.

Regards.

Praveer.

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 08:23:26 GMT

Hi Praveer,

You are right. The contents are meant for .xslx file.

I am not sure how i can check in AL11 but the program uses logical->physical file path method and i forced to save the file in .xlsx. I am able to see the contents, but a pop-up appears when i open that

excel has unreadable content and do you want to repair? when i say 'Yes', then another pop-up appears that the file has been repaired. we want to override this pop-up as we would like to automate the file reading process.

Thanks,

Deepika

Re: Convert Binary data into readable content

ipravir — Tue, 30 Dec 2014 08:29:39 GMT

Hi Deepika,

The same message I was facing, when I change the extension and try to open the file in local system.

Go to AL11 T-Code.

there you can see all folder information of the Application Server.

Select the Folder, where the particular file is storing.

Select the File, and from the Tool Buttons, you select the View Document (not Sure about the name).

After press the tool button, you will able to see the File Contents in SAP screen.

If you are able to see the file content over there, then you have to debug the AL11 t-code at the selection of View Tool Button and check the SAP standard code.

Please check.

Regards.

Praveer.

Re: Convert Binary data into readable content

Former Member — Tue, 30 Dec 2014 08:58:49 GMT

Hi Praveer,

I could not find any Directory having my file in it.

do you know how to find one where the file path is saved in FILE tcode?

thanks,

Deepika