Stack Overflow
Stack Overflow

Questions tagged [amdp]

This tag is intended only for questions touching ABAP Managed Database Procedures (AMDP) technology both on ABAP and HANA stack.

AMDP (ABAP-Managed Database Procedures) (AMDP) is a new SAP data access framework based on Core Data Services (CDS) and HANA database, AMDP procedures are usually written in HANA SQLScript language. AMDP serves as a successor to previous SAP technologies for accessing DB amongst which are NativeSQL and ADBC.

SAP HANA is an in-memory column-oriented relational database management system developed and marketed by SAP SE.

19 questions
0
votes
2 answers

AMDP Select Query is fetching wrong records

I am getting wrong results when I execute the following Select Query in AMDP Procedure. The partner repeats twice with one address number which is not at all related to the value passed in the WHERE condition. SELECT score( ) AS score, …
kiran
  • 1
0
votes
1 answer

Summing up column values of rows based on consecutive date in AMDP/MYSQL

I am trying to convert one SAP ABAP code into newly introduced language SAP AMDP(ABAP Managed Database Procedures) which is based on MYSQL. I want to sum up column values of of rows if they with consecutive dates meaning if Start date of Next row is…
Nitin K
  • 13
  • 3
0
votes
2 answers

Using REPLACE_REGEXPR in BW transformation throws syntax error

I'm trying to implement a routine for replacing some invalid characters in a BW transformation. But I keep getting a syntax error. This is my current code: METHOD S0001_G01_R40 BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY. --…
Renato
  • 15
  • 1
  • 7
-1
votes
1 answer

When do we have Push down code in SAP Hana

I need an answer or better an explanation between SQL (Open/Native), CDS and AMDP. I understand that in order to follow the rules of SAP and push the code down in DB HANA we must use CDS or/and AMDP. I have thought that if we still use only SQL…
ekekakos
  • 563
  • 3
  • 20
  • 39
1
2