I_InvgCsMEmployee

@AbapCatalog.sqlViewName: 'IINVGEMPLOYEE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'ICM Employee'
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking:#REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}


define view I_InvgCsMEmployee
  as select from I_BusinessPartner_to_BP_Role as _bp100
    inner join   I_BusinessUserBasic          as _person on _bp100.BusinessPartner = _person.BusinessPartner
  association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

{

  key    _person.BusinessPartner    as BusinessPartner,
         _bp100.BusinessPartnerRole as BusinessPartnerRole,
         _person.LastName,
         _person.FirstName,
         _BusinessPartner.BusinessPartnerFullName,
         _BusinessPartner.PersonNumber,
         _person.BusinessPartnerUUID,
         _BusinessPartner.IndependentAddressID,
         //personal data blocking

         _person.UserID             as BusinessUser,
         _person.AuthorizationGroup,
         _person.IsBusinessPurposeCompleted,
         _bp100.ValidFrom           as ValidFrom,
         _bp100.ValidTo             as ValidTo,

         _person.PersonFullName,
         _BusinessPartner
}
where
      _bp100.BusinessPartner     = _person.BusinessPartner
  and _bp100.BusinessPartnerRole = 'BUP003'

//  as select from pa0105            as _person

//    inner join   hrp1001           as _hrper on  _hrper.otype = 'P'

//                                             and _hrper.objid = _person.pernr

//    inner join   hrp1001           as _hrbp  on  _hrbp.otype = 'CP'

//                                             and _hrbp.objid = _hrper.sobid

//    inner join   but100            as _bp100 on  _bp100.partner = _hrbp.sobid

//                                             and _bp100.rltyp   = 'BUP003'

//    inner join   I_BusinessPartner as _bp    on _bp.BusinessPartner = _bp100.partner

//

//{

//

//  key    _bp.BusinessPartner                         as BusinessPartner,

//         _bp100.rltyp                                as BusinessPartnerRole,

//         _bp.LastName,

//         _bp.FirstName,

//         _bp.BusinessPartnerFullName,

//         _bp.PersonNumber,

//         _bp.BusinessPartnerUUID,

//         _bp.IndependentAddressID,

//         //personal data blocking

//         _bp.AuthorizationGroup,

//         _bp.IsBusinessPurposeCompleted,

//         usrid                                       as BusinessUser,

//         _bp100.valid_from                           as ValidFrom,

//         _bp100.valid_to                             as ValidTo,

//         _bp.PersonFullName

//

//

//}

//where

//      _person.subty = '0001'

//  and _person.begda <= $session.system_date

//  and _person.endda >= $session.system_date

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNER_TO_BP_ROLE",
"I_BUSINESSUSERBASIC"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/