cancel
Showing results for 
Search instead for 
Did you mean: 

Ho upload leads information from legacy to sap crm

Former Member
0 Kudos

hi guys,

can anybody help that how to upload leads information(as a file) which is exist in legacy system(RIDES) to SAP-CRM to create/Generate a business partner record and a lead document within SAP CRM.

Please help me how to write a abap code to develop above scenario and which bapi should we use.

If u have a sample code please send it to me.

below are the data mapping rules.

3.4 Data Transformation and Mapping

No. Field

Description Type Len Field Label Object Table SAP Field

1 SOURCE_ID Artificial key generated by KBM. Determines which source system this record or customer comes from. Text SOURCE Lead CRMD_OPPORT_H TYPE

2 FIRST_NAME First Name

CHARACTER 40 First Name BP- Person (Prospect) BUT000 NAME_FIRST

3 LAST_NAME Last Name

CHARACTER Last Name BP- Person (Prospect) BUT000 NAME_LAST

4 ADDR_LINE_1 Address Line 1 CHARACTER ADDRESS LINE 1 BP- Person (Prospect) BUT000 STREET

5 ADDR_LINE_2 CHARACTER ADDRESS LINE 2 BP- Person (Prospect) BUT000 STR_SUPPL1

6 ADDR_CITY CHARACTER CITY BP- Person (Prospect) BUT000 CITY1

7 ADDR_STATE_PROVINCE_CODE CHARACTER Region BP- Person (Prospect) BUT000 REGION

8 POSTAL_CODE CHARACTER Postal Code BP- Person (Prospect) BUT000 POST_CODE1

9 ADDR_COUNTY CHARACTER Country BP- Person (Prospect) BUT000 COUNTRY

10 DAY_PHONE_NUM NUMERIC Telephone BP- Person (Prospect) BUT000 TEL_NUMBER

11 EMAIL_ADDRESS CHARACTER Email BP- Person (Prospect) BUT000 SMTP_ADDR

12 EVENING_PHONE_NUM

NUMERIC Telephone BP- Person (Prospect) BUT000 TEL_NUMBER

13 GENDER

CHARACTER SEX BP- Person (Prospect) BUT000 SEXID

14 DOB

CHARACTER Birthday BP- Person (Prospect) BUT000 BIRTHDT

15 SURVEY_DATE CHARACTER Survey Lead Survey (ZOPP) CRMD_OPPORT_H Survey

16 PURCHASE_TIMEFRAME NUMERIC Marketing Attributes Marketing Attribute (BP – Person Prospect) BUT000 Marketing Attribute

17 Dealer No. NUMERIC Dealer Lead - ZOPP CRMD_OPPORT_H Partner Function

18 Buell or Harley? CHARACTER Industry Sector BP – Person BUT000 Industry Sector

19 Product Information? (Unique Product Number) Product ID Lead - ZOPP CRMD_OPPORT_H Product

20 Campaign? Campaign Lead - ZOPP CRMD_OPPORT_H Campaign

regards

viswa

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

There is a BAPI also available. BAPI*CREATEMULTI.( As The system is down now I couldn't give the exact name ) You can search oss note for the same BAPI name you find the sample code. Only thing you need to do in oyur code is data mapping.

Regards,

Abdul raheemS

Former Member
0 Kudos

I suppose you could upload a text-file and create Idocs from the file (CRMXIF_ORDER_SAVE_M02 for the leads and CRMXIF_PARTNER_SAVE_M02 for business partners) in an ABAP program. This requires quite some coding and you'll have to be familiar with idoc-handling.

Michael.