I_OMDOModTechEntyTypeAssgmt

DDL: I_OMDOMODTECHENTYTYPEASSGMT Type: view_entity COMPOSITE

OMDO Model Tech Entity Type Assignment

I_OMDOModTechEntyTypeAssgmt is a Composite CDS View that provides data about "OMDO Model Tech Entity Type Assignment" in SAP S/4HANA. It reads from 2 data sources (I_OMDOModelEntityType, I_OMDOModAddlOMDOAssignment) and exposes 5 fields with key fields OMDOTechnicalEntityType, ODataMobileDataObject, ODataMobileDataObject.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_OMDOModelEntityType I_OMDOModelEntityType from
I_OMDOModAddlOMDOAssignment OMDOAssignment union_all

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label OMDO Model Tech Entity Type Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY OMDOTechnicalEntityType OMDOTechnicalEntityType Technical Entity Type
KEY ODataMobileDataObject ODataMobileDataObject OData Mobile Data Object
OMDOTechnicalEntityType Entity Type Name
KEY ODataMobileDataObject I_OMDOModAddlOMDOAssignment ODataMobileDataObject
OMDOModelEntityTypeName EntityType OMDOModelEntityTypeName 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@EndUserText.label: 'OMDO Model Tech Entity Type Assignment'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #C,
    sizeCategory: #M
  }
}

@VDM.viewType: #COMPOSITE

define view entity I_OMDOModTechEntyTypeAssgmt
  as select from I_OMDOModelEntityType
{
      @EndUserText.label: 'Technical Entity Type'
  key OMDOTechnicalEntityType,
      @EndUserText.label: 'OData Mobile Data Object'
  key ODataMobileDataObject,

      @EndUserText.label: 'Entity Type Name'
      OMDOModelEntityTypeName
}
group by
  OMDOTechnicalEntityType,
  ODataMobileDataObject,
  OMDOModelEntityTypeName // ODataMobileDataObjectModelUUID can multiplicate the rows


union all

select from I_OMDOModAddlOMDOAssignment as OMDOAssignment
  join      I_OMDOModelEntityType       as EntityType on EntityType.OMDOModelEntityTypeUUID = OMDOAssignment.OMDOModelEntityTypeUUID
{
  key OMDOAssignment.OMDOTechnicalEntityType,
  key OMDOAssignment.ODataMobileDataObject,

      EntityType.OMDOModelEntityTypeName
}
group by
  OMDOAssignment.OMDOTechnicalEntityType,
  OMDOAssignment.ODataMobileDataObject,
  EntityType.OMDOModelEntityTypeName // MaintMobileApplicationFeature can multiplicate the rows

Learn More