R_MDOOWNERSHIPMODEL

DDL: R_MDOOWNERSHIPMODEL Type: view_entity Package: MDO_OWNERSHIP_MODEL
19 Fields 1 Data Sources 2 Associations

MDO: Data Ownership Model

R_MDOOWNERSHIPMODEL is a CDS View that provides data about "MDO: Data Ownership Model" in SAP S/4HANA. It reads from 1 data source (mdo_ownrshpmodel) and exposes 19 fields with key field Id. It has 2 associations to related views. Part of development package MDO_OWNERSHIP_MODEL.

Data Sources (1)

SourceAliasJoin Type
mdo_ownrshpmodel OwnershipModel from

Associations (2)

CardinalityTargetAliasCondition
[0..1] mdo_otc_objects _Otc _Otc.odm_objectname = OwnershipModel.odmobjecttype
[0..*] R_MDORULESET _RuleSet

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MDO: Data Ownership Model view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Id id WorklistID
IsActive isactive Object active?
Type type Worklist Type
OdmObjectType odmobjecttype ODM Type
OdmObjectTypeVersion odmobjecttypeversion Object Type Version
DataOwner dataowner Data Owners
LastActivatedAt lastactivatedat Last Activated At
LastActivatedBy lastactivatedby Last Activated By
CreatedByUser createdbyuser User Name
CreatedAt createdat Time Stamp
LastChangedByUser lastchangedbyuser User Name
LastChangedAt lastchangedat Time Stamp
TenantId tenantid Tenant ID
SubaccountId subaccountid Subaccount ID
MdoHostname mdohostname Host Name
MdoUiUrl mdouiurl Application URL
IgnoreTenantValidation
BusinessObjectType _Otc businessobjecttypecode Business Object Type
_RuleSet _RuleSet

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_MDOOWNERSHIPMODEL.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_MDOOWNERSHIPMODEL AS
SELECT
  Id,
  IsActive,
  Type,
  OdmObjectType,
  OdmObjectTypeVersion,
  DataOwner,
  LastActivatedAt,
  LastActivatedBy,
  CreatedByUser,
  CreatedAt,
  LastChangedByUser,
  LastChangedAt,
  TenantId,
  SubaccountId,
  MdoHostname,
  MdoUiUrl,
  cast( '' as mdo_ignore_tenant_check preserving type ) AS IgnoreTenantValidation,
  _Otc.businessobjecttypecode AS BusinessObjectType
FROM mdo_ownrshpmodel AS OwnershipModel
LEFT OUTER JOIN mdo_otc_objects AS _Otc ON _Otc.odm_objectname = OwnershipModel.odmobjecttype  -- association [0..1]
LEFT OUTER JOIN R_MDORULESET AS _RuleSet ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More