Step By Step Procedure to Enhance Standard BI/BW Extractor Using BADI

By N. Rajendran(Raj)

Introduction  

Generally SAP user exit RSAP0001 is used to add any additional fields to the Standard BW Extractors which includes both Master Data and Transactions Data extractors.

But as per SAP’s recommendation BADI’s are more efficient way to enhance the standard extractors than using the exit RSAP0001.

Enhancing a Standard DataSource using BADI has the following advantage over using the exit RSAP0001:

BADI can have multiple implementations so several developers can work simultaneously on different implementations and different logics.  

RSU5_SAPI_BADI is used to enhance the standard BI DataSources.

Scenario  

In this document the Standard MM Master DataSource 2LIS_06_INV is appended with the field ZZDUE_DATE – Due Date. The due date is calculated by using function module and passing the value to the due date field.

Procedure

Enhancing the Extract Structure.

First go to transaction SBIW and expand business content DataSources and click Transfer Business Content Datasources.

Next step, expand SAP-R/3 and identify the relevant datasource. In this case 2LIS_06_INV is the datasource.

Double click on the datasource 2LIS_06_INV. It will take you to the following screen.

Double click the extraction structure “MC06M_0ITM”. It will take you to the following screen

Now click on “Append Structure” and create append structure and then add the required field ZZDUE_DATE(if there is an append structure already available, you can use the same append structure or can create a new append structure.) to the append structure and activate the Extract Structure “MC06M_0ITM”.

Click here to continue...