C_ChgRecdWorkflowRecipientVH

DDL: C_CHGRECDWORKFLOWRECIPIENTVH SQL: CCRPPWFL Type: view CONSUMPTION

People Picker for Change Record task processor

C_ChgRecdWorkflowRecipientVH is a Consumption CDS View that provides data about "People Picker for Change Record task processor" in SAP S/4HANA. It reads from 3 data sources (I_Employee, I_EmployStatDet, I_User) and exposes 3 fields with key field UserID.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
I_Employee _Employee inner
I_EmployStatDet _EmployStatDet inner
I_User _User inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCRPPWFL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view
VDM.viewType #CONSUMPTION view
EndUserText.label People Picker for Change Record task processor view
ObjectModel.semanticKey UserID view
ObjectModel.representativeKey UserID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY UserID I_User UserID
FullName I_Employee EmployeeFullName
Employee 
@AbapCatalog.sqlViewName: 'CCRPPWFL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'People Picker for Change Record task processor'
@ObjectModel: {
    semanticKey: 'UserID',
    representativeKey: 'UserID',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #L,
    usageType.dataClass: #MIXED
}
define view C_ChgRecdWorkflowRecipientVH as select distinct from I_EmployOrgDet   as EmployOrgDet

    inner join            I_EmployStatDet as _EmployStatDet on  EmployOrgDet.EmploymentInternalID =  _EmployStatDet.EmploymentInternalID
                                                            and _EmployStatDet.StartDate          <= EmployOrgDet.EndDate
                                                            and _EmployStatDet.EndDate            >= EmployOrgDet.StartDate

    inner join            I_Employee      as _Employee      on _EmployStatDet.PersonnelNumber = _Employee.PersonnelNumber

    inner join            I_User          as _User          on _Employee.BusinessPartnerUUID = _User.BusinessPartnerUUID

 
{
      @ObjectModel.text.element: 'FullName'
      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      key _User.UserID                      as UserID,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      _Employee.EmployeeFullName        as FullName,
      cast( _Employee.Employee as mmpur_employee_id ) as Employee

}
where
      EmployOrgDet.EndDate            >= $session.system_date
  and _EmployStatDet.EmploymentStatus = '1'

Learn More