SAP List Viewer is used to add an ALV component and provides a flexible environment to display lists and tabular structure. A standard output consists of header, toolbar, and an output table. The user can adjust the settings to add column display, aggregations, and sorting options using additional dialog boxes.You can use following code to display any table:DATA: go_alv TYPE REF TO cl_salv_table.    CALL METHODcl_salv_table=>factory    IMPORTING       r_salv_table = go_alv    CHANGING       t_table     = itab.  go_alv->display( ).Another Dynamic Way to Output Any Internal Table is by using field-symbol, this is a ... Read More

As you mentioned, you are moving to SAP so it means you are moving to SAP HANA Cloud platform or backend SAP system. You can continue with just HTML Angular application that can connect to the backend via an OData service. Angular JS is JavaScript library that adds lot of features to your application. One thing to note here that if you are planning to use Fiori Launchpad, it could be an issue.Following are the advantages/disadvantages of using angular framework:AdvantagesUsing Angular, you can develop complex High interactive rich internet web application.Angular application can be easily integrated with third-party library like Kendo ... Read More

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.

Please note that you can use SAP.NET connector when your API’s are available on SAP system. If this is not correct, you need to get some ABAP programming to develop RFC functions.You can download SAP.NET connector from SAP Market place. To login to market place you need SAP Partner ID also called S-Id.You can refer to below link for more details:http://weblogs.sqlteam.com/jhermiz/archive/2007/08/14/60282.aspxOther options - if you are running the latest version of SAP ECC system, you need to do some backend development to generate Web Services from these RFC’s and call these web services as SOAP service.To turn RFC into web ... Read More

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL) FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

SAP HR is an old module and there are only a few companies which are doing the implementation of old modules onSAP. Moreover, SAP HR has sub-modules like Payroll, Personal Administration, Time Management, etc.If you go for a course in SAP HR, it would only give you conceptual knowledge but it would be tough to use that in companies independently. It is recommended that to join as SAP Module functional consultant you should have some prior experience in the same field. Also being a programmer, I feel that you won’t like generating test data, testing reports, writing specification on the ... Read More

As there are just 500, there would not be much difference among both options. You can use either of them.The ABAP code is as below −LOOP AT lt_table TRANSPORTING NO FIELDS WHERE exp > 5    ADD 1 TO lt_counter ENDLOOP

You are using the correct Port number for instance number “00”. Port number 300315, here 00 represents instance number of your HANA system.Try using HANA client jar file ngdbc.jar instead of SAP Jar file.try {    Class.forName("com.sap.db.jdbc.Driver");    String url ="jdbc:sap://xx.x.x.xxx:30015/DBNAME"; //IP Address of HANAsystem followed by Port number    String user ="user";    String password = "password";    Connection cn = java.sql.DriverManager.getConnection(url, user, password);    ResultSet rs = cn.createStatement().executeQuery("CALL Test.STORED_PROC");    // ...Enter the action here } catch(Exception e) {    e.printStackTrace(); }

You can do this by going to Menu.Navigate to Goto->Text Elements->Selection Text