I_ChangeMasterObjTypeAssgmt

@AbapCatalog.sqlViewName: 'IECNOBJASGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'ChangeNumberObjectType'
@ObjectModel.semanticKey: ['ChangeNumber', 'ChangeNumberObjectType']

@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #SQL_DATA_SOURCE ]

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_LOCAL_API

@EndUserText.label: 'Change Number Object Type Assignment'
define view I_ChangeMasterObjTypeAssgmt
  as select from aenv
  association [0..1] to I_ChangeMasterObjectType       as _ChangeNumberObjectType       on $projection.ChangeNumberObjectType = _ChangeNumberObjectType.ChangeNumberObjectType
  association [1..1] to I_ChangeMaster                 as _ChangeMaster                 on $projection.ChangeNumber = _ChangeMaster.ChangeNumber
  association [0..*] to I_ChangeMstrObjTypeRevisionLvl as _ChangeMstrObjTypeRevisionLvl on $projection.ChangeNumberObjectType = _ChangeMstrObjTypeRevisionLvl.ChangeNumberObjectType
{
        @ObjectModel.foreignKey.association: '_ChangeMaster'
  key   aennr                            as ChangeNumber,
        @ObjectModel.foreignKey.association: '_ChangeNumberObjectType'
  key   aetyp                            as ChangeNumberObjectType,

        cast ( aeerl as /plmb/aeerl )    as IsActiveForChangeNumber,
        aensp                            as IsLockedForChanges,
        tobja                            as IsPartiallyDisplayed,
        cast ( indfl as /plmb/cc_indfl ) as ObjMgmtRecdIsRequired,
        cast ( oigen as /plmb/oigen )    as ObjMgmtRecdIsGenerated,
        cast ( genan as /plmb/genan )    as ObjMgmtRecdIsAutomlyCrted,
        cast ( gendi as /plmb/gendi )    as ObjMgmtRecdIsAutomlyCrtedByDlg,

        @Semantics.businessDate.at: true
        andat                            as ObjectTypeCreationDate,
        annam                            as ObjectTypeCreatedByUser,
        @Semantics.businessDate.at: true
        aedat                            as ObjectTypeLastChangedDate,
        aenam                            as ObjectTypeLastChangedByUser,

        _ChangeNumberObjectType,
        _ChangeMaster,
        _ChangeMstrObjTypeRevisionLvl
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AENV"
],
"ASSOCIATED":
[
"I_CHANGEMASTER",
"I_CHANGEMASTEROBJECTTYPE",
"I_CHANGEMSTROBJTYPEREVISIONLVL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/