You have to use parameters correctly in the function. You have to import the file length to an integer value.CALL METHOD cl_gui_frontend_services=>gui_upload_file ...     IMPORTING     filelength = fleng_i ...Next is to write to a character type variable and add parameter i_attachment_size to a class of add attachment.CALL METHOD w_document->add_attachment EXPORTING     i_attachment_size = fleng  ...

To delete adjacent duplicate entries in an internal table, you can use the below command −DELETE ADJACENT DUPLICATE ENTRIES FROM                      [COMPARING ...                          |ALL FIELDS].Also, consider the below points −The system deletes all adjacent duplicate entries from the internal table . Entries are duplicate if they fulfill one of the following compare criteria:Without the COMPARING addition, the contents of the key fields of the table must be identical in both lines.If you use the addition COMPARING ... Read More

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