on 02-25-2014 4:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.