Skip to Content
-1

Report to show Invoices without Outputs?

Sep 16, 2017 at 02:18 AM

85

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Krishna Murthy Sep 16, 2017 at 04:01 AM
-2

hi

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

Share
10 |10000 characters needed characters left characters exceeded
Satyabrata Sahoo Sep 19, 2017 at 03:03 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Sep 20, 2017 at 12:35 PM
0

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 ).
Share
10 |10000 characters needed characters left characters exceeded