OK, one more time for the dummies ... er ... techies (excluding Jon ... of course ... and may be others ... may be ...)
- how many years in Production
select count(distinct(glctry||glfy)) from f0911
- how many Company
select count(distinct(glco)) from f0911
- how many Business Unit
select count(distinct(glmcu)) from f0911
- (how many Users)
select count(distinct(gluser)) from f0911
- How many ledgers
select count(distinct(gllt)) from f0911
Yeah I know that the details above can be retrieved from other tables (respectively F0008, F0010, F0006, F0092, F0025) but it is possible and, in some cases, even likely, that some values do not exist in the F0911. However, running a SQL on the other tables would be a considerably quicker, but let's not tell the dummies ... er ... techies (excluding ... well you know the rest).