R_WorkAssgmtPrivateAddressTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Private Address for Work Assignment'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

define view entity R_WorkAssgmtPrivateAddressTP

//HCM001

  as select from I_BusinessPartnerAddress_2 as _PrivateAddress
    inner join   R_WorkAssignmentBP         as _BuPaIdentification on _BuPaIdentification.WorkAssignmentBusinessPartner = _PrivateAddress.BusinessPartner

  //Below association/Join is to get the UUID

  association [1..1] to I_BusinessPartner         as _WorkAssignmentBP  on _WorkAssignmentBP.BusinessPartner = _BuPaIdentification.WorkAssignmentBusinessPartner

  //Below association required for deriving PersonUUID - because BEHDEF authorization/lock is depends on PersonUUID

  association [1..1] to I_BusinessPartner         as _WorkforcePersonBP on _WorkforcePersonBP.BusinessPartner = _BuPaIdentification.BusinessPartner

  //Below associations for handling DCL

  association [1..1] to R_WorkforcePersonTP       as _WorkforcePerson   on $projection.PersonUUID = _WorkforcePerson.PersonUUID
//  association        to parent R_WorkAssignmentTP as _WorkAssignment    on $projection.WorkAssignmentUUID = _WorkAssignment.WorkAssignmentUUID

{
  key    _WorkAssignmentBP.BusinessPartnerUUID                                            as WorkAssignmentUUID,
  key    _PrivateAddress.AddressNumber                                                    as AddressNumber,
         tstmp_to_dats(_PrivateAddress.ValidityStartDate,'UTC',  $session.client, 'NULL') as ValidityStartDate,
         tstmp_to_dats(_PrivateAddress.ValidityEndDate,'UTC',  $session.client, 'NULL')   as ValidityEndDate,
         _PrivateAddress.HouseNumber,
         _PrivateAddress.StreetName,
         _PrivateAddress.HouseNumberSupplementText,
         _PrivateAddress.DistrictName,
//         "                                                    as DistrictName,

         _PrivateAddress.PostalCode,
         _PrivateAddress.CityName,
         _PrivateAddress.Country,
         _PrivateAddress.Region,
         _PrivateAddress.POBox,
         _PrivateAddress.POBoxPostalCode,
         _PrivateAddress.Floor,
         _PrivateAddress.RoomNumber,
         _WorkforcePersonBP.BusinessPartnerUUID                                           as PersonUUID,

         /* Associations */
//         _WorkAssignment,

         _WorkforcePerson
}
//where usage_code = 'HCM001'