topic Re: general in Application Development and Automation Discussions

general

Former Member — Tue, 29 Jan 2008 12:39:14 GMT

Hey Folks,

I have a req.. where i have to sum up the records and display at the footer in a classical report for example

matnr price

a 1

b 2

c 3

d 4

i have to get

matnr price

a 1

b 2

c 3

d 4

could somebody write me a sample codew for this as it is urgent and i m stuck with it.

Regards

Rock

Re: general

Former Member — Tue, 29 Jan 2008 12:42:22 GMT

Use the control Break AT LAST with in the ITAB loop and then use the SUM command. It sums all numaric fields only. But ur MATNR is of CHAR type. So, u have to convert CHAR to NUM type.

then, after printing the ITAB, u can use uline and then print the SUM

Narendra

Re: general

Former Member — Tue, 29 Jan 2008 12:43:07 GMT

IF YOU ARE USING INTERNAL TABLE THEN

SUM = 0.

START-OF-SELECTION.

LOOP AT INTERNAL_TABLE INTO WA.

SUM = SUM + MATNR_PRICE.

ENDLOOP.

WRITE: ULINE.

WRITE: SUM.

REWARD POINTS IF HELPFUL,

KUSHAGRA

Re: general

Former Member — Tue, 29 Jan 2008 12:43:24 GMT

Use the control Break AT LAST with in the ITAB loop and then use the SUM command. It sums all numaric fields only. But ur MATNR is of CHAR type. So, u have to convert CHAR to NUM type.

then, after printing the ITAB, u can use uline and then print the SUM

Narendra

Re: general

Former Member — Tue, 29 Jan 2008 12:44:12 GMT

Use the control Break AT LAST with in the ITAB loop and then use the SUM command. It sums all numaric fields only. But ur MATNR is of CHAR type. So, u have to convert CHAR to NUM type.

then, after printing the ITAB, u can use uline and then print the SUM

Narendra

Re: general

Former Member — Tue, 29 Jan 2008 12:51:32 GMT

LOOP it INTO wa.

WRITE <field1>,<field2>.

AT LAST.

WRITE: 'Sum:', 20 sum(t2),

ENDAT.

ENDLOOP.