SAP Table MDOBLREL
Model Data: Relationship Types
MDOBLREL (Model Data: Relationship Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MDOBLREL to other SAP tables.
MDOBLREL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RELTYPE | Relationship type | OBLRELTYPE | CHAR | 10 | 0 | |||||||||
| ROLEA | Role That an Object Takes in the Relationship | OBLROLTYPE | MDOBLROL | CHAR | 10 | 0 | ||||||||
| ROLEB | Role That an Object Takes in the Relationship | OBLROLTYPE | MDOBLROL | CHAR | 10 | 0 | ||||||||
| CARDA | Role Cardinality | OBLROLCARD | CHAR | 1 | 0 |
Possible values
|
||||||||
| CARDB | Role Cardinality | OBLROLCARD | CHAR | 1 | 0 |
Possible values
|
||||||||
| DBTABLE | Table Name | TABNAME | DD02L | CHAR | 30 | 0 | ||||||||
| OWNER | User Name in User Master Record | XUBNAME | USR02 | CHAR | 12 | 0 | ||||||||
| CREATDATE | Date | DATE_ | DATS | 8 | 0 | |||||||||
| MODIFIEDBY | User Name in User Master Record | XUBNAME | USR02 | CHAR | 12 | 0 | ||||||||
| MODIFDATE | Date | DATE_ | DATS | 8 | 0 | |||||||||
| HASPROP | Specifies Whether a Relationship Type Has an Attribute | OBLHASPROP | CHAR | 1 | 0 |
Possible values
|
||||||||
| RELTYPE_O | Relationship type | BINRELTYP | ORBRELTYP | CHAR | 4 | 0 | ||||||||
MDOBLREL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDOBLREL | DBTABLE | * | DD02L | SAP Tables | AS4VERS | |
| MDOBLREL | DBTABLE | MDOBLREL | DBTABLE | DD02L | SAP Tables | TABNAME |
| MDOBLREL | DBTABLE | * | DD02L | SAP Tables | AS4LOCAL | |
| MDOBLREL | MODIFIEDBY | MDOBLREL | MODIFIEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| MDOBLREL | MODIFIEDBY | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| MDOBLREL | OWNER | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| MDOBLREL | OWNER | MDOBLREL | OWNER | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| MDOBLREL | RELTYPE_O | MDOBLREL | RELTYPE_O | ORBRELTYP | Object relationship binary link type | RELTYPE |
| MDOBLREL | ROLEA | MDOBLREL | ROLEA | MDOBLROL | Model Data: Role Types | ROLETYPE |
| MDOBLREL | ROLEB | MDOBLREL | ROLEB | MDOBLROL | Model Data: Role Types | ROLETYPE |
