R_SourcingProjectQuotationTP

@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: [ '_CreatedByUser', '_ChangedByUser']
}

@ObjectModel:{representativeKey: 'SourcingProjectQuotationUUID',
              semanticKey: ['SrcgProjQuotationVersion', 'SourcingProjectQuotation'],

              usageType: {
                dataClass: #TRANSACTIONAL,
                serviceQuality: #A,
                sizeCategory: #M
              },
              sapObjectNodeType.name: 'SourcingProjectQuotation'
}

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

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

define root view entity R_SourcingProjectQuotationTP
  as select from R_SourcingProjectQuotation
  composition [*] of R_SrcgProjQtnItemTP             as _SrcgProjQtnItem
  composition [*] of R_SrcgProjQtnAllowedCurrencyTP  as _SrcgProjQtnAllowedCurrency
  composition [*] of R_SrcgProjQtnSupplierContactTP  as _SrcgProjQtnSupplierContact
  composition [*] of R_SrcgProjQtnNoteTP             as _SrcgProjQtnNote

  association [0..1] to R_SourcingProjectNegotiation as _SourcingProjectNegotiation on $projection.SourcingProjectNegotiationUUID = _SourcingProjectNegotiation.SourcingProjectNegotiationUUID
  association [0..*] to I_SrcgProjQtnSuitabilityTxt  as _SrcgProjQtnSuitabilityTxt  on $projection.SrcgProjQtnSuitability = _SrcgProjQtnSuitabilityTxt.SrcgProjQtnSuitability
  association [0..*] to I_SrcgProjSourcingOriginText as _SrcgProjSourcingOriginText on $projection.SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin
  association [0..*] to I_CurrencyText               as _OfferCurrencyText          on $projection.SrcgProjQtnOfferCurrency = _OfferCurrencyText.Currency
  association [0..*] to I_MaterialGroupText          as _MaterialGroupText          on $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
  association [0..*] to I_SourcingProjectTypeText    as _SourcingProjectTypeText    on $projection.SourcingProjectQuotationType = _SourcingProjectTypeText.SourcingProjectType
  
  //Extension

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

{
  key SourcingProjectQuotationUUID,
      SourcingProjectQuotation,
      SrcgProjQuotationVersion,
      SourcingProjectQuotationType,
      SourcingProjectQuotationName,
      SrcgProjQuotationIsSimulated,
      Bidder,
      CompanyCode,
      PurchasingGroup,
      PurchasingOrganization,
      SrcgProjQtnOfferCurrency,
      SrcgProjQtnTotNetAmt,
      SrcgProjQtnLifecycleStatus,
      SrcgProjQtnRevisionSts,
      SrcgProjQtnActvtnSts,
      SrcgProjQtnSubmsnSts,
      SrcgProjQtnAwardingStatus,
      SourcingProjectUUID,
      SourcingProjectNegotiationUUID,
      PricingProcedure,
      LastChangedByUser,
      CreatedByUser,
      LastChangeDateTime,
      CreationDateTime,
      SrcgProjAttchsAreForbidden,
      SrcgProjNotesAreForbidden,
      SourcingOrigin,
      ExternalSourcingProjectQtnRef,
      QtnLatestSubmissionDateTime,
      LogicalSystem,
      SourceSrcgProjQuotationUUID,
      IsEndOfPurposeBlocked,
      CashDiscount1Days,
      CashDiscount2Days,
      CashDiscount1Percent,
      CashDiscount2Percent,
      NetPaymentDays,
      MaterialGroup,
      SourcingAwardingDate,
      SrcgProjQtnSuitability,
      _SourcingProjectNegotiation.SourcingProjectNegotiationType,
      //Required for the ECM Integration

      cast( concat(SourcingProjectQuotation,
             concat('/' ,cast(SrcgProjQuotationVersion as abap.char(10))))
              as vdm_sourcingprojectuniqueid ) as LglCntntMLinkdObj,
      cast( '' as vdm_spqtntypeisnotauthorized preserving type )   as SrcgProjQtnTypeIsNotAuthorized,
      cast( '' as vdm_purgorgisnotauthorized preserving type  )    as PurgOrgIsNotAuthorized,
      cast( '' as vdm_purggroupisnotauthorized preserving type )   as PurgGroupIsNotAuthorized,
      cast( '' as vdm_companycodeisnotauthorized preserving type ) as CompanyCodeIsNotAuthorized,
      cast( '' as vdm_matlgroupisnotauthorized preserving type )   as MaterialGroupIsNotAuthorized,
      /* Associations */
      _BusinessPartner,
      _CompanyCode,
      _PurchasingGroup,
      _PurchasingOrganization,
      _SourcingProject,
      _SrcgProjQtnItem,
      _SrcgProjQtnAllowedCurrency,
      _SrcgProjQtnLifecycleSts,
      _SrcgProjQtnOfferCurrency,
      _SrcgProjQtnSupplierContact,
      _SrcgProjQtnSuitabilityTxt,
      _SrcgProjQtnNote,
      _DeviationPercentUnit,
      //tbd

      _CreatedByUser,
      _ChangedByUser,
      _MaterialGroup,
      _SourcingProjectNegotiation,
      _SourceSrcgProjQuotation,
      _SrcgProjSourcingOriginText,
      _OfferCurrencyText,
      _MaterialGroupText,
      _SourcingProjectTypeText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_SOURCINGPROJECTNEGOTIATION",
"R_SOURCINGPROJECTQUOTATION"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_CURRENCY",
"I_CURRENCYTEXT",
"I_MATERIALGROUP",
"I_MATERIALGROUPTEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SOURCINGPROJECTTYPETEXT",
"I_SRCGPROJQTNLIFECYCLESTS",
"I_SRCGPROJQTNSUITABILITYTXT",
"I_SRCGPROJSOURCINGORIGINTEXT",
"I_UNITOFMEASURE",
"I_USERCONTACTCARD",
"R_SOURCINGPROJECT",
"R_SOURCINGPROJECTNEGOTIATION",
"R_SOURCINGPROJECTQUOTATION",
"R_SRCGPROJQTNALLOWEDCURRENCYTP",
"R_SRCGPROJQTNITEMTP",
"R_SRCGPROJQTNNOTETP",
"R_SRCGPROJQTNSUPPLIERCONTACTTP"
],
"BASE":
[
"R_SOURCINGPROJECTQUOTATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/