I_Swcstrtdata

@AbapCatalog.sqlViewName: 'ISWCSTRTDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Get Details of Constraints'
@VDM.viewType:#BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
---------------------------

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel: {
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot: true,
  semanticKey:  [ 'EmbeddedSwSoftwareMaterial'],
  transactionalProcessingEnabled: true,
  writeActivePersistence: '/PLMI/SW_CSTRT_D',
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
}

---------------------------
define view I_Swcstrtdata
  as select from /plmi/sw_cstrt
    inner join      mara as m1 on m1.matnr = /plmi/sw_cstrt.sw_module 
    left outer join mara as m2 on m2.matnr = /plmi/sw_cstrt.cstrt_obj_id    
{
  key db_key               as  ProductStructureNodeUUID,
      sw_module            as  EmbeddedSwSoftwareMaterial,
      sw_version_type      as  DocumentType,
      sw_version_id        as  DocNumber,
      sw_version_min       as  EmbeddedSwFromVersion,
      sw_version_max       as  EmbeddedSwToVersion,
      cstrt_rule           as  EmbeddedSwConstraintRule,
      cstrt_obj_type       as  EmbeddedSwConstraintObjectType,
      cstrt_obj_id         as  EmbeddedSwHardwareMaterial,
      cstrt_obj_val_min    as  EmbeddedSwSoftwareMinVersion,
      cstrt_obj_val_max    as  EmbeddedSwSoftwareMaxVersion,
      cstrt_obj_descr      as  EmbeddedSwHardwareMaterialDesc,
      created_on           as  CreationDate,
      created_by           as  CreatedByUser,
      changed_on           as  LastChangeDate,
      changed_by           as  LastChangedByUser,
      etag                 as  EmbeddedSoftwareETag,
      timestamp            as  EmbeddedSoftwareTimeStamp,
      m1.begru             as  AuthorizationGroup,          // master material

      m2.begru             as  MaterialAuthorizationGroup   // item material(include hardward material and software material)

}