Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

upload the excel in CRM System

Former Member
0 Kudos

Hi Experts,

I have to upload the excel sheet of Business partner in to the CRM system.I have the program for this that program have a format for upload the list but when i upload the list then it shows me the error"Error1:-Instance belonging to object type BusinessPartnerFS could not be created"

I am unable to understand this error.

Regards,

Khurram Siddique

3 REPLIES 3

Former Member
0 Kudos

use FM /CEM/ENT_IMPORT_DATAFROMEXCEL

Reward point if helpful

Former Member
0 Kudos

Hi siddique,

http://resources.crmbuyer.com/search/keyword/crmbuyer/Sap%20Upload%20Excel/Sap%20Upload%20Excel

http://blogs.moovar.com/sap/sap-crm-external-list-management-elm-in-web-ic/

Excel file download to an internal table in SAP CRM

, what i did is nge the format of the excel spread sheet into a coma delimiter then loaded into an internal table and then into a sap table seing that u just have to load it into an internal table mayb this will help u, this program takes the file reads it into a dataset n then populates an internal table

REPORT Z_karthikOAD .

tables: zinv_release,

zpo_release.

    • decleration of data

DATA: BEGIN OF my_tab OCCURS 0.

INCLUDE STRUCTURE zinv_release.

DATA: END OF my_tab.

*DATA: hex_tab TYPE x VALUE '09'.

DATA: rec(200)."'/usr/test.dat'.

DATA:

zhours(20) TYPE c,

MINS(20) type c. "decimals.

data: coma.

coma = ','.

SELECTION-SCREEN BEGIN OF BLOCK txt

WITH FRAME TITLE text-001.

PARAMETERS: dsn(60) DEFAULT '
sapdev01\prod\'.

SELECTION-SCREEN END

OF BLOCK txt.

*using a dataset to get text

OPEN DATASET dsn FOR INPUT IN TEXT MODE.

IF sy-subrc = 0.

DO.

READ DATASET dsn INTO rec.

IF sy-subrc <> 0.

EXIT.

ENDIF.

split rec at coma into

zpo_release-REL_GRP

zpo_release-REL_CODE

zpo_release-RESPREL

zpo_release-ALTREL

zpo_release-MANAGER

ZHOURS

MINS

zpo_release-FROMTIME

zpo_release-TOTIME

zpo_release-EXCLWKENDS.

move zpo_release-REL_GRP to my_tab-REL_GRP.

move zpo_release-REL_CODE to my_tab-REL_CODE.

move zpo_release-RESPREL to my_tab-RESPREL.

move zpo_release-ALTREL to my_tab-ALTREL.

move zpo_release-MANAGER to my_tab-MANAGER.

move ZHOURS to my_tab-ZHOURS.

move MINS to my_tab-mins.

move zpo_release-FROMTIME to my_tab-fromtime.

move zpo_release-TOTIME to my_tab-totime.

move zpo_release-EXCLWKENDS to my_tab-exclwkends.

APPEND my_tab.

ENDDO.

INSERT zpo_release FROM TABLE my_tab ACCEPTING DUPLICATE KEYS.

    • DELETE zmm_ppa_cc FROM TABLE tab.

    • INSERT zzzak_emp FROM TABLE my_tab ACCEPTING DUPLICATE KEYS.

IF sy-subrc = 0.

MESSAGE i000(zv) WITH 'File Successful stored in DB.' '' '' ''.

    • ELSE.

MESSAGE i000(zv) WITH 'File already stored in DB.' '' '' ''.

endif.

ENDIF.

thanks

sekhar.

reward me if usefull

Former Member
0 Kudos

Hi Khurram,

I've faced the same error with you. My solution is: you should check the BP number whether it is inside the number range of the related BP Grouping or not. Especially the external number range start with number such as 00010000, when you put in Excel file it will automatically delete 000 at the beginning.

Hope this answer will be helpful for you.

Best Regards,

Duc Lam.