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.
Objects extracted
The SAP ERP catalog source extracts metadata from the following assets in SAP S/4HANA and SAP ECC source systems:
•Packages
Includes subpackages and assets in subpackages.
•Classes in active state
•Data Elements in active state
•Data Sources built on tables, views and function modules
•Domains in active state
•RFC function modules and function modules used in a data source
•Executable programs in active state
•RFC Connections in active state
•Tables in active state such as transparent tables, cluster tables, and pool tables
•Fields
•Transaction codes in active state
•Views such as database views, CDS views, append views, and external views
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.
Data profiling for SAP ERP objects
Prerequisites
- Use the SAP Table connector to run data profiles and data quality tasks on SAP ERP objects. Create an SAP Table connection in Informatica Intelligent Cloud Services 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 configuring SAP Table connection in Administrator and installing 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 running 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
You can run data profiling on all rows in the metadata extracted from SAP S/4HANA and SAP ECC source systems.
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 Data Lineage in the Working With Assets help.