Skip to Content
Author's profile photo Anjali P

Enhancing Logistics Master Data Extractors

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. 



Assigned tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      It's a clean explanation. Keep it up...........

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author

      Thanks Suman!!! Those noble words means a lot 🙂

      Author's profile photo Former Member
      Former Member

      Yes good job!

      Author's profile photo Former Member
      Former Member

      Very Good Document

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      A very neat document that would surely be handy for anyone doing this the first time.

      Benedict

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author

      Thanks Todor, Sushant, Benedict!

      Author's profile photo CH Raman
      CH Raman

      Simple and good presentation. its easy to understand who are new to BW.

      Thanks

      Raman

      Author's profile photo Former Member
      Former Member

      Hi Anjali,

      Well document about Enhancing.

        

      Thank you.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Hi Anjali,

      You explained Very nicely and step by step which is very helpful for who are new in BI.

      Good Job.... Keep it up.

      Regards,

      SM

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author

      Thank you Sudarshan and SM !!!