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
  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._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,
      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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTDATA",
"I_PROJECTOBJECTSHORTTEXT"
],
"ASSOCIATED":
[
"E_PROJECT_2",
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON",
"I_PROJECTTEXT",
"R_WBSELEMENTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/