Populate Current date ABAP code through customer exit variable BW

1) Logon to SAP

2) Go to /ncmod T-code

3) Enter Project details and select "Components". Now click on Display button.

 
















4) Click on Function Exit. Click text next to include. Double click on text next to include once you are in the function exit module.

5)

 //Declaring variables..  
 DATA: l_s_range TYPE rsr_s_rangesid.  
 CASE i  
  when [your customer exit variable name].  
  if i_step = 1.  
   data : cal_day type sy-datum.  
   cal_day = sy-datum.  
   l_s_range-low = cal_day.  
     l_s_range-sign = 'I'.  
     l_s_range-opt = 'EQ'.  
     APPEND l_s_range TO e_t_range.  
 ENDIF.   
 ENDCASE  

Transport or Migrate BEx Query changes from one environment to another (Admin)

Transport or Migrate BEx Query changes from one environment to another

In order to transport/migrate BEx query from lower environments to higher environment, follow below steps:




1) Login to SAP Logon Dev system



2) Go to T-code /nse01. Below screen will appear. Click on Display button at the bottom



3) You should be able to see your latest request number in the queue which needs to be transported/migrated to next system (in my case Quality environment)


4) Expand the request to root level and then starting downwards release each of the root requests first then the main one by clicking on Truck symbol (i.e. Release Directly). You'll be able to see all your changes in another system.

Locking a BEx query in SAP BW

In order to modify any existing BEx query in lower environments first step is to lock the query for which follow below steps:


1) Login to SAP Logon Dev system



2) Go to Transport Connection on left pane



3) Expand SAP Transport -> Click on Object Types -> Expand Query Elements -> Expand Query -> Double Click Select Objects and find for the query by providing technical name and once found click on transfer.



4) New pane will open on right similar to the one shown below. Click on the Display button next to Find and select List



5) For All except Query Element, right click each of them and select Do not Transport Any Below. For Query Element select Transport All Below. Then Click on Truck symbol (i.e. Transport Objects).


6) It will ask for Request no#. If there is no request already present create a new request, save and transfer.




For transporting or migrating the changes to higher environment refer below link
Transport or Migrate BEx query changes to another environment