topic SO_NEW_DOCUMENT_ATT_SEND_API1 convert date in Application Development and Automation Discussions

SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

Former Member — Fri, 10 Jun 2016 07:06:41 GMT

Hello!

We use FM SO_NEW_DOCUMENT_ATT_SEND_API to create a 'CSV' file and send it with email, but there is a Problem with the date. After creating the csv file the date 201606100757 (yyyymmddHHMM) is converted to 2,01606E+11.

In this file we need the format (yymmddHHMM).

If a TXT file is created with this FM, the date is ok.

Dose anyone know a solution?

Best regards,

Manuel

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

Former Member — Fri, 10 Jun 2016 07:10:41 GMT

Hi Manuel,

Did you try to expand the column and see the content in the CSV File.

Could you please attach the screen shot of the column here.

Thanks and Regards,

Vinay Mutt

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

Former Member — Fri, 10 Jun 2016 07:14:58 GMT

Assuming its already char type, Add ' (single quote before passing the value -> equals to '''').

CONCATENATE ''''

v_date

INTO v_date.

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

Former Member — Fri, 10 Jun 2016 07:50:08 GMT

Hi, thanks for your quick Response!

@Vinary Mutt

I tried that and it's still in the wrong Format.

@Elzkie La

Now the value of the column is '201606100757. The date is correct, but now i have a single Quote at first.

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

Former Member — Fri, 10 Jun 2016 07:55:30 GMT

internally it will be displayed with quote but in csv it will not be visible. It's defaulted in excel/csv with 2,##+11 number. Not sure if there is any other solutions for this for excel formating from sap.

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

Former Member — Fri, 10 Jun 2016 08:20:24 GMT

Did you try with declaring data type as NUMC instead CHAR.

Rgds,

Guna