R_EnterpriseProjectDraft

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@AbapCatalog.dataMaintenance: #RESTRICTED
@ObjectModel: {
   usageType: {
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #M
   }
}

@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'PPH',
  allowNewDatasources: false,
  dataSources: ['_ProjectExtension'],
  quota: {
     maximumFields: 204,
     maximumBytes: 2040 
  }
}

@EndUserText.label: 'Enterprise Project Draft'
define view entity R_EnterpriseProjectDraft
   as select from entproj_d as EnterpriseProjectDraft
   inner join sdraft_admin on sdraft_admin.draft_key = EnterpriseProjectDraft.draftadministrativedatauuid
   association [1..1] to R_EnterpriseProject           as _Project  on $projection.ProjectUUID = _Project.ProjectUUID
   association [0..1] to I_EnterpriseProjectForUser    as _EnterpriseProjectForUser on _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID
   ---Extension Association
   association [1..1] to E_EnterpriseProjectDraft      as _ProjectExtension           on $projection.ProjectUUID = _ProjectExtension.ProjectUUID
   association [1..1] to E_CommercialProjectDraft      as _CommercialProjectExtension on $projection.ProjectUUID = _CommercialProjectExtension.ProjectUUID
{
      key EnterpriseProjectDraft.projectuuid             as ProjectUUID,
      EnterpriseProjectDraft.projectsummarytaskuuid      as ProjectSummaryTaskUUID,
      EnterpriseProjectDraft.projectinternalid           as ProjectInternalID,
      EnterpriseProjectDraft.project                     as Project,
      
      EnterpriseProjectDraft.projectcategory             as ProjectCategory,
      EnterpriseProjectDraft.projectdescription          as ProjectDescription,
      EnterpriseProjectDraft.enterpriseprojecttype       as EnterpriseProjectType,
      EnterpriseProjectDraft.prioritycode                as PriorityCode,     
      EnterpriseProjectDraft.projectstartdate            as ProjectStartDate,
      EnterpriseProjectDraft.projectenddate              as ProjectEndDate,
      EnterpriseProjectDraft.actualstartdate             as ActualStartDate, 
      EnterpriseProjectDraft.actualenddate               as ActualEndDate,
  
      EnterpriseProjectDraft.customeruuid                as CustomerUUID,   
      EnterpriseProjectDraft.enterpriseprojectserviceorg as EnterpriseProjectServiceOrg,
      
      EnterpriseProjectDraft.entprojectisconfidential    as EntProjectIsConfidential,
      EnterpriseProjectDraft.restrictedtimeposting       as RestrictedTimePosting,
      
      EnterpriseProjectDraft.processingstatus            as ProcessingStatus,
      
      EnterpriseProjectDraft.responsiblecostcenter       as ResponsibleCostCenter,
      EnterpriseProjectDraft.profitcenter                as ProfitCenter,
      EnterpriseProjectDraft.projectprofilecode          as ProjectProfileCode,
      EnterpriseProjectDraft.functionalarea              as FunctionalArea,
      EnterpriseProjectDraft.companycode                 as CompanyCode,
      EnterpriseProjectDraft.controllingarea             as ControllingArea,   
      EnterpriseProjectDraft.plant                       as Plant,
      EnterpriseProjectDraft.location                    as Location,
      EnterpriseProjectDraft.taxjurisdiction             as TaxJurisdiction,
      EnterpriseProjectDraft.projectcurrency             as ProjectCurrency,
      EnterpriseProjectDraft.availabilitycontrolprofile  as AvailabilityControlProfile,
      EnterpriseProjectDraft.availabilitycontrolisactive as AvailabilityControlIsActive,
      
      EnterpriseProjectDraft.functionallocation          as FunctionalLocation,     
      EnterpriseProjectDraft.investmentprofile           as InvestmentProfile,
      EnterpriseProjectDraft.isbillingrelevant           as IsBillingRelevant,
      
      EnterpriseProjectDraft.lastchangedatetime          as LastChangeDateTime,
      EnterpriseProjectDraft.lastchangedbyuser           as LastChangedByUser,
      EnterpriseProjectDraft.projectlastchangeddatetime  as ProjectLastChangedDateTime,
      EnterpriseProjectDraft.projectlastchangedbyuser    as ProjectLastChangedByUser,
      
      EnterpriseProjectDraft.entprojismultislsorditmsenbld as EntProjIsMultiSlsOrdItmsEnbld,
      EnterpriseProjectDraft.entprojdemandcopyisrequested  as EntProjDemandCopyIsRequested,
      EnterpriseProjectDraft.entprojsettlmtrulecpyisreqd   as EntProjSettlmtRuleCpyIsReqd,
      EnterpriseProjectDraft.entprojhasprojectstockenabled as EntProjHasProjectStockEnabled,
      EnterpriseProjectDraft.entprojectsettlementtype      as EntProjectSettlementType,
      EnterpriseProjectDraft.entprojectsettlementelement   as EntProjectSettlementElement,
  
      EnterpriseProjectDraft.createdbyuser                  as CreatedByUser,
      EnterpriseProjectDraft.creationdatetime               as CreationDateTime,
      EnterpriseProjectDraft.leadingsalesorder              as LeadingSalesOrder,
      EnterpriseProjectDraft.leadingsalesorderitem          as LeadingSalesOrderItem,
      EnterpriseProjectDraft.resultanalysisinternalid       as  ResultAnalysisInternalID,
      EnterpriseProjectDraft.wbselementinternalid           as WBSElementInternalID,
      EnterpriseProjectDraft.factorycalendar                as FactoryCalendar,
      EnterpriseProjectDraft.wbselementobject               as  WBSElementObject,
      EnterpriseProjectDraft.projectobject                  as   ProjectObject,
      EnterpriseProjectDraft.costingsheet                   as   CostingSheet,
      EnterpriseProjectDraft.costcenter                     as    CostCenter   ,    
      EnterpriseProjectDraft.isstatistical                  as  IsStatistical,
      EnterpriseProjectDraft.projecttemplateuuid            as  ProjectTemplateUUID,
      EnterpriseProjectDraft.projectmanager                 as  ProjectManager,

      EnterpriseProjectDraft.draftentitycreationdatetime   as DraftEntityCreationDateTime,
      EnterpriseProjectDraft.draftentitylastchangedatetime as DraftEntityLastChangeDateTime,
      EnterpriseProjectDraft.draftadministrativedatauuid   as DraftAdministrativeDataUUID,
   
      EnterpriseProjectDraft.draftfieldchanges             as DraftFieldChanges,
      EnterpriseProjectDraft.hasactiveentity               as HasActiveEntity,
      EnterpriseProjectDraft.draftentityoperationcode      as DraftEntityOperationCode,
  
  
     _Project,
     _EnterpriseProjectForUser

  
}
where sdraft_admin.created_by = $session.user