R_ProjectBillingRequestTP

//@AbapCatalog.sqlViewName: 'RPROJBILLREQ'

//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AccessControl.privilegedAssociations: ['_SalesBillingPlanDueDate']

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType: {
    sizeCategory: #XL,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #C //B

}
@EndUserText.label: 'Details of Project Billing Request'

@ObjectModel.sapObjectNodeType.name: 'ProjectBillingRequest'
@AccessControl.privilegedAssociations: [ '_EnterpriseProject', '_SalesOrder', '_ProjectBillingReqItemTP', '_ProjBillgReqObjectLink', '_UserContactCard' ]
@AccessControl.personalData.blocking: #REQUIRED

//@Consumption.dbHints: ['NO_SUBPLAN_SHARING'] -- Performance testing


define root view entity R_ProjectBillingRequestTP
  as select from I_ProjectBillingRequest as ProjectBillingRequest
 // association [1..1] to I_EnterpriseProject           as _EnterpriseProject         on  $projection.ProjectInternalID = _EnterpriseProject.ProjectInternalID


  /* association [1..*] to I_ProjectBillgRequestRevnCube  as _ProjectBillgRequestRevnCube  on  ProjectBillingRequest.ProjectBillingRequestUUID = _ProjectBillgRequestRevnCube.ProjectBillingRequestUUID
   */
  /* association [0..1] to I_CostCenterText               as _CostCenterText               on  $projection.costcenter          = _CostCenterText.CostCenter
                                                                                         and $projection.controllingarea     = _CostCenterText.ControllingArea
                                                                                         and $projection.PlannedStartDate <= _CostCenterText.ValidityEndDate
                                                                                         and $projection.PlannedStartDate >= _CostCenterText.ValidityStartDate
                                                                                         and _CostCenterText.Language        = $session.system_language
  */
  /*removing the association as now Profit center name is exposed as Virtual fields*/
  /* association [0..1] to I_ProfitCenterText             as _ProfitCenterText             on $projection.profitcenter     = _ProfitCenterText.ProfitCenter
                                                                                         and $projection.controllingarea = _ProfitCenterText.ControllingArea
                                                                                         and $projection.PlannedStartDate <= _ProfitCenterText.ValidityEndDate
                                                                                         and $projection.PlannedStartDate >= _ProfitCenterText.ValidityStartDate
                                                                                         and _ProfitCenterText.Language  = $session.system_language
    */
  /* association [0..1] to I_EngagementProjectSrvcOrgText as _EngagementProjectSrvcOrgText on $projection.enterpriseprojectserviceorg = _EngagementProjectSrvcOrgText.EngagementProjectServiceOrg
                                                                                         and _EngagementProjectSrvcOrgText.Language  = $session.system_language
   */
  association [1..1] to I_SalesOrder                  as _SalesOrder                on  $projection.SalesDocument = _SalesOrder.SalesOrder
  association [1..1] to I_UserContactCard             as _UserContactCard           on  $projection.ProjBillgReqCreatedBy = _UserContactCard.ContactCardID
  association [0..1] to P_MyProjectBillingRequests    as _MyProjectBillingRequests  on  $projection.SalesDocument        = _MyProjectBillingRequests.SalesOrder
                                                                                    and _MyProjectBillingRequests.UserID = $session.user
  association [1..1] to I_CustomerToBusinessPartner   as _CustomerToBusinessPartner on  $projection.customeruuid = _CustomerToBusinessPartner.BusinessPartnerUUID 
  

  composition [0..*] of R_ProjectBillingRequestItemTP as _ProjectBillingReqItemTP
  composition [0..1] of R_ProjBillgReqObjectLinkTP    as _ProjBillgReqObjectLink
{

  key ProjectBillingRequest.ProjectBillingRequestUUID    as ProjectBillingRequestUUID,
      ProjectBillingRequest.ProjectBillingRequest        as ProjectBillingRequest,
      ProjectInternalID,
      ProjectBillingRequest.ProjectBillingRequestStatus  as ProjectBillingRequestStatus,
      ProjectBillingRequest.ProjBillgReqApprovalStatus   as ProjBillgReqApprovalStatus,
      ProjectBillingRequest.ProjectBillingRequestType    as ProjectBillingRequestType,
      ProjectBillingRequest.SalesDocument                as SalesDocument,
      ProjectBillingRequest.ProjectBillingCategory       as ProjectBillingCategory,
      //      ProjectBillingRequest.SalesDocumentType                                                                                                                                    as SalesDocumentType,

      @Semantics.user.lastChangedBy: true
      ProjectBillingRequest.ProjBillgReqLastChgdBy       as ProjBillgReqLastChgdBy,
      @Semantics.systemDateTime.lastChangedAt: true
      ProjectBillingRequest.ProjBillgReqLastChgdAtDteTme as ProjBillgReqLastChgdAtDteTme,
      @Semantics.user.createdBy: true
      ProjectBillingRequest.ProjBillgReqCreatedBy        as ProjBillgReqCreatedBy,
      @Semantics.systemDateTime.createdAt: true
      ProjectBillingRequest.ProjBillgReqCreatedAtDteTme  as ProjBillgReqCreatedAtDteTme,
      ProjectBillingRequest._ProjectBillingRequestItem,

      tstmp_to_dats( cast( ProjBillgReqCreatedAtDteTme as timestamp ), abap_system_timezone( $session.client,'NULL' ),
                     $session.client, 'NULL' )           as ProjBillgReqCreatedAtDte,
      _EnterpriseProject.Project                         as Project,
      _EnterpriseProject.CustomerUUID,
      _SalesOrder.SoldToParty                            as Customer,
      _MyProjectBillingRequests.UserID,

      //      ProjectBillingRequestDesc,

      
      ------------------------------------- For Performance ATC -------------------------
      _EnterpriseProject.Currency                       as DocumentCurrency,
      _EnterpriseProject.ProjectStartDate               as ProjectStartDate,
      _EnterpriseProject.ProjectEndDate                 as ProjectEndDate,
      _EnterpriseProject.ProfitCenter,
      _EnterpriseProject.ControllingArea,
      _EnterpriseProject.ProjectDescription,
      ------------------------------------- For Performance ATC -------------------------

      _ProjectBillingReqItemTP,
      _SalesOrder,
      _EnterpriseProject,
      _CustomerToBusinessPartner,
      _ProjBillgReqObjectLink,
      _ProjectBillingRequestStatus,
      _ProjBillgReqApprovalStatus,
      _UserContactCard
      
      

      // ***** The below three fields are used in I_CostCenterText and hence cannot be moved up

      // _EnterpriseProject.PlannedStartDate                                                                                                                                       as PlannedStartDate,

      // _EnterpriseProject._ProjectElement.CostCenter,

      // _EnterpriseProject.ControllingArea,

      // _EnterpriseProject.ProfitCenter,

      // _EnterpriseProject.EnterpriseProjectServiceOrg,

      // *****


      // _SalesOrder.TransactionCurrency  as DocumentCurrency,

      // _ProjectBillgRequestRevnCube.DocumentCurrency                                                                                                                              as DocumentCurrency,

      // _SalesOrder.SoldToParty as Customer,

      // _CostCenterText ,

      // _ProfitCenterText,

      // _EngagementProjectSrvcOrgText

}