SAP ABAP Table MDOBLREL (Model Data: Relationship Types)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-GBT-OBL (Application Component) General Object Relations
     ⤷ SOBL (Package) Generic Relation Service for Business Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MDOBLREL	Table Relationship Diagram
Short Description	Model Data: Relationship Types

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	RELTYPE	☑	OBLRELTYPE	OBLRELTYPE	CHAR	10	0	Relationship type
2	.INCLUDE	☐				0	0	Line Type of mdoblrel (Without Primary Key)
3	ROLEA	☐	OBLROLTYPE	OBLROLTYPE	CHAR	10	0	Role That an Object Takes in the Relationship	MDOBLROL
4	ROLEB	☐	OBLROLTYPE	OBLROLTYPE	CHAR	10	0	Role That an Object Takes in the Relationship	MDOBLROL
5	CARDA	☐	OBLROLCARD	OBLROCARD	CHAR	1	0	Role Cardinality
6	CARDB	☐	OBLROLCARD	OBLROCARD	CHAR	1	0	Role Cardinality
7	DBTABLE	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	DD02L
8	OWNER	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
9	CREATDATE	☐	DATE_	DATS	DATS	8	0	Date
10	MODIFIEDBY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
11	MODIFDATE	☐	DATE_	DATS	DATS	8	0	Date
12	HASPROP	☐	OBLHASPROP	OBLFLAG	CHAR	1	0	Specifies Whether a Relationship Type Has an Attribute
13	RELTYPE_O	☐	BINRELTYP	BINRELTYP	CHAR	4	0	Relationship type	ORBRELTYP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDOBLREL	DBTABLE	DD02L	TABNAME		1	CN
2	MDOBLREL	MODIFIEDBY	USR02	BNAME		1	CN
3	MDOBLREL	OWNER	USR02	BNAME		1	CN
4	MDOBLREL	RELTYPE_O	ORBRELTYP	RELTYPE
5	MDOBLREL	ROLEA	MDOBLROL	ROLETYPE		1	CN
6	MDOBLREL	ROLEB	MDOBLROL	ROLETYPE		1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	50A