C_EmployeeValueHelp

DDL: C_EMPLOYEEVALUEHELP SQL: CEMPLRESPVH Type: view CONSUMPTION

Employee Responsible

C_EmployeeValueHelp is a Consumption CDS View that provides data about "Employee Responsible" in SAP S/4HANA. It reads from 1 data source (I_PersonWorkAgreement_1) and exposes 19 fields with key field PersonnelNumber.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_PersonWorkAgreement_1 Employment from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CEMPLRESPVH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Employee Responsible view
ObjectModel.representativeKey PersonnelNumber view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber I_PersonWorkAgreement_1 PersonWorkAgreement
Person Employee Person
Employee Employee PersonExternalID
FirstName Employee FirstName
LastName Employee LastName
PersonFullName Employee PersonFullName
AuthorizationGroup Employee AuthorizationGroup
IsBusinessPurposeCompleted Employee IsBusinessPurposeCompleted
DataControllerSet Employee DataControllerSet
DataController1 Employee DataController1
DataController2 Employee DataController2
DataController3 Employee DataController3
DataController4 Employee DataController4
DataController5 Employee DataController5
DataController6 Employee DataController6
DataController7 Employee DataController7
DataController8 Employee DataController8
DataController9 Employee DataController9
DataController10 Employee DataController10 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CEMPLRESPVH'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Employee Responsible'

@ObjectModel.representativeKey: 'PersonnelNumber'
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: true

define view C_EmployeeValueHelp 
  as select from I_PersonWorkAgreement_1 as Employment 
  association[0..1] to I_WorkforcePerson as Employee on Employee.Person = Employment.Person
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      key Employment.PersonWorkAgreement as PersonnelNumber,
      
      @UI.hidden: true
      Employee.Person, //Internal ID

      
      Employee.PersonExternalID as Employee,

      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      Employee.FirstName,

      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      Employee.LastName,

      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      Employee.PersonFullName,
      
      // For Access control

      @Consumption.hidden: true
      @UI.hidden: true
      Employee.AuthorizationGroup,
      @Consumption.hidden: true
      @UI.hidden: true
      Employee.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController10
}                                                                                                                                           
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERSONWORKAGREEMENT_1",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[
"I_WORKFORCEPERSON"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More