ztoad icon indicating copy to clipboard operation
ztoad copied to clipboard

Error: "The INTO/APPENDING clause must be at the end of the SELECT..."

Open Tino-s opened this issue 2 years ago • 0 comments

The error message: The INTO/APPENDING clause must be at the end of the SELECT. See the long text." Character String as Message

appears from this statement: SELECT distinct
 VGBEL ,
 count( VBELN ) as cnt_VBELN ,
 max( NETWR ) as sum1
 FROM 
 vbak
where 
VGBEL is not null and VGBEL <> '' and 
VGBEL like '002%' and
AUDAT >= '20221201' and 
VBELN like '001%'
group by VGBEL
having count( VBELN ) > 1
 .

BR Tino

Tino-s avatar Jan 19 '24 18:01 Tino-s