Show TOC

 Extracting Business Object Data Using Generated Data Sources

 

To enable external analysis of master data, you can generate datasources for entity types that have corresponding business object types.

Procedure

Define Prefix / Namespace and Package for the Data

Before you activate a data model, assign appropriate Prefix / Namespace values to the data model, and optionally to specific uses of business object types.

  1. Define a Prefix / Namespace and a package at data model level in Customizing for Master Data Governance, Central Governance under Start of the navigation path General Settings Next navigation step Data Modeling Next navigation step Edit Data Model End of the navigation path

    The relevant subdialog is Inactive Data ModelsPrefix and Packages

  2. (Optional) If required, refine the definition for specific uses of a business object type in Customizing for Master Data Governance, Central Governance under Start of the navigation path General Settings Next navigation step Data Modeling Next navigation step Define Data Model-Specific Structures End of the navigation path.

Activate the Data Model

In Customizing for Master Data Governance, Central Governance under Start of the navigation path General Settings Next navigation step Data Modeling Next navigation step Edit Data Model End of the navigation path, choose the Activate (Activate) icon.

Activation of the data model generates the datasources with the assigned Prefix / Namespace values.

Activate the Datasources

After the datasources are generated, you must activate them so they become available for analysis in external tools.

  1. Run transaction RSA5. The Installation of Datasource from Business Content program opens.

  2. Navigate to the application component for SAP Master Data Governance, which is APCO-OLTP_MDG.

  3. Choose the Select Sub-tree icon and activate the data sources for this component.

(Conditional) For Hierarchies, Implement BAdI: Extend Datasources for BW Extraction

If you want hierarchies to be available for analysis, you must implement a BAdI.

  1. Create an implementation of BAdI: Extend Datasources for BW Extraction (RSU5_SAPI_BADI).

  2. Write code for method HIER_TRANSFORM that accomplishes the following:

    • Fills the I_DATASOURCE attribute with the technical name of the data source

    • Fills the IOBJNM attribute of the C_T_HIENODE table with the name of each information object representing the hierarchy node.

      Example Example

      Here is an example of the code to fill the IOBJNM attribute of the C_T_HIENODE table with the name of each information object representing the hierarchy node.

      IF i_datasource = '0MDG_T1_BP_HEADER_HIER'.

      LOOP AT c_t_hienode ASSIGNING ls_hienode.

      <ls_hienode>-iobjnm = 'ZMDGBPHRY'.

      ENDLOOP. 

      End of the example.
Maintain Datasources

After creating datasources, you can choose to maintain them as you see fit.

  1. Run transaction SM30. The Maintain Table Views program opens.

  2. Open table view MDGV_ANLY_DSOURC and maintain the data sources.

    The names of generated structures use the following syntax:<Prefix / Namespace>_S_<Data Model>_EX_<Name of Entity Type>

    The letter S represents structure and the letters EX represent extraction.

    Example Example

    ZMY_S_ZG_EX_ALLIANCE.

    End of the example.
Transaction RSA1: SAP NetWeaver Business Intelligence System: Replicate the DataSources of the Source System and Their Metadata

Replicate all SAP Master Data Governance datasources from the source system to the target system.

  1. In the BI system, run transaction RSA1.

    In the Modeling column, Source Systems is selected.

  2. Navigate to the source system. Right-click the source system and choose Replicate Datasources and then choose Replicate Metadata.