Importing Master Data

Your company’s master data is the basis for calculating your corporate and product footprints. It contains the essential information about your company such as plants, products, and suppliers.

Note

For more information, including a a list with descriptions of all master data entities, refer to the SAP Help portal at: https://help.sap.com/docs/sustainability-footprint-management/application-help-for-corporate-and-products/master-data-entities.

Note

The basis for the calculation of emission data is the master and transactional data replication from the ERP backend system. This data contains the essential information of all supply chain and production activities. The data can be imported from SAP S/4HANA Cloud and SAP S/4HANA (2021 and later) through direct integration. Directly integrate from any ERP through public APIs at:https://api.sap.com/package/SAPProductFootprintManagement/rest (this requires IT project) and from any source through Excel-file upload.

The Import Master Data app allows users to select a source system for importing master data entities. The default source system is SAP S/4HANA. However, you can choose other systems if connected. Configuration options control the visibility of specific master data entities. After configuration, you can initiate import requests for every master data entity. Those requests trigger a live replication from the source system, pulling the data into SAP Sustainability Footprint Management.

To import Excel files, you can download the templates for the respective master data object directly in the app. You can then upload the prepared templates and make the data visible. The app also automatically checks the consistency status, referring to the completeness of the imported master data information. If inconsistencies occur, they show up. You can check and correct the data in the source system or the uploaded file.

Note

For more details, check Using the Import Master Data Application in the SAP Help portal at: https://help.sap.com/docs/sustainability-footprint-management/application-help-for-corporate-and-products/using-import-master-data-application.

Besides the master data, you must import the business transactional data into the system. You do this through the Import Business Transactions app. The data represents transactions on an aggregated level that occurred during the defined period in the ERP source system, such as goods receipts, goods issues, transfers, and returns. For a complete list of all entities with descriptions, refer to Business Transaction Entities in the SAP Help portal at: https://help.sap.com/docs/sustainability-footprint-management/application-help-for-corporate-and-products/business-transaction-entities.

The import and replication are triggered similarly to the master data, through connection to SAP S/4HANA, S/4HANA Cloud, another connected ERP system, or through file upload. Each import is done for a specific inventory scope and a specific period, usually monthly. The data is also automatically validated for consistency.

This information about transactions that happened during a certain period in the backend system is the basis for the CO2e emission calculation.

Note

For more information, refer to Using the Import Business Transactions Application in the SAP Help portal at:

https://help.sap.com/docs/sustainability-footprint-management/application-help-for-corporate-and-products/using-import-business-transactions-application