P_InvoiceWorkFlowRecipient

DDL: P_INVOICEWORKFLOWRECIPIENT SQL: PINVPPWFL Type: view COMPOSITE Package: APPL_MM_IV_WORKFLOW

People Picker for Manage Workflow for Supplier Invoices

P_InvoiceWorkFlowRecipient is a Composite CDS View that provides data about "People Picker for Manage Workflow for Supplier Invoices" in SAP S/4HANA. It reads from 4 data sources (I_User, I_PersonWorkAgreement_1, I_PersonWorkAgrmtStatus, I_WorkforcePerson) and exposes 3 fields with key field UserID. Part of development package APPL_MM_IV_WORKFLOW.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
I_User _User inner
I_PersonWorkAgreement_1 _WorkAgreement inner
I_PersonWorkAgrmtStatus _WorkAgreementStatus inner
I_WorkforcePerson _WorkforcePerson from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PINVPPWFL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY UserID I_User UserID
FullName I_WorkforcePerson PersonFullName
Employee 
@AbapCatalog.sqlViewName: 'PINVPPWFL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
    serviceQuality: #D,
    sizeCategory: #XL,
    dataClass: #MIXED
}
define view P_InvoiceWorkFlowRecipient
  as select from I_WorkforcePerson       as _WorkforcePerson

    inner join   I_PersonWorkAgreement_1 as _WorkAgreement       on _WorkforcePerson.Person = _WorkAgreement.Person

    inner join   I_PersonWorkAgrmtStatus as _WorkAgreementStatus on _WorkAgreement.PersonWorkAgreement = _WorkAgreementStatus.PersonWorkAgreement

    inner join   I_User                  as _User                on _User.BusinessPartnerUUID = _WorkforcePerson.BusinessPartnerUUID
{
  key _User.UserID                                                                   as UserID,
      _WorkforcePerson.PersonFullName                                                as FullName,
      cast( _WorkforcePerson.PersonExternalID as mmpur_employee_id preserving type ) as Employee
}
where
       _WorkAgreementStatus.WorkAgreementStatus    = '1'
  and  _WorkAgreementStatus.EndDate                >= $session.system_date
  and(
       _WorkforcePerson.IsBusinessPurposeCompleted = ''
    or _WorkforcePerson.IsBusinessPurposeCompleted is null
  )

Learn More