본문 바로가기

IT/SAP

(56)
Delete RSECADMIN REPORT ZRSEC_PROT_DEL. TABLES: rseclog_cl. DATA: l_rt_timestamp TYPE RANGE OF rsddtimestmp, l_t_rseclog_cl TYPE TABLE OF rseclog_cl, l_s_rseclog_cl TYPE rseclog_cl, l_pid TYPE sysuuid_c, l_t_pid TYPE rsec_t_pid. "SELECTION-SCREEN BEGIN. SELECT-OPTIONS s_tmstmp FOR rseclog_cl-timestmp. INSERT LINES OF s_tmstmp INTO TABLE l_rt_timestamp. SELECT * FROM rseclog_cl INTO CORRESPONDING FIELDS OF TABLE ..
ZBW_HANA_MIGRATION_COCKPIT (SAP Note 1909597) ************************************************************************ * ZBW_HANA_MIGRATION_COCKPIT (SAP Note 1909597) * Provided by Product Management SAP EDW (BW/HANA) * * This cockpit combines several tools to make the migration of an * existing SAP BW deployment to the SAP HANA platform a more * beautiful experience. * * (c) SAP AG 2011-16 MFB, SAP Canada Inc. * Last update: 2016-03-22 ***..
SAP Solution Manager SSO Use In this automatic activity, you configure Single Sign-On (SSO) between the ABAP and Java stacks of the SAP Solution Manager system. Requirements The following instance parameters are set: login/create_sso2_ticket : 2 login/accept_sso2_ticket : 1 Activities To perform this activity manually, you need to export the SSO certificate from ABAP in order to import in Java and vice versa. Steps to e..
1911102 - Solution Manager application logs reorganization Login on Solution Manager Productive client Start transaction slg2 Select: "and logs which can be deleted before the expire date" (under Expiry date) Specify as value for the "Object" field (under Selection conditions): * N.B.: Do remind to use value exclusions in case for example CDMC is in place (See end of SAP note 1316694) Select: "Delete immediately" (under Options) Create a variant to dele..
[SAP HANA] Row Store Table Ratio SELECT HOST, PORT, CASE WHEN (((SUM(FREE_SIZE) / SUM(ALLOCATED_SIZE)) > 0.30) AND SUM(ALLOCATED_SIZE) > TO_DECIMAL(10)*1024*1024*1024) THEN 'TRUE' ELSE 'FALSE' END "Row store Reorganization Recommended", TO_DECIMAL( SUM(FREE_SIZE)*100 / SUM(ALLOCATED_SIZE), 10, 2) "Free Space Ratio in %", TO_DECIMAL( SUM(ALLOCATED_SIZE)/1048576, 10, 2) "Allocated Size in MB", TO_DECIMAL( SUM(FREE_SIZE)/1048576, ..