SAP table info from Oracle

        SELECT f.tabname,
               f.fieldname, 
               t.ddtext,
               ltrim(position,'0') as position,
               f.keyflag  as "Primary Key",
               d.rollname as "Data Element",
               d.domname  as "Domain",
               d.memoryid, 
               f.datatype, ltrim(f.leng,'0') as leng,
               f.checktable,
               f.reftable,
               f.reffield,
               m.entitytab,
               m.convexit
         FROM dd03l f,
              dd04l d,
              dd04t t,
              dd01L m
        
        WHERE  d.rollname(+) = f.rollname
          AND  t.rollname    = d.rollname
          AND  m.domname(+)  = d.domname
          
          AND  f.tabname  = 'ZSTT9100'
          AND  t.ddlanguage = '3'
        
        ORDER BY to_number(f.position)