i'm a newbie in Abap-Development but I Have developed in some other languages.
My Problem is, that I have to select the max count of a table like this:
Select tab1-field1 max( Count( tab2-field1 ) ) from tab1 inner join tab2 on tab1-field1 = tab2-field2 group by tab1-field1
In single steps:
What I want to see, is the maximum count of tab2-field1 in relation to tab1-field1. How can I do this? In Abap I can not write this sql, because ofter the max is an field expected, am i right?