I_EnterpriseProjectTP_2
Appl. Interface for Enterprise Project
I_EnterpriseProjectTP_2 is a Transactional CDS View that provides data about "Appl. Interface for Enterprise Project" in SAP S/4HANA. It reads from 1 data source (R_EnterpriseProject) and exposes 103 fields with key field ProjectUUID. It has 23 associations to related views. Part of development package VDM_PPM_OBJECTS_TP_PROJECT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_EnterpriseProject | _Project | from |
Associations (23)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_EnterpriseProjectElementTP_2 | _ProjWBSElement | _ProjWBSElement.ProjectUUID = $projection.ProjectUUID and _ProjWBSElement.IsProjectMilestone = '' |
| [0..*] | I_EnterpriseProjectElementTP_2 | _ProjMilestone | _ProjMilestone.ProjectUUID = $projection.ProjectUUID and _ProjMilestone.IsProjectMilestone = 'X' |
| [1..1] | R_EntProjTeamRoleStaffIntTP | _EntProjManager | _EntProjManager.ProjectUUID = $projection.ProjectUUID |
| [1..1] | R_EntProjStatusAreaTP | _StatusAreaData | _StatusAreaData.ProjectUUID = $projection.ProjectUUID |
| [1..1] | R_EntProjectNextEsnlMilestone | _NextEsnlMilestone | _NextEsnlMilestone.ProjectUUID = $projection.ProjectUUID |
| [1..1] | R_EntProjectNextRlvtMilestone | _NextRlvtMilestone | _NextRlvtMilestone.ProjectUUID = $projection.ProjectUUID |
| [0..1] | I_EntProjWorkflowOverview | _EntProjWorkflowOverview | _EntProjWorkflowOverview.ProjectUUID = $projection.ProjectUUID |
| [0..*] | R_EnterpriseProjectBriefCost | _ProjectCostLineItem | _ProjectCostLineItem.ProjectInternalID = $projection.ProjectInternalID |
| [0..1] | I_EntProjUserRoleAssignment | _EntProjUserRoleAssignment | _EntProjUserRoleAssignment.ProjectUUID = $projection.ProjectUUID |
| [1..1] | E_PPM_Project | _ProjectHeaderExtension | $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID |
| [1..1] | E_PPM_EngagementProject | _EngagementProjectExtension | $projection.ProjectUUID = _EngagementProjectExtension.ProjectUUID |
| [0..1] | I_EnterpriseProjectJVATP_2 | _EnterpriseProjectJVA | |
| [0..1] | I_EntProjectPublicSectorTP_2 | _EntProjectPublicSector | |
| [0..*] | I_EnterpriseProjectElementTP_2 | _EnterpriseProjectElement | |
| [0..*] | I_EntProjProjectObjectLinkTP | _EntProjProjectObjectLink | |
| [0..1] | R_EntProjectBlockFunctionTP_2 | _EntProjBlkFunc | |
| [0..*] | R_EnterpriseProjectRoleTP | _EntProjRole | |
| [0..*] | R_EntProjectTeamMemberTP | _EntProjTeamMember | |
| [0..*] | R_EntProjTeamRoleStaffIntTP | _EntProjRoleStaffing | |
| [0..*] | R_EnterpriseProjectHierarchyTP | _EntProjHierarchy | |
| [0..*] | R_EntProjectElementChangeTP | _EntProjElemChange | |
| [1..1] | R_EntProjLongDescriptionTP | _EntProjLongDesc | |
| [0..*] | R_EntProjStatusAreaTP | _EntProjStatusArea | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| ObjectModel.sapObjectNodeType.name | EnterpriseProject | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| EndUserText.label | Appl. Interface for Enterprise Project | view |
Fields (103)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectUUID | ProjectUUID | ||
| ProjectSummaryTaskUUID | ProjectSummaryTaskUUID | |||
| ProjectInternalID | ProjectInternalID | |||
| Project | Project | |||
| ProjectCategory | ProjectCategory | |||
| ProjectDescription | ProjectDescription | |||
| EnterpriseProjectType | EnterpriseProjectType | |||
| PriorityCode | PriorityCode | |||
| ProjectStartDate | ProjectStartDate | |||
| ProjectEndDate | ProjectEndDate | |||
| ActualStartDate | ActualStartDate | |||
| ActualEndDate | ActualFinishDate | |||
| CustomerUUID | CustomerUUID | |||
| EnterpriseProjectServiceOrg | EnterpriseProjectServiceOrg | |||
| EntProjectIsConfidential | EntProjectIsConfidential | |||
| RestrictedTimePosting | RestrictedTimePosting | |||
| ProcessingStatus | ProcessingStatus | |||
| ResponsibleCostCenter | ResponsibleCostCenter | |||
| ProfitCenter | ProfitCenter | |||
| ProjectProfileCode | ProjectProfileCode | |||
| FunctionalArea | FunctionalArea | |||
| CompanyCode | CompanyCode | |||
| ControllingArea | ControllingArea | |||
| Plant | Plant | |||
| Location | Location | |||
| TaxJurisdiction | TaxJurisdiction | |||
| ProjectCurrency | Currency | |||
| AvailabilityControlProfile | AvailabilityControlProfile | |||
| AvailabilityControlIsActive | AvailabilityControlIsActive | |||
| FunctionalLocation | FunctionalLocation | |||
| InvestmentProfile | InvestmentProfile | |||
| IsBillingRelevant | IsBillingRelevant | |||
| LastChangeDateTime | LastChangeDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| ProjectLastChangedDateTime | ProjectLastChangedDateTime | |||
| ProjectLastChangedByUser | ProjectLastChangedByUser | |||
| EntProjIsMultiSlsOrdItmsEnbld | EntProjIsMultiSlsOrdItmsEnbld | |||
| EntProjProfitabilitySegment | EntProjProfitabilitySegment | |||
| EntProjDemandCopyIsRequested | ||||
| EntProjSettlmtRuleCpyIsReqd | ||||
| EntProjHasProjectStockEnabled | EntProjHasProjectStockEnabled | |||
| EntProjectSettlementType | EntProjectSettlementType | |||
| EntProjectSettlementElement | EntProjectSettlementElement | |||
| InventorySpecialStockValnType | InventorySpecialStockValnType | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LeadingSalesOrder | LeadingSalesOrder | |||
| LeadingSalesOrderItem | LeadingSalesOrderItem | |||
| ResultAnalysisInternalID | ResultAnalysisInternalID | |||
| WBSElementInternalID | WBSElementInternalID | |||
| FactoryCalendar | FactoryCalendar | |||
| WBSElementObject | WBSElementObject | |||
| ProjectObject | ProjectObject | |||
| CostingSheet | CostingSheet | |||
| CostCenter | CostCenter | |||
| IsStatistical | WBSIsStatisticalWBSElement | |||
| ProjectTemplateUUID | ProjectTemplateUUID | |||
| ProjectManager | ||||
| _EntProjManager | _EntProjManager | |||
| _StatusAreaData | _StatusAreaData | |||
| _NextEsnlMilestone | _NextEsnlMilestone | |||
| _NextRlvtMilestone | _NextRlvtMilestone | |||
| _ProcessingStatusText | _ProcessingStatusText | |||
| _ProjectProfileText | _ProjectProfileText | |||
| _FunctionalLocationText | _FunctionalLocationText | |||
| _PriorityText | _PriorityText | |||
| _AvailabilityCtrlProfileText | _AvailabilityCtrlProfileText | |||
| _FunctionalAreaText | _FunctionalAreaText | |||
| _InvestmentProfileText | _InvestmentProfileText | |||
| _EnterpriseProjectTypeText | _EnterpriseProjectTypeText | |||
| _EntProjectSettlementTypeText | _EntProjectSettlementTypeText | |||
| _RsltAnlysKeyText | _RsltAnlysKeyText | |||
| _ControllingArea | _ControllingArea | |||
| _ResponsibleCostCenter | _ResponsibleCostCenter | |||
| _ProfitCenter | _ProfitCenter | |||
| _CreatedByUser | _CreatedByUser | |||
| _CostCenter | _CostCenter | |||
| _EntProjWorkflowOverview | _EntProjWorkflowOverview | |||
| _CompanyCode | _CompanyCode | |||
| _Plant | _Plant | |||
| _Location | _Location | |||
| _CostingSheetProcedure | _CostingSheetProcedure | |||
| _ProjWBSElement | _ProjWBSElement | |||
| _ProjMilestone | _ProjMilestone | |||
| _EnterpriseProjectJVA | _EnterpriseProjectJVA | |||
| _EntProjectPublicSector | _EntProjectPublicSector | |||
| _EnterpriseProjectElement | _EnterpriseProjectElement | |||
| _EntProjBlkFunc | _EntProjBlkFunc | |||
| _EntProjProjectObjectLink | _EntProjProjectObjectLink | |||
| _EntProjRole | _EntProjRole | |||
| _EntProjTeamMember | _EntProjTeamMember | |||
| _EntProjRoleStaffing | _EntProjRoleStaffing | |||
| _EntProjElemChange | _EntProjElemChange | |||
| _EntProjLongDesc | _EntProjLongDesc | |||
| _EntProjHierarchy | _EntProjHierarchy | |||
| _ProjectCostLineItem | _ProjectCostLineItem | |||
| _EntProjStatusArea | _EntProjStatusArea | |||
| _CustomerToBusinessPartner | _CustomerToBusinessPartner | |||
| _EnterpriseProjectSrvcOrgText | _EnterpriseProjectSrvcOrgText | |||
| _EntProjProfnlSrvcProjStgeTxt | _EntProjProfnlSrvcProjStgeTxt | |||
| _EnterpriseProjectForUser | _EnterpriseProjectForUser | |||
| _ProjectCurrencyText | _ProjectCurrencyText | |||
| _EntProjUserRoleAssignment | _EntProjUserRoleAssignment |
@Metadata.ignorePropagatedAnnotations: true
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ObjectModel: {
sapObjectNodeType:{
name: 'EnterpriseProject'},
usageType: {
dataClass: #MASTER,
serviceQuality: #C,
sizeCategory: #XL
}
}
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@EndUserText.label: 'Appl. Interface for Enterprise Project'
define root view entity I_EnterpriseProjectTP_2
as select from R_EnterpriseProject as _Project
composition [0..1] of I_EnterpriseProjectJVATP_2 as _EnterpriseProjectJVA
composition [0..1] of I_EntProjectPublicSectorTP_2 as _EntProjectPublicSector
composition [0..*] of I_EnterpriseProjectElementTP_2 as _EnterpriseProjectElement
composition [0..*] of I_EntProjProjectObjectLinkTP as _EntProjProjectObjectLink
composition [0..1] of R_EntProjectBlockFunctionTP_2 as _EntProjBlkFunc
composition [0..*] of R_EnterpriseProjectRoleTP as _EntProjRole
composition [0..*] of R_EntProjectTeamMemberTP as _EntProjTeamMember
composition [0..*] of R_EntProjTeamRoleStaffIntTP as _EntProjRoleStaffing
composition [0..*] of R_EnterpriseProjectHierarchyTP as _EntProjHierarchy
composition [0..*] of R_EntProjectElementChangeTP as _EntProjElemChange
composition [1..1] of R_EntProjLongDescriptionTP as _EntProjLongDesc
composition [0..*] of R_EntProjStatusAreaTP as _EntProjStatusArea
association [0..*] to I_EnterpriseProjectElementTP_2 as _ProjWBSElement on _ProjWBSElement.ProjectUUID = $projection.ProjectUUID
and _ProjWBSElement.IsProjectMilestone = ''
association [0..*] to I_EnterpriseProjectElementTP_2 as _ProjMilestone on _ProjMilestone.ProjectUUID = $projection.ProjectUUID
and _ProjMilestone.IsProjectMilestone = 'X'
association [1..1] to R_EntProjTeamRoleStaffIntTP as _EntProjManager on _EntProjManager.ProjectUUID = $projection.ProjectUUID
association [1..1] to R_EntProjStatusAreaTP as _StatusAreaData on _StatusAreaData.ProjectUUID = $projection.ProjectUUID
association [1..1] to R_EntProjectNextEsnlMilestone as _NextEsnlMilestone on _NextEsnlMilestone.ProjectUUID = $projection.ProjectUUID
association [1..1] to R_EntProjectNextRlvtMilestone as _NextRlvtMilestone on _NextRlvtMilestone.ProjectUUID = $projection.ProjectUUID
association [0..1] to I_EntProjWorkflowOverview as _EntProjWorkflowOverview on _EntProjWorkflowOverview.ProjectUUID = $projection.ProjectUUID
association [0..*] to R_EnterpriseProjectBriefCost as _ProjectCostLineItem on _ProjectCostLineItem.ProjectInternalID = $projection.ProjectInternalID
association [0..1] to I_EntProjUserRoleAssignment as _EntProjUserRoleAssignment on _EntProjUserRoleAssignment.ProjectUUID = $projection.ProjectUUID
// Association for extensibility
association [1..1] to E_PPM_Project as _ProjectHeaderExtension on $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID
association [1..1] to E_PPM_EngagementProject as _EngagementProjectExtension on $projection.ProjectUUID = _EngagementProjectExtension.ProjectUUID
{
key ProjectUUID as ProjectUUID,
ProjectSummaryTaskUUID as ProjectSummaryTaskUUID,
ProjectInternalID as ProjectInternalID,
Project as Project,
@Consumption.hidden: true
ProjectCategory as ProjectCategory,
ProjectDescription as ProjectDescription,
EnterpriseProjectType as EnterpriseProjectType,
PriorityCode as PriorityCode,
ProjectStartDate as ProjectStartDate,
ProjectEndDate as ProjectEndDate,
ActualStartDate as ActualStartDate,
ActualFinishDate as ActualEndDate,
//2008 C4P Harmonization Start
CustomerUUID as CustomerUUID,
EnterpriseProjectServiceOrg as EnterpriseProjectServiceOrg,
@Semantics.booleanIndicator
EntProjectIsConfidential as EntProjectIsConfidential,
RestrictedTimePosting as RestrictedTimePosting,
//2008 C4P Harmonization End
ProcessingStatus as ProcessingStatus,
ResponsibleCostCenter as ResponsibleCostCenter,
ProfitCenter as ProfitCenter,
ProjectProfileCode as ProjectProfileCode,
FunctionalArea as FunctionalArea,
CompanyCode as CompanyCode,
ControllingArea as ControllingArea,
Plant as Plant,
Location as Location,
TaxJurisdiction as TaxJurisdiction,
Currency as ProjectCurrency,
AvailabilityControlProfile as AvailabilityControlProfile,
AvailabilityControlIsActive as AvailabilityControlIsActive,
FunctionalLocation as FunctionalLocation,
InvestmentProfile as InvestmentProfile,
IsBillingRelevant as IsBillingRelevant,
LastChangeDateTime as LastChangeDateTime,
LastChangedByUser as LastChangedByUser,
ProjectLastChangedDateTime as ProjectLastChangedDateTime,
ProjectLastChangedByUser as ProjectLastChangedByUser,
//2102 SD eppm N:1 indicator
EntProjIsMultiSlsOrdItmsEnbld as EntProjIsMultiSlsOrdItmsEnbld,
// CE2602 Profitability Segment
EntProjProfitabilitySegment as EntProjProfitabilitySegment,
cast ( '' as boole_d preserving type ) as EntProjDemandCopyIsRequested,
cast ( '' as boole_d preserving type ) as EntProjSettlmtRuleCpyIsReqd,
EntProjHasProjectStockEnabled as EntProjHasProjectStockEnabled,
EntProjectSettlementType as EntProjectSettlementType,
EntProjectSettlementElement as EntProjectSettlementElement,
InventorySpecialStockValnType as InventorySpecialStockValnType,
// EntProjSettlementRuleControl as EntProjSettlementRuleControl,
//2202 Enable draft for RAP BO ---Start
CreatedByUser as CreatedByUser,
CreationDateTime as CreationDateTime,
LeadingSalesOrder as LeadingSalesOrder,
LeadingSalesOrderItem as LeadingSalesOrderItem,
ResultAnalysisInternalID as ResultAnalysisInternalID,
WBSElementInternalID as WBSElementInternalID,
FactoryCalendar as FactoryCalendar,
WBSElementObject as WBSElementObject,
ProjectObject as ProjectObject,
CostingSheet as CostingSheet,
CostCenter as CostCenter,
WBSIsStatisticalWBSElement as IsStatistical,
ProjectTemplateUUID as ProjectTemplateUUID,
cast( '' as bu_partner ) as ProjectManager,
// IsMyProject as IsMyProject,
// MasterProjectIsConfidential as MasterProjectIsConfidential,
//2202 Enable draft for RAP BO ---End
_EntProjManager,
_StatusAreaData,
_NextEsnlMilestone,
_NextRlvtMilestone,
_ProcessingStatusText,
_ProjectProfileText,
_FunctionalLocationText,
_PriorityText,
_AvailabilityCtrlProfileText,
_FunctionalAreaText,
_InvestmentProfileText,
_EnterpriseProjectTypeText,
_EntProjectSettlementTypeText,
_RsltAnlysKeyText,
_ControllingArea,
_ResponsibleCostCenter,
_ProfitCenter,
_CreatedByUser,
_CostCenter,
_EntProjWorkflowOverview,
_CompanyCode,
_Plant,
_Location,
_CostingSheetProcedure,
_ProjWBSElement,
_ProjMilestone,
_EnterpriseProjectJVA,
_EntProjectPublicSector,
_EnterpriseProjectElement,
_EntProjBlkFunc,
_EntProjProjectObjectLink,
_EntProjRole,
_EntProjTeamMember,
_EntProjRoleStaffing,
_EntProjElemChange,
_EntProjLongDesc,
_EntProjHierarchy,
_ProjectCostLineItem,
_EntProjStatusArea,
_CustomerToBusinessPartner,
_EnterpriseProjectSrvcOrgText,
_EntProjProfnlSrvcProjStgeTxt,
_EnterpriseProjectForUser,
_ProjectCurrencyText,
_EntProjUserRoleAssignment
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA