AMDP Coding Guidelines
These AMDP programming guidelines are a proposal for ABAP and SAP BW projects. They were originally written for the use case of AMDP…
Mehr lesenBlog posts for category "BW/4HANA "
AMDP debugging in transformation routines
With 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 example
In 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 procedures
With 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 Framework
The AMDP framework provides an easy way to use database procedures in SQLScript, in ABAP programs and in BW transformation routines. An…
Mehr lesen
The 2nd edition of SQLScript for SAP HANA is now available.
Officially, 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 ABAPVARCHARMODE: Blanks and Empty Strings in ABAP and SQLScript
The two SAP programming languages ABAP and SQLScript (aka. HANA SQL) behave differently when it comes to processing strings with blanks…
Mehr lesen
SQL Expressions in BW/4HANA Composite Provider (HCPR)
With 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
Reusing Business Logic in AMDP Transformation Routines
Last 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 SQLScript
With SQLScript, errors can be avoided elegantly and performantly during loading due to the unallowed (i.e. invalid) characters in SAP BW…
Mehr lesen
Optimal Package Size for DTPs in BW/4HANA
With 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?
BW/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