Up to top

Enhancing Safyr to support SAP BW Extractors and the tables they access

By Nick Porter | 06 Mar 2018

Categories: SAP, SAP BW

We have often been asked by customers who use SAP and SAP BW whether we could enhance our product Safyr® to show the SAP BW Extractors and the Tables they access. These Extractors are functions in the SAP system that extract data from SAP and pass it across to BW for Business Intelligence purposes. Being able to understand which tables are accessed by these functions is a vital part of tracking how data moves through the SAP landscape.

To support this requirement, we have been working on a new version of Safyr that does just that and have released that functionality in our latest version of our software.

We have been able to identify the Extraction functions and the SAP tables they access. In order to make it easy and straightforward for you to search and find this information we added a new ‘tree’ to our ERP Hierarchy capability for SAP. We call this one the OLTP Source tree.

It’s similar to the SAP Program Tree that we have had in the product for some time, however it focuses on those nodes that identify these OLTP Sources.

The screenshot below gives an example of how this looks:

SAFYR ERP Hierarchy for BW Extractors

SAFYR ERP Hierarchy for BW Extractors

In this technical example, the SAP Business Partner component (AP-MD-BP) contains a Development Class (or Package) called ‘Extraction of SAP BW Payment Cards’.

This in turn contains a Function Group with a similar name and this contains a Function ‘Transfer of Payment Cards’. This function is associated with the OLTP Source ‘SAP BW:  BW Extraction Credit Cards’.

Finally, we can see that the Function Group selects data from the list of tables shown in the list (ADRP, BCCPS…..).

Notice that the OLTP Source has the object type shown at the end of ‘OLTP-Src(F*)’. This means it is an OLTP Source of type Function. We also show OLTP Sources that are based upon a Table or View and these will appear with a type of ‘OLTP-Src(V)’.

As with the other Hierarchies in Safyr, there is a search feature to make it easier to navigate what is a large number of nodes. Examples of the type of searches which are possible include:

Learn more about our latest version of Safyr >>

Leave a Reply

Your email address will not be published. Required fields are marked *



You must be registered to receive support
Please login or Register Here »

Forgot Password? Remember me


Note: The token is a unique string for each Safyr license and can be found on your product delivery instructions

Already registered? Login here »


Enter your username
to receive your password

Login here »

Welcome to Silwood Technology. We use cookies to enhance your browsing experience. Learn more OK