EE

EE is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY Employee Employee,EmployeeExtID 1
_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 1
AdditionalFamilyName AdditionalFamilyName 1
BusinessPartnerRole BusinessPartnerRole 1
BusinessPartnerUUID BusinessPartnerUUID 1
CorrespondenceLanguage CorrespondenceLanguage 1
EmployeeFullName EmployeeFullName 1
EmployeeImageURL EmployeeImageURL 1
EmployeeInternalID EmployeeInternalID 1
FamilyName FamilyName 1
FamilyNamePrefix FamilyNamePrefix 1
FormOfAddress FormOfAddress 1
GenderCode GenderCode 1
GivenName GivenName,HeaderDescription 1
Initials Initials 1
MiddleName MiddleName 1
Person Person 1
PersonnelNumber PersonnelNumber 1
UserID UserID 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

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