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
Articles by Sai Subramanyam
Page 4 of 7
Edit report generated from SAP Crystal Reports
In SAP Crystal Reports, it is not feasible to directly edit a report once it has been generated. The generated reports are read-only by default, and you cannot add constraints or logic to make your report editable in the standard Crystal Reports viewer. Workaround Solution However, there is a practical workaround that involves exporting the report and then modifying the document properties. Here's the approach − Step-by-Step Process Step 1: First, export the generated Crystal Report to your desired format (such as ...
Read MoreUsing ABAP, changing a value in itab by getting data from database table
You should do this using a MODIFY statement as shown below − LOOP AT itab. SELECT SINGLE matnr INTO itab-matnr FROM zlldet WHERE palet = itab-palet. MODIFY itab. ENDLOOP. Also note that when you have an internal table itab with a header line, it means that you have a table itab and structure itab and usage of this depends on the situation. Few of the commands like MODIFY and LOOP AT use both at the same time. Modern Approach Without Header Line ...
Read MoreDynamically creating parameters from table entries in SAP system
Note that parameter statement compiles into selection screen at compile time, so it is not possible to declare dynamic parameters as traditionally expected. The parameter definitions must be known at design time. An alternative approach is to load the dynpro (dynamic program) and change the screen dynamically at runtime. This involves modifying the screen elements programmatically, then activating and running the report that calls the changed screen. This same approach is used in T-code SE16 to generate a selection screen dynamically from any table structure. The system reads the table's field definitions and creates corresponding input fields on ...
Read MoreReplace Tab with space in SAP ABAP
In SAP ABAP, replacing tab characters with spaces is a common requirement when processing text data. You just need to make a small change by adding an "If condition" for handling the tab character as shown below − Method To replace tab characters with spaces, you need to check if the field contains the tab character using the CO (Contains Only) operator and a hexadecimal constant − if CO gc_hex_char Complete Example Here's a more complete implementation showing how to replace tab characters with spaces − DATA: lv_text TYPE string, ...
Read MoreComparing SAP ABAP Field symbols and data reference with Pointers in C
Field symbols resemble pointers in C but there is one main difference: you can use field symbols only to access the values present in them but not the memory address. Similar to a pointer in actual implementation, a field symbol stores the memory address of the variable that was assigned to it. You can see the data held by the variable but you cannot fetch the memory address. Similar to a pointer, if you make changes to data referenced by field symbol, it changes the value at the original location too. ...
Read MoreWhat is constructor chaining in Java?
Constructors are similar to methods but, They do not have any return type. The name of the constructor is same as the name of the class. Every class has a constructor. If we do not explicitly write a constructor for a class, the Java compiler builds a default constructor for that class. Each time a new object is created, at least one constructor will be invoked. A class can have more than one constructor. this() and super() are used to call constructors explicitly. Where, using this() you can call the current class’s constructor and using super() you can ...
Read MoreHow to convert an Array to a Set in Java?
One solution to add an array to set is to use the addAll() method of the Collections class. This method accepts a collection and an element and, it adds the given element to the specified Collection. Example Live Demo import java.util.Collections; import java.util.HashSet; import java.util.Set; public class ArrayToSet { public static void main(String args[]) { Integer[] myArray = {23, 93, 56, 92, 39}; Set set = new HashSet(); Collections.addAll(set, myArray); System.out.println(set); } } Output [23, 39, 56, 92, 93]
Read MoreHow BEFORE UPDATE triggers can be used to emulate CHECK CONSTRAINTnfor updating values in the table?
As we know that MySQL supports foreign key for referential integrity but it does not support CHECK constraint. But we can emulate them by using triggers. It can be illustrated with the help of an example given below −ExampleSuppose we have a table named ‘car’ which can have the fix syntax registration number like two letters, a dash, three digits, a dash, two letters as follows −mysql> Create table car (number char(9)); Query OK, 0 rows affected (0.32 sec)Creating BEFORE UPDATE trigger to emulate CHECK CONSTRAINT for updating the values −Now, suppose if we will try to update the table ...
Read MoreSource code of ABAP reports without restriction
If you have to use RFC, you can write RFC enabled function module. You can write a new FM that allows you to retrieve program source code. To start with, you need to create a structure as shown in below and based on which you have to create a table type. This table can be passed to a RFC function.Here shows a table type that you can use in Function Module:Next step is to create a function module with RFC-enabled. You have to pass parameters while creating function module.function zsrcex_extractor . *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" VALUE(PACKAGE_SIZE) ...
Read MoreHow can we create multicolumn UNIQUE indexes?
For creating multicolumn UNIQUE indexes we need to specify an index name on more than one column. Following example will create a multicolumn index named ‘id_fname_lname’ on the columns ‘empid’, ’first_name’, ’last_name’ of ‘employee’ table −mysql> Create UNIQUE INDEX id_fname_lname on employee(empid, first_name, last_name); Query OK, 0 rows affected (0.41 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe employee; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | empid | int(11) | YES | MUL | NULL | | | first_name | varchar(20) | YES | | NULL | | | ...
Read More