{"id":7348,"date":"2025-08-03T14:25:23","date_gmt":"2025-08-03T08:55:23","guid":{"rendered":"https:\/\/www.sapewmhelp.com\/?question=what-is-amdp"},"modified":"2025-08-03T14:27:57","modified_gmt":"2025-08-03T08:57:57","slug":"what-is-amdp","status":"publish","type":"question","link":"https:\/\/www.sapewmhelp.com\/?question=what-is-amdp","title":{"rendered":"What is AMDP?"},"content":{"rendered":"<p>AMDP (ABAP Managed Database Procedures) in CDS (Core Data Services) in SAP refers to a way to integrate native SQLScript (e.g., HANA procedures) directly within ABAP classes. It&#8217;s not a part of CDS views themselves, but is often used <em>alongside<\/em> CDS views when you need more complex or performance-critical data processing that cannot be handled by CDS alone.<\/p>\n<table>\n<thead>\n<tr>\n<th>Feature<\/th>\n<th>CDS View<\/th>\n<th>AMDP<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Type<\/td>\n<td>Declarative<\/td>\n<td>Procedural<\/td>\n<\/tr>\n<tr>\n<td>Language<\/td>\n<td>DDL (SQL-like)<\/td>\n<td>SQLScript (HANA-specific)<\/td>\n<\/tr>\n<tr>\n<td>Use Case<\/td>\n<td>Data modeling, filtering, joins<\/td>\n<td>Complex calculations, loops, conditional logic<\/td>\n<\/tr>\n<tr>\n<td>Database Execution<\/td>\n<td>Yes<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td>Integration with ABAP<\/td>\n<td>Yes (via Open SQL)<\/td>\n<td>Yes (via ABAP classes\/methods)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img decoding=\"async\" class=\"content-img\" src=\"https:\/\/www.sapewmhelp.com\/wp-content\/uploads\/2025\/08\/AMDP-procedure-implementation.png\" \/><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","question-category":[173],"question_tags":[178,273,199,208,177],"class_list":["post-7348","question","type-question","status-publish","hentry","question-category-cdsviews","question_tags-abap","question_tags-amdp","question_tags-cds","question_tags-hana","question_tags-sap"],"_links":{"self":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question\/7348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question"}],"about":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7348"}],"wp:attachment":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7348"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion-category&post=7348"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion_tags&post=7348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}