Data Load

Show TOC

The data to be consolidated can be loaded from SAP and non-SAP-systems using ETL tools (extract, transform, load).

Solutions offered by SAP are the following:

SLT System Landscape Transformation

Note
Recommended for existing SAP business suite models, as identical data models are used.

End of the note.
SAP HANA Studio Data provisioning including data transformation
CSV File (comma-separated values), for data down- and upload

Note
SAP recommends to import the data in the SAP HANA Studio into an interim table. In a second step the content of the interim tables can be loaded to the source tables using SQL or a custom ABAP report.

End of the note.

Prerequisites

The data has to be transformed into the SAP data structure before the data load can be performed.

Features

Settings for business partner, supplier, and customer

Load the data into the source tables for the BP data model listed below:

Table	Data
BUT000_SRC	Central BP data Note The table is required in all cases. End of the note.
BUT020_SRC BUT_ADRC_SRC	Address data Note The tables are required if address-related data is uploaded. End of the note.
KNA1_SRC	ERP customer data Note The table is required in case you use the customer data model End of the note.
LFA1_SRC	ERP vendor data Note The table is required in case you use the vendor data model End of the note.

Note Note

For a complete list of the tables run the Customizing activity under Start of the navigation path Master Data Governance Next navigation step Consolidation and Mass Processing Configure Process Models End of the navigation path , select the Business Object Type 147 and double click on Tables in the dialog structure.

For source tables the naming convention <table>_src applies.

End of the note.

Note Note

For the upload of data related to organizations, you can also use the vendor or the customer data model. In this case you have to run the report MDC_BP_TRANSFORM_SOURCE_DATA to transform the data to the BP data model after the source tables are filled. The report only supports the transformation of data related to organizations. It does not supports the transformation of person-related data.

End of the note.

Settings for material

Load the data into the source tables for the material data model listed below:

Table	Data
MARA_SRC	Central material data Note The table is required in all cases. End of the note.
MARC_SRC	Plant data for material Note The table is required if plant related data is uploaded. End of the note.
MVKE_SRC	Sales data for material Note The table is required if distribution chain related data is uploaded. End of the note.

Note Note

For a complete list of the tables run the Customizing activity under Start of the navigation path Master Data Governance Next navigation step Consolidation and Mass Processing Configure Process Models End of the navigation path , select the Business Object Type 194 and double click on Tables in the dialog structure.

For source tables the naming convention <table>_src applies.

End of the note.