select distinct
      dd02l~tabname,
      t002~spras,
      case
         when dd02t~tabname is not null
         then 'X'
      end as translation_exists
  from dd02l
  join t002
    on 1 = 1
  left join dd02t
    on dd02t~tabname = dd02l~tabname
         and dd02t~ddlanguage = t002~spras
   where dd02l~as4local = 'A'
     and dd02l~tabname in @s_table
   into table @data(translation_info).
  ct_data  = translation_info.