Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 15 of 58
Using SAP T-code SM37 to check background jobs in SAP system
In SM37 you can only see the scheduled background jobs as it is not used for foreground jobs. This transaction code is essential for monitoring and managing batch processes that run behind the scenes in your SAP system. Accessing SM37 Transaction To access the background job monitoring screen, enter SM37 in the SAP command field and press Enter. Below shows the initial screen of SM37 Transaction code − Key Features of SM37 ...
Read MoreUsing Aggregate function to fetch values from different tables in SAP
When working with SAP databases, you often need to retrieve data from multiple related tables while handling duplicate or varying descriptions for the same entity. Aggregate functions provide an effective solution for consolidating data and selecting specific values when joins result in multiple records. If your query returns different descriptions for the same fund and you want to keep any one description, you can use aggregation functions like MIN() or MAX() to select a single value from the duplicates. Using MIN() Aggregate Function The following example demonstrates how to use the MIN() aggregate function to fetch fund ...
Read MoreInserting an Array to a table in SAP HANA database
As far as I know, there is no direct way of inserting an Array using SQL query in SAP HANA. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database. Array to Table Insert Methods In SAP HANA, when you need to insert array data into a table, you have several approaches to handle this limitation − Method 1: Using UNNEST Function The UNNEST function can convert an array into individual rows, which can then be inserted into a table − ...
Read MoreEdit an ABAP Program using Transaction SE93, SE80
You need to go to SE93 and input your transaction code. It will display the program name behind your transaction code. You can edit the programs using SE80 and SE38 transaction codes. Using SE93 to Find Program Name Transaction code SE93 is used to maintain transaction codes and find the associated program names. This is the first step to identify which program you want to edit. Below shows Transaction code SE93 − Editing ABAP Programs Using SE80 − ABAP Development Workbench Transaction Code SE80 opens the ABAP ...
Read MoreViewing field names or tables names of the forms in SAP Business One
It is possible that the older version of SAP B1 may not show you all the fields of all the forms. If you have the latest version, you should be able to see the data sources that are mapped to given field. You need to open the forms in SAP Business One Studio. There are a couple of methods to view fields. Method 1: Using SAP Business One Studio Integration This method allows you to directly edit forms from within SAP Business One using the integrated Visual Studio environment ...
Read MoreCalling a JAVA method through JavaScript in SAPUI5 project
Create a REST service hosted on a server and place java method inside it. Now you can call this REST service from a SAPUI5 application using AJAX by passing required parameters. Understanding the Architecture In SAPUI5, you cannot directly call Java methods from JavaScript. Instead, you need to expose your Java functionality through a REST API that acts as a bridge between your frontend SAPUI5 application and backend Java services. SAPUI5 App REST Service Java ...
Read MoreCreating a variable with dynamic variable type in SAP ABAP
You can use RTTS (Run Time Type Services) related API to create a standard table like RANGE which has components like LOW, HIGH, SIGN, and OPTION. This technique allows you to dynamically create variables with types determined at runtime. Variable Declarations First, declare the necessary variables and references for dynamic type creation − DATA: rr_data TYPE REF TO data, rt_range_string TYPE RANGE OF string, ...
Read MorePerforming total of a column in a temporary column in SAP
In SAP, when you need to calculate the total of a column and display it alongside individual records, you can use a subquery approach with SUM function and GROUP BY clauses. This technique allows you to perform aggregation in a temporary column while maintaining the detail-level data. Using Nested SELECT with SUM Function To perform the total of a column in a temporary column, you need to perform a SELECT operation on your inner query result. The inner query groups the data, while the outer query calculates the total sum. Example Here is a sample query ...
Read MoreGetting details when a table is modified in SAP HANA DB
You can query SYS.M_TABLE_STATISTICS to get modification details by providing the table name and checking the LAST_MODIFY_TIME column. This system view contains statistical information about tables including when they were last modified. Query Syntax Here is the sample SQL query to retrieve table modification details − SELECT "TABLE_NAME", "LAST_MODIFY_TIME" FROM SYS.M_TABLE_STATISTICS WHERE "TABLE_NAME" = 'YOUR_TABLE_NAME' ORDER BY "LAST_MODIFY_TIME" DESC; In the above command, you need to replace YOUR_TABLE_NAME with your actual table name. Example To get modification details for a table named EMPLOYEES − SELECT "TABLE_NAME", "LAST_MODIFY_TIME" FROM ...
Read MoreConnecting to SAP HANA using odbc_connect() on PHP
The error you are getting is because there are no ODBC drivers installed for your PHP client. You would require downloading the appropriate drivers to establish a connection with SAP HANA database. Installing ODBC Drivers for SAP HANA Following steps can be performed to download and install the drivers − Download the drivers from https://www.easysoft.com/cgi-bin/account/login.cgi after registration or alternatively check the ODBC-ODBC Bridge Client platforms at ...
Read More