Skip to Content
0
Former Member
Jun 06, 2008 at 06:25 PM

Issue with CONCATENATE stament

25 Views

Hi Friends,

I have a report which will send a mail to the user with a Excel attachment, The attched excelsheet name should be like this.

"Export /IC - Orders Not Released to WMS 06/06/08".

In this line Export/IC - Variant Description

- --> a char symbol

Order Not Released to WMS - Character string

06/06/08 - date

This statement is coming fine when I am executing the report in foreground but when the same report i am executing in background the stament is coming something like this.

"- Orders Not Released to WMS 06/06/08". Here I am missing the variant description.

Below code I am using to print this statement using CONCATENATE statement.

W_VARIANT = SY-SLSET.

W_CPROG = SY-CPROG.

W_DATE1 = SY-DATUM.

select report variant vtext from varit into corresponding fields of table t_varit where variant eq w_variant and report eq w_cprog.

CONCATENATE w_date14(2) w_date16(2) w_date1+2(2) into w_date1 separated by '/'.

read table t_varit.

W_VTEXT = T_VARIT-VTEXT.

CONCATENATE W_VTEXT W_SYMBOL TEXT-T01 W_DATE1 INTO LWA_DOC_DATA-OBJ_DESCR SEPARATED BY SPACE.

Please help me where I am going wrong,and why this variant description is not coming.

Thanks a lot in advance

mrutyun^