Report to show Invoices without Outputs?

[Former Member]

Creating an ABAP query but cannot ABAP to save my life.

I want to create a query that will show Invoices without an output generated. So obviously I want to compare if VBRK-VBELN exists in NAST-OBJKY at the simplest. if it doesn't exist, I want the report to list the VBRK-VBELN.

In SQL speak I would write something like:

Select VBELN 
from VBRK 
Where VBELN not in 
  (Select OBJKY 
    from NAST 
    where KAPPL = 'V3' and ERDAT >= 'Yesterday')
and FKDAT  >= 'Yesterday'

I followed this advice but I have been getting "TSV_TNEW_PAGE_ALLOC_FAILED" understandably.

https://archive.sap.com/discussions/thread/3450263

Can someone help me to figure this one out? Thanks in advance.

[former_member241258]

hi

use 'for all entries' may be it will help u

[satyabrata_sahoo3]

"TSV_TNEW_PAGE_ALLOC_FAILED" Error is because of high memory consumption..

[raymond_giuseppi]

Did you try a subquery like

SELECT vbeln INTO TABLE itab
  FROM vbrk
  WHERE fkdat GE yesterday
    AND NOT EXISTS ( select * from nast where kappl = 'V3' and objky eq vbrk~vbeln ).