Variable window for BEAS tables
Hello, I already asked my question on an older post, but I don't think anyone will see it anymore. :-)
I have the following problems ... with an SQL query with a SAP table, this variable window can be displayed with [% 0] at the start.
But now I have beas tables and I would like an input window to appear at startup, but somehow I can't do that.
Here is my query:
Select t0.pers_id as 'Pers.-Nr.', t1.displayname as Mitarbeiter, t0.aplatz_id as Ressource, t2.bez as 'Name Ressource', t0.anfzeit as Von, t0.endzeit as Bis, t0.zeit as Zeit, t0.order as Kundenauftrag
from beas_arbzeit t0
inner join beas_pers t1 on t0.pers_id = t1.pers_id
inner join beas_aplatz t2 on t0.aplatz_id = t2.aplatz_id
where t0.aplatz_id = [% 0]
order by t0.anfzeit
I also tried declare, but I got no result either.
Can someone write me how that should be right?
Many thanks
Martin O.
Please sign in to leave a comment.
Comments
0 comments