Improve Query related to Sales Order - Delivery
I've realized a query that join the VBAK, VBAP, VBEP to LIPS and LIKP. The query works, but it's too slow.
How I can create an internal table with the following fields?
|Key||Key||Key||Output||Output (sort)||Output (sort)||Output|
I need this table to extract:
- the last delivery connected to the sales order position (LIPS-VBELN).
- the goods issue date linked to the last delivery (LIKP-WADAT_IST)
- the 1st delivery date scheduled (VBEP-EDATU).
I'm open to apply other solutions.
Excuse me, but i'm not skilled as abaper.
Thanks and best regards.
There is no need to create a secondary index.
Use the Sales Document Flow table (VBFA).