Count occurrences of role across users?

Question

The table I use stores different system names, corresponding users and their role. My target is to use the SELECT and COUNT commands together to get some output like this:

SysName | Role1 | Role2 | Role3
----------------------------------
sys1    | 10    | 5     | 25
sys2    | 0     | 70    | 12

But it seems that some of the SQL commands or their structure doesn´t work in ABAP code.

Could you let me know if something like this is possible and when how?

ABAP is space sensitive. Did you use a space between COUNT and its parentheses? — , Aug 29 '17 at 10:24
I think it isnt a syntax error. The columns are: - system name - user name - role type — user7715132, Aug 31 '17 at 12:47

score 0 · Answer 1 · answered Sep 04 '17 at 11:57

0

With this Command you are able to count everything in a Table. Just add your WHERE conditions:

SELECT COUNT( * ) INTO integer FROM table [WHERE...].

I hope this is what you are looking for.

answered Sep 04 '17 at 11:57

Marvin

55
11

score 0 · Accepted Answer · answered Mar 23 '18 at 09:46

0

The error was triggered because the key word "DISTINCT" was missing

The correct answer should be something like:

SELECT COUNT( DISTINCT col1 ) ...

answered Mar 23 '18 at 09:46

user7715132

46
2
8

stack overflow user · Answer 3 · 2017-12-01T09:53:44.030

-1

Select col1, COUNT( col2 ) INTO TABLE @tbl GROUP BY col1 doesn't work in abap, only Select col1, COUNT( DISTINCT col2 ) INTO TABLE @tbl GROUP BY col1. I think You should use Select + Loop in this case

edited Dec 01 '17 at 09:53

answered Sep 06 '17 at 13:48

stack overflow user

79
5

It's not true. `SELECT COUNT` perfectly works standalone. – Suncatcher Dec 01 '17 at 08:30
Sorry for unclear answer. I want to say that this type of select doesn't work in abap. SELECT col1 , COUNT( col2 ) INTO TABLE @tbl GROUP BY col1. – stack overflow user Dec 01 '17 at 09:48

Count occurrences of role across users?

3 Answers3