SAP Expert has Published 132 Articles

Joining cobk and coep table using Inner join taking too long

SAP Expert

SAP Expert

Updated on 12-Jun-2020 07:09:39

250 Views

You can make use of T-Code: SE11 to check what indexes are available for table COEPFor one COEP record that you have the (now) 5 criteria for, navigate to T-Code: SE16 pass the selections and run to check how long it takes.To improve performance, you can also create an additional ... Read More

Checking if a button is enabled or disabled in SAP Application

SAP Expert

SAP Expert

Updated on 12-Jun-2020 07:08:35

174 Views

All these methods come under Changeable Property (SapComponent). Refer this link for more details:Changeable Property

Replicating data from HANA db to other HANA system in real time

SAP Expert

SAP Expert

Updated on 12-Jun-2020 07:08:04

403 Views

You can also try using SAP Smart data access feature to transfer data in real time. In SAP HANA system, you can use Smart Data Access (SDA) option to replicate data to HANA database from other data sources where you create virtual tables, which are linked to tables in the ... Read More

Adding a BCC recipient in Infoview publication

SAP Expert

SAP Expert

Updated on 12-Jun-2020 06:11:42

84 Views

I am not sure if you are running latest BO server or running older version of BOXI service. BCC option is available in later version of Business Objects.Refer SAP Note: 1369269 - Unable to Schedule reports through BCCSymptom − 'BCC" option not available while scheduling reports to email.     Reproducing the Issue ... Read More

Replacing/Installing a license in SAP HANA

SAP Expert

SAP Expert

Updated on 12-Mar-2020 11:25:33

253 Views

You can get a permanent license key from SAP Marketplace under Keys and Requests tab. To install a new key, you have to click on Install License key option and then you need to browse the path of license key saved on your system.You can also delete an existing license ... Read More

Getting statistics details of SAP HANA system

SAP Expert

SAP Expert

Updated on 12-Mar-2020 11:07:28

616 Views

_SYS_STATISTICS- This schema stores all system configuration and parameter details of HANA system.You can find this under Catalog folder in HANA Studio once you select relevant HANA system in System pane.

Use of _SYS_BI schema in SAP HANA

SAP Expert

SAP Expert

Updated on 12-Mar-2020 11:00:10

1K+ Views

Both the schema are system defined schemas. _SYS_BI schema is used to store all the metadata of created column Views.It is different from _SYS_BIC and _SYS_REPO schema and you can understand this from below −SYS_BI − This schema stores all the metadata of created column Views._SYS_BIC − Whenever you activate ... Read More

Use of _SYS_BIC schema in SAP HANA

SAP Expert

SAP Expert

Updated on 12-Mar-2020 10:54:48

1K+ Views

When we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. _SYS_BIC schema stores all the columns views of activated objects.When the user activates the Attribute View/Analytic View/Calculation View/Analytic Privilege /Procedure, the respective run-time objects are created under ... Read More

Disk utilization and configuration details view in SAP HANA

SAP Expert

SAP Expert

Updated on 12-Mar-2020 10:29:23

146 Views

You can make use of M_DISKS System View which provides information about disk configuration and utilization of the host machine.SELECT * FROM M_DISKS;

Advertisements