RCG SAP ECC 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.
| Module | Description |
|---|---|
| bapi-create-customer-request | Create Customer Mapping for SAP System |
| bapi-get-list-of-customers-request | Retrieve Customers for SAP System request |
| bapi-retrieve-customer-by-customer-id-request | Retrive Customer by Customer Id |
| bapi-retrieve-customer-by-customer-id-response | Query Customer from SAP System |
| bapi-retrieve-customer-by-date-range-request | Retrieve Customers by Date range from SAP System request |
| bapi-retrieve-customer-by-date-range-response | Lookup Customer using date range from SAP System |
| bapi-retrieve-customer-by-email-request | Retrieve Customer by Customer email for SAP System request |
| bapi-retrieve-customer-by-master-id-request | Retrieve Customer by Customer email for SAP System request |
| bapi-retrieve-customer-by-master-id-response | Query Customer from SAP System |
| bapi-retrieve-customers-by-email-response | Query Customer from SAP System |
| bapi-update-customer-request | Update Customer Mapping for SAP System |
| bapi-update-customer-response | Update Customer Response mapping |
bapi-create-customer-request
Create Customer Mapping for SAP System
Source:
./src/main/resources/dwl/bapi-create-customer-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Create Customer | CIM - Customer | Description |
|---|---|---|
| IV_CATEGORY | partyType | The partyType 1 for Individual 2 for organization and 3 for group |
| IV_FIRSTNAME | party.firstName | The firstname of the Individual |
| IV_LASTNAME | party.lastName | The lastname of the Individual |
| NAME1 | name | The name of the Organization |
| IV_EMAIL | party.contactPointEmail.emailAddress | The email address associated with ContactPointEmail of the Individual |
| IV_ADDRESS1 | party.contactPointAddress.addressLine1 | The address line 1 associated with ContactPointAddress of the Individual |
| IV_ADDRESS2 | party.contactPointAddress.addressLine2 | The address line 2 associated with ContactPointAddress of the Individual - default value "NA" |
| IV_CITY | party.contactPointAddress.cityName | The city name associated with ContactPointAddress of the Individual |
| IV_STATE | "TX" | The state name of the Individual - Set as "TX" |
| IV_COUNTRY | "US" | The country name of the Individual - Set as "US" |
| IV_POSTALCODE | party.contactPointAddress.postalCodeText | The postal code associated with ContactPointAddress of the Individual |
| IV_TELNO | party.contactPointPhone.telephoneNumber | The telephone number associated with ContactPointPhone of the Individual |
| IV_MASTER_ID | party.externalIdType.externalId | A unique identifier assigned to the customer in MDM system |
bapi-get-list-of-customers-request
Retrieve Customers for SAP System request
Source:
./src/main/resources/dwl/bapi-get-list-of-customers-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Create Customer | CIM - Customer | Description |
|---|---|---|
| SIGN | sign | Default to I |
| OPTION | option.Default to BT | |
| LOW | customerStartId | Customers Start Id |
| HIGH | customerStartId | Customers End Id |
bapi-retrieve-customer-by-customer-id-request
Retrive Customer by Customer Id
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-customer-id-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Create Customer | CIM - Customer | Description |
|---|---|---|
| IV_SAP_CUSTOMER | CustomerId | SAP Customer Id |
bapi-retrieve-customer-by-customer-id-response
Query Customer from SAP System
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-customer-id-response.dwl
Mapping Tables
Maps SAP ZBAPI_CUST_QUERY_V3 function Response to CIM Customer format.
| CIM - Customer | SAP | Description |
|---|---|---|
| id | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The identifier of the customer in SAP system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| auditInfo.createdDate | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.CREATION_TIMESTAMP | Timestamp of when the entity was created " |
| auditInfo.createdBy | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.updatedDate | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.LAST_UPDATE_TIMESTAMP | Timestamp of wÍhen the entity was last updated" |
| auditInfo.updatedBy | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.isDeleted | false | Indicates whether or not the entity has been soft-deleted - default as false |
| party[0].id | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The identifier of the customer in SAP system |
| party[0].party[0]Type | "Individual" | The party type - Set as "Individual" |
| party[0].salutation | "" | The Salutation of the customer - Set as "" |
| party[0].firstName | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.FIRSTNAME | The firstname of the Customer in SAP |
| party[0].personName | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.FIRSTNAME ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.LASTNAME | The person name of the Customer |
| party[0].lastName | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.LASTNAME | The last name of the customer |
| party[0].externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| party[0].externalIds[0].externalId | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| party[0].externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| party[0].contactPoints[0].contactPointType | "ContactPointPhone" | The type of contact point - Set as "ContactPointPhone" |
| party[0].contactPoints[0]telephoneNumber | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.TELNO | The telephone number of the Customer in SAP |
| party[0].contactPoints[0]id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[0].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[1].contactPointType | "ContactPointEmail" | The type of contact point - Set as "ContactPointEmail" |
| party[0].contactPoints[1].emailAddress | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.EMAIL | The email address of the customer in SAP |
| party[0].contactPoints[1].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[1].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[2].contactPointType | "ContactPointAddress"] | The type of contact point - Set as "ContactPointAddress" |
| party[0].contactPoints[2].addressLine1 | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.ADDRESS1 | The address line1 of the customer in SAP |
| party[0].contactPoints[2].addressLine2 | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.ADDRESS2 | The address line 2 of the customer in SAP |
| party[0].contactPoints[2].cityName | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CITY | The City of the customer in SAP |
| party[0].contactPoints[2].postalCodeText | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.POSTALCODE | The postal code of he customer in SAP |
| party[0].contactPoints[2].stateProvinceName | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.STATE | The State province of the customer in SAP |
| party[0].contactPoints[2].countryName | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.COUNTRY | The Country name of the customer in SAP |
| party[0].contactPoints[2].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[2].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| customerStatus | "ACTIVE" | The status of the Customer - Set as "Active" |
| customerNumber | ZBAPI_CUST_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The customer number stored in SAP |
bapi-retrieve-customer-by-date-range-request
Retrieve Customers by Date range from SAP System request
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-date-range-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Create Customer | CIM - Customer | Description |
|---|---|---|
| IV_BEGIN_DATE | StartDate | Start date to retrieve customers |
| IV_END_DATE | EndDate.End Date to retrieve customers | |
| IV_BEGIN_TIME | StartTime | Start Time to retrieve Customer with the combination of IV_BEGIN_DATE |
| IV_END_TIME | EndTime | End Time to retrieve Customer with the combination of IV_END_DATE |
bapi-retrieve-customer-by-date-range-response
Lookup Customer using date range from SAP System
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-date-range-response.dwl
Mapping Tables
Maps SAP ZBAPI_CUSTOMER_CD_V3 function response to CIM Customer format.
| CIM - Customer | SAP | DescriptionFor each item in ZBAPI_CUSTOMER_CD_V3.export.ET_item |
|---|---|---|
| id | item.CUSTOM_FIELDS.MASTER_ID | The identifier of the customer in SAP system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| auditInfo.createdDate | item.CONTROL_DATA.CREATION_TIMESTAMP | Timestamp of when the entity was created " |
| auditInfo.createdBy | item.CONTROL_DATA.CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.updatedDate | item.CONTROL_DATA.LAST_UPDATE_TIMESTAMP | Timestamp of when the entity was last updated" |
| auditInfo.updatedBy | item.CONTROL_DATA.UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.isDeleted | false | Indicates whether or not the entity has been soft-deleted - default as false |
| party[0].id | item.CUSTOM_FIELDS.MASTER_ID | The identifier of the customer in SAP system |
| party[0].party[0]Type | "Individual" | The party type - Set as "Individual" |
| party[0].salutation | "" | The Salutation of the customer - Set as "" |
| party[0].firstName | item.FIRSTNAME | The firstname of the Customer in SAP |
| party[0].personName | item.FIRSTNAME item.LASTNAME | The person name of the Customer |
| party[0].lastName | item.LASTNAME | The last name of the customer |
| party[0].externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| party[0].externalIds[0].externalId | item.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| party[0].externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| party[0].contactPoints[0].contactPointType | "ContactPointPhone" | The type of contact point - Set as "ContactPointPhone" |
| party[0].contactPoints[0]telephoneNumber | item.TELNO | The telephone number of the Customer in SAP |
| party[0].contactPoints[0]id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[0].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[1].contactPointType | "ContactPointEmail" | The type of contact point - Set as "ContactPointEmail" |
| party[0].contactPoints[1].emailAddress | item.EMAIL | The email address of the customer in SAP |
| party[0].contactPoints[1].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[1].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[2].contactPointType | "ContactPointAddress" | The type of contact point - Set as "ContactPointAddress" |
| party[0].contactPoints[2].addressLine1 | item.ADDRESS1 | The address line1 of the customer in SAP |
| party[0].contactPoints[2].addressLine2 | item.ADDRESS2 | The address line 2 of the customer in SAP |
| party[0].contactPoints[2].cityName | item.CITY | The City of the customer in SAP |
| party[0].contactPoints[2].postalCodeText | item.POSTALCODE | The postal code of he customer in SAP |
| party[0].contactPoints[2].stateProvinceName | item.STATE | The State province of the customer in SAP |
| party[0].contactPoints[2].countryName | item.COUNTRY | The Country name of the customer in SAP |
| party[0].contactPoints[2].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[2].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | item.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| customerStatus | "ACTIVE" | The status of the Customer - Set as "Active" |
| customerNumber | item.CUSTOM_FIELDS.SAP_CUSTOMER | The customer number stored in SAP |
bapi-retrieve-customer-by-email-request
Retrieve Customer by Customer email for SAP System request
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-email-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Create Customer | CIM - Customer | Description |
|---|---|---|
| IV_E_MAIL | emailAddress | Customer Email Address |
bapi-retrieve-customer-by-master-id-request
Retrieve Customer by Customer email for SAP System request
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-master-id-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Create Customer | CIM - Customer | Description |
|---|---|---|
| IV_MASTER_ID | externalId | unique Global Id |
bapi-retrieve-customer-by-master-id-response
Query Customer from SAP System
Source:
./src/main/resources/dwl/bapi-retrieve-customer-by-master-id-response.dwl
Mapping Tables
Maps SAP ZBAPI_QUERY_V3 function response to CIM Customer format.
| CIM - Customer | SAP | Description |
|---|---|---|
| id | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The identifier of the customer in SAP system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| auditInfo.createdDate | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.CREATION_TIMESTAMP | Timestamp of when the entity was created " |
| auditInfo.createdBy | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.updatedDate | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.LAST_UPDATE_TIMESTAMP | Timestamp of when the entity was last updated" |
| auditInfo.updatedBy | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.isDeleted | false | Indicates whether or not the entity has been soft-deleted - default as false |
| party[0].id | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The identifier of the customer in SAP system |
| party[0].party[0]Type | "Individual" | The party type - Set as "Individual" |
| party[0].salutation | "" | The Salutation of the customer - Set as "" |
| party[0].firstName | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.FIRSTNAME | The firstname of the Customer in SAP |
| party[0].personName | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.FIRSTNAME ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.LASTNAME | The person name of the Customer |
| party[0].lastName | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.LASTNAME | The last name of the customer |
| party[0].externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| party[0].externalIds[0].externalId | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| party[0].externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| party[0].contactPoints[0].contactPointType | "ContactPointPhone" | The type of contact point - Set as "ContactPointPhone" |
| party[0].contactPoints[0].telephoneNumber | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.TELNO | The telephone number of the Customer in SAP |
| party[0].contactPoints[0]id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[0].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[1].contactPointType | "ContactPointEmail" | The type of contact point - Set as "ContactPointEmail" |
| party[0].contactPoints[1].emailAddress | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.EMAIL | The email address of the customer in SAP |
| party[0].contactPoints[1].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[1].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[2].contactPointType | "ContactPointAddress" | The type of contact point - Set as "ContactPointAddress" |
| party[0].contactPoints[2].addressLine1 | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.ADDRESS1 | The address line1 of the customer in SAP |
| party[0].contactPoints[2].addressLine2 | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.ADDRESS2 | The address line 2 of the customer in SAP |
| party[0].contactPoints[2].cityName | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CITY | The City of the customer in SAP |
| party[0].contactPoints[2].postalCodeText | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.POSTALCODE | The postal code of he customer in SAP |
| party[0].contactPoints[2].stateProvinceName | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.STATE | The State province of the customer in SAP |
| party[0].contactPoints[2].countryName | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.COUNTRY | The Country name of the customer in SAP |
| party[0].contactPoints[2].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[2].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| customerStatus | "ACTIVE" | The status of the Customer - Set as "Active" |
| customerNumber | ZBAPI_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The customer number stored in SAP |
bapi-retrieve-customers-by-email-response
Query Customer from SAP System
Source:
./src/main/resources/dwl/bapi-retrieve-customers-by-email-response.dwl
Mapping Tables
Maps SAP ZBAPI_ADDR_QUERY_V3 function response to CIM Customer format.
| CIM - Customer | SAP | Description |
|---|---|---|
| id | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The identifier of the customer in SAP system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| auditInfo.createdDate | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.CREATION_TIMESTAMP | Timestamp of when the entity was created " |
| auditInfo.createdBy | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.updatedDate | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.LAST_UPDATE_TIMESTAMP | Timestamp of when the entity was last updated" |
| auditInfo.updatedBy | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CONTROL_DATA.UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.isDeleted | false | Indicates whether or not the entity has been soft-deleted - default as false |
| party[0].id | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The identifier of the customer in SAP system |
| party[0].party[0]Type | "Individual" | The party type - Set as "Individual" |
| party[0].salutation | "" | The Salutation of the customer - Set as "" |
| party[0].firstName | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.FIRSTNAME | The firstname of the Customer in SAP |
| party[0].personName | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.FIRSTNAME ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.LASTNAME | The person name of the Customer |
| party[0].lastName | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.LASTNAME | The last name of the customer |
| party[0].externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| party[0].externalIds[0].externalId | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| party[0].externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| party[0].contactPoints[0].contactPointType | "ContactPointPhone" | The type of contact point - Set as "ContactPointPhone" |
| party[0].contactPoints[0]telephoneNumber | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.TELNO | The telephone number of the Customer in SAP |
| party[0].contactPoints[0]id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[0].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[1].contactPointType | "ContactPointEmail" | The type of contact point - Set as "ContactPointEmail" |
| party[0].contactPoints[1].emailAddress | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.EMAIL | The email address of the customer in SAP |
| party[0].contactPoints[1].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[1].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[2].contactPointType | "ContactPointAddress" | The type of contact point - Set as "ContactPointAddress" |
| party[0].contactPoints[2].addressLine1 | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.ADDRESS1 | The address line1 of the customer in SAP |
| party[0].contactPoints[2].addressLine2 | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.ADDRESS2 | The address line 2 of the customer in SAP |
| party[0].contactPoints[2].cityName | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CITY | The City of the customer in SAP |
| party[0].contactPoints[2].postalCodeText | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.POSTALCODE | The postal code of he customer in SAP |
| party[0].contactPoints[2].stateProvinceName | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.STATE | The State province of the customer in SAP |
| party[0].contactPoints[2].countryName | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.COUNTRY | The Country name of the customer in SAP |
| party[0].contactPoints[2].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[2].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.MASTER_ID | The external identifier of the Customer stored in SAP |
| externalIds[0].externalIdType | "MDM" | The external identifier type - Set as "MDM" |
| customerStatus | "ACTIVE" | The status of the Customer - Set as "Active" |
| customerNumber | ZBAPI_ADDR_QUERY_V3.export.ES_CUSTOMERDATA.CUSTOM_FIELDS.SAP_CUSTOMER | The customer number stored in SAP |
bapi-update-customer-request
Update Customer Mapping for SAP System
Source:
./src/main/resources/dwl/bapi-update-customer-request.dwl
Mapping Tables
Maps CIM Customer to SAP Customer format. The Individual is the associated Party of the Customer object in CIM.
| SAP - Update Customer | CIM - Customer | Description |
|---|---|---|
| IV_CATEGORY | partyType | The partyType 1 for Individual 2 for organization and 3 for group |
| IV_FIRSTNAME | party.firstName | The firstname of the Individual |
| IV_LASTNAME | party.lastName | The lastname of the Individual |
| NAME1 | name | The name of the Organization |
| IV_EMAIL | party.contactPointEmail.emailAddress | The email address associated with ContactPointEmail of the Individual |
| IV_ADDRESS1 | party.contactPointAddress.addressLine1 | The address line 1 associated with ContactPointAddress of the Individual |
| IV_ADDRESS2 | party.contactPointAddress.addressLine2 | The address line 2 associated with ContactPointAddress of the Individual -Default value "NA" |
| IV_CITY | party.contactPointAddress.cityName | The city name associated with ContactPointAddress of the Individual |
| IV_STATE | "TX" | The state name of the Individual - Set as "TX" |
| IV_COUNTRY | "US" | The country name of the Individual - Set as "US" |
| IV_POSTALCODE | party.contactPointAddress.postalCodeText | The postal code associated with ContactPointAddress of the Individual |
| IV_TELNO | party.contactPointPhone.telephoneNumber | The telephone number associated with ContactPointPhone of the Individual |
| IV_CUSTOMER | id | The unique identifier of the customer in SAP system |
| IV_MASTER_ID | party.externalIdType.externalId | A unique identifier assigned to the customer in MDM system |
bapi-update-customer-response
Update Customer Response mapping
Source:
./src/main/resources/dwl/bapi-update-customer-response.dwl
Mapping Tables
Maps SAP ZBAPI_CUST_QUERY function response to CIM Customer format.
| CIM - Customer | SAP | Description |
|---|---|---|
| id | ZBAPI_CUSTOMER_V3."import".IV_CUSTOMER | The identifier of the customer in SAP system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| auditInfo.createdDate | ZBAPI_CUSTOMER_V3.export.ES_CONTROL_DATA.CREATION_TIMESTAMP | Timestamp of when the entity was created " |
| auditInfo.createdBy | ZBAPI_CUSTOMER_V3.export.ES_CONTROL_DATA.CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.updatedDate | ZBAPI_CUSTOMER_V3.export.ES_CONTROL_DATA.LAST_UPDATE_TIMESTAMP | Timestamp of wÍhen the entity was last updated" |
| auditInfo.updatedBy | ZBAPI_CUSTOMER_V3.export.ES_CONTROL_DATA.UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.isDeleted | false | Indicates whether or not the entity has been soft-deleted - default as false |
| party[0].id | payload.ZBAPI_CUSTOMER_V3."import".IV_CUSTOMER | The identifier of the customer in SAP system |
| party[0].party[0]Type | "Individual" | The party type - Set as "Individual" |
| party[0].salutation | "" | The Salutation of the customer - Set as "" |
| party[0].firstName | ZBAPI_CUSTOMER_V3."import".IV_FIRSTNAME | The firstname of the Customer in SAP |
| party[0].personName | if (ZBAPI_CUSTOMER_V3."import".IV_FIRSTNAME != null and ZBAPI_CUSTOMER_V3."import".IV_LASTNAME != null) (ZBAPI_CUSTOMER_V3."import".IV_FIRSTNAME ++ " " ++ ZBAPI_CUSTOMER_V3."import".IV_LASTNAME) else ZBAPI_CUSTOMER_V3."import".IV_FIRSTNAME | The person name of the Customer |
| party[0].lastName | ZBAPI_CUSTOMER_V3."import".IV_LASTNAME | The last name of the customer |
| party[0].externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| party[0].externalIds[0].externalId | ZBAPI_CUSTOMER_V3."import".IV_MASTER_ID | The external identifier of the Customer stored in SAP |
| party[0].externalIds[0].externalIdType | ["MDM"] | The external identifier type - Set as "MDM" |
| party[0].contactPoints[0].contactPointType | ["ContactPointPhone"] | The type of contact point - Set as ["ContactPointPhone"] |
| party[0].contactPoints[0]telephoneNumber | ZBAPI_CUSTOMER_V3."import".IV_TELNO | The telephone number of the Customer in SAP |
| party[0].contactPoints[0]id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[0].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[1].contactPointType | ["ContactPointEmail"] | The type of contact point - Set as ["ContactPointEmail"] |
| party[0].contactPoints[1].emailAddress | ZBAPI_CUSTOMER_V3."import".IV_EMAIL | The email address of the customer in SAP |
| party[0].contactPoints[1].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[1].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| party[0].contactPoints[2].contactPointType | ["ContactPointAddress"] | The type of contact point - Set as ["ContactPointAddress"] |
| party[0].contactPoints[2].addressLine1 | ZBAPI_CUSTOMER_V3."import".IV_ADDRESS1 | The address line1 of the customer in SAP |
| party[0].contactPoints[2].addressLine2 | ZBAPI_CUSTOMER_V3."import".IV_ADDRESS2 | The address line 2 of the customer in SAP |
| party[0].contactPoints[2].cityName | ZBAPI_CUSTOMER_V3."import".IV_CITY | The City of the customer in SAP |
| party[0].contactPoints[2].postalCodeText | ZBAPI_CUSTOMER_V3."import".IV_POSTALCODE | The postal code of he customer in SAP |
| party[0].contactPoints[2].stateProvinceName | ZBAPI_CUSTOMER_V3."import".IV_STATE | The State province of the customer in SAP |
| party[0].contactPoints[2].countryName | ZBAPI_CUSTOMER_V3."import".IV_COUNTRY | The Country name of the customer in SAP |
| party[0].contactPoints[2].id | null | The identifier of the contact point stored in SAP - set as null |
| party[0].contactPoints[2].activeFromDate | now() | The Date from which the contact point is active - Set as current date |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | payload.ZBAPI_CUSTOMER_V3."import".IV_CC_CUSTOMER | The external identifier of the Customer stored in SAP |
| externalIds[0].externalIdType | ["MDM"]The external identifier type - Set as "MDM" | |
| customerStatus | "ACTIVE" | The status of the Customer - Set as "Active" |
| customerNumber | ZBAPI_CUSTOMER_V3."import".IV__CUSTOMER | The customer number stored in SAP |