zOs/SQL/STATUS

select u.*, COUNT(*), tid104des
  from OA1T.tid104a1,
    (  select       '02 Beleg' na,   tid102ugr gr, tid102uva va
          from OA1T.tid102a1
       union ALL select '03 Status' na,     tid103sgr gr, tid103sva va
          from OA1T.tid103a1
       union ALL select '11 Accounting' na, tid111ugr gr, tid111uva va
          from OA1T.tid111a1
    ) u
  WHERE u.gr = tid104GRP and u.va = tid104val
  group by u.na, u.gr, u.va , TID104DES
  ORDER by u.na, u.gr, u.va
;
select '06 Recovery' na, tid106sta sta, count(*)
     from OA1T.tid106a1
     group by    tid106sta
     order by na, sta
;
select * from oa1t.tid104a1
     order by tid104val;