I_EMPLOYEE

CDS View
8 Fields 10 CDS Views

Employee

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

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ChgRecdWorkflowRecipientVH view inner CONSUMPTION People Picker for Change Record task processor
I_ChangeRecordPartnerVH view from COMPOSITE Obsolete: Value help for Change Record Partner
I_EmplHomeAddress view from BASIC Obsolete - DONOT USE_Employee Home Address
I_EmployeePayment view from BASIC Employee Payment Information
P_Empfactsheet_Projects view from CONSUMPTION Employee Factsheet CDS - Projects
P_Employeekeymapping view inner BASIC Employee Key Mapping
P_EmployeePositionOP view inner BASIC Employee Position for OnPremise
P_EmployeeSysOfRecord view inner BASIC Employee System of Record
P_EmploymentKeyMapping view inner BASIC Keymapping for Employments
P_Servicecostlevel view inner COMPOSITE Cost rate level

Fields (8)

KeyField CDS FieldsUsed in Views
KEY EmployeeInternalID EmployeeInternalID 2
KEY PersonnelNumber PersonnelNumber 4
AuthorizationGroup AuthorizationGroup,PersonWorkAgrmtAuthznGrpg 2
Employee Employee 3
EmployeeFullName FullName 1
FullName FullName,Name 6
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
UserID UserID 1

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 (
    EMPLOYEEINTERNALID,
    PERSONNELNUMBER,
    AUTHORIZATIONGROUP,
    EMPLOYEE,
    EMPLOYEEFULLNAME,
    FULLNAME,
    ISBUSINESSPURPOSECOMPLETED,
    USERID,
    PRIMARY KEY (EMPLOYEEINTERNALID, PERSONNELNUMBER)
);

Learn More