How to find the list of SAP Notes contained in a SAP Support package.

 

 

How to find the list of SAP Notes contained in a Support package in SAP System.

We are patching the SAP system and need to know the what notes are present in a particular SAP support package.

 Follow the below steps to find the snotes in SAP Support Package. 

We can find the list of SAP Notes which are present in a particular support package using the below steps :

1. Goto the SAP Support Portal (Click Here). 

2. Search for the Support Package. Here I am checking for the SAP HR Support package      SAPKE600G8. You can use the below steps to search for the package.
              https://launchpad.support.sap.com/#/softwarecenter
                --> Search for the Software Download
                --> Now search for the technical name of the package.
                         In my case it is SAPKE600G8.

 

3. Now you should be able to see the package. Click on the Related Info of the package.

             For Eg. In my case, R/3 HR Support Package G8 for ECC 6.0 EHP6 

4. Now you should be able to see the application specific list of Notes.

 

5. Now you can see the list of all the Notes in the Support Package.You can download this list by using the option 'Download list' at the bottom of the page. 

6.Download or open the .CSV file to get list of all snote list.

Now we will get the what are all the snotes in SAP Support package.
 

 

How to get the last used time of table in SAP HANA

 

How to get the last used time of table in SAP HANA database.

This below query will work in both environment

• HANA 1.0
• HANA 2.0

 Execute the below query to get the last used time of HANA table in HANA database

• You can get the details from M_TABLE_STATISTICS and HANA_Tables_ColumnStore_Columns_LastTouchTime_*+.txt script.
• You can get the last touched time from those two columns from M_TABLE_STATISTICS.

LAST_MODIFY_TIME	TIMESTAMP	Displays the timestamp when the last INSERT, UPDATE, DELETE, or REPLACE statement was executed.
LAST_SELECT_TIME	TIMESTAMP	Displays the timestamp when the last SELECT statement was executed.

 

SAP IQ

 

SAP IQ

What is SAP IQ?

SAP IQ (Intelligent Query) is a high-performance decision-support server designed specifically for mission-critical business intelligence, analytics, and data warehousing. Component Integration Services within SAP IQ provide direct access to relational and non-relational databases on mainframe, UNIX, or Windows servers.

At the foundation of SAP IQ lies a column store technology that allows for speed compression and ad-hoc analysis. SAP IQ has an open interface approach towards its ecosystem. SAP IQ is also integrated with SAP's Business Intelligence portfolio of products to form an end-to-end business analytics software stack, and is an integral component of SAP's In-Memory Data Fabric Architecture and Data Management Platform.

SAP IQ is a fully ACID-compliant database with guaranteed data integrity regardless of whether your database (or dbspace) is created on raw devices or file system files. Multiplex implementations support GPFS and NFS; simplex implementations support any file system. Both simplex and multiplex support raw devices