topic Re: collect statement using in report in Application Development and Automation Discussions

collect statement using in report

ahanadasgupta_23 — Mon, 22 Aug 2022 12:05:25 GMT

Hi All,

Suppose, I want to use collect statement for matnr values and according to that I want sum of quantity field. but I get an error that we can use collect command if all non unique key fields are numeric. How to write the code for that Please anyone guide me.

Thank you in advance.

Re: collect statement using in report

venkateswaran_k — Mon, 22 Aug 2022 12:07:33 GMT

Please share your internal table on which you set a loop - to collect the sum of quantities.

Also share the piece of code on whihc you do collect.

Re: collect statement using in report

Prasobh — Mon, 22 Aug 2022 12:24:46 GMT

Key should be unique to perform the collect statement. You can use loops on your internal table, and write the logic for addition or use SUM.

https://blogs.sap.com/2018/06/15/new-abap-table-sum/

Re: collect statement using in report

Sandra_Rossi — Mon, 22 Aug 2022 12:28:09 GMT

Please indicate the EXACT error message.

About using COLLECT, the documentation says: "All components that are not part of the primary table key must have a numeric data type."

How did you define your internal table, what is the primary table key, especially what components are NOT part of the primary table key?

Re: collect statement using in report

hagit — Mon, 22 Aug 2022 13:33:53 GMT

Did you use ‘with EMPTY KEY’ ?

If yes then you have to replace it – “WITH KEY <name of the non numeric field>”

For example replace line 18 with line 19:

TYPES:
BEGIN OF sty,
ch(3) TYPE c,
int TYPE i.
TYPES:END OF sty .
TYPES:
tty_orig TYPE TABLE OF sty
* ,tty_sum TYPE TABLE OF sty with EMPTY KEY. "line 18
,tty_sum TYPE TABLE OF sty WITH KEY ch . "line 19

DATA: lt_orig TYPE tty_orig
,ls_orig LIKE LINE OF lt_orig
,lt_sum TYPE tty_sum
.

ls_orig-ch = 'a'.
ls_orig-int = 1.
APPEND ls_orig TO lt_orig.

ls_orig-ch = 'a'.
ls_orig-int = 3.
APPEND ls_orig TO lt_orig.

ls_orig-ch = 'b'.
ls_orig-int = 11.
APPEND ls_orig TO lt_orig.

ls_orig-ch = 'b'.
ls_orig-int = 33.
APPEND ls_orig TO lt_orig.

clear ls_orig.
LOOP AT lt_orig INTO ls_orig .
COLLECT ls_orig INTO lt_sum.
ENDLOOP.

Re: collect statement using in report

Saswata89 — Tue, 23 Aug 2022 09:34:45 GMT

Ahana,

Please share the structure of your internal table and more details(screen capture etc.) on the error. You might also take help from this answer - https://answers.sap.com/questions/2880928/use-of-collect-statement.html