I_EMPLOYEE

CDS View
32 Fields 19 CDS Views

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Employee
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EMPLOYEE (
    EMPLOYEE,
    EMPLOYEEINTERNALID,
    PERSONNELNUMBER,
    _ACADEMICTITLE,
    _EMPLOYMENT,
    _FAMILYNAMEPREFIX,
    _FORMOFADDRESS,
    _GENDER,
    _HOMEADDRESS,
    _LANGUAGE,
    _WORKPLACEADDRESS,
    ACADEMICTITLE,
    ADDITIONALFAMILYNAME,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERROLE,
    BUSINESSPARTNERUUID,
    CORRESPONDENCELANGUAGE,
    EMPLOYEEFULLNAME,
    EMPLOYEEIMAGEURL,
    FAMILYNAME,
    FAMILYNAMEPREFIX,
    FORMOFADDRESS,
    FULLNAME,
    GENDERCODE,
    GIVENNAME,
    INITIALS,
    ISBUSINESSPURPOSECOMPLETED,
    MIDDLENAME,
    PERSON,
    USERID,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (EMPLOYEE, EMPLOYEEINTERNALID, PERSONNELNUMBER)
);

Learn More