Skip to Content

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

Improve Query related to Sales Order - Delivery

Hi,

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?

VBAP-VBELNVBAP-POSNRVBEP-ETENRVBEP-EDATULIPS-VBELNLIPS_POSNRLIKP-WADAT_IST
Key Key Key OutputOutput (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.

Antonio

Former Member replied

There is no need to create a secondary index.

Use the Sales Document Flow table (VBFA).

Rob

0 View this answer in context

Helpful Answer

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