Hello Everybody
I collect some records from our SAP System and put them into an inMemoryTable (SAP_Op)
Now i want to do some overdue analysis.
The query i would fire against our SAP System would be something like this:
SELECT customerno,customername,
sum(case when overduedays <= 0 then amount else 0 end) as no_overdue,
sum(case when overduedays > 0 then amount else 0 end) as overdue,
case when overduedays > 40 then amount else 0 end) as critical_overdue,
from bsid
group by customerno,customername
order by overduedays desc
I don't kow, how to do this with querybuilder against my inMemoryTable 'SAP_Op'
Any help welcomed. Example would be great.
Best recards
Albert