Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

comparing to year, comparing a select statement against 2 itabs.

Hello experts,

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!

Tags:
Not what you were looking for? View more on this topic or Ask a question