R_SourcingProjectContactTP

@AccessControl: { authorizationCheck:     #MANDATORY,
                  personalData.blocking:  #REQUIRED
}

@ObjectModel:{  representativeKey: 'SourcingProjectContactUUID',

                usageType: {
                  dataClass:      #TRANSACTIONAL,
                  serviceQuality: #B,
                  sizeCategory:   #L
                }
}

@VDM: {
  viewType:                 #TRANSACTIONAL,
  lifecycle.contract.type:  #SAP_INTERNAL_API
}

@EndUserText.label: 'Contact for Sourcing Project - TP'
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  allowNewDatasources: false,
  elementSuffix: 'SPC',
  quota: { maximumFields: 404,
           maximumBytes: 40400 },
  allowNewCompositions: true }


define view entity R_SourcingProjectContactTP
  as select distinct from R_SourcingProjectContact
  association        to parent R_SourcingProjectTP     as _SourcingProject              on $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
  association [0..*] to I_SourcingProjectContactCatT   as _ContactCatText               on $projection.SourcingProjectContactCategory = _ContactCatText.SourcingProjectContactCategory
  //Extension

  association [1..1] to E_SourcingProjectContact       as _Extension                    on $projection.SourcingProjectContactUUID = _Extension.SourcingProjectContactUUID
  association [0..1] to I_SrcgProjCntctWorkplaceAddr   as _WorkplaceAddress             on $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID
  association [0..*] to I_SrcgProjSourcingOriginText   as _SrcgProjSourcingOriginText   on $projection.SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin
  association [0..*] to I_SrcgProjSourcingScenarioText as _SrcgProjSourcingScenarioText on $projection.SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario

{
  key SourcingProjectContactUUID,

      SourcingProjectUUID,

      SourcingProjectContactCategory,

      BusinessPartner,
      BusinessPartnerUUID,

      SrcgProjCntctIsVisibleToSuplr,
      SrcgProjContactIsContributor,
      UserID,

      IsBusinessPurposeCompleted,

      AuthorizationGroup,

      SourcingOrigin,
      SourcingScenario,

      /* Associations */
      _SourcingProject,
      _SourcingProjectContactCat,
      _BusinessPartner,
      _WorkplaceAddress,
      _ContactCatText,
      _SrcgProjSourcingOriginText,
      _SrcgProjSourcingScenarioText
}