I_PPM_PROJECTTASK
Milestone Information
I_PPM_PROJECTTASK is a CDS View in S/4HANA. Milestone Information. It contains 56 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_EntProjElmntMassChgParameter | view | from | CONSUMPTION | Parameters for Project Element Mass Change |
| C_EntProjElmntWthProjMassChg | view | from | CONSUMPTION | WBS Element with Projects for Mass Change |
| C_EntProjWrkPckgProjectStatus | view | from | CONSUMPTION | WBS Element object page processing status |
| I_BlockFuncForEntProjElmnt | view | from | COMPOSITE | Basic view for block function calculation |
| I_EnterpriseProjectElementTP | view | from | TRANSACTIONAL | TP view for CRUD API for EPPM Workpackages and milestones |
| I_PPM_ProjectTaskTP | view | from | TRANSACTIONAL | Milestone Information - transac. proc. |
| P_EntProjElmntBlockFunc | view | from | COMPOSITE | |
| P_FuncnlAreaWBSElmnt | view | from | COMPOSITE | WUFAREA WBS Elements |
| P_FundWBSElement | view | from | COMPOSITE | WUFUND WBS Elements |
| P_GrantWBSElement | view | from | COMPOSITE | WUGRANT WBS Elements |
| P_SpnsrdPgmWBSElmnt | view | from | COMPOSITE | WUSPDPGM WBS Elements |
Fields (56)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | TaskUUID | ProjectElementUUID,TaskUUID | 4 |
| _AuthGroup | _AuthGroup | 2 | |
| _AuthRole | _AuthRole | 2 | |
| _AuthSubst | _AuthSubst | 2 | |
| _AuthUser | _AuthUser | 2 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 2 | |
| _CostCenter | _CostCenter | 1 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| _FactoryCalendar | _FactoryCalendar | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _I_Project | _I_Project | 1 | |
| _Plant | _Plant | 1 | |
| _ProcessingStatus | _ProcessingStatus | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjectRoot | _ProjectRoot | 1 | |
| _ProjObjRoot | _ProjObjRoot | 1 | |
| _ResponsibleCostCenter | _ResponsibleCostCenter | 2 | |
| _Root | _Root | 1 | |
| ActualEndDate | ActualEndDate | 2 | |
| ActualStartDate | ActualStartDate | 2 | |
| CompanyCode | CompanyCode | 3 | |
| ControllingArea | ControllingArea | 3 | |
| CostCenter | CostCenter | 2 | |
| CostingSheet | CostingSheet | 2 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationDateTime | CreationDateTime | 2 | |
| FactoryCalendar | FactoryCalendar | 2 | |
| ForecastedEndDate | ForecastedEndDate | 1 | |
| ForecastedStartDate | ForecastedStartDate | 1 | |
| FunctionalArea | FunctionalArea | 3 | |
| FunctionalLocation | FunctionalLocation | 1 | |
| InvestmentProfile | InvestmentProfile | 2 | |
| IsMainMilestone | IsMainMilestone | 1 | |
| IsProjectMilestone | IsProjectMilestone | 2 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangedByUser | LastChangedByUser | 2 | |
| Location | Location | 1 | |
| MilestoneApprovalStatus | MilestoneApprovalStatus | 1 | |
| ObjectType | ObjectType | 1 | |
| ParentObjectUUID | ParentObjectUUID | 1 | |
| PlannedEndDate | PlannedEndDate | 2 | |
| PlannedStartDate | PlannedStartDate | 2 | |
| Plant | Plant | 3 | |
| ProcessingStatus | ProcessingStatus | 2 | |
| ProfitCenter | ProfitCenter | 3 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectUUID | ProjectUUID | 4 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 3 | |
| SortingNumber | SortingNumber | 1 | |
| Task | ProjectElement | 1 | |
| TaskName | TaskName | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| WBSElementInternalID | WBSElementInternalID | 2 | |
| WBSElementIsBillingElement | IsBillingRelevant,WBSElementIsBillingElement | 2 | |
| WBSIsStatisticalWBSElement | WBSIsStatisticalWBSElement | 1 |
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.
-- Milestone Information
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PPM_PROJECTTASK (
TASKUUID,
_AUTHGROUP,
_AUTHROLE,
_AUTHSUBST,
_AUTHUSER,
_COMPANYCODE,
_CONTROLLINGAREA,
_COSTCENTER,
_CREATEDBYUSER,
_FACTORYCALENDAR,
_FUNCTIONALAREA,
_I_PROJECT,
_PLANT,
_PROCESSINGSTATUS,
_PROFITCENTER,
_PROJECTROOT,
_PROJOBJROOT,
_RESPONSIBLECOSTCENTER,
_ROOT,
ACTUALENDDATE,
ACTUALSTARTDATE,
COMPANYCODE,
CONTROLLINGAREA,
COSTCENTER,
COSTINGSHEET,
CREATEDBYUSER,
CREATIONDATETIME,
FACTORYCALENDAR,
FORECASTEDENDDATE,
FORECASTEDSTARTDATE,
FUNCTIONALAREA,
FUNCTIONALLOCATION,
INVESTMENTPROFILE,
ISMAINMILESTONE,
ISPROJECTMILESTONE,
LASTCHANGEDATETIME,
LASTCHANGEDBYUSER,
LOCATION,
MILESTONEAPPROVALSTATUS,
OBJECTTYPE,
PARENTOBJECTUUID,
PLANNEDENDDATE,
PLANNEDSTARTDATE,
PLANT,
PROCESSINGSTATUS,
PROFITCENTER,
PROJECTINTERNALID,
PROJECTUUID,
RESPONSIBLECOSTCENTER,
SORTINGNUMBER,
TASK,
TASKNAME,
TAXJURISDICTION,
WBSELEMENTINTERNALID,
WBSELEMENTISBILLINGELEMENT,
WBSISSTATISTICALWBSELEMENT,
PRIMARY KEY (TASKUUID)
);
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