Create a Data Mapping Definition with SAP Datasphere as Source

Create a data mapping definition with SAP Datasphere as source.

Prerequisites

To use SAP Datasphere as a source instance, you must create a dedicated destination in the SAP BTP Cockpit, which will let the application know the location of the system you want to extract data from. For more information, see Configure Destinations for SAP Datasphere as Source Instance for Data Mapping.

Context

Procedure

  1. From the Data Mapping Definitions page, choose the Create button.
  2. In the General Information section, enter a name and a description.
  3. Optionally, select a parent definition. For more information, see Create Hierarchies in Data Mapping Definitions.
  4. Optionally, choose the Runnable from Packages option. For more information, see Specific Mapping File Structure for Jobs Runnable from Packages and Run a Job from Within a Package.
  5. In the Source Definition section, select the Source: SAP Datasphere.
  6. In the Source Instance Used field, select an instance from the available instances retrieved from the SAP BTP Cockpit.
  7. In the Space field, select the space you want to connect to.

    A space is a workspace that holds data models and views.

  8. In the Asset field, select the asset you want to use.

    An asset is a specific data set or object inside a space.

  9. In the Source Filters section, you can choose to apply filters on several dimensions.
    1. In the Field column, select a dimension for which you want to restrict values.
    2. In the Operator column, first select Include or Exclude, then a comparison operator such as Equal to or Greater than.
    3. In the Value column, specify a or several values depending on the source field selected.
  10. In the Mapping File section, select the mapping file you have created.

    If the mapping file contains errors, they are displayed in the Errors section.

    You can download and correct your mapping file in Excel by choosing the Download Mapping File link. After you have corrected the errors, upload the mapping file once again.
  11. In the Import Options section, select the different import options you want to apply. For more information, see Import Options.
  12. In the Traceability section, choose if you want to force generate a traceability log file for each job run, or upon request when the job is run. For more information, see Force Generate Traceability Logs.
  13. Choose Including Mapping File Sheets if you want the different mapping file sheets of your data mapping file to be displayed in the traceability log. For more information, see Traceability Logs.
  14. In the Access Restrictions section, you can optionally choose to restrict access to your mapping definition by selecting specific dimension values. Once the restriction set, the application compares these dimension values to the global parameters of the user. If the global parameters of the user are included in the access restrictions of the definition, the definition is visible to the user. For more information, see Define Access Restrictions.
  15. Choose Create.

Next Steps

For more information, you can consult the following blog post on the SAP Community: https://community.sap.com/t5/financial-management-blog-posts-by-sap/accelerating-financial-close-integrating-sap-datasphere-with-sap-group/ba-p/14288032Information published on SAP site.
Related Information