C_EngmtProjTeamSrchHelp

DDL: C_ENGMTPROJTEAMSRCHHELP SQL: CENGPROJTEAMSRCH Type: view CONSUMPTION

Search Help For JAM

C_EngmtProjTeamSrchHelp is a Consumption CDS View that provides data about "Search Help For JAM" in SAP S/4HANA. It reads from 1 data source (I_WorkforcePerson) and exposes 15 fields with key field PersonWorkAgreement. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkforcePerson WorkforcePerson inner

Associations (1)

CardinalityTargetAliasCondition
[1] I_PersWrkAgrmtSrchHelp_1 _PersWrkAgrmtSrchHelp_1 $projection.PersonWorkAgreement = _PersWrkAgrmtSrchHelp_1.PersonWorkAgreement

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CENGPROJTEAMSRCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Search Help For JAM view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement PersWrkAgrmtSrchHelp_1 PersonWorkAgreement
EmployeeFullName PersWrkAgrmtSrchHelp_1 PersonFullName
DefaultEmailAddress
_PersWrkAgrmtSrchHelp_1 _PersWrkAgrmtSrchHelp_1
DataControllerSet
DataController1
DataController2
DataController3
DataController4
DataController5
DataController6
DataController7
DataController8
DataController9
DataController10 
@AbapCatalog.sqlViewName: 'CENGPROJTEAMSRCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Search Help For JAM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED
define view C_EngmtProjTeamSrchHelp
  as select distinct from I_PersWrkAgrmtSrchHelp_1 as PersWrkAgrmtSrchHelp_1
    inner join            I_WorkforcePerson        as WorkforcePerson on PersWrkAgrmtSrchHelp_1.Person = WorkforcePerson.Person
  // Association Added For DCL

  association [1] to I_PersWrkAgrmtSrchHelp_1 as _PersWrkAgrmtSrchHelp_1 on $projection.PersonWorkAgreement = _PersWrkAgrmtSrchHelp_1.PersonWorkAgreement
{

  key PersWrkAgrmtSrchHelp_1.PersonWorkAgreement         as PersonWorkAgreement,
      PersWrkAgrmtSrchHelp_1.PersonFullName              as EmployeeFullName,
      WorkforcePerson._WorkplaceAddress.DefaultEmailAddress,

      //Association For DCL

      _PersWrkAgrmtSrchHelp_1,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataControllerSet as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController1   as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController2   as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController3   as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController4   as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController5   as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController6   as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController7   as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController8   as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController9   as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      WorkforcePerson._BusinessPartner.DataController10  as DataController10
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_PERSWRKAGRMTSRCHHELP_1",
"I_WORKFORCEPERSON",
"I_WORKPLACEADDRESS"
],
"ASSOCIATED":
[
"I_PERSWRKAGRMTSRCHHELP_1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More