Update text from 2 columns to 1 field.

[Former Member]

Dear All,

I would like to update RM06I-LTEX1 field with 2 columns of data in CSV file.

How should I write my BDC Program to let it pull data from 2 columns and fit it in 1 field? What is the transparent table for RM06I-LTEX1?

At first I only have field like below.

"IPQ-2007-08-20 "

then now I wish to update the data for that field become:

"IPQ-2007-08-20 YES"

Any guide/ advice/ example?

I damn worry if I did it wrongly in the BDC program, then the existing data will be overwrite.

Please help!

Thank you very much!!

[Former Member]

hi peai,

In youe example, Is 'yes' is a field??

Gaurav

[Former Member]

Hi,

IPQ-2007-08-20 YES is in 1 field ..

At first is only 'IPQ-2007-08-20' in that field RM06I-LTEX2 now user want to fully utilize this long text field. so want to add something at RHS of this field.

You may refer this link to get clearer idea, what is the user want.

<a href="http://allyoucanupload.webshots.com/v/2003186583194973129">[IMG]http://aycu16.webshots.com/image/37295/2003186583194973129_rs.jpg[/IMG]</a>

How should I insert 2 column of data (eg 'IPQ-2007-08-20' and 'YES' ) into this 1 field (RM06I-LTEX2) without overwrite each other?

Message was edited by:

Peai Chun Ong

[Former Member]

hi,

You can concatenate this two things before actually transferring into bdc.

ex : longext1 = 'Maintext1'.

temp = 'YES'.

concatenate longtext1 temp into longtext1.

then,

perform bdc statements.

This way you can easily use and solve the problem

Reply fast,

Gaurav