SELECT-statement with Where function in CUSTOM CDS-VIEW APP?

Hi,

I want to see with the Custom CDS-View Fiori App which production order was used when another production order is moved. This is supposed to be part of my analysis for an embedded story dashboard.

Is it possible in the Custom CDS-View App to use WHERE functions for a custom column?

My intention is that I get back a production order ID, in which I search by the WHERE function which production order ID was used at this timestamp by the column "starttimestamp" and that the work center is the same.

In the Custom CDS-View column I created, the production order ID used should be written.

Is something like this possible in the Fiori app? perhaps in the later processing in the embedded analytic story?

I think that's about how I would write it in ABAP directly:

SELECT i~ProductionOrderID
FROM YY1_CustomTable AS c
INNER JOIN I_MFGORDERWITHSTATUS AS i
ON c~ProductionOrderID = i~ProductionOrderID
WHERE i~StartTimeStamp = c~MovedTimeStamp 
AND i~WorkcenterID = c~WorkcenterID.

In the Fiori app I only need to add the WHERE function, because I have already created the join function.

Thank you for the help!

Lukas