cancel
Showing results for 
Search instead for 
Did you mean: 

RFCtoJDBC scenario. I want put two space characteristic from RFC to DB.

Former Member
0 Kudos

If consider, Space set "_" character.

In SAP ERP.

"A__B" means A character and two SPACE and B character.

I wan't to send above character from SAP to DB.

but result is "A_B".

I looking the RWB and SXMB_MONI. when the message was enter the SAP XI, converted already.

How can I do?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

As per your information the A__B (with two spaces) is converted to A_B(one space) while coming from R/3 to XI.

Can you do one thing here to pass the value as A__B( Instead of space use "_" or any special character) from SAP.

In XI while mapping with Database structre use API "replaceString" to replace the "__" by two spaces.

While coming the data from R/3 the spaces may get neglected.

Lets try it out this way and let me know

Thanks

Swarup

Former Member
0 Kudos

Thank you Swarup.

I understand what you means. but, I didn't understand why I convert like this.

and what character is replace the SPACE character? as possible the whole character in data fields.

isn't have any solution?

Answers (1)

Answers (1)

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi

you wouldt have any problem with this issue,

in you graphical mapping use the function concat

Field1__________

Concat -


Target Field

Field2----


press double click in Concat function and add 2 spaces and test your mapping.

also, you can do a UDF like this

str1,str2 --> parameters you send to UDF

//--


code--


str1 = st1.concat (" ");

str1 = str.concat(str2);

return str1;

//--


code--


try and let me know

hope it helps,

Former Member
0 Kudos

Hi Rodrigo.

first of all, when the message arrived in SAP XI, already converted.

so In IR of SAP XI, nothing to do.

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi,

why dont you do this by PI and the sender system just send you the data?? why you need to convert it from sender system before arrive to pi??

Former Member
0 Kudos

Umm...

I don't know exactly. so I looking for the answer.

I try above answer.

in SAP ERP, convert spact to #. and send to SAP XI.

in SAP XI, used repalceString standard function in graphic mapping.

but, post converted, two space character is change one space.

It's crazy..

<inbound payload>

- <item>

<BSTKD>1</BSTKD>

<BSTZD>1</BSTZD>

<MATNR>000000000100001000</MATNR>

<ATCNT>1</ATCNT>

<ATNAM>A1003</ATNAM>

<ATWRT>450#KG##(6#)</ATWRT>

<ATSTD>X</ATSTD>

</item>

<technical routing payload>

- <access>

<ESTI_NO>1</ESTI_NO>

<SEQ>1</SEQ>

<PART_CODE>000000000100001000</PART_CODE>

<CODE_SEQ>1</CODE_SEQ>

<CODE>A1003</CODE>

<VALUE>450 KG (6 )</VALUE>

<DEFAUL>X</DEFAUL>

<XIFLAG>G</XIFLAG>

</access>

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi

why dont you try to create your own UDF to ReplaceString.

also do a test like:

<BSTKD>1</BSTKD>

<BSTZD>1</BSTZD>

<MATNR>000000000100001000</MATNR>

<ATCNT>1</ATCNT>

<ATNAM>A1003</ATNAM>

<ATWRT>450#######KG##(6####)</ATWRT>

<ATSTD>X</ATSTD>

</item>

and see what happend.

if it fial try this

Former Member
0 Kudos

I'm already done.

Thank you Rodrio. I'm really glad for your help.

but, I think this is product issue. isn't it?

Former Member
0 Kudos

It was solved.

cause I didn't understand about HTML attribute and XML attribute.

in HTML, reduce white space. but white space exist in XML.

I'm sorry too carelessness.

Thank you all SDNer.

regard John.