Found 6705 Articles for Database

Changing Data Element of a column and showing description in Transaction SE16N

Anjana
Updated on 30-Jul-2019 22:30:20

435 Views

You probably need to activate the change. Other option is by deleting the description and enter the wrong character in data element name.This will make the system show an error message since that element does not exist.Correct the DDIC element spelling. The system now considers this a big enough change to the pull in an correct description of the element.

Concatenate 2 strings in ABAP without using CONCATENATE function

Moumita
Updated on 14-Feb-2020 05:32:25

3K+ Views

In ABAP you can use && sign to concatenate variables as belowDatahello TYPE string, world TYPE string, helloworld TYPE string. hello = 'hello'. world = 'world'. helloworld = hello && world.If you want to concatenate strings directly, you can usehelloworld = 'hello' && 'world'.If you want to keep space in between, you would require ` symbol as belowhelloworld = hello && ` and ` && world

Using ABAP Function module RSAQ_REMOTE_QUERY_CALL, NO_DATA_SELECTED exception using selection parameters

Manikanth Mani
Updated on 14-Feb-2020 05:44:59

493 Views

As SAP provides flexible options that allow selection parameters easy to use. As you are using multiple parameters please note the following:Set KIND to “s” only for using select option. If you are using parameters, it should be “P”Instead of using EN, try using internal language “E”RSAQ_REMOTE_QUERY_FIELDLIST- this function module can be used to find the types as below −Use T-code SE37 and enter the FM name → Display

Fetching list of products from SAP: connecting SAP database from .net application

Monica Mona
Updated on 12-Dec-2019 06:53:34

220 Views

You can troubleshoot by trying a telnet to SAP system.Open a command prompt on the system you are running your .net application and try to telnet server having SAP system installed.Telnet 127.0.0.1 3300If you using a local system, try using a hostname instead of loopback IP address and make an entry in host file of the system.How to find host file in the system?Press the Windows key.Type Notepad in the search field.In the search results, right-click Notepad and select Run as administrator.From Notepad, open the following file: c:\Windows\System32\Drivers\etc\hosts.Make the necessary changes to the file. Click File -> Save to save your ... Read More

Delete duplicate alphanumeric entries from column data in SQL

Nitya Raut
Updated on 18-Dec-2019 10:05:14

182 Views

You can opt for using regular expressions to remove the duplicate numbers from column c or any other intended column.ExampleSELECT REPLACE_REGEXPR ('([A-Za-z0-9])\1+' in 'BB11222343CC'    WITH '\1'    OCCURRENCE ALL) FROM OutputB12343C

Advertisements