P_SingleResponsibleForProj

DDL: P_SINGLERESPONSIBLEFORPROJ Type: view_entity COMPOSITE Package: ODATA_PS_COS_PROJ_OVERVIEW

Returns the calculated single resp for a Project

P_SingleResponsibleForProj is a Composite CDS View that provides data about "Returns the calculated single resp for a Project" in SAP S/4HANA. It reads from 1 data source (I_EntProjectResponsiblePerson) and exposes 4 fields with key field ProjectInternalID. Part of development package ODATA_PS_COS_PROJ_OVERVIEW.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_EntProjectResponsiblePerson Responsible from

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID I_EntProjectResponsiblePerson ProjectInternalID
BusinessPartnerUUID I_EntProjectResponsiblePerson BusinessPartnerUUID
BusinessPartnerFullName _BusinessUser PersonFullName
IsBusinessPurposeCompleted _BusinessUser IsBusinessPurposeCompleted 
//@EndUserText.label: 'Returns the calculated single resp for a Project'

@VDM.viewType: #COMPOSITE

//@AbapCatalog: {

////    sqlViewName: 'PSNGLRSP4PRJ',

//    compiler.compareFilter: true

   // preserveKey:true

//}

@VDM.private:true
@ObjectModel: {  
   usageType: {
     serviceQuality:  #C,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #L
   }
}
//

//@ClientHandling.algorithm: #SESSION_VARIABLE

// this view will only show GUIDs, no data

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

//@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view entity P_SingleResponsibleForProj as select from I_EntProjectResponsiblePerson as Responsible

  association        to I_BusinessUserBasic as _BusinessUser    on $projection.BusinessPartnerUUID = _BusinessUser.BusinessPartnerUUID

//  association [0..1] to I_BPUsrExternalID   as _BPUsrExternalID on $projection.businesspartner          = _BPUsrExternalID.BusinessPartner

//                                                                and(

//                                                                  _BPUsrExternalID.BPIdentificationType = 'HCM001'

//                                                                  or // HCM001 - Employee ID

//                                                                  _BPUsrExternalID.BPIdentificationType = 'HCM030'

//                                                                  or // HCM030 - Service Agent

//                                                                  _BPUsrExternalID.BPIdentificationType = 'HCM031'

//                                                                )    // HCM031 - Freelancer

{
    key Responsible.ProjectInternalID,

    //  Responsible.ReferencedObjectUUID as ProjectSummaryTaskUUID,

      Responsible.BusinessPartnerUUID,
      
   _BusinessUser.PersonFullName            as BusinessPartnerFullName,
     // _BusinessPartner.BusinessPartner,

      //2508 Perf - begin

     // Responsible.ProjectInternalID,

      _BusinessUser.IsBusinessPurposeCompleted
      //2508 Perf - end


//      _BusinessPartner,

//      _BusinessUser,

//      _BPUsrExternalID

}
group by

Responsible.ProjectInternalID,

    //  Responsible.ReferencedObjectUUID as ProjectSummaryTaskUUID,

      Responsible.BusinessPartnerUUID,
      
   _BusinessUser.PersonFullName,
     // _BusinessPartner.BusinessPartner,

      //2508 Perf - begin

     // Responsible.ProjectInternalID,

      _BusinessUser.IsBusinessPurposeCompleted
      //2508 Perf - end

Learn More