Skip to Content
-1
Former Member
Sep 16, 2017 at 02:18 AM

Report to show Invoices without Outputs?

165 Views

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.