Recap: SQL selection patterns in SAP HANA database, presented at SAP Inside Track Wroclaw 2025

Good practices are worth following and this is why design patterns like singleton, factory, prototype and many others became popular within object-oriented programming languages. The same may partially apply to data retrieval from any relational database. I noticed that there are typical techniques of data selection, that are useful in different projects for the customers from various branches: pharma, retail, automotive, utility supply to name few of them. In this blog I will share those selection patterns using syntax from ABAP Advanced Open SQL, ABAP CDS view entities and SQL script. HANA database is compliant with standard SQL ANSI 2016, so the examples presented in this blog may be useful to retrieve the data from other relational databases, which are compliant with SQL standard. 

 

​ Good practices are worth following and this is why design patterns like singleton, factory, prototype and many others became popular within object-oriented programming languages. The same may partially apply to data retrieval from any relational database. I noticed that there are typical techniques of data selection, that are useful in different projects for the customers from various branches: pharma, retail, automotive, utility supply to name few of them. In this blog I will share those selection patterns using syntax from ABAP Advanced Open SQL, ABAP CDS view entities and SQL script. HANA database is compliant with standard SQL ANSI 2016, so the examples presented in this blog may be useful to retrieve the data from other relational databases, which are compliant with SQL standard.    Read More Technology Blog Posts by Members articles 

#SAP

#SAPTechnologyblog

You May Also Like

More From Author