Five Ways to Enhance BI Functionality Using ABAP-- Part I--Data Extraction [Link]

 

This part I will explain the first point: Data Extraction.

For data extraction, there are three aspects that we can do the enhancement.

1. Creating generic DataSources using function modules for data extraction.

When should we use the generic data extraction tools to create a DataSource?

• Business Content does not include a DataSource for your application.
• You want to implement a delta method on your generic DataSource that cannot be implemented by using the generic delta functionality(timestamp,date...)
• The application does not allow you to create additional application-specific generic extractors(CO-PA,FI-SL,LIS)
• You use your own programs in the SAP system to populate your own tables
• You have to extract data from several DB tables when: Using a view is not possible because of insufficient JOIN; Only some fields are relevant to these tables; Data has to be enriched with information not available in the BW system.

Tools for Generic Data Extraction: TCODE---RS02.

For funtion module here I used SAP Standard: RSAX_BIW_GET_DATA_SIMPLE, you can see the detail through TCODE:SE37. OR you can write your own function module as well.

2. Enhancing DataSources for transaction data, master data attributes, and texts.

Reasons:

• You want to add extra attributes to the characteristics(master data) shipped with the system
• You want to populate additional fields that you appended to the extract structure with data at the time of extraction
• You want to change/enhance texts or hierachies.

TCODE: SBIW---> Postprocessing of DataSources ----> Edit DataSources and Application Component Hierarchy

click the red mark button: 'Enhance Extraction Structure'.

fill in the name and then you can append the fields in this structure.

3. Using the Service API function enhancement to enrich data.

TCODE: SBIW---> Postprocessing of DataSources ----> Edit DataSources and Application Component Hierarchy

click the red mark button: 'Function Enhancement'

create the project and assign the Enhancement 'RSAP0001' (this is the only enhancement for service API).

See there are four user-exits for different use.

EXIT_SAPLRSAP_001: use for transaction data

EXIT_SAPLRSAP_002: use for master data

EXIT_SAPLRSAP_003: use for text

EXIT_SAPLRSAP_004: use for hierarchy

You can write the code in each of these function modules according to your requirements.

-->