Which CDS Views use I_EMPLOYEE?

I_EMPLOYEE is used by 19 CDS view(s), including: C_ChgRecdWorkflowRecipientVH, C_PersonWorkAgrmtSrvcCostLevel, I_ChangeRecordPartnerVH, I_EmplHomeAddress, I_EmployeeDetails, I_EmployeePayment, I_EmployeePositionOP, I_EmployeeWorkplaceAddress, I_EmploymentManagerCl, I_EmploymtsofEE.

How many fields does I_EMPLOYEE have?

I_EMPLOYEE has 32 fields. Key fields: Employee, EmployeeInternalID, PersonnelNumber.

I_EMPLOYEE

CDS View

Employee

I_EMPLOYEE is a CDS View in S/4HANA. Employee. It contains 32 fields. 19 CDS views read from this table.

CDS Views using this table (19)

View	Type	Join	VDM	Description
C_ChgRecdWorkflowRecipientVH	view	inner	CONSUMPTION	People Picker for Change Record task processor
C_PersonWorkAgrmtSrvcCostLevel	view	inner	CONSUMPTION	Work Agreement Service Cost Level for Employment
I_ChangeRecordPartnerVH	view	from	COMPOSITE	Obsolete: Value help for Change Record Partner
I_EmplHomeAddress	view	from	BASIC	Obsolete - DONOT USE_Employee Home Address
I_EmployeeDetails	view	from	COMPOSITE	Employee Details
I_EmployeePayment	view	from	BASIC	Employee Payment Information
I_EmployeePositionOP	view	inner	BASIC	Employee Position for OnPremise
I_EmployeeWorkplaceAddress	view	inner	BASIC	Employee Workplace Address
I_EmploymentManagerCl	view	inner	BASIC	Employment Manager for Cloud
I_EmploymtsofEE	view	from	BASIC	Employments of Employee
P_EMPCONSUMPTION	view	from	CONSUMPTION	Employee Consumption View
P_Empfactsheet_Projects	view	from	CONSUMPTION	Employee Factsheet CDS - Projects
P_EmployeeAllAttribs	view	from	BASIC
P_Employeekeymapping	view	inner	BASIC
P_EmployeePositionOP	view	inner	BASIC
P_EmployeeSysOfRecord	view	inner	BASIC
P_EmploymentKeyMapping	view	inner	BASIC
P_EmpProjects	view	from	CONSUMPTION	Projects of an Employee
P_Servicecostlevel	view	inner	COMPOSITE

Fields (32)

Key	Field	CDS Fields	Used in Views
KEY	Employee	Employee,EmployeeID,ManagerEmployee	9
KEY	EmployeeInternalID	EmployeeInternalID	4
KEY	PersonnelNumber	ManagerPersonnelNumber,PersonnelNumber	11
	_AcademicTitle	_AcademicTitle	1
	_Employment	_Employment	1
	_FamilyNamePrefix	_FamilyNamePrefix	1
	_FormOfAddress	_FormOfAddress	1
	_Gender	_Gender	1
	_HomeAddress	_HomeAddress	1
	_Language	_Language	1
	_WorkplaceAddress	_WorkplaceAddress	1
	AcademicTitle	AcademicTitle	2
	AdditionalFamilyName	AdditionalFamilyName	2
	AuthorizationGroup	AuthorizationGroup,PersonWorkAgrmtAuthznGrpg	6
	BusinessPartnerRole	BusinessPartnerRole	1
	BusinessPartnerUUID	BusinessPartnerUUID	1
	CorrespondenceLanguage	CorrespondenceLanguage	1
	EmployeeFullName	EmployeeFullName,FullName	3
	EmployeeImageURL	EmployeeImageURL	3
	FamilyName	FamilyName	2
	FamilyNamePrefix	FamilyNamePrefix	2
	FormOfAddress	FormOfAddress	2
	FullName	EmployeeFullName,FullName,ManagerFullName,Name	10
	GenderCode	GenderCode	2
	GivenName	GivenName	2
	Initials	Initials	2
	IsBusinessPurposeCompleted	IsBusinessPurposeCompleted	6
	MiddleName	MiddleName	2
	Person	Person	1
	UserID	UserID	4
	ValidityEndDate	ValidityEndDate	2
	ValidityStartDate	ValidityStartDate	2

@AbapCatalog.sqlViewName: 'IEMPLOYEE'
@EndUserText.label: 'Employee'
@VDM.viewType: #BASIC
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true } //-- DPP change

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.representativeKey: 'PersonnelNumber'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
//@ObjectModel.usageType.serviceQuality: #C

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

define view I_Employee
//  as select from P_U_Employee

  as select from WFD_TF_Employee( p_client : $session.client ) as emp
    inner join but000       as bp     on bp.partner = emp.EmployeeInternalID
  association [0..1] to I_PersonFormOfAddress  as _FormOfAddress         on  $projection.FormOfAddress = _FormOfAddress.FormOfAddress
  association [0..1] to I_Gender               as _Gender                on  $projection.GenderCode = _Gender.GenderCode
  association [0..1] to I_AcademicTitle        as _AcademicTitle         on  $projection.AcademicTitle = _AcademicTitle.AcademicTitle
  association [0..1] to I_Language             as _Language              on  $projection.CorrespondenceLanguage = _Language.Language
  association [0..1] to I_Familynameprefixtext as _FamilyNamePrefix      on  $projection.FamilyNamePrefix = _FamilyNamePrefix.FamilyNamePrefix
  association [0..*] to I_EmployeeHomeAddress  as _HomeAddress           on  $projection.Person = _HomeAddress.Person
  association [0..1] to I_WorkplaceAddress     as _WorkplaceAddress      on  $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID
  association [0..*] to I_Employment           as _Employment            on  $projection.PersonnelNumber = _Employment.PersonnelNumber
  association [0..1] to I_Employment           as _MainEmployment        on  $projection.PersonnelNumber      = _MainEmployment.PersonnelNumber
                                                                         and _MainEmployment.IsMainEmployment = 'X'
  association [0..*] to I_EmployeePayment      as _Payment               on  $projection.PersonnelNumber = _Payment.PersonnelNumber
  association [0..*] to I_EmployeeskillTags    as _EmployeeSkillTags     on  $projection.PersonnelNumber = _EmployeeSkillTags.PersonnelNumber
  association [0..*] to I_BPRoleText           as _BPRoleText            on  $projection.BusinessPartnerRole = _BPRoleText.BusinessPartnerRole
  association [0..1] to I_ServicePerformerFor  as _IsServicePerformerFor on  $projection.EmployeeInternalID          = _IsServicePerformerFor.BusinessPartner
                                                                         and _IsServicePerformerFor.RoleRelationType = 'BUR025'
  association [0..1] to I_User                 as _User                  on  $projection.BusinessPartnerUUID = _User.BusinessPartnerUUID
  association [0..1] to /shcm/hrp5092          as _EmployeeImageURL      on  _EmployeeImageURL.otype     = 'CP'
                                                                         and $projection.PersonnelNumber = _EmployeeImageURL.objid

{
      @ObjectModel.text.element: 'EmployeeFullName'
  key emp.PersonnelNumber, //not to be used in UI

      emp.EmployeeInternalID,
      emp.Employee,
      emp.ValidityStartDate,
      emp.ValidityEndDate,
      emp.FormOfAddress,
      emp.FamilyName,
      emp.FirstName, //depricated

      emp.GivenName,
      emp.MiddleName,
      emp.AdditionalFamilyName,
      emp.AcademicTitle,
      emp.FamilyNamePrefix,
      emp.Initials,
      emp.FullName, //depricated

      @Semantics.text
      emp.EmployeeFullName,
      emp.CorrespondenceLanguage,
      emp.GenderCode,
      emp.BusinessPartnerRole,
      emp.Person,
      emp.BusinessPartnerUUID,
      _User.UserID                         as BusinessUser, //depricated

      _User.UserID,
      _EmployeeImageURL.employee_image_url as EmployeeImageURL,
      //    CONCAT ( CONCAT( '/sap/opu/odata/SHCM/CB_EMPLOYEE_SRV/EmployeePhotoStreamSet', CONCAT('(',CONCAT('''',CONCAT(Employee.PersonnelNumber,'''')))), ')/$value') as EmployeeImageURL,

      emp.CreatedByUser,
      emp.CreationDate,
      emp.CreationTime,
      emp.LastChangedByUser,
      emp.LastChangeDate,
      emp.LastChangeTime,
      emp.AuthorizationGroup,
      emp.IsBusinessPurposeCompleted,
      _FormOfAddress,
      _Gender,
      _AcademicTitle,
      _Language,
      _FamilyNamePrefix,
      _HomeAddress,
      _WorkplaceAddress,
      _Employment,
      _MainEmployment,
      _Payment,
      _EmployeeSkillTags,
      _BPRoleText,
      _IsServicePerformerFor,

      //Added only for DCL check

      /////// Start of Datacontroller 10+1 fields -  Not to be consumed by any other views//////////


      @Consumption.hidden:true
      @UI.hidden:true
      bp.xdcset                                                  as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr1                                             as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr2                                             as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr3                                             as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr4                                             as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr5                                             as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr6                                             as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr7                                             as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr8                                             as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr9                                             as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      bp.data_ctrlr10                                            as DataController10
}

//define view I_Employee

//  as select from P_U_Employee

//  association [0..1] to I_PersonFormOfAddress  as _FormOfAddress         on  $projection.FormOfAddress = _FormOfAddress.FormOfAddress

//  association [0..1] to I_Gender               as _Gender                on  $projection.GenderCode = _Gender.GenderCode

//  association [0..1] to I_AcademicTitle        as _AcademicTitle         on  $projection.AcademicTitle = _AcademicTitle.AcademicTitle

//  association [0..1] to I_Language             as _Language              on  $projection.CorrespondenceLanguage = _Language.Language

//  association [0..1] to I_Familynameprefixtext as _FamilyNamePrefix      on  $projection.FamilyNamePrefix = _FamilyNamePrefix.FamilyNamePrefix

//  association [0..*] to I_EmployeeHomeAddress  as _HomeAddress           on  $projection.Person = _HomeAddress.Person

//  association [0..1] to I_WorkplaceAddress     as _WorkplaceAddress      on  $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID

//  association [0..*] to I_Employment           as _Employment            on  $projection.PersonnelNumber = _Employment.PersonnelNumber

//  association [0..1] to I_Employment           as _MainEmployment        on  $projection.PersonnelNumber      = _MainEmployment.PersonnelNumber

//                                                                         and _MainEmployment.IsMainEmployment = 'X'

//  association [0..*] to I_EmployeePayment      as _Payment               on  $projection.PersonnelNumber = _Payment.PersonnelNumber

//  association [0..*] to I_EmployeeskillTags    as _EmployeeSkillTags     on  $projection.PersonnelNumber = _EmployeeSkillTags.PersonnelNumber

//  association [0..*] to I_BPRoleText           as _BPRoleText            on  $projection.BusinessPartnerRole = _BPRoleText.BusinessPartnerRole

//  association [0..1] to I_ServicePerformerFor  as _IsServicePerformerFor on  $projection.EmployeeInternalID          = _IsServicePerformerFor.BusinessPartner

//                                                                         and _IsServicePerformerFor.RoleRelationType = 'BUR025'

//  association [0..1] to I_User                 as _User                  on  $projection.BusinessPartnerUUID = _User.BusinessPartnerUUID

//  association [0..1] to /shcm/hrp5092          as _EmployeeImageURL      on  _EmployeeImageURL.otype     = 'CP'

//                                                                         and $projection.PersonnelNumber = _EmployeeImageURL.objid

//

//{

//      @ObjectModel.text.element: 'EmployeeFullName'

//  key PersonnelNumber, //not to be used in UI

//      EmployeeInternalID,

//      Employee,

//      ValidityStartDate,

//      ValidityEndDate,

//      FormOfAddress,

//      FamilyName,

//      FirstName, //depricated

//      GivenName,

//      MiddleName,

//      AdditionalFamilyName,

//      AcademicTitle,

//      FamilyNamePrefix,

//      Initials,

//      FullName, //depricated

//      @Semantics.text

//      EmployeeFullName,

//      CorrespondenceLanguage,

//      GenderCode,

//      BusinessPartnerRole,

//      Person,

//      BusinessPartnerUUID,

//      _User.UserID                         as BusinessUser, //depricated

//      _User.UserID,

//      _EmployeeImageURL.employee_image_url as EmployeeImageURL,

//      //    CONCAT ( CONCAT( '/sap/opu/odata/SHCM/CB_EMPLOYEE_SRV/EmployeePhotoStreamSet', CONCAT('(',CONCAT('''',CONCAT(Employee.PersonnelNumber,'''')))), ')/$value') as EmployeeImageURL,

//      CreatedByUser,

//      CreationDate,

//      CreationTime,

//      LastChangedByUser,

//      LastChangeDate,

//      LastChangeTime,

//      AuthorizationGroup,

//      IsBusinessPurposeCompleted,

//      _FormOfAddress,

//      _Gender,

//      _AcademicTitle,

//      _Language,

//      _FamilyNamePrefix,

//      _HomeAddress,

//      _WorkplaceAddress,

//      _Employment,

//      _MainEmployment,

//      _Payment,

//      _EmployeeSkillTags,

//      _BPRoleText,

//      _IsServicePerformerFor

//}



//old code -> Before CDS Rewiring

//as select from P_EmployeeUnion as Employee

//  association[0..1] to I_PersonFormOfAddress  as _FormOfAddress     on $projection.FormOfAddress        = _FormOfAddress.FormOfAddress

//  association[0..1] to I_Gender               as _Gender            on $projection.GenderCode           = _Gender.GenderCode

//  association[0..1] to I_AcademicTitle        as _AcademicTitle     on $projection.AcademicTitle        = _AcademicTitle.AcademicTitle

//  association[0..1] to I_Language             as _Language          on $projection.CorrespondenceLanguage = _Language.Language

//  association[0..1] to I_Familynameprefixtext as _FamilyNamePrefix  on $projection.FamilyNamePrefix     = _FamilyNamePrefix.FamilyNamePrefix

//  association[0..*] to I_EmployeeHomeAddress  as _HomeAddress       on $projection.Person   =  _HomeAddress.Person

//  association[0..1] to I_WorkplaceAddress     as _WorkplaceAddress  on $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID

//  association[0..*] to I_Employment           as _Employment        on $projection.PersonnelNumber      = _Employment.PersonnelNumber

//  association[0..1] to I_Employment           as _MainEmployment    on $projection.PersonnelNumber      = _MainEmployment.PersonnelNumber and

//                                                                       _MainEmployment.IsMainEmployment = 'X'

//  association[0..*] to I_EmployeePayment      as _Payment           on $projection.PersonnelNumber      = _Payment.PersonnelNumber

//  association[0..*] to I_EmployeeskillTags    as _EmployeeSkillTags on $projection.PersonnelNumber      =  _EmployeeSkillTags.PersonnelNumber

//  association[0..*] to I_BPRoleText           as _BPRoleText        on $projection.BusinessPartnerRole  = _BPRoleText.BusinessPartnerRole

//  association[0..1] to I_ServicePerformerFor  as _IsServicePerformerFor on $projection.EmployeeInternalID = _IsServicePerformerFor.BusinessPartner and

//                                                                           _IsServicePerformerFor.RoleRelationType = 'BUR025'

//  association[0..1] to I_User                 as _User              on $projection.BusinessPartnerUUID = _User.BusinessPartnerUUID

//  association[0..1] to /shcm/hrp5092          as _EmployeeImageURL  on _EmployeeImageURL.otype = 'CP' and

//                                                                       $projection.PersonnelNumber = _EmployeeImageURL.objid

//{

//@ObjectModel.text.element: 'EmployeeFullName'

//key Employee.PersonnelNumber as PersonnelNumber, //not to be used in UI

//    EmployeeInternalID,

//    Employee,

//    ValidityStartDate,

//    ValidityEndDate,

//    FormOfAddress,

//    FamilyName,

//    FirstName,   //depricated

//    GivenName,

//    MiddleName,

//    AdditionalFamilyName,

//    AcademicTitle,

//    FamilyNamePrefix,

//    Initials,

//    FullName, //depricated

//    @Semantics.text

//    EmployeeFullName,

//    CorrespondenceLanguage,

//    GenderCode,

//    BusinessPartnerRole,

//    Person,

//    BusinessPartnerUUID,

//    _User.UserID as BusinessUser, //depricated

//    _User.UserID,

//    _EmployeeImageURL.employee_image_url as EmployeeImageURL,

////    CONCAT ( CONCAT( '/sap/opu/odata/SHCM/CB_EMPLOYEE_SRV/EmployeePhotoStreamSet', CONCAT('(',CONCAT('''',CONCAT(Employee.PersonnelNumber,'''')))), ')/$value') as EmployeeImageURL,

//    CreatedByUser,

//    CreationDate,

//    CreationTime,

//    LastChangedByUser,

//    LastChangeDate,

//    LastChangeTime,

//    AuthorizationGroup,

//    IsBusinessPurposeCompleted,

//    _FormOfAddress,

//    _Gender,

//    _AcademicTitle,

//    _Language,

//    _FamilyNamePrefix,

//    _HomeAddress,

//    _WorkplaceAddress,

//    _Employment,

//    _MainEmployment,

//    _Payment,

//    _EmployeeSkillTags,

//    _BPRoleText,

//    _IsServicePerformerFor

//}

//

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USER",
"/SHCM/HRP5092",
"BUT000"
],
"ASSOCIATED":
[
"I_ACADEMICTITLE",
"I_BPROLETEXT",
"I_EMPLOYEEHOMEADDRESS",
"I_EMPLOYEEPAYMENT",
"I_EMPLOYEESKILLTAGS",
"I_EMPLOYMENT",
"I_FAMILYNAMEPREFIXTEXT",
"I_GENDER",
"I_LANGUAGE",
"I_PERSONFORMOFADDRESS",
"I_SERVICEPERFORMERFOR",
"I_USER",
"I_WORKPLACEADDRESS",
"/SHCM/HRP5092"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_EMPLOYEE

CDS Views using this table (19)

Fields (32)

Learn More