You can use the SAP ERP catalog source to extract metadata from an SAP ERP source system.
SAP Enterprise Resource Planning (ERP) is a platform that incorporates the key business functions of an organization. Use this catalog source to extract metadata from SAP ERP Central Component (ECC) or SAP S/4HANA source systems.
Extracted metadata
You can extract specific metadata from an SAP ERP source system with an SAP ERP catalog source.
The SAP ERP catalog source extracts metadata from the following assets in SAP S/4HANA and SAP ECC source systems:
•Classes in active state
•Data Elements in active state
•Data Sources built on tables, views and function modules
•Domains in active state
•Executable programs in active state
•Fields
•Packages
Includes subpackages and assets in subpackages.
•RFC Connections in active state
•RFC function modules and function modules used in a data source
•Tables in active state such as transparent tables, cluster tables, and pool tables
•Transaction codes in active state
•Views such as database views, CDS views, append views, and external views
Note:
If an incremental metadata extraction job includes a view, it extracts the corresponding tables even if the tables were extracted in previous runs.
Data profiling for SAP ERP objects
Configure data profiling to run profiles on the metadata extracted from a SAP ERP source system. Use the SAP Table connector to run data profiles and data quality tasks on SAP ERP objects. You can view the profiling statistics in Data Governance and Catalog.
Perform the following prerequisite tasks:
•Create an SAP Table connection in IDMC Administrator.
•To read data from SAP tables, install the SAP Table connection transport files from the Secure Agent directory to the SAP system.
For information about the configuration of the SAP Table connection in Administrator and the installation of transport files to read from SAP tables, see SAP Connector in the Data Integration Connectors help.
Configure data profiling to run profiles on metadata extracted from SAP S/4HANA and SAP ECC source systems.
You can run data profiles on the following SAP ERP objects:
•Table
•View
Note:
You can run data profiles on database views and CDS views.
After you run the catalog source job, you can view the profiling statistics in Data Governance and Catalog.
The data profiling task runs profiles on the following data types for SAP ERP objects:
•ACCP
•CHAR
•CLNT
•CUKY
•CURR
•DATS
•DEC
•D16D
•D16R
•D34D
•D34R
•FLTP
•INT2
•INT4
•LANG
•LCHR
•LRAW
•NUMC
•QUAN
•SSTRING
•STRING
•STRU
•TIMS
•UNIT
•RAW
•RAWSTRING
For information about rules and guidelines for SSTRING, STRING, and RAWSTRING data types, see SAP Connector in the Data Integration-Free and PayGo help.
Sampling type
Determine the sample rows on which you want to run a data profiling task.
You can choose one of the following sampling types:
- All Rows
- Limit N Rows
Compatible connectors
Before you configure an SAP ERP catalog source, you must connect to the SAP ERP source system.
Use one of the following connectors to connect to SAP ERP source systems:
•SAP Bapi
•SAP Table. For data profiling.
For information about configuring a connection, see Connections.