R_PPM_PROJECTTASK

CDS View

Enterprise Project Element Internal

R_PPM_PROJECTTASK is a CDS View in S/4HANA. Enterprise Project Element Internal. It contains 16 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 16 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProjectDemandWorkPackageText view from COMPOSITE Textual information for work packages including project data

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ProjectElementUUID ProjectElementUUID 1
_ControllingArea _ControllingArea 1
_ProfitCenter _ProfitCenter 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
FunctionalArea FunctionalArea 1
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
Plant Plant 1
ProcessingStatus ProcessingStatus 1
ProfitCenter ProfitCenter 1
ProjectElementDescription ProjectElementDescription 1
ProjectInternalID ProjectInternalID 1
ProjectUUID ProjectUUID 1
ResponsibleCostCenter ResponsibleCostCenter 1
WBSElementInternalID WBSElementInternalID 1 
@EndUserText.label: 'Enterprise Project Element Internal'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@ObjectModel: {
   semanticKey  :     [ 'ProjectElement' ],
   representativeKey: 'ProjectElementUUID',
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ],
   usageType: {
     serviceQuality : #A,
     dataClass      : #MASTER,
     sizeCategory   : #XL
   }
}

//@Analytics.internalName:#LOCAL 

//@Analytics.dataExtraction: {

//        enabled :true,

//        delta.changeDataCapture: {

//            mapping:[

//                {

//                    table: '/s4ppm/task', role :#MAIN,

//                    viewElement: ['ProjectElementUUID'],

//                    tableElement: ['guid']

//                },

//                {

//                    table: 'prps', role :#LEFT_OUTER_TO_ONE_JOIN,

//                    viewElement: ['WBSElementInternalID'],

//                    tableElement: ['pspnr']

//                }

//            ]

//        }

//}

//@Analytics.dataCategory: #DIMENSION

//@Metadata.allowExtensions:true

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type:  #SAP_INTERNAL_API
}

define view entity R_PPM_ProjectTask
  as select from P_EnterpriseProjectElement as ProjectElement
  //For Cat 7 Authorization                                                                                      

  association [0..1] to I_EnterpriseProjectForUser     as _EnterpriseProjectForUser on _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID
{

key ProjectElement.ProjectElementUUID,
    ProjectElement.ProjectElement,
    ProjectElement.ProjectUUID,
    ProjectElement.ProjectElementDescription,
    ProjectElement.ProcessingStatus,
    ProjectElement.PlannedStartDate,
    ProjectElement.PlannedEndDate,
    ProjectElement.ActualStartDate,
    ProjectElement.ActualFinishDate,
    ProjectElement.SortingNumber,
    ProjectElement.EntProjectElementObjectType,
    ProjectElement.EntProjectElementType,
    ProjectElement.TaskTemplateUUID,
    ProjectElement.IsProjectMilestone,
    ProjectElement.TaxJurisdiction,
    ProjectElement.FunctionalLocation,
    ProjectElement.WBSElementIsBillingElement,
    ProjectElement.WBSElementInternalID,
    ProjectElement.ProjectInternalID,
    ProjectElement.WBSIsStatisticalWBSElement,
    ProjectElement.CompanyCode,
    ProjectElement.ControllingArea,
    ProjectElement.ProfitCenter,
    ProjectElement.FactoryCalendar,
    ProjectElement.CostCenter,
    ProjectElement.CostingSheet,
    ProjectElement.FunctionalArea,
    ProjectElement.InvestmentProfile,
    ProjectElement.AssetLocation,
    ProjectElement.Plant,
    ProjectElement.ResponsibleCostCenter,
    ProjectElement.ResultAnalysisInternalID,
    ProjectElement.LeadingSalesOrder,
    ProjectElement.LeadingSalesOrderItem,
    ProjectElement.CreatedByUser,
    ProjectElement.CreationDateTime,
    ProjectElement.LastChangedByUser,
    ProjectElement.LastChangeDateTime,
    
    ProjectElement._CompanyCode,
    ProjectElement._ControllingArea,
    ProjectElement._CostCenter,
    ProjectElement._EnterpriseProject,
    ProjectElement._FactoryCalendar,
    ProjectElement._FunctionalArea,
    ProjectElement._Hierarchy,
    ProjectElement._Plant,
    ProjectElement._ProcessingStatus,
    ProjectElement._ProfitCenter,
    ProjectElement._Project,
    ProjectElement._ResponsibleCostCenter,
    
    _EnterpriseProjectForUser

}

Learn More