R_ProjectTP_2

DDL: R_PROJECTTP_2 Type: view_entity TRANSACTIONAL Package: VDM_PS_PROJECT_TP

TP for I view I ProjectData 2

R_ProjectTP_2 is a Transactional CDS View that provides data about "TP for I view I ProjectData 2" in SAP S/4HANA. It reads from 1 data source (I_ProjectData_2) and exposes 83 fields with key field ProjectInternalID. It has 3 associations to related views. Part of development package VDM_PS_PROJECT_TP.

Data Sources (1)

SourceAliasJoin Type
I_ProjectData_2 I_ProjectData_2 from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProjectText _ProjectText $projection.ProjectObject = _ProjectText.ProjectObject and _ProjectText.Language = $session.system_language ---Extension
[1..1] E_Project_2 _Extension $projection.ProjectInternalID = _Extension.ProjectInternalID
[1..*] R_WBSElementTP_2 _WBSElement

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP for I view I ProjectData 2 view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name Project view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (83)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID
ProjectDescription ProjectDescription
ProjectLangBsdDescription _ProjectText ProjectLangBsdDescription
ProjectProfileCode ProjectProfileCode
CompanyCode CompanyCode
ControllingArea ControllingArea
FunctionalArea FunctionalArea
ProfitCenter ProfitCenter
PlannedStartDate PlannedStartDate
PlannedEndDate PlannedEndDate
WorkCenterLocation WorkCenterLocation
TaxJurisdiction TaxJurisdiction
ResponsiblePerson ResponsiblePerson
ResponsiblePersonName ResponsiblePersonName
ApplicantCode ApplicantCode
ApplicantName ApplicantName
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
BasicDatesLastScheduledDate BasicDatesLastScheduledDate
FcstdDatesLastScheduledDate FcstdDatesLastScheduledDate
FactoryCalendar FactoryCalendar
SchedulingDurationUnit SchedulingDurationUnit
BusinessArea BusinessArea
Plant Plant
Currency Currency
BudgetProfile BudgetProfile
PlanningProfile PlanningProfile
InvestmentProfile InvestmentProfile
ProjInterestCalcProfile ProjInterestCalcProfile
ResultAnalysisInternalID ResultAnalysisInternalID
ControllingObjectClass ControllingObjectClass
NetworkProfile NetworkProfile
WBSSchedulingProfile WBSSchedulingProfile
PlanningMethForProjBasicDate PlanningMethForProjBasicDate
PlanningMethForProjFcstdDate PlanningMethForProjFcstdDate
NetworkAssignmentType NetworkAssignmentType
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement
WBSIsMarkedForIntegratedPlng WBSIsMarkedForIntegratedPlng
ProjectHasOwnStock ProjectHasOwnStock
InventorySpecialStockValnType InventorySpecialStockValnType
WBSIsMarkedForAutomReqmtGrpg WBSIsMarkedForAutomReqmtGrpg
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Language Language
WBSElementMaskID WBSElementMaskID
Division Division
DynItemProcessorPrfl DynItemProcessorPrfl
JointVenture JointVenture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode
JointVentureEquityType JointVentureEquityType
JointVentureObjectType JointVentureObjectType
JntIntrstBillgClass JntIntrstBillgClass
JntIntrstBillgSubClass JntIntrstBillgSubClass
StatusProfile StatusProfile
WBSStatusProfile WBSStatusProfile
SimulationProfile SimulationProfile
SchedulingScenario SchedulingScenario
DistributionProfile DistributionProfile
PartnerDeterminationProcedure PartnerDeterminationProcedure
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedQuantity1 FreeDefinedQuantity1
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit
FreeDefinedQuantity2 FreeDefinedQuantity2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit
FreeDefinedAmount1 FreeDefinedAmount1
FreeDefinedAmount1Currency FreeDefinedAmount1Currency
FreeDefinedAmount2 FreeDefinedAmount2
FreeDefinedAmount2Currency FreeDefinedAmount2Currency
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedIndicator1 FreeDefinedIndicator1
FreeDefinedIndicator2 FreeDefinedIndicator2
ProjectObject ProjectObject
StatusCombinationCode StatusCombinationCode
_WBSElement _WBSElement
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP for I view I ProjectData 2'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
   sapObjectNodeType:{
      name: 'Project'},
   usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}
define root view entity R_ProjectTP_2
  as select from I_ProjectData_2
  composition [1..*] of R_WBSElementTP_2 as _WBSElement
  ---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
{
  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
      _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,
      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,
      StatusCombinationCode,

      //Associataions

      _WBSElement,
      @Consumption.hidden: true
      _ResponsiblePerson,
      @Consumption.hidden: true
      _ProjectApplicant
}