FSM Cloud Connector field mapping

IDOC SEGMENT

IDOC FIELD

SAP TABLE

FSM OBJECT DTO

/PACG/ECM_IS_CUST

ID

kna1vv-kunnr

id

NAME

kna1-name1 or adrc-name1

name

TYPE

'CUSTOMER',  /pacg/ecm_ktokdm-extktokd

type

OFFICEPHONE

adr2-tel_number
adr2-r3_user = 1

officePhone

MOBILEPHONE

adr2-tel_number

adr2-r3_user = 3

mobilePhone

OTHERPHONE

adr2-tel_number

adr2-r3_user =  space

otherPhone

FAX

adr3-fax_number

fax

EMAILADDRESS

adr6-smtp_addr

emailAddress

WEBSITE

adr12-uri_addr

website

REMARKS

adrct-remarks

remarks

PLTYP

knvv-pltyp / knvv-pltyp knvv-waers

pricelist

WAERS

knvv-waers

currency

BPGROUP

kna1-kukla/

kna1-brsch

groupCode

BPTEXT

tkukt-vtext/

t016t-brtxt/
BPGROUP

groupName

CITY

kna1-ort01 or adrc-city1

city

COUNTRY

kna1-land1

country

ZTERMID

knvv-zterm

paymentTerm

SHIPPINGTYPE

knvv-vsbed

shippingType

ZLSCH

paymentType

ADD_NAME

kn01-name2 or adrc-name2

additionalName

BLOCKED

Value 1,2,3 depending on kna1-faksd/knvv-faksd and kna1-lifsd/knvv-lifsd

blocked

END_CUST_NUMBER

Counted knvp-kunn2

endCustomersNumber

LANGUAGE

kna1-spras

language

/PACG/ECM_IS_CUST2

CROWDTYPE

crowdType

CODE

knvv-kunnr/kna1-kunnr

code

/PACG/ECM_IS_EXTERNAL

EXTERNALID

externalId

/PACG/ECM_IS_SYNCOBJECTKPI

KPIID

OBJECTID

OBJECTTYPE

CLOUDDATATYPE

cloudDataType

DESCRIPTION

description

VALUE

value

ADDINFO

additionalInformation

/PACG/ECM_IS_LOCATION

LATITUDE

location.latitude location.longitude

LONGITUDE

/PACG/ECM_IS_UDFDATA_OUT

UDFID

udfdata

UDFKEY

UDFVALUE

UDFADDINFO

TDFORMAT

UDFTYPE

LTEXT_LINEAR

/PACG/ECM_IS_UDFGROUP_OUT

UDFGID

udfgroup

/PACG/ECM_IS_GROUPDATA

OBJECTKEY

groupData (groupCode/groupName?)

/PACG/ECM_IS_BRANCHLIST

BRANCHID

branch

IDOC SEGMENT

IDOC FIELD

SAP TABLE user

SAP TABLE employee

FSM OBJECT DTO

/PACG/ECM_IS_USER

TYPE

/pacg/ecm_cl_x_common=>mc_usertype_erpuser

/pacg/ecm_cl_x_common=>mc_usertype_employee

type

ID

cloudname
P/+ pa0001-pernr

P/+ pa0001-pernr

id

EMAILADDRESS

pa0105-subty = ‘0010’
pa0105-usrid_long

adr6-stmp_ddr

pa0105-subty = ‘0010’
pa0105-usrid_long

emailAddress

FAX

pa0105-subty = ‘0005’
pa0105-usrid

adr3-fax_number

pa0105-subty = ‘0005’
pa0105-usrid

fax

FIRSTNAME

pa0002-vorna

adrp-name_first

pa0002-vorna

firstName

HOMEPHONE

adr2-tel_number

adr2-r3_user <> 3

-

homePhone

JOBTITLE

adcp-function

-

jobTitile

LASTNAME

pa0002-nachn

adrp-name_last

pa0002-nachn

lastName

MOBILEPHONE

pa0105-subty = ‘MPHN’
pa0105-usrid_long

adr2-tel_number

adr2-r3_user = 3

pa0105-subty = ‘MPHN’
pa0105-usrid_long

mobilePhone

NOLONGEREMLOYED

-

OFFICEPHONE

pa0105-subty = ‘0020’
pa0105-usrid_long

pa0105-subty = ‘0020’
pa0105-usrid_long

officephone

PAGER

pa0105-subty = ‘PAGR’
pa0105-usrid_long

adr13-pager_nmbr

pa0105-subty = ‘PAGR’
pa0105-usrid_long

pager

POSITIONNAME

-

positionName

EXTERNALRESOURCE

/PACG/ECM_VUSER0-subcontractor

/PACG/ECM_VUSER0-subcontractor

externalResource

ADDRESSID

-

address

REFID

/PACG/ECM_IS_USER id

if pernr is not initial
P/ +/pacg/ecm_uniper
P/+ pa0001-pernr

cloudname
/PACG/ECM_IS_USER id

P/+ pa0001-pernr

refId

PLANNABLERESOURCE

/PACG/ECM_VUSER0-plannable

/PACG/ECM_VUSER0-plannable

plannableResource

MANAGERID

manager

SKYPE

skypeName

USERNAME

pa0001-pernr

/pacg/ecm_vuser0-bname

/pacg/ecm_vuser0-pernr

pa0001-pernr

userName

LOGINENABLED

default ‘true’

true (if e4c user)

loginEnabled

/PACG/ECM_IS_USER2

BRANCHCODE

branchCode

BRANCHNAME

branchName

DEPARTMENTCODE

pa0001-orgeh

pa0001-orgeh

departmentCode

DEPARTMENTNAME

T527x-ORGTX or pa0001-orgeh

adcp-department

T527x-ORGTX or pa0001-orgeh

departmentName

CODE

pa0001-pernr or SZI?

pa0001-pernr

code

BUSINESSPARTNERID

‘V/’ + pa0315-lifnr

‘V/’ + pa0315-lifnr

buisnessPartner

CROWDTYPE

/PACG/ECM_VUSER0-user_crowd_type // dd07t-ddtext

/PACG/ECM_VUSER0-user_crowd_type // dd07t-ddtext

crowdType

FSM_USER_ID

/PACG/ECM_VUSER0-FSM_USER_ID ?

FSM_USR_PERM

/PACG/ECM_VUSER0-FSM_USER_PERM

permissionGroupId

FSM_USER_ACTIVE

/PACG/ECM_VUSER0-FSM_USR_ACTIVE

inactive

/PACG/ECM_IS_REMARK

LINE

remarks

/PACG/ECM_IS_USER_EXT

USERNAME

/PACG/ECM_VUSER0-FSM_USER_ID

/PACG/ECM_IS_USER username

/PACG/ECM_IS_USER
emailaddress

/PACG/ECM_VUSER0-FSM_USER_ID

pa0001-pernr

/PACG/ECM_IS_USER emailaddress

/PACG/ECM_IS_USER_SKILL

SKILL

-

pa0024-quali
t574b-qtext+t777Q-chara_text

skills

/PACG/ECM_IS_EXTERNAL

EXTERNALID

externalId

/PACG/ECM_IS_UDFDATA_OUT

UDFID

/pacg/ecm_udfval-udfid

‘USER_TEST’

udfData

UDFKEY

UDFVALUE

/pacg/ecm_udfval-udfvalue

‘abc’

UDFADDINFO

TDFORMAT

UDFTYPE

LTEXT_LINEAR

/PACG/ECM_IS_GROUPDATA

OBJECTKEY

-

/pacg/ecm_cl_s_badi_group_wc=>mc_groupid_prefix

/pacg/ecm_cl_s_badi_group_pg=>mc_groupid_prefix

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+t500p-land1_t500p-regio

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+adrc-country+adrc-region

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix + pa0006-land1+ pa0006-state

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+ kna1-land1 + kna1-regio

groupData

/PACG/ECM_IS_REGIONDATA

OBJECTKEY

/pacg/ecm_cl_s_badi_region_wc=>mc_regionid_prefix

/pacg/ecm_cl_s_badi_region_pg=>mc_regionid_prefix

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+t500p-land1_t500p-regio

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+adrc-country+adrc-region

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix + pa0006-land1+ pa0006-state

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+ kna1-land1 + kna1-regio

/pacg/ecm_cl_s_badi_region_wc=>mc_regionid_prefix

/pacg/ecm_cl_s_badi_region_pg=>mc_regionid_prefix

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+t500p-land1_t500p-regio

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+adrc-country+adrc-region

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix + pa0006-land1+ pa0006-state

/pacg/ecm_cl_s_badi_group_ar=>mc_regionid_prefix+ kna1-land1 + kna1-regio

regionData

/PACG/ECM_IS_BRANCHLIST

BRANCHID

branch