Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

EXCEL-Attachment with numeric-value

Former Member
0 Likes
350

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
308

did you tried this..

loop at itab.

write ITAB-BRGEW to BRGEW.

regds,

kiran

2 REPLIES 2
Read only

Former Member
0 Likes
309

did you tried this..

loop at itab.

write ITAB-BRGEW to BRGEW.

regds,

kiran

Read only

0 Likes
308

Hi Kiran,

thanks, very simple but good solution.

regards, Dieter