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 varma
Page 4 of 6
Allow only a possible set of values to choose from while setting value in SAP ABAP
If you need to place a restriction on field values, you can use predefined domains on the column or text field to control the permissible values. Implementation Steps The process follows this hierarchy − Select Table Field -> Data Element -> Specify Domain While specifying the domain, you can set the permissible set of values which you want the table field to accept. This creates a value restriction at the domain level that applies to all fields using that domain. Domain Value Table Configuration To configure allowed values in your domain − ...
Read MoreHow to check all objects belong to list of TR's in SAP system
SAP provides standard tables that you can use to get details about transport objects in the Change and Transport System (CTS). These tables contain comprehensive information about transport requests and their associated objects. Standard SAP Transport Tables The following tables are essential for tracking transport objects − E070 − Change & Transport System: Header of Requests/Tasks E070T − Change & Transport System: Short Texts for Requests/Tasks E071 − Change & Transport System: Object Entries of Requests/Tasks (provides details of transport objects) E070A − Change ...
Read MoreDetermining values of parameters of given type on a given selection screen in SAP
The function module RS_SELSCREEN_INFO will provide you with the list of parameters and selection options once the report name is input. You can see full details about this FM by entering the name RS_SELSCREEN_INFO into the relevant SAP T-code like SE37 or SE80. Using RS_SELSCREEN_INFO Function Module You can call this FM RS_SELSCREEN_INFO as below − CALL FUNCTION 'RS_SELSCREEN_INFO' EXPORTING report = 'REPORT_NAME' ...
Read MoreUnderstand more about roles in SAP system
On a high level, both the tables are almost same as both of them deal with storing details about profiles which are generated for a role. Understanding AGR_PROF Table Let's talk about AGR_PROF first. It stores the text of the generated profile which is dependent on language. It stores profile ID as well. So, it results in having only at max one possible combination of a profile and language which is referred to a master profile. To view further details about this Table ...
Read MoreGet access or point to SAP UI5 control
You are making a small mistake over here. Method addContent is a method available for UI5 controls, not over normal DOM elements. Accessing SAP UI5 Controls If you want to gain a reference to a UI5 control and add content to it, you can use the byId method to get access to the control by its ID. This method is available in views and controllers. Example Here's how to get a reference to a toolbar control and add a button to it − this.getView().byId("").addContent(new sap.m.Button({ text: "My Button", ...
Read MoreWhat is Is-a relationship in Java?
IS-A is a way of saying: This object is a type of that object. Let us see how the extends keyword is used to achieve inheritance.Examplepublic class Animal { } public class Mammal extends Animal { } public class Reptile extends Animal { } public class Dog extends Mammal { }Now, based on the above example, in Object-Oriented terms, the following are true −Animal is the superclass of Mammal class.Animal is the superclass of Reptile class.Mammal and Reptile are subclasses of Animal class.Dog is the subclass of both Mammal and Animal classes.Exampleclass Animal { } class Mammal extends Animal { ...
Read MoreHow can MySQL produce the output in a vertical format rather than tabular format?
By using \G at the end of MySQL statement, it returns the output in a vertical format rather than a tabular format. Consider the example below −mysql> Select curdate(); +------------+ | curdate() | +------------+ | 2017-11-06 | +------------+ 1 row in set (0.00 sec) mysql> Select CURDATE()\G *************************** 1. row *************************** CURDATE(): 2017-11-06 1 row in set (0.00 sec)From the example above, the difference of using \G at the end of the MySQL statement can be understood. It returns the same output in a vertical format rather than a tabular format.
Read MoreHow MySQL IF ELSE statement can be used in a stored procedure?
MySQL IF ELSE statement implements a basic conditional construct when the expression evaluates to false. Its syntax is as follows −IF expression THEN statements; ELSE else-statements; END IF;The statements must end with a semicolon.To demonstrate the use of IF ELSE statement within MySQL stored procedure, we are creating the following stored procedure which is based on the values, as shown below, of the table named ‘student_info’ −mysql> Select * from student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | ...
Read MoreHow to check table status of the tables in a particular MySQL database?
We can check the status of tables in a database with the help of show table status statement. For example, in the database named tutorial, by executing this statement we can get the status of tables as follows −mysql> show table status \G*************************** 1. row *************************** Name: student Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 7340032 Auto_increment: NULL Create_time: 2017-10-24 09:34:29 ...
Read MoreHow can we take a backup of the single database by using mysqldump client program?
By using mysqldump client program we can take the backup of a database into a file having the extension ‘.sql’. it can be understood with the help of following example −ExampleIn this example, with the help of mysqldump client program, we are taking the backup of a database named ‘tutorials’ in a file named ‘tutorials.sql’. The following command will do this −C:\mysql\bin>mysqldump -u root tutorials > tutorials.sqlThe above command will create a file named ‘turorials.sql’ in the bin folder of MySQL. This file will contain drop table, create a table and insert command for all the tables in the tutorials ...
Read More