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.
Can someone help me to figure this one out? Thanks in advance.