cancel
Showing results for 
Search instead for 
Did you mean: 

SLT - couldn't concatenate source fields into new field

Former Member
0 Kudos

Hi,

I have problem with concatenate source fields (SAP ECC) into new field (SAP HANA) using SLT.

In STCode: SE38 I have created include Z_LFA1_TEST_001 (temporary, &TMP):

*&---------------------------------------------------------------------*
*&  Include           Z_LFA1_TEST_001
*&---------------------------------------------------------------------*
CONCATENATE
<wa_s_lfa1>-name1
<wa_s_lfa1>-name2

INTO
<wa_r_lfa1>-zfullname.

SEPARATED BY space.

Now I went to STCode: IUUC_REPL_CONTENT

I have changed "Rule Assignment" like below

I went to "Table settings" -> "Table structure" and I have added new field ZFULLNAME and I have droped all columns from the field LNRZA lke below:

At this moment I have started replication from STCode: LTRC. I have added new table to replication (LFA1). I saw in SAP HANA changed structure (removed columns and one added). But I can't see any value in column ZFULLNAME.

Do you have any suggestions what I have missed?

Thanks,

Pawel

Accepted Solutions (1)

Accepted Solutions (1)

justin_molenaur2
Contributor
0 Kudos

Do two things

1) Check the application logs on SLT side to see if there were errors generating the conversion objects. I tried your code on another table and got what looks like a syntax error here.

2) Try using the following code instead

CONCATENATE <wa_s_lfa1>-name1 ' ' <wa_s_lfa1>-name2 INTO <wa_r_lfa1>-zfullname SEPERATED BY SPACE.


Sometimes syntax is everything


Regards,

Justin

Former Member
0 Kudos

Hi Justin,

Yes, in this case syntax was everything Thanks a lot - it's works now.

Regards,

Pawel

Former Member
0 Kudos

Hi Pawel,

CONCATENATE

INTO

SEPARATED BY   all belong to one command.

Remove the "dot" at the end of INTO clause

Correct statement is...

CONCATENATE

<wa_s_lfa1>-name1

<wa_s_lfa1>-name2

INTO

<wa_r_lfa1>-zfullname

SEPARATED BY space.

Best of luck

Answers (0)