Skip to Content

Introduction

We go for DataSource enhancement when the standard business content
DataSource doesn’t completely meet our data modeling requirements.

SAP provides enhancement RSAP0001 that you use to populate
the extract structure. This enhancement has four components that are specific
to each of the four types of R/3 DataSources:

1) Transaction data EXIT_SAPLRSAP_001

2) Master data attributes EXIT_SAPLRSAP_002

3) Master data texts EXIT_SAPLRSAP_003

4) Master data hierarchies EXIT_SAPLRSAP_004

With these four components (they’re actually four different function modules),
any R/3 DataSource can be enhanced. In this case, we are enhancing a transaction data
DataSource so we will be using the first one.

Scenario

We have a reporting requirement where the business wants to analyze based on
Industry Sector. For this we have to append 2LIS_11_VAITM with a field MBRSH
(Industry Sector) from MARA table.

1.PNG

2.PNG

Check the Communication Structure

First we have to start with checking whether the field we want to enhance is
available within the communication structure. For this Go to LBWE–>11:SDSales BW–>Extract Structures–>MC11VA0ITM–>Maintenance.

In our case, we see that the required field is not available.

Enhancing the Extract Structure

The extract structure for 2LIS_11_VAITM is MC11VA0ITM.  Alternatively you can go to DataSource Repository and check.

Go to RSA2

Untitled.png

/wp-content/uploads/2012/10/4_142986.png

Double click on MC11VA0ITM or go to SE11, give the extract structure name and display.

5.PNG

Click on Append Structure and click on Create and give an append name.

/wp-content/uploads/2012/10/6_142989.png

Here give the component and component type. 

7.PNG

Save, check, and activate.

8.PNG

Now we can see the enhanced field in the extract structure. 

After this we need to write a customer exit code for this enhanced field.

                                                                                             (continued)

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Pierrick Horpin

    Hi,

    I am unable to see screenshots 😐 too bad because it’s a good blog.

    I tried with IE and Chrome but it’s the same.

    Could you check this with webmaster ?

    Thank you in advance,

    Regards

    Pierrick

    (0) 

Leave a Reply