Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct
- dd02t~tabname,
- t002~spras,
- case when spras = ddlanguage then 'X'
- end as translation_exists
- from dd02t
- join t002
- on 1 = 1
- where dd02t~as4local = 'A'
- and dd02t~tabname in @s_table
- group by tabname, spras, ddlanguage
- into table @data(table_translations).
- delete adjacent duplicates from table_translations comparing tabname spras.
- move-corresponding table_translations to ct_data.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement