on 2007 Mar 06 10:30 AM
Hi all,
I have to upload arround 1 million record in CRM system. and i am using LSMW Idoc method....in which i am using CRM_XIF_PARTNER_SAVE and CRM_XIF_PARTNER_SAVE_M IDoc. And i have create the file port and the partner number.
But i am stuck at this point .. Any one who has done this before can sedn me step doc which help me in doing so...
Points will be rewarded....
Thanks in advance
Vertika
Hi Vertika,
This are the steps I have done in order to load business partners in SAP CRM. I use a flat file as data source, LSMW as SAP CRM tool, IDOC as import method and message type CRMXIF_PARTNER_SAVE_M
1. Customizing for Business Partners. Transaction SPRO. You have to check if all the customizing for BP is defined (Roles, Number Ranges, Groupings, etc).
2. Create Ports for LSMW - Transaction WE21
3. Create Partner Nº for LSMW - Transaction WE20. In this step you must set US for partner and include CRMXIF_PARTNER_SAVE_M as Inbound Parameter.
4. Create a Project in LSMW. Transaction LSMW.
5. Create a SubProject in LSMW. Transaction LSMW.
6. Create a Object in LSMW. Transaction LSMW.
7. Set IDoc Inbound Processing in LSMW. Transaction LSMW. In this step you must set the port, the partner type an number and activate the idoc inbound processing.
8. Automatic Workflow Customizing. Transaction SWU3. You must execute the automatic Workflow Customizing.
9. Verify Workflow. Transaction SWU3. You must start the Verification Workflow.
10. Maintain Object Attributes. Transaction LSMW. In this step you must specify the import method (IDOC), the message type CRMXIF_PARTNER_SAVE_M and the basic type CRMXIF_PARTNER_SAVE_M02
11. Maintain Source Structures. Transaction LSMW. In this step you define a name for your source structure.
12. Maintain Source Fields. Transaction LSMW. In this step you define the name, length and type for all the fields that you are going to include in the flat file where you have stored the source data.
13. Maintain Structure Relations. Transaction LSMW. In this step you define the segments of the IDOC that you want to map.
14. Maintain Field Mapping and Conversion Rules. Transaction LSMW. In this step you define the mapping and conversion rules between the source fields and the segments included in the IDOC.
15. Specify Files. Transaction LSMW. In this step you define the source files (from your PC or the CRM server). You must define wich are the separator in the flat file (tabulator, comma, etc).
16. Assign Files. Transaction LSMW.
17. Read Data. Transaction LSMW. In this step the CRM system read data from flat file.
18. Display Read Data. Transaction LSMW. You have to check if the data from the flat file have been read in a correct way.
19. Convert Data. Transaction LSMW. In this step, the CRM system map and convert the data.
20. Display Converted Data. Transaction LSMW. You have to check if the data have been mapped and converted in a correct way.
21. Start IDoc Generation. Transactio LSMW. In this step, the CRM system create the IDOC. The IDOCs created remains with status 64.
22. Start IDoc Processing. Transactio LSMW. In this step, the CRM system process the IDOC. The IDOCs processed change the status to 51 (incorrect) or 53 (correct).
23. Check the IDOCs. Transaction WE02.
24. Check the bdocs. Transaction SMW01. Every IDOC processed OK, generate a BDOC BUPA_MAIN. You have to check is the bdoc status is green.
25. Check the Busines Partner. Transactio BP. You have to check if the Business Partner are created and the data are ok.
Best Regards,
Alvaro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi alvaro,
thanks for making it so clear...justa small help more requiered..can you pls explain step13 little more...for ex: which idoc struc i have to select..like if there are two phone numbers for Bp which strcu i have to select and how to handle that.
Any help will greatly be appreicated...
or if there are some screen shots which depicts which strcu to be select ..can you mail me at vertika_verma2000@yahoo.com
thnk in advance
vertika..
User | Count |
---|---|
11 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.