SAP ABAP IMG Activity BW_BCT_SRM_AMDM (Carry out Local Master Data Matching)
Hierarchy
BI_CONT (Software Component) Business Intelligence Content
   BW-BCT-BBP (Application Component) Business-to-Business Procurement
     RS_BCT_SRM (Package) Business Content: Supplier Relationship Management
IMG Activity
ID BW_BCT_SRM_AMDM Carry out Local Master Data Matching  
Transaction Code S_B52_73000019   (empty) 
Created on 20040121    
Customizing Attributes BW_BCT_SRM_AMDM   Carry out Local Master Data Matching 
Customizing Activity BW_BCT_SRM_AMDM   Carry out Local Master Data Matching 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name BW_BCT_SRM_AMDM    

Use

In this IMG step you can combine vendors and products in groups and assign local categories to standard categories. This way it is possible in Reporting to have aggregated key figures displayed for groups/categories.

For various reasons, products can be present as master data more than once in a BW System although there is physically only one product. Reasons include: the number of systems in a landscape, typing errors during data entry, the use of abbreviations, or multiple creation in the same system. Using Advanced Master Data Maintenance, you can combine these multiple entries.

Purchasing categories can have non-matching names and/or different levels of detail in different systems. The assignment of standard categories enables standardized reporting.

Requirements

You have loaded the master data for the InfoObjects Vendor (0GN_VENDOR), Product Category (0GN_CAT_PUR) and Product (0PRODUCT) from the linked source systems into BW.

For Category grouping, you have loaded a standard schema for product categories via csv file into BW. In the Standard the use of the schemas eCl@ss and UNSPSC is offered.

The master data referred to is active.

Standard settings

Activities

There are three tabs with which you can group the following master data:

  • Vendors
  • Purchasing categories
  • Products

You can preselect this master data and thus avoid having to read all the data records at once.

The grouping of vendors and products works the same way: The vendor or product is placed in a table with the corresponding attributes. Based on this data, you can decide which vendors/products are identical and should, therefore, be grouped. In order to group vendors/products, select the relevant lines and choose New Group.

You can also remove groupings, add single vendors/products to a group, and delete single vendors/products from a group. You can define the name of new groups as you wish and change the name later. This name is displayed in reporting. In order to transfer the changes to the master data to the database, choose Save.

When you are assigning standard categories to your local purchasing categories, the local categories that you have loaded into BW appear on the left of the screen after preselection. On the right of the screen, your standard schema is represented in a tree-view. By double-clicking, select a section of the standard schema tree to which you wish to assign local categories. The section of the tree is expanded. Using Drag & Drop, you can drag purchasing categories from the left side to corresponding standard categories on the right side.

If the standard categories are classified in more detail than the local purchasing categories so that multiple standard categories are possible as a target category, choose the next highest node. You can reassign categories or drag them back to the left side.

Save your entries. The master data is now assigned to the appropriate standard categories.

Example

You wish to view all vendors that begin with the letter "H". On the Vendors tab you enter "H*" in the selection field Name. A list of all vendors beginning with "H" is displayed together with their attributes. The names and attributes of three of these vendors are very similar: "Holden LTD", "Holden Limited" and "Holden LTD", the latter has been loaded from a different source system to the first. You establish that these three vendors are in fact one and the same. Therefore, you select the three lines and choose New Group. For the name of the group, you select the proposed "Holden LTD". This name is transferred to the table field Group. You save your changes. In a report that shows the total order volume for a specific vendor, you now see not only the order volume for the three individual vendor entries but also the aggregated order volume for the entire group. This is the amount that you have actually ordered from the vendor "Holden LTD".

Business Attributes
ASAP Roadmap ID 899   not to be assigned 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG BW_BCT_SRM_AMDM 0 ARS0000023 Business Content and Extractors 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
IMGDUMMY D - Dummy object SRM_AMDM  
History
Last changed by/on SAP  20040527 
SAP Release Created in 352