RCG SAP S/4 HANA Customers System API - Implementation Template
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 Field | SAP HANA source field | Description of source field |
|---|---|---|
| contactPointType | NA | Set to "ContactPointAddress" |
| id | AddressID | Address id in SAP HANA |
| activeFromDate | NA | Set to current date |
| addressLine1 | StreetName | Address street |
| addressLine2 | HouseNumber | House Number |
| cityName | HomeCityName | City name |
| postalCodeText | PostalCode | Postal code |
| stateProvinceName | Region | State |
| countryName | Country | Country |
| geoLatitude | NA | NA |
| geoLongitude | NA | NA |
| geoAccuracy | NA | NA |
contactPoints (ContactPointEmail) response mapping.
| Resp Field | SAP HANA source field | Description of source field |
|---|---|---|
| contactPointType | NA | Set to "ContactPointEmail" |
| id | AddressID | Address id in SAP HANA |
| activeFromDate | ValidityStartDate | Validity start date |
| emailAddress | EmailAddress | Email address |
contactPoints (ContactPointPhone) response mapping.
| Resp Field | SAP HANA source field | Description of source field |
|---|---|---|
| contactPointType | NA | Set to "ContactPointEmail" |
| id | AddressID | Address id in SAP HANA |
| activeFromDate | NA | Set to current date |
| telephoneNumber | PhoneNumber | Phone number |
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 Field | SAP HANA source field | Description of source field |
|---|---|---|
| contactPointType | NA | Set to "ContactPointAddress" |
| id | AddressID | Address id in SAP HANA |
| activeFromDate | NA | Set to current date |
| addressLine1 | StreetName | Address street |
| addressLine2 | HouseNumber | House Number |
| cityName | HomeCityName | City name |
| postalCodeText | PostalCode | Postal code |
| stateProvinceName | Region | State |
| countryName | Country | Country |
| geoLatitude | NA | NA |
| geoLongitude | NA | NA |
| geoAccuracy | NA | NA |
contactPoints (ContactPointEmail) response mapping.
| Resp Field | SAP HANA source field | Description of source field |
|---|---|---|
| contactPointType | NA | Set to "ContactPointEmail" |
| id | AddressID | Address id in SAP HANA |
| activeFromDate | ValidityStartDate | Validity start date |
| emailAddress | EmailAddress | Email address |
contactPoints (ContactPointPhone) response mapping.
| Resp Field | SAP HANA source field | Description of source field |
|---|---|---|
| contactPointType | NA | Set to "ContactPointEmail" |
| id | AddressID | Address id in SAP HANA |
| activeFromDate | NA | Set to current date |
| telephoneNumber | PhoneNumber | Phone number |
create-customer-org-request
Source:
./src/main/resources/dwl/customers/create-customer-org-request.dwl
Mapping Tables
Search customers response mapping.
| CIM Source Field | SAP target field | Description of target field |
|---|---|---|
| NA | BusinessPartnerCategory | Set to "2" for Organization |
| NA | CorrespondenceLanguage | Set to "EN" |
| NA | BusinessPartnerGrouping | Set to "BP02" |
| party.name | BusinessPartnerName | Name of the Business Partner |
| originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | Account Template |
| primaryAccount | YY1_SME_ParentID_RTL_bus | Parent Id |
| party.contactPoints | NA | Customer's address details |
| externalIds.externalId | YY1_SME_MPARTYROLEID_bus | External Id |
| OrganizationBPName1 | name | Name of the Organization |
to_BusinessPartnerAddress response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| activeFromDate | ValidityStartDate | Active from date |
| addressLine1 | StreetName | Address street |
| cityName | HomeCityName | City name |
| postalCodeText | PostalCode | Postal code |
| stateProvinceName | Region | State |
| countryName | Country | Country |
| geoLatitude | NA | NA |
| geoLongitude | NA | NA |
| geoAccuracy | NA | NA |
to_EmailAddress response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| emailAddress | EmailAddress | Email address |
to_PhoneNumber response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| telephoneNumber | PhoneNumber | Phone number |
to_BusinessPartnerRole response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| customerRole | BusinessPartnerRole | Role to be assigned to the customer |
to_CustomerSalesArea response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| salesOrganization | SalesOrganization | SalesOrganization |
| distributionChannel | DistributionChannel | Distribution channel |
| division | Division | Division |
create-customer-request
Source:
./src/main/resources/dwl/customers/create-customer-request.dwl
Mapping Tables
Search customers response mapping.
| CIM Source Field | SAP target field | Description of target field |
|---|---|---|
| NA | BusinessPartnerCategory | Set to "1" for Persons |
| NA | CorrespondenceLanguage | Set to "EN" |
| NA | BusinessPartnerGrouping | Set to "BP02" |
| party.firstName | FirstName | Customer's first name |
| party.lastName | LastName | Customer's last name |
| party.middleName | MiddleName | Customer's middle name |
| party.birthDate | BirthDate | Customer's DOB |
| party.contactPoints | NA | Customer's address details |
| party.name | BusinessPartnerName | Name of the Business Partner |
| originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | Account Template |
| primaryAccount | YY1_SME_ParentID_RTL_bus | Parent Id |
| externalIds.externalId | BusinessPartnerIDByExtSystem | External Id |
| party.personName | PersonFullName | Person's full name |
to_BusinessPartnerAddress response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| activeFromDate | ValidityStartDate | Active from date |
| addressLine1 | StreetName | Address street |
| cityName | HomeCityName | City name |
| postalCodeText | PostalCode | Postal code |
| stateProvinceName | Region | State |
| countryName | Country | Country |
| geoLatitude | NA | NA |
| geoLongitude | NA | NA |
| geoAccuracy | NA | NA |
to_EmailAddress response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| emailAddress | EmailAddress | Email address |
to_PhoneNumber response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| telephoneNumber | PhoneNumber | Phone number |
to_BusinessPartnerRole response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| customerRole | BusinessPartnerRole | Role to be assigned to the customer |
to_CustomerSalesArea response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| salesOrganization | SalesOrganization | SalesOrganization |
| distributionChannel | DistributionChannel | Distribution channel |
| division | Division | Division |
update-customers-request
Source:
./src/main/resources/dwl/customers/update-customers-request.dwl
Mapping Tables
Search customers response mapping.
| CIM Source Field | SAP target field | Description of target field |
|---|---|---|
| NA | BusinessPartnerCategory | Set to "1" for Persons |
| NA | CorrespondenceLanguage | Set to "EN" |
| NA | BusinessPartnerGrouping | Set to "BP02" |
| party.firstName | FirstName | Customer's first name |
| party.lastName | LastName | Customer's last name |
| party.middleName | MiddleName | Customer's middle name |
| party.birthDate | BirthDate | Customer's DOB |
| party.contactPoints | NA | Customer's address details |
| externalIds.externalId | BusinessPartnerIDByExtSystem | External Id |
| party.personName | PersonFullName | Person's full name |
| originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | AccountTemplate |
| primaryAccount | YY1_SME_ParentID_RTL_bus | PrimaryAccount |
to_BusinessPartnerAddress response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| activeFromDate | ValidityStartDate | Active from date |
| addressLine1 | StreetName | Address street |
| cityName | HomeCityName | City name |
| postalCodeText | PostalCode | Postal code |
| stateProvinceName | Region | State |
| countryName | Country | Country |
| OrganizationBPName1 | name | name of the organization |
| geoLatitude | NA | NA |
| geoLongitude | NA | NA |
| geoAccuracy | NA | NA |
to_EmailAddress response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| emailAddress | EmailAddress | Email address |
to_PhoneNumber response mapping.
| CIM source Field | SAP HANA target field | Description of target field |
|---|---|---|
| telephoneNumber | PhoneNumber | Phone number |
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 Field | SAP HANA source field | Description of source field |
|---|---|---|
| partyRoleType | NA | Set to "Customer" |
| id | Customer | Customer id |
| name | OrganizationBPName1 | name of the organization |
| party | NA | Customer details |
| party.id | Customer | Customer id |
| party.salutation | NA | Customer salutation |
| party.personName | FirstName and LastName | Customers full name |
| party.firstName | FirstName | Customers first name |
| party.lastName | LastName | Customers last name |
| party.birthDate | BirthDate | Customers DOB |
| party.partyType | NA | set to "Individual" |
| party.contactPoints | NA | Customer's address details |
| party.partyRole | to_BusinessPartnerRole | Customer's Roles |
| party.partyRelatedParty | to_BPRelationship | Customer's Relationships |
| party.accountOrgUnit | YY1_SME_OrgUnit_RTL_bus | Customer's Organization Unit Relationship |
| party.users | to_BusinessPartnerContact | Customer's Contacts Relationship |
| externalIds.id | NA | externalId id |
| externalIds.externalId | BusinessPartnerIDByExtSystem | External Id |
| externalIds.externalIdType | NA | set to "MDM" |
| externalIds.statusLastChangedDate | LastChangeDate and LastChangeTime | Customer last modified datetime |
| externalIds.status | NA | set to "VALID" |
| auditInfo.createdDate | CreationDate and CreationTime | Customer creation date time in SAP |
| auditInfo.createdBy | CreatedByUser | Customer created by |
| auditInfo.updatedDate | LastChangeDate and LastChangeTime | Customer last modified datetime |
| auditInfo.updatedBy | LastChangedUser | Last modified by |
| auditInfo.isDeleted | NA | Is customer deleted |
| customerNumber | BusinessPartner | Customer id |
| customerStatus | NA | set to "ACTIVE" |
| originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | AccountTemplate |
| primaryAccount | YY1_SME_ParentID_RTL_bus | ParendId |