RCG SAP S/4 HANA Customers System API - Implementation Template

(0 reviews)

Data mappings

This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.

contact-point-retrieve-response

Source: ./src/main/resources/dwl/contactpoints/contact-point-retrieve-response.dwl

Mapping Tables

contactPoints (ContactPointAddress) response mapping.

Resp FieldSAP HANA source fieldDescription of source field
contactPointTypeNASet to "ContactPointAddress"
idAddressIDAddress id in SAP HANA
activeFromDateNASet to current date
addressLine1StreetNameAddress street
addressLine2HouseNumberHouse Number
cityNameHomeCityNameCity name
postalCodeTextPostalCodePostal code
stateProvinceNameRegionState
countryNameCountryCountry
geoLatitudeNANA
geoLongitudeNANA
geoAccuracyNANA

contactPoints (ContactPointEmail) response mapping.

Resp FieldSAP HANA source fieldDescription of source field
contactPointTypeNASet to "ContactPointEmail"
idAddressIDAddress id in SAP HANA
activeFromDateValidityStartDateValidity start date
emailAddressEmailAddressEmail address

contactPoints (ContactPointPhone) response mapping.

Resp FieldSAP HANA source fieldDescription of source field
contactPointTypeNASet to "ContactPointEmail"
idAddressIDAddress id in SAP HANA
activeFromDateNASet to current date
telephoneNumberPhoneNumberPhone number

(back to top)

search-customers-contact-point-retrieve-response

Source: ./src/main/resources/dwl/contactpoints/search-customers-contact-point-retrieve-response.dwl

Mapping Tables

contactPoints (ContactPointAddress) response mapping.

Resp FieldSAP HANA source fieldDescription of source field
contactPointTypeNASet to "ContactPointAddress"
idAddressIDAddress id in SAP HANA
activeFromDateNASet to current date
addressLine1StreetNameAddress street
addressLine2HouseNumberHouse Number
cityNameHomeCityNameCity name
postalCodeTextPostalCodePostal code
stateProvinceNameRegionState
countryNameCountryCountry
geoLatitudeNANA
geoLongitudeNANA
geoAccuracyNANA

contactPoints (ContactPointEmail) response mapping.

Resp FieldSAP HANA source fieldDescription of source field
contactPointTypeNASet to "ContactPointEmail"
idAddressIDAddress id in SAP HANA
activeFromDateValidityStartDateValidity start date
emailAddressEmailAddressEmail address

contactPoints (ContactPointPhone) response mapping.

Resp FieldSAP HANA source fieldDescription of source field
contactPointTypeNASet to "ContactPointEmail"
idAddressIDAddress id in SAP HANA
activeFromDateNASet to current date
telephoneNumberPhoneNumberPhone number

(back to top)

create-customer-org-request

Source: ./src/main/resources/dwl/customers/create-customer-org-request.dwl

Mapping Tables

Search customers response mapping.

CIM Source FieldSAP target fieldDescription of target field
NABusinessPartnerCategorySet to "2" for Organization
NACorrespondenceLanguageSet to "EN"
NABusinessPartnerGroupingSet to "BP02"
party.nameBusinessPartnerNameName of the Business Partner
originatingCustomerSourceYY1_SME_AccouTemp_RTL_busAccount Template
primaryAccountYY1_SME_ParentID_RTL_busParent Id
party.contactPointsNACustomer's address details
externalIds.externalIdYY1_SME_MPARTYROLEID_busExternal Id
OrganizationBPName1nameName of the Organization

to_BusinessPartnerAddress response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
activeFromDateValidityStartDateActive from date
addressLine1StreetNameAddress street
cityNameHomeCityNameCity name
postalCodeTextPostalCodePostal code
stateProvinceNameRegionState
countryNameCountryCountry
geoLatitudeNANA
geoLongitudeNANA
geoAccuracyNANA

to_EmailAddress response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
emailAddressEmailAddressEmail address

to_PhoneNumber response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
telephoneNumberPhoneNumberPhone number

to_BusinessPartnerRole response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
customerRoleBusinessPartnerRoleRole to be assigned to the customer

to_CustomerSalesArea response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
salesOrganizationSalesOrganizationSalesOrganization
distributionChannelDistributionChannelDistribution channel
divisionDivisionDivision

(back to top)

create-customer-request

Source: ./src/main/resources/dwl/customers/create-customer-request.dwl

Mapping Tables

Search customers response mapping.

CIM Source FieldSAP target fieldDescription of target field
NABusinessPartnerCategorySet to "1" for Persons
NACorrespondenceLanguageSet to "EN"
NABusinessPartnerGroupingSet to "BP02"
party.firstNameFirstNameCustomer's first name
party.lastNameLastNameCustomer's last name
party.middleNameMiddleNameCustomer's middle name
party.birthDateBirthDateCustomer's DOB
party.contactPointsNACustomer's address details
party.nameBusinessPartnerNameName of the Business Partner
originatingCustomerSourceYY1_SME_AccouTemp_RTL_busAccount Template
primaryAccountYY1_SME_ParentID_RTL_busParent Id
externalIds.externalIdBusinessPartnerIDByExtSystemExternal Id
party.personNamePersonFullNamePerson's full name

to_BusinessPartnerAddress response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
activeFromDateValidityStartDateActive from date
addressLine1StreetNameAddress street
cityNameHomeCityNameCity name
postalCodeTextPostalCodePostal code
stateProvinceNameRegionState
countryNameCountryCountry
geoLatitudeNANA
geoLongitudeNANA
geoAccuracyNANA

to_EmailAddress response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
emailAddressEmailAddressEmail address

to_PhoneNumber response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
telephoneNumberPhoneNumberPhone number

to_BusinessPartnerRole response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
customerRoleBusinessPartnerRoleRole to be assigned to the customer

to_CustomerSalesArea response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
salesOrganizationSalesOrganizationSalesOrganization
distributionChannelDistributionChannelDistribution channel
divisionDivisionDivision

(back to top)

update-customers-request

Source: ./src/main/resources/dwl/customers/update-customers-request.dwl

Mapping Tables

Search customers response mapping.

CIM Source FieldSAP target fieldDescription of target field
NABusinessPartnerCategorySet to "1" for Persons
NACorrespondenceLanguageSet to "EN"
NABusinessPartnerGroupingSet to "BP02"
party.firstNameFirstNameCustomer's first name
party.lastNameLastNameCustomer's last name
party.middleNameMiddleNameCustomer's middle name
party.birthDateBirthDateCustomer's DOB
party.contactPointsNACustomer's address details
externalIds.externalIdBusinessPartnerIDByExtSystemExternal Id
party.personNamePersonFullNamePerson's full name
originatingCustomerSourceYY1_SME_AccouTemp_RTL_busAccountTemplate
primaryAccountYY1_SME_ParentID_RTL_busPrimaryAccount

to_BusinessPartnerAddress response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
activeFromDateValidityStartDateActive from date
addressLine1StreetNameAddress street
cityNameHomeCityNameCity name
postalCodeTextPostalCodePostal code
stateProvinceNameRegionState
countryNameCountryCountry
OrganizationBPName1namename of the organization
geoLatitudeNANA
geoLongitudeNANA
geoAccuracyNANA

to_EmailAddress response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
emailAddressEmailAddressEmail address

to_PhoneNumber response mapping.

CIM source FieldSAP HANA target fieldDescription of target field
telephoneNumberPhoneNumberPhone number

(back to top)

retrieve-customer-by-id-response

Source: ./src/main/resources/dwl/customers/retrieve-customer-by-id-response.dwl

Mapping Tables

Retrieve customer by id response mapping.

Resp FieldSAP HANA source fieldDescription of source field
partyRoleTypeNASet to "Customer"
idCustomerCustomer id
nameOrganizationBPName1name of the organization
partyNACustomer details
party.idCustomerCustomer id
party.salutationNACustomer salutation
party.personNameFirstName and LastNameCustomers full name
party.firstNameFirstNameCustomers first name
party.lastNameLastNameCustomers last name
party.birthDateBirthDateCustomers DOB
party.partyTypeNAset to "Individual"
party.contactPointsNACustomer's address details
party.partyRoleto_BusinessPartnerRoleCustomer's Roles
party.partyRelatedPartyto_BPRelationshipCustomer's Relationships
party.accountOrgUnitYY1_SME_OrgUnit_RTL_busCustomer's Organization Unit Relationship
party.usersto_BusinessPartnerContactCustomer's Contacts Relationship
externalIds.idNAexternalId id
externalIds.externalIdBusinessPartnerIDByExtSystemExternal Id
externalIds.externalIdTypeNAset to "MDM"
externalIds.statusLastChangedDateLastChangeDate and LastChangeTimeCustomer last modified datetime
externalIds.statusNAset to "VALID"
auditInfo.createdDateCreationDate and CreationTimeCustomer creation date time in SAP
auditInfo.createdByCreatedByUserCustomer created by
auditInfo.updatedDateLastChangeDate and LastChangeTimeCustomer last modified datetime
auditInfo.updatedByLastChangedUserLast modified by
auditInfo.isDeletedNAIs customer deleted
customerNumberBusinessPartnerCustomer id
customerStatusNAset to "ACTIVE"
originatingCustomerSourceYY1_SME_AccouTemp_RTL_busAccountTemplate
primaryAccountYY1_SME_ParentID_RTL_busParendId

(back to top)


Reviews

TypeTemplate
OrganizationMulesoft Inc.
Published by
MuleSoft Solutions
Published onOct 16, 2023
Asset overview

Asset versions for 2.2.x

Asset versions
VersionActions
2.2.7
2.2.6
2.2.4
2.2.3