Skip to Content

In this document I would like to detail about Enhancing the LO Master Data Extractors.

Scenario

We have a business requirement of adding a field Production Planning Group (ZPPGRP) to the standard extractor 0MATERIAL_ATTR which is already in use in DEV.

Steps

ECC Side

1) RSA6

1.JPG

Double click and check the extract structure.

2.JPG   

Double click on the Extract Structure.

3.JPG

2) Click on Append Structure to append the field.

4.JPG

Here if no append structure is created, create one and give Short Description.  Here I am using the append structure ZMATNR_AP.

5.JPG

Here give the Component and Component type.  If the field you are enhancing is a currency/quantity field you need

to give reference table and reference field in the Currency/quantity tab. Once the fields have been added Check, Save, and

Activate the extract structure.

3)You can check for the enhanced field in RSA6 again.

6.JPG

By default, the enhanced field will hidden, unhide it.  Field only should be checked as this indicates that the

field is an enhanced one and the customer exit should be checked to fill the values.

The SAP has an enhancement RSAP001 for filling the enhanced fields.  It has the following enhancement components:

exit_saplrsap_001 – for Transaction Data.

exit_saplrsap_002 – for Master Data Attributes/Texts

exit_saplrsap_004 – for Hierachies.

Here we will be using EXIT_SAPLRSAP_002.

Go to se37 give this exit and display/change mode.

7.JPG

Go into the Include

8.JPG

Give the code in the tab Source Code.

9.JPG

Check, Save, and Activate.

Now you can check the DataSource in RSA3.

10.JPG


BI Side

1) Go to RSA1–> DataSources and Select yours, Context Menu Replicate MetaData.


11.JPG

Once the replication is successful, create and infopackage and fetch the records to PSA.

Here I will be using the already available InfoPackage.

12.JPG

2) Once this is successful create an InfoObject for the appended field.

13.JPG

Now add this as an attribute to the InfoObject 0Material.

14.JPG

Here it is required that the attribute be a navigational attribute. For this, I have unchecked ‘Attribute Only’ flag while creating the InfoObject ZZPPGRP and have switched on the navigation attribute while adding this to the InfoObject 0Material.

Now while activating the 0Material, in my case, the following screen pops up indicating that the transformations have become inactive.

15.JPG

For making an InfoObject as a master data bearing one we need to select the InfoArea in which it has to be contained and context menu ‘Insert Characteristics as an InfoProvider’.  Give 0Material here.

16.JPG

Now create a transformation and DTP between the DataSource and the InfoObject. In my case, I have activated the inactive transformation and DTP. 


17.JPG

18.JPG

Execute the DTP and fetch the records to the InfoObject. Check the data in the enhanced field.

19.JPG

20.JPG



Hope this has been helpful. 



To report this post you need to login first.

10 Comments

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

Leave a Reply