I_PPM_PROJECTSUMMARYTASK
Project, Projecttemplate or snapshot
I_PPM_PROJECTSUMMARYTASK is a CDS View in S/4HANA. Project, Projecttemplate or snapshot. It contains 55 fields. 35 CDS views read from this table.
CDS Views using this table (35)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PPM_MyActvProjectsCostTable | view | from | CONSUMPTION | My Projects - Cost Table (OVP) |
| C_ProjectFinCtrlrOvw | view | left_outer | CONSUMPTION | Project Financial Controller Overview |
| D_EnterpriseProjActSetProcgSts | view | from | Enterprise Proj API Actn Set Processing Status | |
| I_AccountAssignmentWBSElmntVH | view | inner | COMPOSITE | Account Assignment WBS Elmnt Value Help |
| I_BlockFuncForEntProject | view | from | COMPOSITE | Basic view for block function calculation |
| I_DfsEnterpriseProject | view | from | COMPOSITE | Defence Enterprise Projects |
| I_EnterpriseProjectElementTP | view | inner | TRANSACTIONAL | TP view for CRUD API for EPPM Workpackages and milestones |
| I_EnterpriseProjectRankingCost | view | left_outer | COMPOSITE | Costs of projects assigned to Ranking |
| I_EnterpriseProjectVH | view | from | COMPOSITE | Enterprise Project value help |
| I_PPM_IsMyProjectAsSubstitute | view | inner | COMPOSITE | All prjs a usr is rsp for as a subst |
| I_PPM_MostCriticalProject | view | from | COMPOSITE | My Projects - Critical |
| I_PPM_MyActvProjectsStsArea | view | inner | COMPOSITE | My Projects - Active: Status Area |
| I_PPM_MyChecklistItem | view | inner | COMPOSITE | Returns My Checklist Items |
| I_PPM_Myplannedprojects | view | from | COMPOSITE | My Projects – Planned |
| I_PPM_MyTask | view | inner | COMPOSITE | My Tasks |
| I_PPM_ObjectPageChecklistItem | view | left_outer | COMPOSITE | Determines Checklist Items |
| I_PPM_ProjectCostForecastData | view | from | COMPOSITE | Project Cost Forecast: ML Training Input |
| I_PPM_ProjectCostSumCurrent | view | from | COMPOSITE | Project Cost To Current Date |
| I_PPM_ProjectCostSumToDate | view | from | COMPOSITE | Project Cost To Date |
| I_PPM_ProjectElement | view | left_outer | COMPOSITE | Project Element |
| I_PPM_ProjectForUpdate | view | from | COMPOSITE | Lists all projects which can be updated |
| I_PPM_ProjectObjectLink | view | inner | COMPOSITE | PPM Project Object Link |
| I_PPM_ProjectPublicSector | view | from | COMPOSITE | Extension for Public Sector Fields |
| I_PPM_ProjectSearch | view | from | COMPOSITE | Basic Enterprise Search view for projects |
| I_PPM_ProjectStatusArea | view | inner | COMPOSITE | PPM Project Status Area Compositional Hierarchy View |
| I_PPM_ProjJntVentureAccounting | view | from | COMPOSITE | Extension for Joint Venture Accounting |
| I_PPM_SingleResponsibleForProj | view | inner | COMPOSITE | Returns the calculated single responsible for a project |
| I_PPM_UpcMilestonesProjects | view | inner | COMPOSITE | Upcoming Milestones for Projects |
| P_ActvPROJECTSWITHPROJCAT6 | view | inner | COMPOSITE | |
| P_PPM_Project | view | from | COMPOSITE | |
| P_PPM_ProjectList | view | from | COMPOSITE | |
| P_PPM_Prstcm_ProjData | view | from | CONSUMPTION | |
| P_PPM_PrStCmrProjByKeyFigures | view | from | COMPOSITE | |
| P_ProjectsWithProjCat6 | view | inner | COMPOSITE | |
| P_PROJWITHPROJCAT6 | view | from | COMPOSITE |
Fields (55)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjectInternalID | ProjectInternalID | 12 |
| KEY | ProjectSummaryTaskUUID | ParentObjectUUID,ProjectSummaryTaskUUID | 23 |
| KEY | ProjectUUID | ProjectUUID | 21 |
| _AuthGroup | _AuthGroup | 11 | |
| _AuthRole | _AuthRole | 11 | |
| _AuthSubst | _AuthSubst | 11 | |
| _AuthUser | _AuthUser | 11 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| _I_Project | _I_Project | 2 | |
| _PriorityText | _PriorityText | 1 | |
| _ProjectLastChangedByUser | _ProjectLastChangedByUser | 1 | |
| _ProjectType | _ProjectType | 1 | |
| _ProjectTypeName | _ProjectTypeName | 1 | |
| _ProjObjRoot | _ProjObjRoot | 7 | |
| ActualFinishDate | ActualEndDate | 1 | |
| ActualFinishDateTime | ActualFinishDateTime | 1 | |
| ActualStartDate | ActualStartDate | 1 | |
| ActualStartDateTime | ActualStartDateTime | 1 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDateTime | CreationDateTime | 3 | |
| DurationUnit | DurationUnit | 1 | |
| EarliestFinishDateTime | EarliestFinishDateTime | 1 | |
| EarliestStartDateTime | EarliestStartDateTime | 1 | |
| EntProjIsMultiSlsOrdItmsEnbld | EntProjIsMultiSlsOrdItmsEnbld | 1 | |
| FinishConstraintDateTime | FinishConstraintDateTime | 1 | |
| ForecastedFinishDateTime | ForecastedFinishDateTime | 1 | |
| ForecastedStartDate | ForecastedEndDate,ForecastedStartDate | 1 | |
| ForecastedStartDateTime | ForecastedStartDateTime | 1 | |
| IsSummaryTaskEnabled | IsSummaryTaskEnabled | 1 | |
| LastChangeDateTime | ProjectLastChangedDateTime | 1 | |
| LatestFinishDate | ProjectEndDate | 3 | |
| LatestFinishDateTime | LatestFinishDateTime | 1 | |
| LatestStartDate | ProjectStartDate | 3 | |
| LatestStartDateTime | LatestStartDateTime | 1 | |
| MasterLanguage | MasterLanguage | 6 | |
| OrganizationalUnit | OrganizationalUnit | 2 | |
| OrganizationalUnitObjectType | OrganizationalUnitObjectType | 2 | |
| PlanVersion | PlanVersion | 2 | |
| PriorityCode | PriorityCode | 5 | |
| Project | Project | 12 | |
| ProjectCategory | ProjectCategory | 6 | |
| ProjectEarliestOrLatest | ProjectEarliestOrLatest | 1 | |
| ProjectElementDuration | ProjectElementDuration | 2 | |
| ProjectLastChangedByUser | LastChangedByUser,ProjectLastChangedByUser | 3 | |
| ProjectLastChangedDateTime | LastChangeDateTime,ProjectLastChangedDateTime | 3 | |
| ProjectLocation | ProjectLocation | 1 | |
| ProjectName | ProjectName,ProjectNameMasterLanguage | 9 | |
| ProjectProcessingStatus | ProcessingStatus,ProjectProcessingStatus | 8 | |
| ProjectReasonCode | ProjectReasonCode | 1 | |
| ProjectTemplateUUID | ProjectTemplateUUID | 1 | |
| ProjectType | ProjectType | 4 | |
| ProjectVersionNumber | ProjectVersionNumber | 2 | |
| ReleaseDateTime | ReleaseDateTime | 1 | |
| StartConstraintDateTime | StartConstraintDateTime | 1 | |
| WBSElementInternalID | WBSElementInternalID | 12 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Project, Projecttemplate or snapshot
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PPM_PROJECTSUMMARYTASK (
PROJECTINTERNALID,
PROJECTSUMMARYTASKUUID,
PROJECTUUID,
_AUTHGROUP,
_AUTHROLE,
_AUTHSUBST,
_AUTHUSER,
_CREATEDBYUSER,
_I_PROJECT,
_PRIORITYTEXT,
_PROJECTLASTCHANGEDBYUSER,
_PROJECTTYPE,
_PROJECTTYPENAME,
_PROJOBJROOT,
ACTUALFINISHDATE,
ACTUALFINISHDATETIME,
ACTUALSTARTDATE,
ACTUALSTARTDATETIME,
CREATEDBYUSER,
CREATIONDATETIME,
DURATIONUNIT,
EARLIESTFINISHDATETIME,
EARLIESTSTARTDATETIME,
ENTPROJISMULTISLSORDITMSENBLD,
FINISHCONSTRAINTDATETIME,
FORECASTEDFINISHDATETIME,
FORECASTEDSTARTDATE,
FORECASTEDSTARTDATETIME,
ISSUMMARYTASKENABLED,
LASTCHANGEDATETIME,
LATESTFINISHDATE,
LATESTFINISHDATETIME,
LATESTSTARTDATE,
LATESTSTARTDATETIME,
MASTERLANGUAGE,
ORGANIZATIONALUNIT,
ORGANIZATIONALUNITOBJECTTYPE,
PLANVERSION,
PRIORITYCODE,
PROJECT,
PROJECTCATEGORY,
PROJECTEARLIESTORLATEST,
PROJECTELEMENTDURATION,
PROJECTLASTCHANGEDBYUSER,
PROJECTLASTCHANGEDDATETIME,
PROJECTLOCATION,
PROJECTNAME,
PROJECTPROCESSINGSTATUS,
PROJECTREASONCODE,
PROJECTTEMPLATEUUID,
PROJECTTYPE,
PROJECTVERSIONNUMBER,
RELEASEDATETIME,
STARTCONSTRAINTDATETIME,
WBSELEMENTINTERNALID,
PRIMARY KEY (PROJECTINTERNALID, PROJECTSUMMARYTASKUUID, PROJECTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA