Author: Ankush Bhardwaj
Company: Infosys Technologies Limited
Date written: 18/07/2012
Author Bio: Ankush Bhardwaj is currently working as an MDM Consultant in Infosys Technologies Limited
Target readers: Sap MDM consultant, SAP PI Consultants, SAP ECC Consultants and Data Migration Teams
Keywords: SAP MDM, SAP, Master Data Extraction, MDM_CLNT_EXTR
Summary:
This document caters to the Business Scenario where Master Date is residing in ECC system and is required to be distributed to various target systems like SAP MDM or SAP or Non-SAP systems. It uses SAP PI system as intermediate systems that will accept the data from Sender system and convert the data in required format for destination system and then sends data to target system. This Document talks about the Landscape Description of the Master Data Extraction of Material Master Data from the SAP ERP System to Target systems. This document will provide all the minute configuration details of the SAP ECC system. This document will only deal with the Extraction procedure of Material Master Data from Backend SAP ECC System.
Table Of Contents:
Glossary
References
Glossary
ALE - The technology for setting up and operating distributed applications.
Application Link Enabling (ALE) facilitates the distributed, but integrated, installation of SAP systems. This involves business-driven message exchange using consistent data across loosely linked SAP applications. Applications are integrated using synchronous and asynchronous communication - not by using a central database.
ALE consists of the following layers:
Application services
Distribution services
Communication services
Delta Mode - The Delta Mode is a specific distribution mode for an extraction run. A delta extraction run uses the system’s change pointers to extract and distribute only those master data objects that have been changed since the last extraction run. In delta mode, the extraction framework performs some mandatory checks. As the delta modes reuses the selection and transfer criteria of an initial extraction run for a master data object, it is mandatory that this object has at least been initially extracted once. Otherwise the object will be excluded from the delta extraction run. In addition, you cannot define selection and transfer criteria in the delta mode.
Extraction Object - An Extraction Object is a valid implementation of an object specific extractor. It consists of the extraction logic how to read the master data from the system storage according to the defined selection criteria and the system/object specific implementation of the communication technology used for sending the master data to the receiver system. As a common rule, the SAP delivered object extractors for R/3 & ERP systems use ALE IDoc technology, whereas object extractors for CRM and SRM systems use the ABAP Proxy XML Message technology.
Distribution Mode - The distribution mode defines how the data is extracted from the SAP system and sent to the target receiving system. The extraction framework is able to support multiple, different distribution modes as the mode to be used is part of the extraction variant object configuration. The actual implementation of a distribution mode has to be done specifically by the extraction object – this implementation is not part of the generic extraction framework. The framework supports implementing an Initial and a Delta Mode only, including the generic handling of selection and transfer criteria for these modes.
Extraction Run - An Extraction Run is the execution of a maintained Extraction Variant. It retrieves the selected master data objects from the system and sends it to the chosen target system. An Extraction Run can either be executed in Initial or Delta Mode.
Extraction Variant - An Extraction Variant is the prerequisite to start an Extraction Run. The Extraction Variant consists of a name and description, the extraction object, the selection and transfer criteria, the extraction mode, the target receiving system and the resulting message size. It is the configuration of the master data extraction. Extraction Variants can be stored in the system.
Initial Mode - The Initial Mode is a specific distribution mode for an extraction run. Initial Mode executes the first, complete extraction and distribution of the chosen master data object. The objects are extracted from the system’s storage according to the given selection criteria, independent from change pointers. The scope of the distributed object is sized according to the given transfer criteria. An extraction run in initial mode is a prerequisite for extraction runs in delta mode.
Steps of ALE Configurations:
1. Creating a New Logical System for Receiver PI System
For the ALE Configuration the first step is the creation of a Logical System for Receiver PI system.
Configuration Steps:
Figure 1: Initial Screen for t-code “SALE”
Figure 2: Screen to create new Logical Systems
2. Creating the Logical System for Sender R3 System & Assigning the Client
Configuration Steps:
Go to Transaction SCC4: Linking Sender System to Client
3.Configuration of RFC Destination Pointing to PI System
A RFC Destination is to be created with the exact same name as the LS name for the Receiver PI System. This RFC Destination will point to the receiver PI System which would be used in the integration Landscape.
Configuration Steps:
Figure 3: Initial Screen of SM59 for RFC Configurations
Figure 4: Initial Screen to create RFC Destination
Figure 5: Technical Settings for RFC Destination
Figure 6: Logon & Security Settings for RFC Destination
4. Configuration of Communication Port (Transactional Port to be mapped with RFC Destination)
A Transactional RFC Communication Port is to be created which is used for R/3 systems. Then the port needs to be mapped with the RFC Destination.
Configuration Steps:
Figure 7: Initial Screen for creating Port
Figure 8: Technical Settings for Port
5. Configuration of Partner Profile (For Outbound messages)
Partner Profile needs to be configured for Outbound Message types for Material Master that is MATMAS05 and MDMRECEIPT.
Configuration Steps:
Figure 9: Initial Screen for Creating Partner Profiles
Figure 10: Outbound Parameters and other settings
Figure 11: Screen for Outbound Parameter settings of Partner Profile
“BI 003 – Could not determine recipients for message type MDMRECEIPT”.
6. Creation of ALE distribution Model/Customer Distribution Model
This step needs to be performed for creating communication channel from Sender system to receiver system.
A customer distribution model needs to be created with a Model Name & then the MATMAS & MDMRECEIPT Message Type should be added there under the Sender PI System & Receiver R3 System.
Configuration Steps:
Figure 12: Initial Screen for Creating Distribution Model view
Figure 13: Pop-up screen for Creating Distribution Model
Figure 14: Pop-up screen for Assigning Message Types to Model view
Figure 15: Complete Distribution Model
Figure 16: Path for Generating Partner Profile for Distribution Model
Figure 17: Selection screen for generation of Partner Profile
Figure 18: Path for distributing model to target system
7. Create Variant for Initial Extraction(Selection Criteria and Transfer segments are defined)
The Master Extractor needs to be configured by setting the variants & using the LS name of the ALE settings done above.
The Variant Name is according to Material Master Data & a short description is also given. The Extraction Object is given according to the Message type of the Master which is to be exported. In the Target system the Logical System Name of the Receiver PI system is given. The Mode is kept Initial if it is a first time Extraction. The Block size is selected on the basis of how many records are to be bundled together in one IDOC.
Customizing Steps:
Figure 20: Initial Screen for MDM_CLNT_EXTR
Figure 21: Screen for entering Selection criteria and transfer selection
Note: In case you are entering some value range for Numeric Type, then you need to enter the value including Leading Zeroes for the concerned field. If this is not done, then extraction will start but message will be generated saying “No Data Found”. For Example, we need to maintain Material Number – MATNR as 000000000070000000 (total 18characters) and not only 70000000 (8 characters).
Figure 22: Batch Jobs executed for MDM_CLNT_EXTR
Figure 23: Log display for Batch Job
Figure 24: Idoc display for extracted idocs
Software Check:
References
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |