C_SlsPriceWorkflowRecipientVH

DDL: C_SLSPRICEWORKFLOWRECIPIENTVH SQL: CSLSPRCGWFRCPTVH Type: view CONSUMPTION

Sales Price Workflow Recipient

C_SlsPriceWorkflowRecipientVH is a Consumption CDS View that provides data about "Sales Price Workflow Recipient" in SAP S/4HANA. It reads from 5 data sources (I_WorkforcePerson, I_PersonWorkAgrmtStatus, I_PersonWorkAgreement_1, P_SlsPriceWrkFlwPotntlApprvr, I_User) and exposes 6 fields with key field UserID.

5 data source(s) 6 fields

Data Sources (5)

SourceAliasJoin Type
I_WorkforcePerson _Employee inner
I_PersonWorkAgrmtStatus _EmployStatDet inner
I_PersonWorkAgreement_1 _PersonWorkAgreement inner
P_SlsPriceWrkFlwPotntlApprvr _PotntlApprvr inner
I_User _User inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSLSPRCGWFRCPTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Sales Price Workflow Recipient view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey UserID view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY UserID I_User UserID
PersonFullNameendasFullName
AuthorizationGroup I_WorkforcePerson AuthorizationGroup
IsBusinessPurposeCompleted I_WorkforcePerson IsBusinessPurposeCompleted
LastName I_WorkforcePerson LastName
PersonFullName I_WorkforcePerson PersonFullName 
@AbapCatalog.sqlViewName: 'CSLSPRCGWFRCPTVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Sales Price Workflow Recipient'

@Search.searchable: true

@VDM: {
  viewType: #CONSUMPTION
}
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.dataCategory:#VALUE_HELP


@ObjectModel.representativeKey: 'UserID'



define view C_SlsPriceWorkflowRecipientVH
  as select distinct from I_PersonWorkAgrmtOrglDetails as EmployOrgDet

    inner join            I_PersonWorkAgrmtStatus      as _EmployStatDet       on  EmployOrgDet.PersonWorkAgreement =  _EmployStatDet.PersonWorkAgreement
                                                                               and _EmployStatDet.StartDate         <= EmployOrgDet.EndDate
                                                                               and _EmployStatDet.EndDate           >= EmployOrgDet.StartDate

    inner join            I_PersonWorkAgreement_1      as _PersonWorkAgreement on  _EmployStatDet.PersonWorkAgreement= _PersonWorkAgreement.PersonWorkAgreement
    
    inner join            I_WorkforcePerson            as _Employee            on  _PersonWorkAgreement.Person  = _Employee.Person

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

    inner join           P_SlsPriceWrkFlwPotntlApprvr   as _PotntlApprvr        on  _User.UserID = _PotntlApprvr.UserID

{

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

      @Semantics.text: true
      case
        when _Employee.PersonFullName is initial
          then _Employee.LastName 
          else _Employee.PersonFullName
        end                                             as FullName,
      
      @Consumption.hidden: true
      _Employee.AuthorizationGroup,
      @Consumption.hidden: true
      _Employee.IsBusinessPurposeCompleted,
      
      @UI.hidden: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      _Employee.LastName,
      
      @UI.hidden: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      _Employee.PersonFullName

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

Learn More