topic Re: how to add fields in Application Development and Automation Discussions

how to add fields

Former Member — Wed, 23 Apr 2008 10:58:19 GMT

Hi All

I have a requirement,

where i have 2 fields

employee & Amount

suppose i have repeated entreis for the employess

a---- 10

b----5

Hence now my answer should be something lile foe field A answer is 40 rs & field B has 10 rs.

any inputs plz

Regards

Rohini

Re: how to add fields

Former Member — Wed, 23 Apr 2008 11:06:14 GMT

Use collect statement. This will add the numeric values when the data is appended in the internal table

Re: how to add fields

prasanth_kasturi — Wed, 23 Apr 2008 11:09:04 GMT

use collect insted of append when you are entering data nto table. and be sure that the field is of numeric data type otherwise the value cannot be added

regards

prasanth

Re: how to add fields

Former Member — Wed, 23 Apr 2008 11:09:58 GMT

Hi,

As suggested collect statement will suit your requirement

declare another internal table internaltable2 of the same type containing the 2 fields internaltable1 and also a workarea

loop at internaltable1 to workarea.

collect workarea to internaltable2

endloop.

Regards

Byju

Re: how to add fields

former_member480923 — Wed, 23 Apr 2008 11:12:52 GMT

Use the following code:



*&---------------------------------------------------------------------*
*& Report  ZTEST_PRG6
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  ztest_prg6.

TYPES: BEGIN OF types_data,
       fld1 TYPE char4,
       fld2 TYPE dmbtr,
       END OF types_data.

DATA: lt_data TYPE STANDARD TABLE OF types_data,
      ls_data TYPE types_data.

ls_data-fld1 = 'A'.
ls_data-fld2 = 10.
COLLECT ls_data INTO lt_data.
CLEAR: ls_data.

ls_data-fld1 = 'A'.
ls_data-fld2 = 10.
COLLECT ls_data INTO lt_data.
CLEAR: ls_data.

ls_data-fld1 = 'A'.
ls_data-fld2 = 10.
COLLECT ls_data INTO lt_data.
CLEAR: ls_data.

ls_data-fld1 = 'A'.
ls_data-fld2 = 10.
COLLECT ls_data INTO lt_data.
CLEAR: ls_data.

ls_data-fld1 = 'B'.
ls_data-fld2 = 05.
COLLECT ls_data INTO lt_data.
CLEAR: ls_data.

ls_data-fld1 = 'B'.
ls_data-fld2 = 05.
COLLECT ls_data INTO lt_data.
CLEAR: ls_data.

SORT lt_data BY fld1.

LOOP AT lt_data INTO ls_data.

  WRITE:/ ls_data-fld1,
          ls_data-fld2.

ENDLOOP.

Hope That Helps

Anirban M.

Re: how to add fields

vinod_vemuru2 — Wed, 23 Apr 2008 11:13:59 GMT

Hi Rohoni,

U can use either collect or SUM statements to achieve this.

or else following logic.

SORT itab BY employee.

LOOP AT itab INTO wa.

logic1

w_amount = w_amount + wa-amount.

AT END OF employee.

WRITE w_amount.

CLEAR w_amount.

ENDAT.

logic2

SUM.

AT END OF employee.

WRITE wa-amount.

ENDAT.

ENDLOOP.

Thanks,

Vinod.

Re: how to add fields

Former Member — Wed, 23 Apr 2008 11:30:55 GMT

Its better to use COLLECT statement,but be sure that the fields that have to be added should of type I,P,F data types only.

Re: how to add fields

Former Member — Wed, 23 Apr 2008 11:32:39 GMT

Its Better to use COLLECT statement,but make sure that the fields which are to be added are of data type I,P,F.

Reward if helpful

cheers

Amith

Re: how to add fields

Former Member — Wed, 12 May 2010 08:48:12 GMT

Solved myself.