R_CentralRequestForQuotation

@VDM.viewType: #BASIC
@EndUserText.label: 'Restricted View for Central Request For Quotation Header'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'RCNTRLRFQHDR'
@AccessControl.privilegedAssociations: [ '_CreatedByUser' ]

@ObjectModel:{ representativeKey: 'CentralRequestForQuotation',
               semanticKey: 'CentralRequestForQuotation',
               usageType.dataClass: #TRANSACTIONAL,
               usageType.serviceQuality: #C,
               usageType.sizeCategory: #M }

define view R_CentralRequestForQuotation
  as select from R_PurchasingDocument

  association [1..*] to R_CentralReqForQuotationItem as _CentralReqForQuotationItem on  $projection.CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation

  association [1..*] to R_CntrlReqForQuotationBidder as _CntrlReqForQuotationBidder on  $projection.CentralRequestForQuotation = _CntrlReqForQuotationBidder.CentralRequestForQuotation

  association [0..1] to I_PurchasingDocumentType     as _FollowOnDocumentType       on  $projection.PurchasingDocumentCategory = _FollowOnDocumentType.PurchasingDocumentCategory
                                                                                    and $projection.PurchasingDocumentType     = _FollowOnDocumentType.PurchasingDocumentType

  association [0..1] to I_RequestForQuotationType    as _RFQType                    on  $projection.PurchasingDocumentType = _RFQType.RFQType

  association [0..1] to I_PurchasingDocumentCategory as _FollowOnDocumentCategory   on  $projection.FollowOnDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory

  association [0..*] to R_CentralSupplierQuotation   as _CentralSupplierQuotation   on  $projection.CentralRequestForQuotation = _CentralSupplierQuotation.CentralRequestForQuotation

  association [0..1] to I_RFQLifecycleStatus         as _RFQLifecycleStatus         on  $projection.RFQLifecycleStatus = _RFQLifecycleStatus.RFQLifecycleStatus

  association [0..1] to E_PurchasingDocument         as _CentralReqForQuotationExtn   on _CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation
 
{

      @ObjectModel: { readOnly: true }
  key cast (R_PurchasingDocument.PurchasingDocument as vdm_cntrlrequestforquotation preserving type)     as CentralRequestForQuotation,

      @ObjectModel: { foreignKey.association: '_CompanyCode',
                      mandatory: true }
      R_PurchasingDocument.CompanyCode,

      @ObjectModel: { readOnly: true,
                      foreignKey.association: '_PurchasingDocumentCategory' }
      R_PurchasingDocument.PurchasingDocumentCategory,

      @ObjectModel: { readOnly: true,
                      foreignKey.association: '_RFQType' }
      cast(R_PurchasingDocument.PurchasingDocumentType as vdm_rfq_doc_type preserving type )             as PurchasingDocumentType,

      @ObjectModel: { readOnly: true }
      @Semantics.user.createdBy: true
      R_PurchasingDocument.CreatedByUser,

      @ObjectModel: { readOnly: true }
      @Semantics.systemDate.createdAt: true
      R_PurchasingDocument.CreationDate,

      @ObjectModel.readOnly: true
      @Semantics.systemDateTime.lastChangedAt: true
      R_PurchasingDocument.LastChangeDateTime,
      @Semantics.language: false
      R_PurchasingDocument.Language,

      @ObjectModel: { foreignKey.association: '_PurchasingOrganization',
                      mandatory: true }
      cast(R_PurchasingDocument.PurchasingOrganization as ekorg_ll preserving type )                     as PurchasingOrganization,

      @ObjectModel: { foreignKey.association: '_PurchasingGroup',
                      mandatory: true }
      R_PurchasingDocument.PurchasingGroup,

      @Semantics.currencyCode:true
      @ObjectModel: { foreignKey.association: '_DocumentCurrency'}
      R_PurchasingDocument.DocumentCurrency,

      @ObjectModel: { foreignKey.association: '_IncotermsClassification' }
      R_PurchasingDocument.IncotermsClassification,
      R_PurchasingDocument.IncotermsTransferLocation,
      @ObjectModel: {foreignKey.association: '_IncotermsVersion' }
      R_PurchasingDocument.IncotermsVersion,
      R_PurchasingDocument.IncotermsLocation1,
      R_PurchasingDocument.IncotermsLocation2,

      @ObjectModel.foreignKey.association: '_PaymentTerms'
      R_PurchasingDocument.PaymentTerms,
      R_PurchasingDocument.CashDiscount1Days,
      R_PurchasingDocument.CashDiscount2Days,
      R_PurchasingDocument.CashDiscount1Percent,
      R_PurchasingDocument.CashDiscount2Percent,
      R_PurchasingDocument.NetPaymentDays,
      R_PurchasingDocument.ValidityStartDate,
      R_PurchasingDocument.ValidityEndDate,
      cast( R_PurchasingDocument.PurchasingDocumentOrderDate as vdm_rfq_publishing_date preserving type) as RFQPublishingDate,
      R_PurchasingDocument.QuotationLatestSubmissionDate,
      R_PurchasingDocument.BindingPeriodValidityEndDate,
      @DefaultAggregation:#NONE
      R_PurchasingDocument.TargetAmount,

      @ObjectModel: {  foreignKey.association: '_RFQLifecycleStatus'}
      cast ( R_PurchasingDocument.PurchasingProcessingStatus as vdm_rfq_lfst_cd preserving type)         as RFQLifecycleStatus,
      cast ( R_PurchasingDocument.PurchasingDocumentName as vdm_rfq_name preserving type)                as RequestForQuotationName,
      R_PurchasingDocument.QuotationEarliestSubmsnDate,
      cast (R_PurchasingDocument.LatestRegistrationDate as vdm_apply_by preserving type)                 as LatestRegistrationDate,
      R_PurchasingDocument.CorrespncInternalReference,

      @ObjectModel.foreignKey.association: '_FollowOnDocumentCategory'
      R_PurchasingDocument.FollowOnDocumentCategory,

      @ObjectModel.foreignKey.association: '_FollowOnDocumentType'
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'PurgDocFollowOnDocumentType'
      R_PurchasingDocument.FollowOnDocumentType,
      R_PurchasingDocument.FollowOnDocumentType                                                          as PurgDocFollowOnDocumentType,
      R_PurchasingDocument.PurchasingDocumentDeletionCode,
      R_PurchasingDocument.IsEndOfPurposeBlocked,

      R_PurchasingDocument._PurchasingDocumentType,
      R_PurchasingDocument._PurchasingDocumentCategory,
      R_PurchasingDocument._PaymentTerms,
      R_PurchasingDocument._CreatedByUser,
      R_PurchasingDocument._DocumentCurrency,
      R_PurchasingDocument._CompanyCode,
      R_PurchasingDocument._PurchasingGroup,
      R_PurchasingDocument._Language,
      R_PurchasingDocument.ValidityStartDate                                                             as PurContrValidityStartDate,
      R_PurchasingDocument.ValidityEndDate                                                               as PurContrValidityEndDate,

      // Associations //

      _CentralReqForQuotationItem,
      _CntrlReqForQuotationBidder,
      _RFQType,
      _IncotermsClassification,
      _IncotermsVersion,
      _PurchasingOrganization,
      _CentralSupplierQuotation,
      _RFQLifecycleStatus,
      _FollowOnDocumentCategory,
      _FollowOnDocumentType

}
where
  R_PurchasingDocument.PurchasingDocumentCategory = 'N'