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