Mapping: CR (\n) tag in XML node gives # sign in R/3
My flow is JDBC to R/3 via a BAPI call. I have a problem transporting carriage returns (hard enters) from my DB table to R/3. IN XI the CR comes in as '\n' sign, afterwards it's mapped to the BAPI but when the BAPI is executed in R/3 the CR becomes a '#' sign in my textfield.
I already tried more then 30 possibilities in a UDF function:
Replace \n by: \r\n , \r , System.setProperty("line.separator", "\r\n") , #xD , #xA , \xD , \xA , , 0D0A , %0D0A% , ...
I also tried with 2,3 or even 4 backward slashes...nothing gives me a real CR (or linefeed in UNIX?) in my textfield in the backend system.
Anyone experience with transporting CR/LF signs via PI to your backend system?