on 2018 Feb 28 6:47 PM
Hello gurus,
I have a requirement to do join in CDS view and I need only first found row from the right table for every record from the left table. As I searched through forum here, I had found I need to use CDS table function and implement SQL script in my method. However, it does not work as planned.
Here is simple example:
Imagine I have EKKO (purchase order header) table. For each purchasing document (EKKO-EBELN) I want to find first found material from EKPO (purchasing document items - EKPO-MATNR).
1) I have created table function:
2) I have created AMDP class implementation:
3) I use my table function in CDS view:
4) The result looks like this:
The result I want is first matnr for each document.
Any help would be highly appreciated.
Thank you.
Lukas
Request clarification before answering.
You could try it with simple select in your ABAP (so no CDS)
SELECT ... UP TO 1 ROWS
and don't forget ORDER BY PRIMARY KEY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
12 | |
9 | |
8 | |
7 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.