Review 10. HANA Tech Night & SAP CodeJam17. June 2024The cover picture of the article symbolises the day: HANA Tech Night is celebrating its 10th birthday. And as with every HTN, there will be…Mehr lesen
Cheat Sheet - Modern ABAP21. April 2023Cheat Sheet Modern ABAP The ABAP language has evolved tremendously since NetWeaver ABAP 7.40. Many new language constructs have been added…Mehr lesen
AMDP Coding Guidelines12. July 2022These AMDP programming guidelines are a proposal for ABAP and SAP BW projects. They were originally written for the use case of AMDP…Mehr lesen
GUID and UUID in SAP HANA26. January 2022You will often encounter GUID and UUID in SAP HANA and in S/4HANA as key fields. As long as these do not have to be interpreted or…Mehr lesen
AMDP debugging in transformation routines25. January 2022With AMDP debugging in transformation routines on BW/4HANA, errors can be easily found. An excerpt from my book "SQLScript for SAP HANA…Mehr lesen
HANA SQLScript Transformation Routines in BW/4HANA - an example25. January 2022In this blog post, I would like to share a small example of an AMDP aka. HANA Script or AMDP Script ((Actually there is no HANA Script or…Mehr lesen
AMDP procedures24. January 2022With AMDP procedures, ABAP can easily and elegantly outsource more complex requirements in the SAP HANA database. An excerpt from the 2nd…Mehr lesen
The AMDP Framework24. January 2022The AMDP framework provides an easy way to use database procedures in SQLScript, in ABAP programs and in BW transformation routines. An…Mehr lesen
Embedded Analytics with CDS Queries - with Query Template20. January 2022What are CDS Queries? CDS queries can only read data from CDS InfoProviders Reporting directly in the transactional ERP system (e.g. S/4HANA…Mehr lesen
CDS InfoProvider - The solid basis for Embedded Analytics in S/4HANA18. January 2022The CDS InfoProvider Views form a modeling layer that serves as the starting point for Embedded Analytics in S/4HANA with CDS queries…Mehr lesen
The different CDS View types17. January 2022Unfortunately, in the official SAP documentation there is no clear definition of designations to the CDS View types concerning their…Mehr lesen
Cheat Sheet CDS ABAP14. January 2022Cheat Sheet CDS ABAP The perfect complement to Brandeis Consulting's training courses This cheat sheet contains a comprehensive overview of…Mehr lesen
The 2nd edition of SQLScript for SAP HANA is now available.17. September 2021Officially, the 2nd edition of SQLScript for SAP HANA, the English edition of my book, has been available since mid-August. Today I received…Mehr lesen
The HANA Web Console from Brandeis Consulting14. September 2021The HANA Web-Console (HWC) from Brandeis Consulting is the quick entry into SQLScript programming on the SAP HANA database . For trainings…Mehr lesen
The 2nd edition of SQLScript for SAP HANA will be published in August19. July 2021The 2nd edition of the English edition of SQLScript for SAP HANA is scheduled for release on August 26, 2021. The issue is updated and…Mehr lesen
The ABAPVARCHARMODE: Blanks and Empty Strings in ABAP and SQLScript21. April 2021The two SAP programming languages ABAP and SQLScript (aka. HANA SQL) behave differently when it comes to processing strings with blanks…Mehr lesen
HANA Express images deleted in the cloud16. January 2021SAP has unfortunately decided to stop making its VM images of the free HANA Express , which were previously available in the cloud from…Mehr lesen
SQL Expressions in BW/4HANA Composite Provider (HCPR)16. January 2021With the SPS04 for BW / 4HANA 2.0, SAP has built some useful features into the composite provider (list of new features in the SAP…Mehr lesen
Cheat Sheet - The SAP HANA SQLScript Overview29. December 2020Cheat Sheet - The SAP HANA SQLScript Overview This SQLScript Overview is the perfect complement to the training of Brandeis Consulting…Mehr lesen
AMDP (ABAP Managed Database Procedures)18. November 2020With the ABAP Managed Database Procedures, or AMDP for short, SAP succeeds in making the performance of the SAP HANA database in ABAP…Mehr lesen
Reusing Business Logic in AMDP Transformation Routines18. November 2020Last week I read Lars Breddemann's great article about separating business logic from the underlying database tables without using…Mehr lesen
Treat unallowed characters in SAP BW/4HANA with SQLScript6. November 2020With SQLScript, errors can be avoided elegantly and performantly during loading due to the unallowed (i.e. invalid) characters in SAP BW…Mehr lesen
Why are scalar UDFs so slow?29. October 2020When loading data from source systems, there are requirements in SAP BW that are often repeated at the field level. This includes, above all…Mehr lesen
Neo environment will be switched off16. August 2020The Neo environment of the SAP Cloud Platform will be switched off on November 14th! This also means that a popular opportunity to create a…Mehr lesen
SQLScript Unit Tests, the End-User Test Framework11. May 2020With version 2.0 SPS04 of the SAP HANA database, the so-called "End-User Test Framework in SQLScript" was introduced. This makes it possible…Mehr lesen
User Defined Libraries (UDL) in SQLScript19. November 2019SAP HANA 2.0 SPS03 introduced the concept of User Defined Libraries (UDL) in SQLScript . It enables us as developers to bundle several…Mehr lesen
Anonymous Functions in SQLScript8. November 2019With SAP HANA 2.0 SPS04, another feature has been added to the SQLScript language: The embedded functions . These enable the use of…Mehr lesen
Recursive procedure calls in SQLScript5. November 2019Up to SAP HANA 2.0 SPS03 recursive calls in SQLScript were not allowed. This means that a procedure may not call itself either directly or…Mehr lesen
Optimal Package Size for DTPs in BW/4HANA24. October 2019With BW/4HANA 2.0 I observed that the packet size of the DTPs is dynamically suggested by the system. Figure 1 shows, for example, a…Mehr lesen
BW/4HANA Cockpit - Where is the Administration in the SAP GUI?22. October 2019BW/4HANA 2.0 no longer supports the administration of InfoProviders and requests in the SAP GUI. Instead, a browser window with the SAP BW…Mehr lesen
Uploading Transport Requests to an SAP CAL System12. July 2019In the SAP Cloud Appliance Library (CAL) , you can use SAP's latest systems in the cloud with little effort. Some of the systems are free…Mehr lesen