SAP OSS Notes
2020286 SAP OSS Note - DB changeover to "Column Store" for SAP HANA
SAP OSS Note 2020286 version 0003 contains details of a know issue related to DB changeover to "Column Store" for SAP HANA . This includes any associated symptoms and instructions on how to fix it, see below for full details. Also check out the comments section to view/add related contributions, questions or screen shots, based on real life experience of this oss note and problem.
...For more information about the SAP support system known as OSS please check out the SAP OSS NOTES SECTION, whih includes how to download & implement them onto your SAP system using transaction code SNOTE.
Note 2020286 Details:
When does this problem occur
The memory type of the database tables TBRF134 and TBRF911 is "Row
Store". Both tables contain fields with the type "String", so the m
emory type "Column Store" has not been possible until now. This
technical restriction no longer exists. The memory type of the databas
e tables TBRF134 and TBRF911 have been changed to "Column Store". This
improves performance if you use an SAP HANA database.
Cause of the problem and Pre-requisites
Solution instructions
Import the Support Package or perform the manual steps.
Description of problem
BRF; Business Rule Framework; SAP HANA; performance
------------------------------------------------------------------------
|Manual Activity |
------------------------------------------------------------------------
|VALID FOR |
|Software Component SAP_BASIS SAP Basis compo...|
| Release 740 Until SAPKB74007 |
------------------------------------------------------------------------
Changeover of tables TBRF134 and TBRF911 to the memory type "Column
Store".
Call transaction SE13 and change the tables TBRF134 and TBRF911 one
after the other as follows:
- Enter the table name.
- Choose "Technical settings -> Change".
- Go to the tab for the DB-specific properties.
- Select the memory type "Column Store".
- Save and activate the technical settings.
Solution instructions
Please import the corrections attached to this OSS note into your SAP system using SNOTE.
You can also view the full details of this OSS note and download it to your SAP system ready for implementation using transaction code SNOTE. Once it has been downloaded you can read the full details, check out any installation instructions including manual changes and see if there are any pre-requisites.
You can also check if a new version of note 2020286 has been released as well as see if the note is valid for your current SAP system landscape.
Check if SAP OSS note 2020286 has already been downloaded and is valid
To check if this note has already been download, what status it has and if it is valid for your system first execute t-code SNOTE and click on the SAP Note Browser icon
From here you can just enter the note number 2020286 and press execute. If the note already exists it's details will be displayed. See here for full step by step instructions on how to check if an SAP note has been downloaded and is valid for your system.
If note 2020286 does not exist on your system you will receive the message "Unable to find SAP Note that meets specified criteria"
If this is the case you will need to download the note to you SAP system also using transaction SNOTE. For further details see Download note using SNOTE. Even if it does exist you may still want to check if you have downloaded the latest version of the note.
Alternatively you can find full details of this note on the SAP service market place(SNumber / Service market place login will be required)