Enhancing the standard datasources in BI 7.0

By Venkat Suman B, IBM India

Goto Tcode CMOD  and enter the project  name

Here the project  name is ZBW02HDR

Select radio button Components with the project name..  

Here we got four customer exits..

EXIT_SAPLRSAP_001— Transactional data

EXIT_SAPLRSAP_002 --- Master data attributes

EXIT_SAPLRSAP_003 —Master data Texts

EXIT_SAPLRSAP_004 --- Master data Hierarchies

Let’s consider the first instance EXIT_SAPLRSAP_001

  

Will be writing required code as per module specific as seen above

GET-BW-MACRO is a macro to fetch data from table entry for i_datasource and lc_include. 

This macro calls the Function module ‘/DS1/C_BW_GET_INCLUDE_VALUES ‘ which contains the code as  shown below.

/ds1/bw_mt_buva is a table holding the corresponding Include & datasource for an EXIT.

 

Steps to enhance a datasource

0PM_OM_OPA_1 is a Transaction datasource which has to be enhanced..

Goto Tcode RSO2

The above datasource uses a Function Module  ‘BWSM_PM_GET_ORDCST’  

As seen above the extraction can be done by following ways but in our case a standard function module is being used..

Checking FM ’BWSM_PM_GET_ORDCST’ in SE37

ICORDCST is the structure used which has to be appended to occupy our new fields.

 

This is the code for one of the datasources used for Games (Plant Maintenance)

We create a subroutine first and assign that Include name later in our code...

The below code will be common always.

case i_datasource.
  when 'Datasource name'.
    case t_inc.
      when 'include name'.
        perform datasourcename_exit_new in program saplxrsa
        tables c_t_data if found.
   endcase. endcase.

This is the include created for a subroutine 

The appended fields are populating in this manner as shown above.

The entries need to be maintained in the table as shown below for the Datasources

Steps  to Test the Datasource

Taking  Datasource 0PM_OM_OPA_1 as an example .

Go to Tcode RSA3 to extract/test Datasource

Records are fetched in packets based on data/record calls field value above. .