Use of EXCEPT in HANA SQL Script with Internal Table
EXCEPT use is quite simple. Its like a minus operation. The result of EXCEPT operation is the record set that present in first and not present in the second.
Below one internal table contains all the records of a client present in DB and another internal table contains few records.
The AMDP method with EXCEPT operation between two internal tables.
Program/Report to test the AMDP method.
Result table of the EXCEPT operation-
First Table record details-