Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT dd02l~tabname, t002~spras, CASE WHEN dd02t~tabname IS NOT NULL THEN 'X' END AS translation_exists
- FROM t002 CROSS JOIN dd02l
- LEFT JOIN dd02t ON dd02t~tabname = dd02l~tabname
- AND dd02t~ddlanguage = t002~spras
- AND dd02t~as4local = 'A'
- WHERE dd02l~tabname IN @s_table
- AND dd02l~as4local = 'A'
- INTO TABLE @ct_data.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement