R_PROJECTTP_2
TP for I view I ProjectData 2
R_PROJECTTP_2 is a CDS View in S/4HANA. TP for I view I ProjectData 2. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_Project_3 | view_entity | projection | COMPOSITE | Project data details |
@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
}