R_ProjectTP

@AbapCatalog.sqlViewName: 'RPROJECTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP view for Project for Project API'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
    sizeCategory: #L,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #C
}

define root view R_ProjectTP
  as select from I_ProjectData_2
  composition [1..*] of R_WBSElementTP             as _WBSElement
  ---Project DPP changes
  ---Project Responsible
  association [0..1] to I_ProjectResponsiblePerson as _ResponsiblePerson on  $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson
  ---Project Applicant
  association [0..1] to I_ProjectApplicant         as _ProjectApplicant  on  $projection.ApplicantCode = _ProjectApplicant.ApplicantCode
  ---Project short text
  association [0..1] to I_ProjectText              as _ProjectText       on  $projection.ProjectObject = _ProjectText.ProjectObject
                                                                         and _ProjectText.Language     = $session.system_language

  ---Extension Association
  association [1..1] to E_Project_2                as _Extension         on  $projection.ProjectInternalID = _Extension.ProjectInternalID

{
      //i_projectbasicdata

  key ProjectInternalID,
      case ProjectExternalID
      when ''
      then cast( Project as ps_pspid_edit preserving type )
      else
      ProjectExternalID
      end as ProjectExternalID,
      @Semantics.text: true
      ProjectDescription,
      @Semantics.text: true
      I_ProjectData_2._ProjectShortText.LanguageBasedShortText as ProjectLangBsdDescription,
      //_ProjectText.ProjectLangBsdDescription,

      ProjectProfileCode,
      CompanyCode,
      ControllingArea,
      FunctionalArea,
      ProfitCenter,
      PlannedStartDate,
      PlannedEndDate,
      WorkCenterLocation,
      TaxJurisdiction,
      ResponsiblePerson,
      ResponsiblePersonName,
      ApplicantCode,
      ApplicantName,
      CreatedByUser,
      CreationDate,
      LastChangedByUser,
      LastChangeDate,
      BasicDatesLastScheduledDate,
      FcstdDatesLastScheduledDate,
      FactoryCalendar,
      SchedulingDurationUnit,
      ForecastedStartDate,
      ForecastedEndDate,
      BusinessArea,
      Plant,
      Currency,
      BudgetProfile,
      PlanningProfile,
      InvestmentProfile,
      ProjInterestCalcProfile,
      ResultAnalysisInternalID,
      ControllingObjectClass,
      NetworkProfile,
      WBSSchedulingProfile,
      PlanningMethForProjBasicDate,
      PlanningMethForProjFcstdDate,
      NetworkAssignmentType,
      WBSIsStatisticalWBSElement,
      WBSIsMarkedForIntegratedPlng,
      ProjectHasOwnStock,
      InventorySpecialStockValnType,
      WBSIsMarkedForAutomReqmtGrpg,
      SalesOrganization,
      DistributionChannel,
      Language,
      WBSElementMaskID as WBSElementExternalID,
      Division,
      DynItemProcessorPrfl,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityType,
      JointVentureObjectType,
      JntIntrstBillgClass,
      JntIntrstBillgSubClass,
      StatusProfile,
      WBSStatusProfile,
      SimulationProfile,
      SchedulingScenario,
      DistributionProfile,
      PartnerDeterminationProcedure,
      FreeDefinedTableFieldSemantic,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedQuantity1,
      FreeDefinedQuantity1Unit,
      FreeDefinedQuantity2,
      FreeDefinedQuantity2Unit,
      FreeDefinedAmount1,
      FreeDefinedAmount1Currency,
      FreeDefinedAmount2,
      FreeDefinedAmount2Currency,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      ProjectObject,
      _WBSElement,
      _ResponsiblePerson,
      _ProjectApplicant
}