i need atext from table t518a for my report

[Former Member]

hi all , this is my code for atext which is working SELECT SINGLE atext

    FROM t522t

    INTO wa_output-anredtxt

   WHERE sprsl EQ sy-langu AND

         anred EQ p0002-anred.

Moderator message: don't post the same question again after the first one was locked, this is very basic, please do some research and try yourself before posting.

Message was edited by: Thomas Zloch

[Former Member]

n i want same for t518a which is fir employee qualification,but this table have onle mandt and ausbi so how to write it, plz help

[Former Member]

You have this information in table T518B.

Óscar

[former_member189779]

      select single * from t518a where

ausbi = t518a-ausbi.

make sure your ausbi is 8 char long. Do not miss leading zeros if its less than 8