I_PPM_TaskSearch

Task data for Enterprise Search consumption | view: IPPMTASK4SEARCH | TRAN | Extraction: Not supported | Component: Virtual Data Model for Portfolio and Project Mgmnt
Column Name Description
TaskUUID Entity Guid
Column Name Description
💲 Currency Key (ManualRevenueRateCurrency):
ManualRevenueRate Different Revenue
💲 Currency Key (ManualCostRateCurrency):
ManualCostRate Different Costs
Column Name Description
📏 Unit for Work (PlannedWorkQuantityUnit):
RemainingWorkQuantityInSeconds Remaining Work
ActualWorkQuantityInSeconds Confirmation (Insternal Display)
PlannedWorkQuantity Work
Column Name Description
Column Name Description
ObjectType Object Category in Project Planning Show values
TaskProcessingStatus Object Processing Status Show values
TaskParentProcessingStatus Processing Status of Higher-Level Object Show values
IsSummaryTask Summary Task Show values
IsApprovalRelevant Relevant for Approval Show values
StartConstraintType Type of Scheduling Constraint Show values
FinishConstraintType Type of Scheduling Constraint Show values
IsManualRemainingWorkEnabled Enter Remaining Work Manually Show values
IsMirroredTask Mirrored Task Show values
IsReschedulingRequired Rescheduling Required Show values
SchedulingStatus Status of Scheduling Data Show values
SchedulingBehavior Scheduling Behavior Show values
Column Name Description Domain name
ExternalId Identification of Entities /S4PPM/EXTERNAL_ID
ProjectVersionNumber Version DPR_TV_VERSION
SortingNumber Sort Number
ProjectUUID Entity Guid /S4PPM/GUID
IsProjectMilestone Milestone flag CHAR1
PriorityCode Priority NUMC3
TaskType Task Type DPR_TSK_TYPE
FactoryCalendar Factory Calendar WFCID
EarliestStartDateTime Planned start date (Earliest Start) TZNTSTMPS
EarliestFinishDateTime Planned start date (Earliest Finish) TZNTSTMPS
StartConstraintDateTime Constraint Date TZNTSTMPS
FinishConstraintDateTime Constraint Date TZNTSTMPS
ActualStartDateTime Actual Start TZNTSTMPS
ActualFinishDateTime Actual Finish TZNTSTMPS
LatestStartDateTime Latest start TZNTSTMPS
LatestFinishDateTime Latest finish TZNTSTMPS
TotalFloat Total Float
ForecastedStartDateTime Forecast Start TZNTSTMPS
ForecastedFinishDateTime Forecast Finish TZNTSTMPS
ProjectElementDuration Duration of Execution
PercentageOfCompletion Percentage of Completion
ReleaseDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
StatusProfile Status Profile Template J_STSMA
CostRevenueRateCode Cost Rate/Revenue Rate for Project Costing DPR_RATE_TYPE
CreatedByUser Name of Person Who Created Object
CreationDateTime Timestamp of Object Creation TZNTSTMPS
LastChangedByUser Name of Person Who Changed Object USNAM
LastChangeDateTime Timestamp of Last Object Change TZNTSTMPS