Skip to Content
Product Information
Author's profile photo Tammy Powlas

Recap: SAP BW/4HANA 2.0 Webcast #BW4HANA #ASUG Q&A

This was a comprehensive ASUG webcast last week given by SAP.


Source: SAP

Webcast abstract:

Delivery of new features and functionality of BW/4HANA2.0. Understand the impacts with regards to Data Tiering Optimization, the Modeling Tools, SAP Data Hub integration and new “push downs” of OLAP capabilities.


Lothar Henkes, SAP

Gordon Witzel, SAP

You can register for replay here. Don’t forget to register for these related upcoming webcasts:

February 13 BI: What’s New: Data Wrangling and Modeling in SAP Analytics Cloud

February 14 BI: Empowering Business Users with Analytics On The Go

February 19 BI: SAP Analytics Cloud for BW Customers

February 28: #askSAP Call: SAP Analytics 2019 Strategy and Roadmap

March 27 BI: Influence of Agility and Big Data Principles to BW/4HANA Architecture

March 28 BI: Overview of Latest BI Features in SAP Cloud Analytics

April 2 BI: A Beginner’s Guide to Use SAP Analytics Cloud for Business Planning

April 3 BI: Smart Predict Update

April 9 BI: Data Protection & Privacy with BW/4HANA

April 10 BI: What’s New with Application Design in SAP Analytics Cloud

April 16 BI: What’s New in Transitioning from SAP BW to SAP BW/4HANA

May 16 BI: BW/4HANA and Data Hub Integration


Source: SAP

The legal disclaimer applies that things in the future are subject to change

Expected release date of BW/4HANA 2.0 is February 25 and you need to be on HANA 2.0


Source: SAP

Why BW/4HANA? More simplification with data modeling, to be faster to new scenarios or changing existing scenarios

SP04 – first integration with data hub

2.0 – will be shipped February 25; go in GA immediately

BW/4HANA has the purpose to complete simplification – integration to cloud applications


Source: SAP

The mission statement for BW/4HANA 2.0

Integration with smart data, integration with SAP Cloud applications


Source: SAP

Simplification in 1.0 was related to data models; reduced to 4 modeling objects and leaner data flows

New concept for data tiering, and web admin cockpit is more efficient


Source: SAP

This shows the screen shot for the BW administrator’s cockpit

It is UI5 based technology; admin can access from mobile device

Tiles can be configured

BW/4HANA – cockpit is central point for administrator – maintenance, authorizations, process chains

2.0 has additional tiles mentioned on the left

More simplified search capabilities, notifications if process chain has failed, web based master data maintenance, more stats on data volume, selection

Data tiering has more information

Data protection management is managed here

HANA view maintenance, direct upload for agile test scenarios


Source: SAP

Statistics are based on ABAP CDS views; will replace the former technical content. In the past needed to activate in BW

Today it is on CDS views; when run statistics in admin cockpit they will be generated; no need to fill tables or activate content

Areas covered data volumes, data selection from queries, how often query has been executed

Obtain a comprehensive view on volumes and selection

Staging support for data

Benefits – out of box app statistics; easy to use UI, no need to activate content and filling internal tables; can monitor data to your needs


Source: SAP

See how modeling tools evolved

New data flow modeler easy to use

New modeling types for process chain integration, new maintenance for DSO, currency translation


Source: SAP

Can now copy more than one option in data flow copy

Modeling of data flow object/remodeling is easier in 2.0

Process chain integration


Source: SAP

Agile modeling capabilities, upload data fast, and not model for every field (field based modeling)

Later, you decide from field based modeling to info object (for authorizations, texts, etc.) – just replace that in DSO

Example above is product ID field, replace with Info Object 0PRODUCT – decide how values filled

In past if you did this in DSO, delete, remodel, reload – no longer required

Just do remodeling, when finished, create request, decide in cockpit when activate/execute

Benefits are higher productivity and flexibility


Source: SAP

Direct update of DSO

Many customers user Data Services and use it in context in BW/4HANA; before this release had to load to HANA then to BW

No longer this case; direct write update – Data Services can write to DSO

Same is true for SAP Cloud Platform integration; built applications and these apps write data to BW

Data Hub integration planned for H2/2019

Not open for all ETL tools; just the ones listed in slide


Source: SAP

Items in bold above are new with BW/4HANA 2.0

Combine unstructured/structured – process chain can execute Data Hub flow, flow back to process chain


Source: SAP

Integration with S/4HANA Cloud

CDS based extractors

S/4HANA Cloud has ABAP CDS views; operation delta queue – ODP/Data source and connect S/4HANA cloud to BW/4HANA

Availability of note is in slide, describes which CDS extractors are provided; can extend and build your own

Benefits include connectivity with S/4HANA Cloud to BW/4HANA


Source: SAP

Native access to BW tables; something not supported before

Now have a new SQL view for lookup – for scenarios access ADSO, mixed scenarios in HANA, this view is a controlled way for how customers can have access


Source: SAP

Conditions now executed in HANA directly

Connectivity to BRF (business rule framework)


Source: SAP

New chart types for SAP Analytics Cloud


Source: SAP

Data protection workbench, many of you have heard of GDPR

Read access logging

Source system side has ILM covering archiving and deletion; today do not have integration between BW/ILM – workbench delivered to have that


Source: SAP

Notifications are generated, and those are stored in central and there they can be replicated to BW system, part of technical content

Data Protection Workbench is based on advanced data store object


Source: SAP

Customization – identify sensitive characteristic, define ILM object, define data source to objects, replicate to BW

Integration between ILM and BW/4HANA and admin cockpit


Source: SAP


Source: SAP

Complete data flow

ODP source system, data targets, perform activities / functions on info providers, jump to more logs

Actions – more activities to be performed, let system show you all records to be deleted


Source: SAP

One code line covers on premise/private cloud

Following, Blueberry is the Cloud Data Warehouse planned for middle of this year

Integrated with Data Hub


Source: SAP

This slide was covered throughout the presentation


Source: SAP

Further enhancements for Project Blueberry

On premise BW – see additional automation for data tiering optimization

Update to cold data (cold data should not be updated)

Working on pilot projects to provide system health monitoring, evaluate how use machine learning algorithm on BW/4HANA (locks, dumps) to provide admin more information and support

Integration with the Data Hub is planned, tight integration with repository; transport complete scenarios (BW4-process chain – data hub, etc.)

HDI support

Open Hub is still there in BW/4HANA

Expect further push down with current member


Source: SAP

Where to get more information

Question & Answer

Special thanks to Lothar & team for detailed responses

Is BW/4HANA 2.0 about to release on 25th/Feb/2019?

Yes, GA is planned for 25th/Feb/2019.

Can I upgrade from BW 7.5 directly to BW/4HANA 2.0 or we have to upgrade to BW/4HANA1.0 –> BW/4HANA 2.0

Yes, you must go to SAP BW/4HANA 1.0 first and then upgrade to SAP BW/4HANA 2.0. A direct path is planned for SAP BW/4HANA 2.0 SP02.

Isn’t Eclipse with BW-MT dead? When will BW modelling be going into XSA/WebIDE? Are there any plans yet?

BW4 Modeling Tools in Eclipse will continue to be the tool for BW Developer. No plans to move to the XSA/WebIDE.

RSA1 is not needed anymore?

RSA1 is still there but has no longer a modeling and administration aspect.

Statistics: When converting from BW on HANA to BW/4HANA, are the same RSDDSTAT* statistics tables retained and used with the new CDS views? Or are new tables created that only have BW/4 statistics?

In SAP BW/4HANA we use the known statistic tables like RSDDSTAT* plus some new created ones.

Hi, Could you please tell what is the plan for planning sequence modelling integration?

SAP BW/4HANA does no longer support planning capabilities, we have planned to deliver for SAP BW/4HANA2.0 an appropriate BPC11.1 add-on. (please do not use the name BPC12.0).

Please comment on integration of HANA 2.0 new data modelling features like with containers with BW4HANA. Also, integration HDI transport architecture. Currently, transport synch for ABAP and HANA objects are manual and disjoint

HDI consumption is supported with SAP BW/4HANA 2.0 – the creation of HDI artefacts is planned for 2020. See more details here –

What is the function of “”fill with value” in the ADSO remodeling tool ? Can we essentially do data transformation there ?

With this functionality you can apply a fixed value (constant) to your new created DSO field/IO.

Does BW4HANA 2.0 has the capability to NLS into Cloudera HADOOP ?

See SAP Note 2363218 for the supported Hadoop distributions and Information, Recommendations and Limitations about Hadoop NLS.

Are the CDS based Datasources only available on S4HANA on Cloud? Or is it also available for S4HANA on Premise edition?

CDS based Datasources will be available for S4HANA on Premise as well. The new S/4 BW content based on CDS extractors is exclusively available for S/4Cloud.

is there an associated content pack that will be available for BW4 2.0 that offers additional BW4-enabled content?

Yes, there will be a new content add-on (BW4CONTB 200 and BW4CONT 200) that can be installed only in a BW/4HANA 2.0 system.

How about aDSO remdeling using ABAP and/or AMDP?

All aDSO remodeling is done via the optimized DSO maintenance in Eclipse.

Could you explain more on the difference between the new SQL view on ADSO versus the calculation view on ADSO ?

SAP Note 1682131 explains that direct access to tables storing DSO (advanced) data is not supported by SAP. The External SAP HANA SQL View provides a stable interface which allows official and authorized access to the data stored in a DSO (advanced). Additional information is provided via SAP Note 2723506.

What about the limitation of adsos when using non cumulative key figures which is (still?) about around 120 characteristics max (all chars are key flag checked)? Any change here?

No changes.

Any changes on composite provider limitations with regards to joins, nesting etc.?

No changes.

What about changing the s/4 embedded netweaver bw stack to bw/4?

Currently not planned by S/4HANA.

“BW/4HANA 1.0 end of maintenance is 12.31.2020.

SAP BW 7.5 end of maintenance is 12.31.2024.

BW/4HANA 2.0 end of maintenance is 12.31.2024.

What can we propose to our customers that are currently on BW on HANA? The end of maintenance dates suggest to wait until BW/4HANA 2.0 is GA before swtiching from BW on HANA(so do not switch to BW4 1.0). ”

The target release should be SAP BW/4HANA 2.0. Depending on the planned timelines different paths are available. For conversion projects an intermediate step to SAP BW/4HANA 1.0 might be necessary.

Will project blueberry be available for big size companies or just for small/medium size companies?

Project Blueberry will be part of SAP’S planned data warehouse as a service offering – further details are planned to communicate for H2/2019.

Hello, do you have any plan to release BPC 12 version on BW4/HANA? Based on PAM , BPC 11 is available on BW4/HANA and there is a confusion on end of main stream maintainence . If BPC 11 is supported on BW 4/HANA, is the support for BPC 11 available until BW 4/HANA 2.0 is supported?

SAP BW/4HANA does not longer support planning capabilities, we have planned to deliver for BW/4HANA2.0 an appropriate BPC11.1 add-on. (please do not use the name BPC12.0). The maintenance of BPC11.0 and BPC11.1 is strongly aligned with the underlaying BW release. With the help of the picture, you will get information about the BW/4HANA End of Mainstream Maintenance Key Date (With respect to our legal disclaimer, all forward looking statements could be subject to change).


Source: SAP

From the functional perspective, BPC 11.0 and BPC 11.1 offer the same mass of functionality.

is there any new updates on migration path from bw older versions like 7 to bw4 hana?

There are no changes on the migration paths to SAP BW/4HANA. The available paths are described here:

How BW4 HANA play key role in presence of S4 HANA Analytics .. since every company has this question of do we need BW4HANA after we implement S4HANA ?

As already mentioned several times S4HANA is not replacing data warehouse functionalities (strategic reporting, consolidation, historical data, data cleansing, etc. . . . ).

Many thanks for the update. I was wondering if you could indicate if Learning Hub Course will be updated when ? A lot of colleagues are using material for BW4HANA1 , will this become obsolete ? is still valid and available.

We will produce a SAP BW/4HANA 2.0 delta course by the end of 2019.

biggest issue for customers on bw 7 version, is long process to get to bw 4hana, it would be great if you can come up with better upgrade/transition plan.

The conversion paths are described in detail here: Furthermore the SAP Readiness Check can help to find the conversion path which fits best to the customer needs.

What customization options are available for the CDS based BW Stats (create new queries, enhance etc.)? Is the only option to create new views based on the base RSDDSTAT tables?

It is possible to create customer specific views based on the delivered content cds views.

We have a Big Data source system for BW4HANA. How would it differentiate to extract data using SAP Data Hub for Big Data?

The Big Data source system provides central and unified access to Big Data sources. Access is possible via SAP HANA Smart Data Access and the SPARK SQL (DESTINATION) adapter.

Big Data Hub is much more – it is a comprehensive toolset of ETL tools and data orchestration functionalities to integrate all kind of data.

is it necessary to do any type of conversion from 1.0 SP8 to 2.0 or is this seamless?

There will be a simple and easy upgrade path from SAPBW/4HANA 1.0 to . SAPBW/4HANA 2.0

Is there changes on BPC side?

From the functional perspective, BPC 11.0 and BPC 11.1 offer the same scope of functionality.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Frederic Cincet
      Frederic Cincet

      Liked and Shared.

      Thanks Tammy.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Thank you for taking the time to read and comment,  Frédéric Cincet

      Author's profile photo Thomas Quäbicker
      Thomas Quäbicker

      Hello Tammy,

      can you please check your information regarding SAP note 2723506. This note is not released.

      Kind regards,



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Thomas - the responses to the questions came directly from SAP.  Hopefully it will be released soon.  Thank you for reading

      Author's profile photo Gabriele Mutti
      Gabriele Mutti

      Hi Tammy

      You say:

      Yes, there will be a new content add-on (BW4CONTB 200 and BW4CONT 200) that can be installed only in a BW/4HANA 2.0 system.

      I can't find that software, I found only BW4CONTB 100 and BW4CONT 100, also oss note 2347382 at point 3. Information relevant for SAP BW/4HANA 2.0 show show BW4CONT 100 SP09  and BW4CONTB 100 SP09 for BW/4HANA 2.0 system.

      Can you clarify me what is the content I need to install for for SAP BW/4 HANA 2.0 and where I can find it ?

      Thanks and BR


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Giampaolo - I recommend asking this as a question at

      Thank you for reading and commenting

      Author's profile photo Former Member
      Former Member

      Hello Tammy,

      is there already a released guide available for upgrade from BW/4HANA 1.0 to 2.0?

      Thanks and best regards


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Markus - there's a what's new guide available on the community page here:

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      thanks for your response and the helpful link.

      Best regards


      Author's profile photo Sudhanshu Surma
      Sudhanshu Surma

      Hi Tammy, Could you please clarify what the BW/4H 2.0 Roadmap - Dec 2019 imply when it says "Planning Tools (Planning Functions)" listed under "Recent Achievements (from Feb'19 release)"? As you and many ASUG forums still maintain that BW/4H will not support BW-IP, but only BPC 11.0 addon for BW/4H, so does these Planning Tools refer to BPC and not BW-IP? Thanks for your guidance.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - thank you for reading and commenting;  I recommend asking this as a question at

      Author's profile photo Sudhanshu Surma
      Sudhanshu Surma

      Thanks Tammy, I have taken your advice. Regards

      Author's profile photo Sudhanshu Surma
      Sudhanshu Surma

      One more thing please Tammy. Would you still have a link to the recorded webcast? Why I ask is, because against this slide with the remark on planning tools you mentioned "This slide was covered throughout the presentation", so maybe I can get lucky if the presenters shared some more insights during the webcast. Thanks for your support!

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - I checked the website and I could not locate the recording; but I caution you that this webcast is over 1 year old and the content is subject to change.  So it is better (I think) that you asked the question at

      Author's profile photo Sudhanshu Surma
      Sudhanshu Surma

      Thanks for looking for me Tammy. I agree. Interestingly, the most recent BW/4H 2.0 road-map from Dec-2019 still lists that item under recent innovations, yet we don’t find a single blog on someone sharing their experience with using the “planning tools” (I assume non-BPC) available in BW/4 since Feb’19 :-p Regards.