cancel
Showing results for 
Search instead for 
Did you mean: 

AMDP Select Statement

Former Member
0 Kudos

Hi,

I am in the progress of learning AMDP. I have created a class and methods to fetch data from a database table.

In ABAP, we had the flexibility to fetch a single record from database using SELECT SINGLE or SELECT... UP TO N ROWS.

How can we leverage this in AMDP SQL Script.

-- Selva.

Accepted Solutions (0)

Answers (1)

Answers (1)

lucas_oliveira
Advisor
Advisor

Hi Selva,

This is already discussed here in SCN -

So please search before posting

Anyway, you can use SQL on AMPD methods so 'SELECT TOP <N>...' covers that for you. Official doc:

SELECT - SAP HANA SQL and System Views Reference - SAP Library

BRs,

Lucas de Oliveira

PatrickDean
Participant
0 Kudos

Strangely, when searching, this is the top hit.... 😄