SAP table MDOBLREL (Model Data: Relationship Types)
SAP table MDOBLREL has 1 primary key field being RELTYPE.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| RELTYPE | Relationship type | CHAR | 10 | 0 | OBLRELTYPE | ||
| ROLEA | Role That an Object Takes in the Relationship | CHAR | 10 | 0 | MDOBLROL | OBLROLTYPE | |
| ROLEB | Role That an Object Takes in the Relationship | CHAR | 10 | 0 | MDOBLROL | OBLROLTYPE | |
| CARDA | Role Cardinality | CHAR | 1 | 0 | OBLROLCARD | ||
| CARDB | Role Cardinality | CHAR | 1 | 0 | OBLROLCARD | ||
| DBTABLE | Table Name | CHAR | 30 | 0 | DD02L | TABNAME | |
| OWNER | User Name in User Master Record | CHAR | 12 | 0 | USR02 | XUBNAME | |
| CREATDATE | Date | DATS | 8 | 0 | DATE_ | ||
| MODIFIEDBY | User Name in User Master Record | CHAR | 12 | 0 | USR02 | XUBNAME | |
| MODIFDATE | Date | DATS | 8 | 0 | DATE_ | ||
| HASPROP | Specifies Whether a Relationship Type Has an Attribute | CHAR | 1 | 0 | OBLHASPROP | ||
| RELTYPE_O | Relationship type | CHAR | 4 | 0 | ORBRELTYP | BINRELTYP |
MDOBLREL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 MDOBLREL | DBTABLE | DD02L | SAP Tables | TABNAME |
| 0 MDOBLREL | DBTABLE | DD02L | SAP Tables | AS4LOCAL |
| 0 MDOBLREL | DBTABLE | DD02L | SAP Tables | AS4VERS |
| 1 MDOBLREL | MODIFIEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 0 MDOBLREL | OWNER | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 1 MDOBLREL | RELTYPE_O | ORBRELTYP | Object relationship binary link type | RELTYPE |
| 0 MDOBLREL | ROLEA | MDOBLROL | Model Data: Role Types | ROLETYPE |
| 1 MDOBLREL | ROLEB | MDOBLROL | Model Data: Role Types | ROLETYPE |