I_SourcingProjectQuotation

@AbapCatalog.sqlViewName: 'ISRCGPROJQTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel:{ representativeKey: 'SourcingProjectQuotationUUID',
               semanticKey: ['SourcingProjectQuotation'],
               usageType.dataClass: #TRANSACTIONAL,
               usageType.serviceQuality: #A,
               usageType.sizeCategory: #M }

@VDM.viewType: #BASIC

@EndUserText.label: 'Quotation for Sourcing Project'

define view I_SourcingProjectQuotation
  as select from R_SourcingProjectQuotation

  association [0..1] to I_SourcingProject          as _SourcingProject          on $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

  association [1..*] to I_SrcgProjQtnItem          as _SrcgProjQtnItem          on $projection.SourcingProjectQuotationUUID = _SrcgProjQtnItem.SourcingProjectQuotationUUID

  //  association [1..*] to I_SrcgProjQtnSupplierContact as _SrcgProjQtnSupplierContact on $projection.SourcingProjectQuotationUUID = _SrcgProjQtnSupplierContact.SourcingProjectQuotationUUID


  //foreign key associations

  association [0..1] to I_Currency                 as _SrcgProjQtnOfferCurrency on $projection.SrcgProjQtnOfferCurrency = _SrcgProjQtnOfferCurrency.Currency
  association [0..1] to I_CompanyCode              as _CompanyCode              on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_PurchasingGroup          as _PurchasingGroup          on $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
  association [0..1] to I_PurchasingOrganization   as _PurchasingOrganization   on $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
  association [0..1] to I_SrcgProjQtnLifecycleSts  as _SrcgProjQtnLifecycleSts  on $projection.SrcgProjQtnLifecycleStatus = _SrcgProjQtnLifecycleSts.SrcgProjQtnLifecycleStatus
  association [0..1] to I_BusinessPartner          as _BusinessPartner          on $projection.Bidder = _BusinessPartner.BusinessPartner
  //tbd

  //tbd

  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
  association [0..1] to I_MaterialGroup            as _MaterialGroup            on $projection.MaterialGroup = _MaterialGroup.MaterialGroup

  //Extension

  association [1..1] to E_SourcingProjectQuotation as _Extension                on $projection.SourcingProjectQuotationUUID = _Extension.SourcingProjectQuotationUUID

{
  key SourcingProjectQuotationUUID  as SourcingProjectQuotationUUID,
      SourcingProjectQuotation      as SourcingProjectQuotation,
      SrcgProjQuotationVersion      as SrcgProjQuotationVersion,
      SourcingProjectQuotationType  as SourcingProjectQuotationType,
      Bidder                        as Bidder,
      CompanyCode                   as CompanyCode,
      PurchasingGroup               as PurchasingGroup,
      PurchasingOrganization        as PurchasingOrganization,
      @Semantics.currencyCode: true
      SrcgProjQtnOfferCurrency      as SrcgProjQtnOfferCurrency,
      @Semantics.amount.currencyCode: 'SrcgProjQtnOfferCurrency'
      @DefaultAggregation: #NONE
      SrcgProjQtnTotNetAmt          as SrcgProjQtnTotNetAmt,

      SrcgProjQtnLifecycleStatus    as SrcgProjQtnLifecycleStatus,
      SrcgProjQtnRevisionSts        as SrcgProjQtnRevisionSts,
      SrcgProjQtnActvtnSts          as SrcgProjQtnActvtnSts,
      SrcgProjQtnSubmsnSts          as SrcgProjQtnSubmsnSts,
      SrcgProjQtnAwardingStatus     as SrcgProjQtnAwardingStatus,

      SourcingProjectUUID           as SourcingProjectUUID,

      @Semantics.user.lastChangedBy: true
      LastChangedByUser             as LastChangedByUser,
      @Semantics.user.createdBy: true
      CreatedByUser                 as CreatedByUser,

      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime            as LastChangeDateTime,

      @Semantics.systemDateTime.createdAt: true
      CreationDateTime              as CreationDateTime,

      SrcgProjAttchsAreForbidden    as SrcgProjAttchsAreForbidden,
      SrcgProjNotesAreForbidden     as SrcgProjNotesAreForbidden,

      SourcingOrigin                as SourcingOrigin,
      ExternalSourcingProjectQtnRef as ExternalSourcingProjectQtnRef,
      QtnLatestSubmissionDateTime   as QtnLatestSubmissionDateTime,
      LogicalSystem                 as LogicalSystem,

      IsEndOfPurposeBlocked         as IsEndOfPurposeBlocked,
      CashDiscount1Days             as CashDiscount1Days,
      CashDiscount2Days             as CashDiscount2Days,
      CashDiscount1Percent          as CashDiscount1Percent,
      CashDiscount2Percent          as CashDiscount2Percent,
      NetPaymentDays                as NetPaymentDays,
      MaterialGroup                 as MaterialGroup,


      /* Associations */
      _SourcingProject,
      _SrcgProjQtnItem,
      //      _SrcgProjQtnSupplierContact,

      //foreign key associations

      _CompanyCode,
      _PurchasingGroup,
      _PurchasingOrganization,
      _SrcgProjQtnOfferCurrency,
      _SrcgProjQtnLifecycleSts,
      _BusinessPartner,
      //tbd

      _CreatedByUser,
      _ChangedByUser,
      _MaterialGroup

}