Found 6722 Articles for Database

I don’t think it can be automated so that configuration is not copied to the database. Try checking SAP Transport and Change Management detail, it could be possible by making some changes in Transport configuration.

Generating the database diagram completely as generated in SQL server or other DBMS is not possible over here. But there are couples of ways that can be of small help in your case. Firstly, you can refer to Object Model guide present in the SAP market place. This guide will explain you the most common relations between the most popular and common business objects It does not cover each and every bit of the database but the most common bad highly usage one are covered. Secondly, if required you can generate diagram of a single table by displaying it in ABAP transaction ... Read More

If you want to check the relation between different tables, you need to have a minimum read-only access to SAP system.Below is the link to refer information about dictionary structure −https://help.sap.com/saphelp_46c/helpdata/en/ea/e9a3bb4c7211d189520000e829fbbd/frameset.htm

You can do this by creating your own function module that can perform selection as per the requirement.You could also use to create a database view and that can be used to call RFC_READ_TABLE. Also, check for prebuilt SAP connectors provided by companies for SQL joins:http://www.plsapconnector.com/

Note that parameter statement compiles into selection screen at compile team so it is not possible to declare dynamic parameters as proposed by you. Other approach would be that you could load dynpro and change the screen dynamically. You have to activate and then run the report that calls the changed screen. This same approach is used in T-code SE16 to generate a selection screen from a table.

There is a number of ways you can achieve this. Here are few of the methods to do the same.a) There are many standard tools in SAP by use of which you can extract the data and also automate the whole process. With the use of an ETL tool, this can be achieved like SAP Data Services, OWB, etc.b) The other option is to write a code in ABAP to fetch the data from the database and the write into a format as per your requirement.c) You can also write a RFC or remote-enable function module which can be called ... Read More

I think you need to put a colon (before variable as below:EXEC SQL.    INSERT INTO order VALUES('2', :sy-datum) ENDEXEC.I would also suggest you to use OpenSQL instead of Native SQL here. Native SQL is used when you try to use any features that are database specific.The query you have used is very generic and not exclusive for backend database.

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.

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

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