Varma has Published 69 Articles

Determining values of parameters of given type on a given selection screen in SAP

varma

varma

Updated on 13-Feb-2020 12:42:12

500 Views

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 SE80You can call this FM RS_SELSCREEN_INFO as below ... Read More

Allow only a possible set of values to choose from while setting value in SAP ABAP

varma

varma

Updated on 13-Feb-2020 11:39:43

298 Views

If you need to place a restriction as you said, you can go ahead with using predefined domains on the column or text field.Select Table Field -> Data Element -> Specify DomainWhile specifying the domain you can set the permissible set of values which you want the table field to ... Read More

Understand more about roles in SAP system

varma

varma

Updated on 13-Feb-2020 11:35:12

82 Views

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.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, ... Read More

How can we find the duplicate values available in a MySQL table by using JOINS?

varma

varma

Updated on 10-Feb-2020 06:29:05

47 Views

Suppose we have the following table named ‘stock_item’ in which the column quantity is having duplicate values i.e. for item name ‘Notebooks’ and ‘Pencil’, the column ‘Quantity’ is having duplicate values ‘40’ as shown in the table.mysql> Select * from stock_item; +------------+----------+ | item_name  |quantity  | +------------+----------+ | Calculator | ... Read More

Align the text of a document with CSS

varma

varma

Updated on 31-Jan-2020 06:02:44

92 Views

The text-align property is used to align the text of a document. Possible values are left, right, center, justify.ExampleYou can try to run the following code to align text:                            Asia is a continent.                      Asia is a continent.          

Make a font italic with CSS

varma

varma

Updated on 30-Jan-2020 09:24:23

246 Views

To make a font italic, use the font-style property. You can try to run the following code to learn how to work with the font-style property:Example                            This text is in italic style          

Including an external stylesheet file in your HTML document

varma

varma

Updated on 30-Jan-2020 08:25:06

231 Views

The element can be used to include an external style sheet file in your HTML document.An external style sheet is a separate text file with .css extension. You define all the Style rules within this text file and then you can include this file in any HTML document using ... Read More

Type Selectors in CSS

varma

varma

Updated on 30-Jan-2020 07:24:30

838 Views

A selector is an HTML tag at which a style will be applied. This could be any tag like or etc.With the type selector, set for HTML tags like h1, h2, h3, p, etc:h2 {    color: #FF0000; }Set for p:p {    color: #800000; }

What is the use of NO_UNSIGNED_SUBTRACT SQL mode in handling overflow?

varma

varma

Updated on 30-Jan-2020 07:10:16

249 Views

In case of enabled SQL strict mode, subtraction between integers value in which one is of UNSIGNED type will produce an unsigned result by default. But MySQL produces an error if the result is a negative one. It can be observed with the following example −mysql> SET sql_mode = ''; ... Read More

How can MySQL interpret the number and string, having no delimiter, as a date?

varma

varma

Updated on 29-Jan-2020 06:48:06

162 Views

If a string or number, even without any delimiter, in the format of YYYYMMDDHHMMSS or YYMMDDHHMMSS is making sense as the date is provided then MySQL interpret that string as a valid date.Examples are given for valid as well as invalid dates −mysql> Select Timestamp(20171022040536); +---------------------------+ | Timestamp(20171022040536) | +---------------------------+ | ... Read More

Advertisements