Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP QUERY and Alias tables.

Former Member
0 Kudos

Hello all,

I am building a query that needs to read the same table with 3 different select options.

The table is SWWWIHEAD (workflow table).

SWWWIHEAD has to link to another table, so I used the JOIN option.

I added a ALIAS table for SWWWIHEAD called SWIHEAD.

I added an extra field where I am trying to make a select on SWIHEAD.

I got an error that says

"SWIHEAD" is not defined in the ABAP Dictionary as a table, projection view

or database view.

Can any body guide me in how to use the ALIAS tables properly?

1 REPLY 1

Former Member
0 Kudos

I found the way.

I had to add the alias table to the join.

M.