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.
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 classification for SAP ERP objects
Configure data classification for SAP ERP catalog sources to classify and organize data in your organization.
You can choose one of the following options:
•Data Classification Rules. Choose from predefined or custom data classifications.
•Generated Data Classifications. CLAIRE automatically generates data classifications for the data elements.
Note:
SAP ERP source systems can contain ambiguous data with technical field names. To ensure that CLAIRE generates accurate data classifications, it uses the extracted
Business Name
attribute to generate data classifications.
You can view the data classification results in Data Governance and Catalog.
For more information about data classifications, see Data classification in the Administration help.
•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
Data Lineage
Lineage data is available for SAP ERP assets that connect to the following source systems:
•SAP Business Warehouse (BW)
•SAP BW/4HANA
The lineage for SAP ERP Central Component (ECC) and SAP S/4HANA source systems indicate the tables that relate to each other through primary keys and foreign keys. This is indicated by the labels 'PK' and 'FK'.
For more information about data lineage, see the Asset Discovery help.