Monday, December 3, 2018
BW/4HANA: Custom ABAP code in transformations
Sunday, December 2, 2018
BW/4HANA Simplifications (BW4SL)
- Last update 01Nov2023
One of strengths of BW for
HANA aka BW/4HANA
(BW/4, B4H, BW4) is simplification. This comes as something that can’t be seen
(e.g. removal of approx. more than 5 million lines of ABAP SAP BW code) and
also more visible changes that need to be adapted otherwise it will break BW
systems once moved to BW/4 e.g.:
- changes to official interfaces (RSNDI, RSDRI)
- deletion of old/obsolete customer exits (CMOD) and BAdI
methods for exit variables that are replaced by corresponding enhancement spots
- switch to new request management for all loading processes
- SAP HANA generated views are Calculation Views only (so
called OneView model)
To get an overview of all
“simplifications” that BW/4 comes with there see so called BW4SL notes available on SAP support site. At the time of writing
this blog there were 66 SAP Notes like that. Each of the Note is dealing with
particular BW functionality that was changed/simplified. Change is described
also with possibilities how to dealt with it - like how to migrate/convert/adjust
particular object. Below few examples of the Notes:
2444718 -
BW4SL - MultiProviders
2443489 -
BW4SL – InfoCubes
2479567 -
BW4SL - Transformations
Central Note has number 2421930.
All changes are also described in one central PDF document called Simplification
List for SAP BW/4HANA:
Simplification
List for SAP BW/4HANA 1.0
Simplification
List for SAP BW/4HANA 2.0
SAP offers also interactive
web page that provides a description of all changes having an impact when
converting from SAP BW to SAP BW/4HANA called Simplification Item Catalog
(SIC).
More information:
Simplification
Item Catalog (SIC) -> launchpad.support.sap.com/#/sic
2421930 -
Simplification List for SAP BW/4HANA
BW-B4H-CNV – SAP support site component
Conversion
Guide for SAP BW/4HANA1.0
Conversion
Guide for SAP BW/4HANA2.0
Thursday, November 22, 2018
SAP HANA 2.0 express edition (HXE) administration - cheat sheet
and
HDB start
or
Wednesday, October 31, 2018
SAP TechEd 2018 Las Vegas my experience
For rest of my TechEd stay I following tracks related to mostly Analytics (Next Gen Data Management (DAT), Applied Intelligence (AIN), App Landscapes and Cloud Native Architectures (CNA) and Integration Out-of-the-Box (INT) sessions. In total I attended 27 sessions. I did few exercised at google booth – part of App Space. Unfortunately had no time to do more tutorials in other vendor’s booths. Also not really had time to go through all exhibitor’s booths. I visited only few which I had an interests in their products. In next part of the blog I briefly introduce what I learned during sessions I attended.
As my TechEd package didn’t contain hands-ons I was only visiting few of them and I tried just shadow other people who were working on them. It was actually great to meet new people and engage.
AIN100 – Analytics Overview 101 – Dedicated to SAP’s analytics strategy. Got an overview on what’s are current tools within portfolio. In this session I learned about SAP Analytics Cloud (SAC) tool.
CNA222 - A Developer’s View of SAP Cloud Platform, ABAP Environment – one of sessions related to SAP CP ABAP Environment. Overview of use cases for ABAP in CP was provided. Along the others I think possibility to leverage ABAP skills in CP by SAP customers is the biggest benefit of ABAP Environment in the CP that I see. Learned things like: $TMP as development package is not present anymore in the CP; ABAP key words related to web/dynpro, OS, SAP GUI (basically everything which have no sense in cloud environment, see what is whitelisted in blog) are not supported; RESTful ABAP Programming (RAP) intro. Seen demos on: console app; abapGit usage, CDS view creation + ODATA service generation + FIORI Elements preview.
AIN200 – SAP Analytics Cloud and SAP BW/4HANA: Complementing SAP S/4HANA – Got an overview of SAP S/4HANA embedded analytics, apps (Content) available in this area; how it is integrated with SAP BW/4HANA and SAP Analytics Cloud (SAC). Speakers were nicely answering to pretty tricky questions like “do we still need BW if we have embedded analytics?” J
DAT110 – Project Blueberry – A Sneak Peek – intro to new product Packaged DWH as a Service (DWaaS). It shares same code line as SAP BW/4HANA; to be a first app to run on the SAP CP ABAP Environment; components of SAP “DWaaS”; integration with integration to SAP Data Hub and SAC were discussed.
AIN105 – Overview of SAP Cloud Analytics (SAC), All Analytics on One Platform – Dedicated to analytics as BI/Planning/Predictive/App Design on one platform; Live connections that is used to access data in SAC tool. Very basic feature of the SAC that I learned is that it doesn’t move/store/replicate any data before it is displayed to user.
DAT367 – End-to-End Modeling and Operations with SAP BW/4HANA – hands-on session. In this one we did a creation a new data flow; creation of a Process Chain in the SAP BW/4HANA Administration Cockpit and finally we tried data tiering optimization in BW/4HANA system.
DAT100 – Analytics Clients for SAP BW/4HANA – learned about analytics strategy as big picture, front end tools like SAC, SAP Lumira (mostly about designer edition as for discovery edition won’t get new major feature updates starting in 2019) and SAP Analysis for Microsoft Office were discussed. Great demos were provided. For support of BEx tools in SAP BW/4HANA see SAP Note 2496706.
AIN864 – SAP Analysis for Microsoft Office: Road Map – Learned about upcoming new features of 2.7 version introduced for the tool like: EPM and Analytics plug-ins in MS Excel are now merged into one products; left outer join feature; comments feature; history panel; integration with SAC; etc.
CNA120 – ABAP Strategy – current innovation in ABAP were discussed, in particular:
DAT204 – SAP BW/4HANA: An Agile Architecture for the Intelligent Data Warehouse – different architecture approaches discussed within BW/4HANA like: simplified EDW, flexible EDW, agile DWH and relational Data Lake architecture.
DAT366 – SAP BW/4HANA and SAP SQL Data Warehousing – hands-on session. Example of an integration of SAP and non-SAP data combined in SAP BW/4HANA and SAP SQL Data Warehousing solution. We created Flowgraph in Web IDE tool (DWH) and data flow in BW/4HANA. Data from both sources were accessible in SAP BW/4HANA.
CNA302 – Custom Code Adaptation for SAP S/4HANA – Options of checking custom code when converting to SAP S/4HANA were discussed. Different tools for that were presented like Custom Code Lifecycle Management (CCLM), ABAP Test Cockpit (ATC) etc.
CNA202 – How to Get to SAP S/4HANA Embedded Analytics – capabilities of S/4HANA’s embedded analytics were discussed. Many demos presented.
DAT370 – Experience with Using SAP Analytics Cloud for SAP BW/4HANA – hands-on session. We could practice working with SAC tool in scenarios leveraging local data and live data. It was great session as Ingo Hilgefort went beyond expectation and he provided very deep insight on topics like storytelling in analytics, gave a tips on books for BI people etc.
DAT101– What’s New in Native Development for SAP HANA – delta information between HANA 2 SPS02 and SPS03 were discussed from Client Interfaces, SQL, SQLScript, CDS, Development Tools and XSA perspectives.
INT303 – Using Hana Express with No SAP Experience – Example on how HANA Express edition can be installed and used even in productive manner.
DAT839 – SAP Data Hub: Road Map – SAP Data Hub 2.3 solution was discussed.
CNA210 – Entering the World of Git with ABAP – Great session showcasing power of ABAPGit in conjunction with Continuous Integration (CI) tool Jenkins. In spirit of “CTS goes Git” demo was presented where and ABAP change was done in development system in Eclipse. The change was pushed (exported) to git repository. CI part (pipeline): CI server observed the change in the repository. It created a new build and deployed it into test system. Afterwards the CI server tests the change in test system. In case the test is successful the change is promoted to production system.
CNA216 – A Technical Deep Dive into the ABAP RESTful Programming Model –Technical things about the RESTful ABAP Programming (RAP) model. Stared with business object (BO) and business service details. Demo on how the BO is modeled/implemented via business definition/implementation language. Followed by service definition and binding. Finally, the BO was exposed in SAP Fiori UI service with SAP Fiori Elements Preview called from Eclipse.
CNA415 – Test Driven Development with ABAP – better say it was about how to write testable ABAP code. Great session by Graham Robinson. I had a lot of fun while attending it. Graham showcased in his demo how he can rely on a fact that ABAP code was refactored correctly by leveraging ABAP Unit classes.
DAT203 – Best Practices for Modeling Mixed Scenarios – very helpful session providing an examples of possible mixed scenarios while combining modeling capabilities of BW/4HANA and HANA.
DAT108 – An Outlook on Data Integration Tools from SAP: When to Use What – different use cases of products like SAP Data Services, SAP Cloud Platform Integration for data services, SAP HANA smart data integration / SAP Cloud Platform Smart Data Integration, SAP Landscape Transformation Replication Server and SAP Data Hub were discussed.
DAT876 – SAP BW/4HANA: Road Map – features were discussed from Recent innovations -> Planned innovations (2019) -> Product direction (2020) -> Product vision (2021) point of view. See also here.
DAT815 – Machine Learning in SAP HANA – machine learning capabilities of HANA were discussed.
AIN102 – Application Design with SAP Analytics Cloud – probably best session in analytics area I had a chance to attend. David Stocker discussed a lot of detail on how SAC was designed. Also many background information on how SAP tried to integrate many of their BI front end tools. Can’t wait to try this tool out. Hope there will be trail version available soon!
Friday, October 26, 2018
SAP RFC APIs: "Classic" RFC Library and NetWeaver RFC SDK
Thursday, September 20, 2018
miniSAP - SAP NetWeaver 7.52 SPS1, installation
miniSAP - SAP NetWeaver 7.51 SPS2, installation




