On the Road to BW/4HANA
Since BW/4HANA is available from 7th of September 2016 and we already saw how the Road the BW/4HANA can look like:
It is now time to go on the actual Road for BW/4HANA to get more details about the technical and application specific tasks to do.
This Blog is not talking at this time in detail how to convert your customer specific objects rather then to understand the e2e process of the BW/4HANA migration.
In-Place conversion of an existing SAP BW 7.50 on HANA
the following example describes the In-place conversion to BW/4HANA
Note 2285440 – Technical prerequisites in BW for “SAP BW Edition for SAP HANA” add-on
Note 2283111 – “SAP BW, edition for SAP” SAP HANA add-on – B4H mode
Note 2448571 – BW4HANA: Starter Add-on(checks) => included in BW 7.50 SP08
Note 2468484 – Dump: “TYPE_NOT_FOUND” in CL_RSPERS_TRANSFER_DSO_2_TAB
You can use the SAP Notes Analyzer Report to find all necessary Notes for the correct usage of the BW/4HANA Starter Add-On
Note 1614266 – System Copy: Post-Copy Automation (PCA) / LVM
BASIS_Content_V18.xml and Report Source Code
Note 1707321 – BW System Copy: Post Copy Automation (BW-PCA)
The Report RS_B4HANA_CONVERSION_CONTROL
The Report can run without having the SAP BW/4HANA Starter Add-On Installed.
However, it is suitable to start with SP08 or higher, e.g. SP10 for SAP BW 7.50 on HANA with the checks and the conversion or implement at least the following SAP Notes:
Note 2477795 – Corrections 1 & 2 on BW/4 Transfer Preparation Tasks
Note 2478899 – Corrections 1 & 2 on BW/4 Transfer InPlace Tasks
Note 2457478 – BW4HANA: Starter Add-On – corrections correlated to transfer toolbox
Note 2503455 – BW4HANA: Starter Add-On – Changes (Transfer Toolbox Version 1)
Note 2508989 – BW4HANA: Starter Add-On – Changes (Transfer Toolbox Version 1 – INPLACE)
Note 2512548 – B4H Whitelist: tlogo RSDS added to F4 help
Note 2537300 – BW4HANA: Starter add-on changes (Transfer Toolbox Version 1, revision 4 – ADDON)
Note 2548625 – BW4HANA: Starter add-on changes – Pre-check term due to query messages (ADD-ON)
Note 2548631 – BW4HANA: Starter add-on changes – Pre-check term due to query messages (INPLACE)
Note 2549514 – BW/4HANA Conversion: Corrections for note 2539205 (ADSO: ODSO comp views)
Starting with SAP BW 7.50 SP08 the “BW mode” option is added to the Report, to switch back to the original state of the system without de-installing the Starter Add-On.
In advance maintain the “Whitelist” prior to the further tasks for the Implementation of the BW/4HANA Starter Add-On
The Report RS_B4HANA_WHITELIST_MAINTAIN
In the Whitelist you can specify Objects which must be able to edit during the checks and conversion phase.
Virtual InfoProviders are not available in BW/4HANA.
The following alternative options can be used to replace them.
1. Open ODS Views (e.g. replacing Virtual InfoProviders based on DataSources)
2. HANA CalculationsViews (for complex modeling requirements including scripting of business logic)
3. new: BADI Provider (use only in exceptional cases where the business logic must be implemented in ABAP – by nature of this InfoProvider the calculations are executed in ABAP, which may have massive performance drawbacks, this option should therefore only be used in very rare cases). Not available in 7.50 but BW/4HANA only.
When installing the “SAP BW/4HANA Starter” Add-on, the system is in compatibility mode where existing scenarios can continue running but changes of legacy objects (like Virtual InfoProvider) are forbidden. To modify a legacy object, you should add it’s technical name to the whitelist (Report RS_B4HANA_WHITELIST_MAINTAIN). Please note that the whitelist will be ignored in B4H mode. Before switching to B4H mode, you need to remodel your scenarios manually according to the suggestions above.
Objects like MPRO, CUBE or IOBC which are not supported in the BW/4HANA mode anymore.
Tasks in the Maintenance Planer
The First Stop for the BW/4HANA Starter Add-On is the creation of the stack.xml in Maintenance Planer Application in the Cloud.
(!) Make sure, you removed all non supported SAP BW Add-On beforehand. e.g. the following Example will not work and will lead in the Maintenance Planer in the error:
Note 2011192 – Uninstalling ABAP add-ons
Note 2378346 – Errors when preparing Add-On Installations / Upgrades in Add-On Installation Tool (SAINT) Version 0063
Note 1231203 – Release strategy for SAP TDMS (add-on: DMIS, DMIS_CNT and so on)
"OCS package SAPK-100AHINBW4HANA does not match the current software component vector"
Despite the Fact that you can download the Starter Add-On manually and upload the sources to your BW 7.50 on HANA system, the current SPAM/SAINT Version (750/0065) won’t allow the import without a valid stack.xml file.
Once you uploaded your configuration, you can now search for your System, e.g. B75/HBD and choose the option “Update SAP NetWeaver” to select the SAP BW/4HANA STARTER Add-On.
By this time all existing Add-On’s must be removed from the Source System. The current ST-A/PI 01S_731 Add-on is not compatible with BW/4 HANA at this time.
These are the step by step screens in the Maintenance Planer (selected important steps only):
(!) Tip: Select only the BW/4HANA Starter Add-On including SP01 to avoid re-implementation of other Support Packages.
After you downloaded the Stack XML and pushed the necessary files to the Download Basket, you can upload the files to your SAP BW on HANA 7.50 System.
Tasks in the SAP BW system
After the BW/4HANA Starter Add-On is installed in the system, we can continue preparing the SAP BW system to activate the “Compability mode“.
Enabling the BW4/HANA mode
The transaction RSMIGRATE
You must use the transaction RSMIGRATE to migrate 3.x DataFlows to 7.x DataFlows, as this is a pre-requisite for the existing 3.x DataFlows. This migration is not part of the conversion toolbox.
Check for the latest corrections in the component BW-WHM-DST-DFG
Please note that the transfer tool is allowed to be called only in BW4HANA mode.
Furthermore the Program can only transfer empty objects. To transfer loaded objects you have to wait for the BW/4HANA conversion toolbox which is planned for Q2/2017
The Report RS_B4HANA_CONVERSION_CONTROL
(BW/4HANA Starter Add-On)
To search for the latest corrections for the BW/4HANA Starter Add-On, use the following Entries in the SAP Note Launchpad:
|Components (Start with)||BW-BEX-OT-DBIF|
|Support Package (Greater Than)||SAPK-75006INSAPBW|
|mostly delivered with SP08 for 7.50|
(!) Please Note: when the Starter Add-on is installed, it is not possible to use the BEx Query Designer anymore as you must switch to the BW-MT at this time.
the first result in the Report RS_B4HANA_CONVERSION_CONTROL looks mostly like that:
Execution of the Conversion Steps via new created Task Lists
- BW/4HANA conversion toolbox
Task List RS_COMPATIBILITY_TO_B4H
This Task List is a collection of several cleaning and Housekeeping activities which might also be very useful to clean old Objects out of an BW 7.50 on HANA System.
No imports of unsupported object types allowed and white list is not relevant any more. Furthermore only SAP BW/4HANA compatible objects are available in the system. System is still working with the old objects, final preparation for the conversion is not done yet.
Deletion of BW technical Content (0TCT*)
Even in an empty SAP BW system the technical content is active by default. Sometimes depending on the scope of the system also the CATT objects are activated.
(!) Deleting the BW technical content can have massive impact of existing scenarios in your system, as the objects might be used in several InfoProvider without knowing it, hence no TCT InfoObject will be deleted with this Report.
The Report RS_DELETE_TECHNICAL_CONTENT
this Report was recently added to the following correction:
Note 2447513 – BW4HANA: Starter Add-On – further corrections (4)
Note 2468411 – BW4HANA: Starter Add-On – further corrections (5)
Note 2383530 – Conversion to BW/4HANA – Step by Step description
Note 2384088 – BW4HANA: Delete BW Objects in D-version Before BW4HANA Upgrade
Note 2385887 – BW4HANA: Delete BW Objects in D-Version Before BW4HANA Upgrade (customer content)
The Report RS_DELETE_TLOGO (optional)
As you can use now the Report RS_DELETE_3X_WEBTEMPLATES, you also can use the Report RS_DELETE_TLOGO to delete additional objects which are not supported in the BW/4 mode.
Be VERY careful while using the program, as you don’t want to delete objects you still need.
Object Types: ITEM, BITM, TMPL, BTMP, RSDS, ISTD, ISFS, ISCS
InfoObjects: 0TCT*, 0RSTT*
These are “typical objects” which has to be removed before you can set the BW/4HANA Add-On to active.
If under any circumstances the mentioned Report cannot delete the old Objects, you can also use the following options to remove non supported objects
- Transaction RSZDELETE to remove 3.x Queries which are only available in the M Version
- Transaction RSDCUBE to remove fractions of old Aggregates which are not in use
Please Note that there are some 0TCT* InfoObjects which cannot be deleted and needed for the for the core functions of the SAP BW system
Task List SAP_BW4_TRANSFER_READY4CONV
To enable the “Ready for Conversion Mode” this Task List must be executed first.
Task List RS_B4H_TO_READY4CONVERSION
Final preparation is done and system is ready for conversion. Some parts of the systems are not working any more (SAPI Source Systems, Virtual InfoProviders, BPC, ..). Should be planned in a way that this step is entered right before the system conversion.
The BW/4HANA conversion toolbox (delivered in Q2/2017)
at this stage you can also use the BW/4HANA conversion toolbox to convert your scenarios for Example in the In-Place Option. The “toolbox” is also delivered as a task-list.
In the In-Place Conversion you first decide, if it is a in-place or remote conversion and continue with the conversion.
The MYSELF connection (the old heard of BW)
The deletion of the MYSELF connection is now part of the RS_B4H_TO_READY4CONVERSION task list.
Once the MYSELF system is gone it is not possible anymore (referring to the old system):
- apply Support Packages
- apply Business Content Support Packages
- run SPAU
- refresh imported SAP Notes in SNOTE
Last Stop before activating the “Ready for Conversion mode” Report RS_B4HANA_CONVERSION_CONTROL
Note 1815374 – Clean up entries in tables after delete source system
Note 2069865 – ITAB_DUPLICATE_KEY dump in program SAPLRSAODS during various staging processes
Note 2214733 – SAPI: Inconsistent IDoc segments/transfer structures in source system
Note 2400086 – Myself-System not allowed in strict mode
Note 2347185 – SAPI/ODP DeltaQueue Conversion
Note 2354041 – Migrate SAPI to ODP – ODP in Source
Note 2436640 – SAPI – incorrect message: There are still no BW systems connected to DataSource &1 (RSQU010)
Once all Objects are migrated or deleted to be compatible with the BW/4HANA mode we continue with the next steps of the conversion.
Final Result in the Report RS_B4HANA_CONVERSION_CONTROL
Did I forgot to mention that the BW-MT are mandatory now?
Now we can go back to the Maintenance Planer to define the target vector for BW/4HANA.
This will be the Blog – On the Road to BW/4HANA – second stage finalized
Roland Kramer, PM EDW (BW/HANA/IQ), SAP SE