SEPM_I_EMPLOYEE

CDS View
16 Fields 3 CDS Views

EPM Demo: Employee

SEPM_I_EMPLOYEE is a CDS View in S/4HANA. EPM Demo: Employee. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
S_EPM_WF_USER view from BASIC EPM Demo: User/Employee
SEPM_I_Employee_E view from EPM Demo: Employee with External IDs
SEPMRA_I_Employee view from Employee

Fields (16)

KeyField CDS FieldsUsed in Views
KEY SystemUser SystemUser 2
_Company _Company 1
_GenderCode _GenderCode 1
CompanyUUID CompanyUUID 1
EmailAddress EmailAddress 1
Employee Employee 1
EmployeePictureURL EmployeePictureURL 1
EmployeeUUID EmployeeUUID 1
FirstName FirstName 2
FullName FullName 2
GenderCode GenderCode 1
Initials Initials 1
LastName LastName 2
MiddleName MiddleName 1
MobilePhoneNumber MobilePhoneNumber 1
PhoneNumber PhoneNumber 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.

-- EPM Demo: Employee
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPM_I_EMPLOYEE (
    SYSTEMUSER,
    _COMPANY,
    _GENDERCODE,
    COMPANYUUID,
    EMAILADDRESS,
    EMPLOYEE,
    EMPLOYEEPICTUREURL,
    EMPLOYEEUUID,
    FIRSTNAME,
    FULLNAME,
    GENDERCODE,
    INITIALS,
    LASTNAME,
    MIDDLENAME,
    MOBILEPHONENUMBER,
    PHONENUMBER,
    PRIMARY KEY (SYSTEMUSER)
);

Learn More