Skip to Content
avatar image
-1
Former Member

Report to show Invoices without Outputs?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 16, 2017 at 04:01 AM
    -2

    hi

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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 19, 2017 at 03:03 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2017 at 12:35 PM

    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 ).
    Add comment
    10|10000 characters needed characters exceeded