Data Mapping
This function enables you to perform mapping between list data and the SAP Business Partner structure according to the mapping rules that you have defined in the mapping format.
This function is also applicable for external lists created for high-volume data and here the mapping happens between list data and marketing prospect data record.
You have executed the External List Upload
step or selected the step for execution.
To map the data, choose the Map Data
step and determine the start dates.
Once this step has been executed, you can see the successfully mapped records using Display Show Lists
.
Errors may occur in the process due to erroneous external data, system-related problems and incorrect mapping format.
Errors occurring during the execution of the Map Data
step are logged. If errors are logged, the traffic light next to Map
Data
is red and a hyperlink is available. Error details can be viewed by clicking the hyperlink and subsequently corrected.
If no active implementation is located for the mapping format, the system uses the default implementation. If you have enhanced the structure fields in the default implementation, then you must ensure that the length of the field name does not exceed 25 characters. This is because five characters are needed to build a prefix like PERS_.
In a B2B context, if the fields for organization and person are mapped, more than one contact person for an organization can be created later on in the step Maintain Business Partners
. In this case the data file must have the same number of records for an organization
as the number of contact persons. Each of these B2B records must contain information about the same organization as well as information about different contact persons.
Example
Here is an example of the file content:
Entry 1: Organisation A, Person A-1
Entry 2: Organisation A, Person A-2
Entry 3: Organisation B, Person B-1
Entry 4: Organisation C, Person B-1
During mapping, the content of the fields ORG_NAME1, ORG_NAME2, ORG_NAME3, ORG_CITY, ORG_POSTL_COD1, POSTL_COD2, and ORG_STREET are used by the system to determine identical organizations within the list. The content of these fields must be identical for all records that belong to one organization.
Note
While working with external lists for business partners, the next step is Postal Check and while working with marketing prospects, the next step is Marketing Prospect Creation.