I need your help.
I have to calculate the throughput time of my requisition.
In Table 1 (EBAN) I find the start date (“Lieferdatum”).
Since a requisition can have multiple positions, I need the earliest date (PU_FIRST?).
In Table 2 (Actiontable) I find the end date.
Here I need the “Bestellnummer” activity for the purchase requisition and the last date of each Bestellnummer (PU_LAST?).
I hope someone can help.
The photo serves as an example.