Ho upload leads information from legacy to sap crm

144 Views

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