When you create a view, it is created on top of multiple database tables using an inner join. Note that basis table of database views should be transparent tables.To create a view on 2 tables, you have to enter the primary table you want to maintain and place the cursor in that field and click on the button below the list of tables and select the other table to add the view. If you are not getting this option, it means Relationship is wrong.To know more about database Views: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenddic_database_views.htmRead More

When your T0.name is char filed, you should replace Order By as below −order by case when cast(left (T0.Name,2) as int)>=8    then cast(left (T0.Name,2) as int)-8    else cast(left (T0.Name,2) as int)+4  end

Note that it is easy to store data in form of SAP database tables as compared to files. You can also access files in SAP system but they are available on file system of SAP Application server and not easy to use with.With use of ABAP, you can easily raise queries against database tables and it is safe to run queries to get data. SAP has various tools that allow you to work with table entries and also to manage entire landscape easily.What databases are supported by SAP?PartnerVendorMicrosoft SQL Serverwww.microsoft.comMySQL MaxDBwww.mysql.comIBM DB2 (various versions)www.ibm.comOraclewww.oracle.comAlso SAP has its own in-memory computing ... Read More

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:

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.