Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

[Former Member]

Hi ABAPers,

I'm hoping someone can get me started with a requirement. I"m using SO_DOCUMENT_SEND_API1 to email a file as an excel attachment. I'm required for a four digit code to show as (0003). Instead, when I open the excel attachment, it displays as 3. Would anyone know how to set the document to show all fields as text? Any help would be appreciative.

Thanks,

Meezy

[Former Member]

In addition, I need the fields to display this way as default when the document is opened. The requirement is to not have the business perform this action.

Thanks,

Meezy

[venkat_o]

Hi Meezy, When u r building Excel attachement, take one variable of type N with length 4 and pass to excell file. Then only it is possible. Regards, Venkat.O

[Former Member]

Hi Venkat,

The program is sending the 4 digit code perfectly through excel in debug mode. However, when it's when I open the file that it get's cut off. 3000 shows up fine. Only codes with leading 0's are cut off. 3000 shows as 3000 but 0003 shows as 3.

Thanks,

Meezy

[Former Member]

I've figured it out.

[Former Member]

Meezy,

I am also loking for same solution, can you please let me know what needs to be done.

Thanks!

Thiru

[Former Member]

Hi Meezy,

Even I am trying to format my excel attachment created through FM 'SO_DOCUMENT_SEND_API1'. Can you please share your solution? Any additional tips on formatting (like framing, coloring or making the fields bold) would be helpful.

Thanks,

AMol

[Former Member]

Hi Meezy,

Can you please post the solution which you worked out.

Hope to hear from you soon!!!

Thanks

VJ