topic Summarization In an Internal table- Smartforms in Application Development and Automation Discussions

Summarization In an Internal table- Smartforms

Former Member — Tue, 04 Feb 2014 11:02:22 GMT

Hello Experts,

I have the following requirement.

I have a internal table with 10 fields of which am displaying only 6 fields in my maintable of smartform. Now in my internal table structure i have the last two fields as MATNR and MATKL.

Now the 6 fields am displaying on main table are

1) Item no

2)description

3)QTY

4)some integer value1

5)some integer value2

6)some integer value3

Now based on the combination of matnr and matkl i must add the line items in the item table.

Conditions,

Item no, description can be taken from the first line item, rest all fields must be added.

Can you help me on acheiving this requirement.

Am very thankful to your immediate response

Thanks

Loki

Re: Summarization In an Internal table- Smartforms

former_member1716 — Tue, 04 Feb 2014 11:06:01 GMT

Hi Lokeswari,

Why dont you try using At new, At last functionalities

Thanks,

Satishi

Re: Summarization In an Internal table- Smartforms

VijayaKrishnaG — Tue, 04 Feb 2014 11:10:22 GMT

Hi Mohan,

You can use COLLECT Statement.

LOOP HEAD_TAB.

WA_ITEM = WA_HEAD. "(required fields)

COLLECT WA_ITEM TO ITEM_TAB.

ENDLOOP.

Here except 4,5,6 and 7 remaining all are Char fields. So, these fields will be simulated with respect to non numeric fields.

Hope you understand.

regards,

Vijay

Re: Summarization In an Internal table- Smartforms

thangam_perumal — Tue, 04 Feb 2014 12:59:31 GMT

Hi Lokeshwari,

with help of your collect statements we can achieve your requirements.

here data type of field should be specified below type.

data: begin of wa,

matnr(20) type c,

matkl(20) type c,

Item_no(6) type c ,

description(40) type c

QTY type n,

some integer value1 type n,

some integer value2 type n,

some integer value3 type n,

end of wa.

data : itab like wa occurs 0.

loop at itab into wa.

collect wa to itab.

endloop.

Regards,

Thangam.P

Re: Summarization In an Internal table- Smartforms

Former Member — Tue, 04 Feb 2014 15:20:53 GMT

Hello All Please understand the condition that i have to maintain,

For every line item having same material number and material group i have to sum up the fields.

Hope i explained my requirement clearly

Thanks,

loki

Re: Summarization In an Internal table- Smartforms

VijayaKrishnaG — Tue, 04 Feb 2014 16:07:14 GMT

Hi,

Have you tried COLLECT?

If you are having data as below,

MAT1 MATGRP1 20 50 10

MAT1 MATGRP1 10 10 20

MAT1 MATGRP1 30 20 40

MAT1 MATGRP1 40 50 50

Collect makes this as

MAT1 MATGRP1 100 130 120. I think, this is what you required.

-Vijay

Re: Summarization In an Internal table- Smartforms

Former Member — Tue, 04 Feb 2014 17:01:20 GMT

yes you are right, but i may also have MAT2MATGRP2, MAT3MATGRP3 will it work for all conditions?

Can you please also specify the syntax for collect ?

Re: Summarization In an Internal table- Smartforms

VijayaKrishnaG — Tue, 04 Feb 2014 17:37:03 GMT

Hi Mohan,

Yes it will workout for all materials and groups.

Already I mentioned the syntax and sample in my first reply. Generally when we are moving data from one table to another we use APPEND WA TO ITAB at the end of loop, instead of APPEND use COLLECT WA INTO ITAB.

And also go through this link for clear syntax and example code.

ABAP Keyword Documentation

-Vijay

Re: Summarization In an Internal table- Smartforms

thangam_perumal — Wed, 05 Feb 2014 04:31:45 GMT

Hi Lokeshwari,

                     DATA: BEGIN OF seats,
        carrid   TYPE sflight-carrid,
        connid   TYPE sflight-connid,
        seatsocc TYPE sflight-seatsocc,
      END OF seats.

DATA seats_tab LIKE HASHED TABLE OF seats
               WITH UNIQUE KEY carrid connid.

SELECT carrid connid seatsocc
       FROM sflight
       INTO seats.
COLLECT seats INTO seats_tab.
ENDSELECT.

let me know know still facing the problem.

Regards,

Thangam.P

Re: Summarization In an Internal table- Smartforms

former_member1716 — Fri, 07 Feb 2014 03:33:36 GMT

Hi Lokeshwari,

I hope you got the answer

If not you can try this code below, it will work i have checked

Do the following steps before you use the code,

Make the field matnr (Whichever field you want to use as a condition for summarization) as first field in your structure,

Also create one extra internal table as final which will hold your summarized value and use that table to display.

Define other data as we used in the code,

after that use the code below,

LOOP AT it_item1 INTO wa_item1.

AT NEW matnr.

G_flag1 = 1.
ENDAT.

IF G_flag1 is NOT INITIAL.
wa_final-item = wa_item1-item.
wa_final-desc = wa_item1-item.
CLEAR G_flag1.
ENDIF.

    wa_final-qty         = wa_final-qty+ wa_item1-qty.
    wa_final-intvalue1 = gwa_final-intvalue1+ gwa_item1-intvalue1.
    wa_final-intvalue2 = gwa_final-intvalue2+ gwa_item1-intvalue2.
    wa_final-intvalue3 = gwa_final-intvalue3+ gwa_item1-intvalue3.

at END OF matnr.
G_flag2 = 1.
ENDAT.

   IF G_flag2 is NOT INITIAL.
     APPEND wa_final TO it_final.
    CLEAR wa_final.
    CLEAR G_flag2.
   ENDIF.

ENDLOOP.

" Am using Flag value inside "at new" and "at end of" because variables will be holding only junk value inside these control break statements.

Hope you got this logic, Please get back if you have any issues in understanding the code

Thanks,

Satish

Re: Summarization In an Internal table- Smartforms

Former Member — Fri, 07 Feb 2014 08:29:13 GMT

Hi Satish,

Thanks for the reply, Your code worked

Also i thank all others who contributed for my query.

Thanks,

lokeshwari

Re: Summarization In an Internal table- Smartforms

former_member1716 — Fri, 07 Feb 2014 08:33:06 GMT

Glad that you got the solution

Re: Summarization In an Internal table- Smartforms

former_member536910 — Mon, 30 Jun 2014 07:56:01 GMT

hiiii alll,

if i have 1 field which i dnt want to collect like rate whos value must b same throughout...

for eg..

total_diamnd_stn discription no_of_stn diamnd_rate total_val

.22 round 22 120 = 120*.22

.32 crt_round 12 150 =150*.32

.45 round 2 120 =120*.45

.85 crt_round 8 150 =150*.85

now i want to club all the columns, but the diamnd_rate column also gets clubed, which i want only 120 and 150 correspondly...

output like below...

total_diamnd_stn discription no_of_stn diamnd_rate total_val

.67 round 24 120 120*.67

1.17 crt_round 20 150 150*1.17

plz help......

thank u..

Re: Summarization In an Internal table- Smartforms

VijayaKrishnaG — Mon, 30 Jun 2014 08:36:48 GMT

Hi Priyanka,

Make DIAMND_RATE column type as C (CHAR) and try.

Regards,

Vijay