R_SourcingProjectNegotiation

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'RSRCGPNGN'
@AbapCatalog.compiler.compareFilter:true
@ObjectModel:{
               usageType.dataClass: #TRANSACTIONAL,
               usageType.serviceQuality: #A,
               usageType.sizeCategory: #L,
               semanticKey: ['SourcingProjectNegotiation'],
               representativeKey: 'SourcingProjectNegotiationUUID'   }
@EndUserText.label:'Negotiation for Sourcing Project'
define view R_SourcingProjectNegotiation
  as select from mmsrcgpngn

  association [1..*] to R_SrcgProjNegotiationQuotation as _SrcgProjNegotiationQuotation on $projection.SourcingProjectNegotiationUUID = _SrcgProjNegotiationQuotation.SourcingProjectNegotiationUUID
  association [0..*] to R_SrcgProjNegttnQuotationItem  as _SrcgProjNegttnQuotationItem  on $projection.SourcingProjectNegotiationUUID = _SrcgProjNegttnQuotationItem.SourcingProjectNegotiationUUID
  association [0..1] to I_SrcgProjNegttnLfcycStatus    as _SrcgProjNegttnLfcycStatus    on $projection.SrcgProjNegttnLifecycleStatus = _SrcgProjNegttnLfcycStatus.SrcgProjNegttnLifecycleStatus
  association [0..1] to I_SrcgProjNegotiationType      as _SrcgProjNegotiationType      on $projection.SourcingProjectNegotiationType = _SrcgProjNegotiationType.SourcingProjectNegotiationType
  association [1..*] to I_SrcgProjNegttnQtanSummary    as _SrcgProjNegttnQtanSummary    on $projection.SourcingProjectNegotiationUUID = _SrcgProjNegttnQtanSummary.SourcingProjectNegotiationUUID
  association [1..1] to R_SourcingProject              as _SourcingProject              on $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
  association [0..1] to I_UserContactCard              as _CreatedByUser                on $projection.CreatedByUser = _CreatedByUser.ContactCardID
  association [0..1] to I_UserContactCard              as _ChangedByUser                on $projection.LastChangedByUser = _ChangedByUser.ContactCardID
{
  key sourcingprojectnegotiationuuid as SourcingProjectNegotiationUUID,
      sourcingprojectnegotiation     as SourcingProjectNegotiation,
      @ObjectModel: {  foreignKey.association: '_SrcgProjNegotiationType'}
      sourcingprojectnegotiationtype as SourcingProjectNegotiationType,
      sourcingprojectnegotiationname as SourcingProjectNegotiationName,
      @ObjectModel: {  foreignKey.association: '_SrcgProjNegttnLfcycStatus'}
      srcgprojnegttnlifecyclestatus  as SrcgProjNegttnLifecycleStatus,
      srcgprojnegotiationstartdate   as SrcgProjNegotiationStartDate,
      srcgprojnegotiationenddate     as SrcgProjNegotiationEndDate,
      srcgprojnegttnstartdatetime    as SrcgProjNegttnStartDateTime,
      srcgprojnegttnenddatetime      as SrcgProjNegttnEndDateTime,
      sourcingprojectuuid            as SourcingProjectUUID,
      @Semantics.user.createdBy: true
      createdbyuser                  as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime               as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      lastchangedbyuser              as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime             as LastChangeDateTime,

      /* Associations */
      _SrcgProjNegotiationQuotation,
      _SrcgProjNegttnQuotationItem,
      _SrcgProjNegttnLfcycStatus,
      _SrcgProjNegotiationType,
      _SrcgProjNegttnQtanSummary,
      _SourcingProject,
      _CreatedByUser,
      _ChangedByUser

}