Problem with Email Attachement.

[sastry_gunturi]

FORM BUILD_XLS_DATA.

  CONSTANTS: CON_CRET TYPE X VALUE '0D',
             CON_TAB  TYPE X VALUE '09'.

*  CLASS CL_ABAP_CHAR_UTILITIES DEFINITION LOAD.
*  CONSTANTS:
*     CON_TAB TYPE C  VALUE CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB,
*    CON_CRET TYPE C  VALUE CL_ABAP_CHAR_UTILITIES=>CR_LF.

  CONCATENATE 'MATERIAL' 'RELEASED' 'PENDING' 'ONHOLD' 'WEEK' 
  INTO IATTACH SEPARATED BY CON_TAB.

  CONCATENATE CON_CRET IATTACH INTO IATTACH.
  APPEND IATTACH.

  LOOP AT IT_MARD.
    CONCATENATE IT_MARD-DESC IT_MARD-LABST IT_MARD-INSME IT_MARD-ONHOLD
                IT_MARD-WEEK  INTO IATTACH SEPARATED BY
CON_TAB.
    CONCATENATE CON_CRET IATTACH INTO IATTACH.
    APPEND IATTACH.
  ENDLOOP.

ENDFORM.    

I am building the excel file as shown above..........week column in the excel file appears to be too long......how can fix it to correct length.

[naimesh_patel]

This statment should be like this:

CONCATENATE IATTACH CON_CRET  INTO IATTACH.   " <<  
  APPEND IATTACH.

  LOOP AT IT_MARD.
    CONCATENATE IT_MARD-DESC IT_MARD-LABST IT_MARD-INSME IT_MARD-ONHOLD
                IT_MARD-WEEK  INTO IATTACH SEPARATED BY
CON_TAB.

*    CONCATENATE CON_CRET IATTACH INTO IATTACH.
     CONCATENATE IATTACH CON_CRET  INTO IATTACH.  " << CON_CRET must be at the end

    APPEND IATTACH.
  ENDLOOP.

Regards,

Naimesh Patel

[sastry_gunturi]

I made the changes as Naimesh suggested.........now i see the that there is no data being populated in the First column 'Description'...................How can i fix it.

[Former Member]

Hi,

I have not fully understood your problem.If u what is the exact problem then i can give u any solution.

Thanks,

Aditya.