EXCEL-Attachment with numeric-value

Former Member — Thu, 01 Feb 2007 15:20:18 GMT

Hi all,

i send data from MARA via email as excel-attachment.

The code-extract is like this:

CONCATENATE 'Material' CON_TAB

'Materialart' CON_TAB

'Warengruppe' CON_TAB

'Bruttogewicht' CON_CRET

INTO OBJ_BIN.

APPEND OBJ_BIN.

...

LOOP AT ITAB.

BRGEW = ITAB-BRGEW.

CONCATENATE ITAB-MATNR CON_TAB

ITAB-MTART CON_TAB

ITAB-MATKL CON_TAB

BRGEW CON_CRET

INTO OBJ_BIN.

APPEND OBJ_BIN.

ENDLOOP.

I have problems with BRGEW wich is not transfered correct.

How can i transfer it to a correct value.

in SAP BRGED = 13,000 in EXCEL BRGEW = 13.000 which is 13000

Thanks for help

Regards, Dieter

Re: EXCEL-Attachment with numeric-value

Former Member — Thu, 01 Feb 2007 15:24:42 GMT

did you tried this..

loop at itab.

write ITAB-BRGEW to BRGEW.

regds,

kiran

Former Member — Thu, 01 Feb 2007 15:29:31 GMT

Hi Kiran,

thanks, very simple but good solution.

regards, Dieter