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
-
Economics & Finance
SAP HANA Articles
Page 9 of 58
Using datatype/element for destination in SAP ABAP
You can use RFCDEST to specify the destination for Remote Function Call connections in SAP ABAP. The RFCDEST statement specifies the destination value for a Remote Function Call connection and gateway information. This statement is essential for establishing connections to remote SAP systems. Supported Job Types This statement is optional for the following job types − SAP Batch Input Session SAP Business Warehouse InfoPackage SAP ...
Read MoreDebugging a failed Insert statement in SAP ABAP
In SAP ABAP, debugging failed INSERT statements is crucial for maintaining data integrity. The system variable sy-subrc is your primary indicator for operation success, where sy-subrc = 0 means the INSERT statement executed successfully, while any non-zero value indicates an error. Using System Return Code (sy-subrc) After executing an INSERT statement, always check the sy-subrc value to determine if the operation was successful − INSERT INTO ztable VALUES wa_data. IF sy-subrc = 0. WRITE: 'Record inserted successfully'. ELSE. WRITE: 'Insert failed with return code:', sy-subrc. ENDIF. Debugging Techniques Setting ...
Read MoreGenerating range of numbers 1...n in SAP HANA
In SAP HANA, you can generate a range of numbers from 1 to n using different approaches. This is particularly useful when you need to populate tables with sequential data or create test datasets. Method 1: Using FOR Loop You can use a FOR loop to iterate through a range of numbers and insert them into a table − FOR START_CID IN 1..1000 DO INSERT INTO "TEST_TABLE" VALUES(START_CID, ''); END FOR; This loop will iterate from 1 to 1000 and insert each number as a CID value along with an ...
Read MoreUsing > operators in SAP HANA
When working with SAP HANA queries that contain comparison operators like > (greater than) in XML contexts, you need to use CDATA sections. The term CDATA means Character Data. CDATA is defined as blocks of text that are not parsed by the XML parser, but are otherwise recognized as markup. The predefined XML entities such as , and & require entity encoding and are generally difficult to read in the markup. Instead of writing > for the greater than operator, CDATA sections allow you to use the actual > symbol directly. CDATA Section Syntax Following is the ...
Read MoreGetting Error message "Object doesn't support property or method 'attachEvent'" in IE11 to call SAP system
Note that attachEvent is no longer supported in IE11 and you should use addEventListener that can be used to bind specific function to an event. Using attachEvent in Older IE Versions In older versions of IE (IE8 and below), you can use attachEvent like this − object.attachEvent(event, pDisp) Parameters event [in] Type: String A String that specifies any of the standard DHTML Events. ...
Read MoreLinking ABAP Dynpro screen elements to program variables
You can make the connection between ABAP Dynpro screen elements and program variables by using the name of Global variables. A Global variable can be defined by using this code − DATA matnr TYPE MATNR. This creates a global variable matnr of type MATNR. You can also define DDIC structure or table references using the TABLES statement − TABLES: MARA. Once you have declared the table or structure, you can reference the fields of table/structure ...
Read MoreInternal Table itab declaration in SAP and difference between both the declarations
When working with internal tables in SAP ABAP, there are two main declaration approaches that differ in memory allocation and performance characteristics. Declaration Methods The two common ways to declare internal tables are − Method 1: With Initial Size DATA: itab TYPE TABLE OF customer_tab INITIAL SIZE 5. Method 2: Without Initial Size DATA: itab TYPE TABLE OF customer_tab. Key Differences As per my understanding, the key difference between two statements is that in first you are reserving memory space for storing 5 lines of the customer_tab table. ...
Read MoreInserting Array list into HANA database
To insert array lists into a HANA database, you can use JDBC statements with HANA's ARRAY function. This approach allows you to store multiple values as array columns in your database table. Example The following code demonstrates how to insert array data into a HANA database table − Integer[][] myarray = { {1}, {1, 2}, {1, 2, 3, 4, 5} }; String test = "Insert Arrays"; stopWatch.start(test); myDBconn.setAutoCommit(false); Statement stmt = myDBconn.createStatement(); stmt.execute("TRUNCATE TABLE Schema.Table1"); // Running a loop over our array of arrays for (int i = 0 ; i < (myarray.length); i++) { ...
Read MoreI want to round a number to 2 decimal places in SAPUI5. Could anyone help?
The RoundingMode function is used for rounding numbers in SAPUI5 and it uses these parameters: the number to be rounded and how many decimal digits to display. This is particularly useful when working with currency values or percentages that need to be displayed with consistent decimal places. Using Float Type with Format Options You can round a number to 2 decimal places by using the sap.ui.model.type.Float type with specific format options in your data binding − Format Options Explained The format options control how the number is displayed − ...
Read MoreDenormalization of dimension tables in InfoCube in SAP BW
In Data Warehouse systems, data load operations occur less frequently compared to data read operations. When using normalized tables, the system requires more joins, which significantly affects performance when running multiple read statements on the DW system. Denormalization is the process of combining normalized tables to reduce the number of joins required during query execution. When you implement denormalized tables, the response time of queries improves significantly, however, this comes with trade-offs including increased load time and higher memory space requirements. Benefits of Denormalizing Dimension Tables in InfoCube ...
Read More