comparing to year, comparing a select statement against 2 itabs.
I have a couple of questions for my select statement. Here it is:
1. how can I compare a certain field against the current year? for example:
where gjahr eq '2006'...
2. I have a select statement that needs to be compared to two itabs. Here it is:
select f1 f2 f3 f4 from anlc where bukrs = company code
derived from it_equz-iwerk, anln1 eq it_iloa-anlnr, gjahr = system date year, afabe = '01'.
it_equz and it_iloa are the 2 itabs.
Thanks a lot guys and have a nice day!