The DM42S table in SAP ERP or S/4HANA stores DM Relationship data. There are total 17 fields in DM42S table. The DM Relationship table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DM42S table. It is in DM: Data Modeler (new) and SIMO (old) (SDUM) ABAP package and is part of the Data Modeler (BC-DWB-TOO-DMO) module.
SAP DM42S Table Fields
Following is the list of fields that are available in SAP DM42S table. The primary key fields of the table are ENTIDTO (Target entity type), AS4LOCAL (Activation State of Repository Object), ENTIDFROM (Start entity type), EBROLNR (Relationship role).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| ENTIDTO | Target entity type | UDENTITO | DM02L | CHAR (26) |
| AS4LOCAL | Activation State of Repository Object | AS4LOCAL | CHAR (1) | |
| ENTIDFROM | Start entity type | UDENTIFR | DM02L | CHAR (26) |
| EBROLNR | Relationship role | UDEBROLNR | CHAR (1) | |
| FLG_DEF | Flag: documentation object exists | UDFLGDOC | CHAR (1) | |
| FLG_COM | Flag: documentation object exists | UDFLGDOC | CHAR (1) | |
| EBVAR | Temporary reference for relationships | UDRELREST | CHAR (1) | |
| EBTYP | Relationship type | UDRELTYPE | CHAR (1) | |
| CARD1 | Cardinality of a relationship | UDCDLEFT | CHAR (2) | |
| CARD2 | Cardinality of a relationship | UDCDRIGHT | CHAR (2) | |
| FSTUSER | Created by | UDFUSER | CHAR (12) | |
| FSTDATE | Date on which the record was created | UDFDATE | DATS (8) | |
| FSTTIME | Created At | UDFTIME | TIMS (6) | |
| LSTUSER | Changed by | UDLUSER | CHAR (12) | |
| LSTDATE | Changed on | UDLDATE | DATS (8) | |
| LSTTIME | Last Changed At | UDLTIME | TIMS (6) | |
| LOESCHZ | Deletion Indicator | UDLOEKZ | CHAR (1) |
