How to replicate a material master from R/3 to SRM

1. Basis setup
First of all, you must set a RFC connectivity between SRM and backend system:

• Create system users for remote connection (RFC_CONN). This user must have SAP_ALL authorization.
• Create RFC connections in SRM system.
  Go to transaction SM59 on SRM side and click on 'create' button. Set RFC destination name to the back-end system <sid>CLNT<client> (eg. R3DCLNT200), connection type to 3 (abap / R/3 connection) and fill the target host to your back-end system. On the Logon/Security tab, add the RFC_CONN user created in the previous step. Save your settings.
• Create RFC connections in the back-end system.
  Go to transaction SM59 on the back end and click on 'create' button. Set the RFC destination name to SRM system <sid>CLNT<client> (eg. SR1CLNT300), connection type to 3 (abap / R/3 connection) and fill in the target host to your back-end system. On the Logon/Security tab, add the RFC_CONN user created in the previous step. Save your settings.
• Create a logical system name in SRM.
  Go to transaction SPRO -> SAP Implementation Guide -> Supplier Relationship Management -> SRM Server -> Technical Basic Settings -> ALE Settings -> Distribution -> Basic Settings -> Logical Systems -> Define Logical System Add a new value:
  
  Log.System Name
  R3DCLNT200 R3DCLNT200
  
  Save your settngs.
  
• Create a logical system name in the back end.
  Go to transaction SPRO -> SAP Customizing Implementation Guide -> SAP Web Application Server -> Application Ling Enabling -> Sending and Receiving Systems -> Logical Systems -> Define Logical System Add a new value:
  
  Log.System Name
  SR1CLNT300 SR1CLNT300
  
  Save your settngs.
  



2. Middleware parameters setup
Go to transaction SM30 on backend system and choose table CRMCONSUM. Add the following values:

User Active Description Q Prefix
CRM checked SRM connection R3A
Next, choose CRMSUBTAB for subscription table for the Up and Download Object and add the following values:

User ObjectName U/D Obj. Class Function Obj. Type Funct. Name
CRM empty Download Material empty empty CRS_MATERIAL_EXTRACT
CRM empty Download Material empty empty CRS_CUSTOMIZING_EXTRACT
CRM ...

To continue reading for free, register below or login
Requires Membership to View
To gain access to this and all member only content, please provide the following information:
Email Address:



By joining SearchSAP.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy
To read more you must become a member of SearchSAP.com
As an existing member of the TechTarget network please activate your SearchSAP.com account 
By joining SearchSAP.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy




Digg This!     StumbleUpon     Del.icio.us






RELATED CONTENT SAP tips and best practices Minimizing business disruptions during an SAP upgrade or implementation Retrieving content from an SAP workflow attachment Updating URLs in SAP SRM How to change default settings in SAP SRM What are the benefits of implementing SAP SRM? Increase column width in a transaction screen Updating an RT table entry in SAP HR Payroll -- without the ADDWTE option Is this the quickest way to find a BADI? Adding custom fields for retail product comparisons in SAP BW Improving performance with ABAP Objects in SAP Workflow SAP MDM software Quiz: SAP master data management (MDM) For MDM, start by getting to know your enterprise data Creating an enterprise MDM initiative in an SAP environment Using SAP NetWeaver MDM with CRM, SCM and NetWeaver BI The importance of master data management following mergers and acquisitions Enterprise MDM: SAP MDM for reducing data silos and duplicate records Designing your SAP NetWeaver master data management strategy Successful MDM strategy starts with finding broken processes, not technology TechEd: Kraft provides tips for a successful SAP MDM project SAP, chemical firm work through MDM issues SAP supplier relationship management software Benefits and tradeoffs of on-demand SAP SRM SAP SRM 7.0 bolsters firms' procurement processes The benefits of SAP supplier relationship management (SRM) Understanding supply processes and concepts in SAP SRM Implementing SAP Enterprise Buyer and other SAP supply components Updating URLs in SAP SRM How to change default settings in SAP SRM What are the benefits of implementing SAP SRM? SAP extends enhancement packages across suite with Business Suite 7 Switching from an extended classic to a classic scenario

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary Collaborative Master Data Management  (SearchSAP.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary



empty Download Material empty empty CRS_SERVICE_EXTRACT


Next, choose CRMRFCPAR for definitions of RFC Connections and add the following values:

User ObjectName Destination Load Type INFO InQueue Flag Send XML
CRM * SR1CLNT300 Initial Download SR1CLNT300 X Send XML
CRM * SR1CLNT300 Request SR1CLNT300 X Send XML
CRM MATERIAL SR1CLNT300 Initial Download SR1CLNT300 X Send XML

Leave all other field empty.
Now, configure filtering for the material master:
Choose the CRMPAROLTP table for CRM OLTP Parameters and add the following values:

Parameter name Param. Name 2 Param. Name 3 User Param. Value Param. Value 2
CRM_FILTERING_ACTIVE MATERIAL empty CRM X empty


Now we must edit the table for the application indicator. Go to transaction SE16N on the back-end side and choose table TBE11. Search or add an application component BC-MID and edit activity settings (field AKTIV = X).
Save your settings.



3. Enterprise buyer with/without CRM
In this activity, you define whether you are running the Enterprise Buyer and CRM in the same system. This might accelerate the Master Data download performance. If you are using CRM in the client, then skip this activity.

In the SRM system run transaction BBP_PRODUCT_SETTINGS, deselect 'Test mode' and choose the Execute button.
The system generates a report containing all tables that have been deactivated.


4. Generate repository objects
With this procedure, you generate the middleware function modules (BDoc Object Type) for the material master.

Go to transaction SMOGGEN and choose object PRODUCT_MAT and PRODUCT_SRV. Generate services for all object categories.

[IMAGE]


5. Number range object maintenance
On the SRM system, go to transaction SRNO and assign number ranges for all CRM Replication and Realigment Queues. Enter in object field RRSEQ* and hit F4 button. Choose the first object (RRSEQ_AC) and click on the 'change' button. On the next screen, click the button 'Number Ranges' and add the following range:

No From number To Number Ext.
01 00000000000000000001 99999999999999999999 no


Repeat these steps for all of RRSEQ* objects.


6. Output format of product ID
Check your output format for Product ID in the backend and SRM system. This values must be the same for both systems.
Go to transaction COMCPRFORMAT in SRM and check the product ID lenght and values for displaying leading zeroes.

Save your settings.


7. CRM middleware monitoring cockpit
On the SRM side, go to transaction SMWP. Open System Settings and double-click on 'Number of sites per site type' name. The Administration Console shows up.
Click on 'Create Object' icon and fill in the Name and description. Choose R/3 for 'Type' parameter and click on Site Attributes. Enter and create an RFC destination to backend system (R3DCLNT200).

[IMAGE]
Save your settings.


8. Start of download material
Go to transaction R3AS on SRM side and choose the first object to download (DNL_CUST_BASIS3).

[IMAGE]

After this, the source site and desitination site on data flow should fill with proper values. Click on the 'Execute' button. After this, go to transaction R3AM1 for the monitoring object.

[IMAGE]

If you have a green light, go to transaction R3AS again and repeat the steps for objects:


• DNL_CUST_PROD0
• DNL_CUST_PROD1
• DNL_CUST_SRVMAS
• MATERIAL


After this, go to transaction COMM_HIERARCHY to see what kind of categories are replicated from backend system.

[IMAGE]

Go to transaction COMMPR01 to see what kind of Products are replicated from backend system.

[IMAGE]


9. Filtering Material Master records
If you want to filter material master or other objects, go to transaction R3AC1 on SRM side. You will see the following table:

[IMAGE]

Click on filter icon on object MATERIAL. On the filter settings tab, choose Source Site Name and click edit button.

The filter settings object table corresponds to the fields and tables/structures from backend system. If you want to download only one material, enter the following values:

[IMAGE]


10. Deleting the material master from SRM
If you want to delete hierarchy of product, run this report:
• COM_HIERARCHY_DELETE_SINGLE - Deletes all hierarchy and category data
• COM_HIERARCHY_DELETE_ALL - Deletes all hierarchy and category data


If you want to delete all or selected product, run this report:
• COM_PRODUCT_DELETE_SINGLE - Deletion of a product from the database
• COM_PRODUCT_DELETE_ALL - Deletion of all product master data

Marcin Gajewski is a SAP consultant in PWPW S.A. (Polish Security Printing Works), Poland, responsible for business development and implementation of new features.

Want to read more from this author? Click here to read Marcin Gajewski's Weblog. Click here to read more about Business Solutions on SDN.