Hi Paul
Apart from the fact that a simple join between the two tables on konsumfeld
SELECT ...
FROM Tableb b
LEFT JOIN Tablea a ON a.konsumfeld = b.konsumfeld
would eliminate rows from tableb where konsumfeld = 'U', I can't see what the problem is. Why would you want to make another copy of the table in order to index konsumfeld?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden