This can be done by using UNION or UNION ALL operator as followsselect id, Empl_name, DeptId from table1 union select id, Empl_name, DeptId from table2 The difference between UNION and UNION ALL is that UNION removes the duplicates while UNION ALL shows duplicates as well.

The SAPUI5 library files are a part of Eclipse SAPUI5 plug-in.If you are running the app by using the Web App preview on the startup page ( Go to Run As -> select “Web APP Preview”), then eclipse starts a local HTTP server for development which serves at “/resources” the library.Till the preview window is open, you can go ahead and use the URL in any browser of your choice to debug the application.

It is advised not to call the event function from any other function but what you can do is refactor the event function implementation in a separate function and call that from any other function as shown below:ExampleBtnPress: function(oEvent) {    // Separate the implementation in the helper function    this.btnPressHelper(); } // Define the helper btnPressHelper: function() {    //logic here } // call the helper from whichever function you want to get the desired output PerformSomething: function() {    this.btnTapHelper(); }

This way is called as a Predictive Method call. This will work if the initial value is false and false is the initial value. You can refer to below link to know about Predictive method call and also to see examples:https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenpredicative_method_calls.htm

This can be achieved by creating an Indicator as per condition you are looking for- minimum drawn date time for POST-Test and Maximum drawn date time for PRE-Test. Once you create this indicator, it will show “Y” for the rows highlighted in yellow as per condition and “N” for other rows.=If ([Drawn date] = Min([Drawn date]) In ([Patient ABO/RN])  Where ([PrePost] = "POST") )  Or ([Drawn date] = Max([Drawn date]) In ([Patient ABO/RN])  Where ([PrePost] = "PRE")  )  Then "Y" Else "N"You need to apply a filter for rows with indicator value- “Y”.Other option is you can create 3 variables as ... Read More

The problem is that you have not declared Field-symbol. Try using the below code.data:  ws_bkpf      TYPE bkpf_type. SELECT MANDT    INTO CORRESPONDING FIELDS OF ws_mandt UP TO 1 ROWS    FROM bkpf    WHERE belnr = '1700001016'. ENDSELECT.

Please follow the steps below to make it functional.First, open the screen painterNow, double click on the button you want to make functionalAbove “Context Menu Form", you will find a field to enter Functional code where you enter the functional code.This will convert your button to functional trigger theOK code which will run the dynpro “PROCESS AFTER INPUT". Now add a PAI module to this dynpro which indicates the screen you want to call when the button is clicked. Below is the examplecase sy-ucomm. " the ok code   when 'Functioncode’.       call screen screennumber.   when others. ... Read More

There would not be much of difference in both ways. The only thing is without AT_FIRST, the counter variables will be cleared in all cases while using AT_FIRST, the counter variables will be cleared only if there is at least one execution of the loop. So, the only difference would come into the picture if ls_itab is empty.

You are trying to make use of references but you should be aware that it is accessible only with the same stack and in your case, it is not. You are creating a remote function module and here references will not work. So, you should be going with parameters as ‘pass by value’ instead of ‘pass by reference’.

It is not because of a number of columns but the actual total size of the fields you are querying. It should not be more than 512 bytes.  For RFC communication, the types likes DATA or STANDARD table are not supported. So the RFC_READ_TABLE function module has to convert the data into the generic format and the data is transferred as a series of lines. It is the size of these table lines that matter. The size cannot exceed 512 characters.  If the size is greater than 512 characters, the module throws a Rfcabapexception exception with a short dump.  The ... Read More