What does Atlan crawl from SAP ECC?
Atlan integrates with SAP ECC to crawl and map various asset types, helping you gain insights into structured business data. This page outlines the SAP ECC components that Atlan supports and how their properties are mapped.
Lineage
Atlan supports lineage for the following lineage:
- Asset Lineage - Table to View
- Column Level Lineage - Table Columns to View Columns Assets
Table relationships
Beyond lineage, Atlan captures the relationships that SAP declares between tables in the ABAP Dictionary. Each SAP table asset lists its related tables under the sapErpRelatedTables attribute, letting you move from a transactional table to the master data and text tables it depends on.
Atlan derives related tables from three ABAP Dictionary relationship types:
| Relationship type | What it captures | Example |
|---|---|---|
| Check table | A column validates its values using a master or value table. | The material number column in a plant data table checks the material master table, so the material master appears as a related table. |
| Foreign key | A foreign key that SAP declares between two tables. | A plant data table declares a foreign key to the plant master table. |
| Text table | The table that holds language-dependent descriptions for a base table. | The material description table is the text table for the material master, so it appears as a related table of the material master. |
Keep the following in mind when you work with table relationships:
- Relationships are bidirectional. Atlan stores each relationship once, and both tables show the other as a related table. You don't need to crawl the tables in a particular order.
- Atlan only links tables it has crawled. If a related table falls outside your component filters or selected asset types, Atlan omits that relationship rather than creating a link to an asset that doesn't exist in your catalog.
- Relationships apply to tables only. Views don't carry related tables.
Assets
Atlan extracts metadata from SAP ECC across different asset types, including:
- Components: Software modules providing specific functionalities.
- Tables: Structured storage for master data, transactions, and configurations.
- Views: Logical representations of data for efficient access.
- Columns: Data attributes within tables and views.
- ABAP programs: Custom scripts written for automation and processing.
- Function modules: Reusable logic blocks for ABAP programs and remote function calls.
- Transaction Codes: Shortcuts for executing SAP functions.
- Classes: Groups of customer-defined characteristics used to classify master data.
- Characteristics: Typed attribute definitions that belong to a class.
The following sections detail how each asset type is mapped in Atlan.
Components
SAP ECC components are modular software units that deliver specific business functions. These components form the foundation of SAP's enterprise applications, enabling functionalities such as finance, logistics, and human resources. Atlan maps Components from SAP ECC to its SapErpComponent asset type.
| Source property | Atlan property |
|---|---|
TEXT | name |
NAME | sapComponentName |
Tables
Tables in SAP ECC store structured business data, including master records, transactional details, and configuration settings. These tables form the foundation of SAP's data storage and retrieval system. Atlan maps Table from SAP ECC to its SapErpTable asset type.
| Source property | Atlan property |
|---|---|
TABNAME | name |
DDTEXT | description |
TABCLASS | sapErpTableType |
DEVCLASS | sapPackageName |
Column Count | sapFieldCount |
CONTFLAG | sapErpTableDeliveryClass |
AS4USER | sourceUpdatedBy |
AS4DATE | sourceUpdatedAt |
CHECKTABLE | sapErpRelatedTables |
For details on how Atlan derives sapErpRelatedTables, see Table relationships.
Views
Views provide a logical representation of data by combining information from one or more tables. They simplify data access and reporting by allowing users to work with pre-defined, structured datasets. Atlan maps View from SAP ECC to its SapErpView asset type.
| Source property | Atlan property |
|---|---|
VIEWNAME | name |
DDTEXT | description |
VIEWCLASS | sapErpViewType |
DEVCLASS | sapPackageName |
Column Count | sapFieldCount |
AS4USER | sourceUpdatedBy |
AS4DATE | sourceUpdatedAt |
Columns
Columns define individual data attributes within tables and views. Each column has a specific data type, length, and constraints, ensuring accurate data representation and integrity. Atlan maps Column from SAP ECC to its SapErpColumn asset type.
| Source property | Atlan property |
|---|---|
FIELDNAME | name |
TABNAME | sapErpTableName or sapErpViewName |
ROLLNAME | sapErpColumnDataElement |
DATATYPE | sapDataType |
INTTYPE | sapErpColumnLogicalDataType |
LENG | sapErpColumnLength |
DECIMALS | sapErpColumnDecimals |
KEYFLAG | sapErpColumnIsPrimary |
CHECKTABLE | sapErpColumnIsForeign |
NOTNULL | sapErpColumnIsMandatory |
DEVCLASS | sapPackageName |
POSITION | sapFieldOrder |
ABAP programs
Advanced Business Application Programming (ABAP) programs are scripts used to automate processes, manipulate data, and extend SAP functionalities. These programs are written in SAP's proprietary programming language. Atlan maps ABAP Programs from SAP ECC to its SapErpAbapProgram asset type.
| Source property | Atlan property |
|---|---|
PROGNAME | name |
TEXT | description |
SUBC | sapErpAbapProgramType |
DEVCLASS | sapPackageName |
CNAM | sourceCreatedBy |
CDAT | sourceCreatedAt |
UNAM | sourceUpdatedBy |
UDAT | sourceUpdatedAt |
Function modules
Function modules are reusable code blocks that perform predefined operations in SAP ECC. They can be called within ABAP programs or accessed remotely to execute business logic efficiently. Atlan maps Function Modules from SAP ECC to its SapErpFunctionModule asset type.
| Source property | Atlan property |
|---|---|
FUNCNAME | name |
STEXT | description |
FUNC_GROUP | sapErpFunctionModuleGroup |
Import Parameters | sapErpFunctionModuleImportParams |
Import Parameters Count | sapErpFunctionModuleImportParamsCount |
Export Parameters | sapErpFunctionModuleExportParams |
Export Parameters Count | sapErpFunctionModuleExportParamsCount |
Exception List | sapErpFunctionExceptionList |
Exception List Count | sapErpFunctionExceptionListCount |
DEVCLASS | sapPackageName |
Transaction Codes
Transaction codes (T-codes) provide quick access to specific SAP functions or screens. Users enter T-codes in the SAP command field to navigate directly to related operations, improving workflow efficiency. Atlan maps Transaction Code from SAP ECC to its SapErpTransactionCode asset type.
| Source property | Atlan property |
|---|---|
FUNCNAME | name |
STEXT | description |
DEVCLASS | sapPackageName |
Classes
SAP Classification models attributes that your organization defines rather than ones SAP ships as table columns. A class groups related characteristics and declares the kind of object it applies to, such as materials or equipment. Atlan catalogs each class from SAP ECC as an asset that holds its characteristics and links to the tables it classifies.
Atlan stores class assets using the SapErpTable type and identifies them with assetUserDefinedType set to Classes.
| Source property | Atlan property |
|---|---|
CLASS | name |
KSCHL | description |
KLART with class type description | sapErpTableType |
| Characteristic count | sapFieldCount |
VNAME | sourceUpdatedBy |
VDATU | sourceUpdatedAt |
| Classified object tables | sapErpRelatedTables |
A class asset links to the tables it applies to, combining the object table its class type declares with the tables of any objects that have actually been classified. From a master data table you can therefore see both the tables SAP relates it to and the classes applied to it, listed together under related tables. Classes are labeled Classes, so you can tell them apart from table relationships at a glance.
Characteristics
Characteristics are the typed attribute definitions that make up a class, each with a data type, length, and optional check table. Atlan catalogs each characteristic from SAP ECC as an asset within the class it belongs to.
Atlan stores characteristic assets using the SapErpColumn type and identifies them with assetUserDefinedType set to Characteristics.
| Source property | Atlan property |
|---|---|
ATNAM | name |
ATBEZ | description |
ATFOR with data type description | sapDataType |
ANZST | sapErpColumnLength |
ANZDZ | sapErpColumnDecimals |
ATERF | sapErpColumnIsMandatory |
ATPRT | sapErpColumnCheckTableName |
POSNR | sapFieldOrder |
CLASS | sapErpTableName |
Keep the following in mind when you work with classes and characteristics:
- Atlan creates one characteristic asset per class. A characteristic that belongs to three classes appears as three assets, one under each class, in the same way a column belongs to exactly one table.
- Component filters don't apply. SAP stores classes as customizing data rather than repository objects, so they carry no application component or package. Include and exclude component filters have no effect on classes and characteristics, and these assets carry no
sapPackageName. - Atlan only links tables it has crawled. If you select only Classes & Characteristics, Atlan creates no links to tables, because it hasn't crawled any tables to link to.