Mar 22, 2018

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  



Mar 19, 2018

Create header in cross tab - Webi

Create header in cross tab - WEBI


Usually for cross tabs if we put required text above the crosstab data part it would replicate (i.e. it wont merge) the same header in all columns.

So here's solution to get single header across cross tab data

1) Create a variable by right clicking on Variables in left pane and  New with required text that needs to go in the header and set its qualification to Dimension. 

2) Right-click on the headings row and choose Insert -> Insert Row above. Now drag and drop the variable to the header portion of cross tab

3) Right-click on the object in the cross table heading and choose Break -> Add Break

4) Right-click on this object again and choose Break -> Manage Breaks. Within the Manage Breaks dialog box, unselect "Break Footer" and change the Duplicate Values behavior to "Merge".