cancel
Showing results for 
Search instead for 
Did you mean: 

target file has # appended at the end of each record. SFTP adapter

Former Member
0 Kudos

Hi ,

We are having a flow from SFTP-->PO-->SFTP

It is a passthrough interface without any mappings.

We pick the file and place the same file in a different SAP server.

When SAP , views the file in transaction al11, they see an appended # at the end of each row, which is causing a issue with file processing.

Solution tried.

Adding:     AF_Modules/MessageTransformBean  , Transform.ContentType = text/xml;charset=utf-8

http://scn.sap.com/community/pi-and-soa-middleware/blog/2014/10/09/character-encoding-handled-the-ri... ,we followed, still we findign same issue.

Please let us know if you have any inputs to solve this issue.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Ryan-Crosby
Active Contributor
0 Kudos

Hi Rohit,

If people are seeing # at the end of the file in AL11 then there is probably nothing wrong with the file.  The # character will be displayed in many places/transactions in an ABAP system when the character is not one that can be displayed... e.g. line feed, carriage return or the combination of carriage return/line feed, other control characters, etc.  Likely more analysis should be done with whatever is being done to process the file on the receiving system.

Regards,

Ryan Crosby

Former Member
0 Kudos

Hi Ryan,

Is there any way we can remove it. The target team is adament about removing the #

Ryan-Crosby
Active Contributor
0 Kudos

Hi Rohit,

You have missed the point of what I was saying... likely the character(s) in question are not truly # characters but simply a GUI representation of some other control character.  Download the file from the location and view it in something like Notepad++ to see what data is there - what you will find is that those are something like carriage returns or line feeds.

Regards,

Ryan Crosby

Ryan-Crosby
Active Contributor
0 Kudos

Hi Rohit,

To further explain... here is a debugger example showing how the SAP GUI shows two carriage return/line feeds in a row within a string from our HR system.  In the highlighted section you see four # characters to represent the control characters and the hex below of 000D000A000D000A or what would be 0D0A0D0A in single byte ASCII.

Regards,

Ryan Crosby

Answers (0)