Ausgabe der PFCG-Rollenzuordnung

  SELECT a.mandt, a.uname, a.agr_name
    FROM agr_users a, usr02 u
   WHERE     a.uname = u.bname
         AND a.mandt = u.mandt
         AND a.from_dat <= TO_CHAR (SYSDATE, 'YYYYMMDD')
         AND a.to_dat >= TO_CHAR (SYSDATE, 'YYYYMMDD')
         AND u.gltgv <= TO_CHAR (SYSDATE, 'YYYYMMDD')
         AND (u.gltgb >= TO_CHAR (SYSDATE, 'YYYYMMDD') OR u.gltgb = '00000000')
ORDER BY a.uname, a.mandt;

SELECT a.mandt, a.uname, a.agr_name FROM agr_users a, usr02 u WHERE a.uname = u.bname AND a.mandt = u.mandt AND a.from_dat <= TO_CHAR (SYSDATE, 'YYYYMMDD') AND a.to_dat >= TO_CHAR (SYSDATE, 'YYYYMMDD') AND u.gltgv <= TO_CHAR (SYSDATE, 'YYYYMMDD') AND (u.gltgb >= TO_CHAR (SYSDATE, 'YYYYMMDD') OR u.gltgb = '00000000') ORDER BY a.uname, a.mandt;