SAP BW Tip 1 – How to identify the R/3 source for a SAP BW Extractor

March 21, 2011 by Comments are off

To resolve problems and answer queries, it is often necessary to compare R/3 data with the data reported through BW. Just identifying the datasource for an extractor can sometimes be a challenge.

SAP Extractor

Here is some help… For Master Data, Text and Hierarchies take a look at table ‘RODCHABAS‘. This table contains entries of InfoObject/Basic Characteristics together with various entries detailing the source of the object, e.g. Function Module (field ‘MSDFNAME’) and View (field ’MSDVIEWNM’ for Master Data objects based on a view). The table also contains indicators such as Object is Time Dependant and Object has Attributes.

If it is a Transaction datasource you are investigating, take a look at the ‘ROIS’ table. This table lists all the function modules used to generate the data. Select the function module you require and enter the name into transaction SE37.

Categories
Tags

About the Author:

Pete has been working with SAP technologies for over 10 years. He started out as an ABAP consultant and then moved on to BW where he has worked many different clients covering a wide variety of industries. "I love introducing SAP technology (especially BI) to new clients and showing them how they can go from zero to hero within their business in super fast time". Contact me on twitter @PeterMoxon