_EMPLOYEE

31 Fields

_EMPLOYEE is an SAP database table in S/4HANA. It contains 31 fields.

Fields (31)

KeyField CDS FieldsUsed in Views
KEY Employee Employee 4
KEY HCMOrganizationalUnit HCMOrganizationalUnit 1
KEY HCMPersonnelNumber HCMPersonnelNumber 1
KEY HCMPosition HCMPosition 1
KEY PersonnelNumber PersonnelNumber 1
_BusinessPartner _BusinessPartner 4
AuthorizationGroup AuthorizationGroup 9
BPIdentificationNumber Employee 3
BusinessPartner BusinessPartner 8
BusinessUser BusinessUser 5
DataController1 DataController1 4
DataController10 DataController10 4
DataController2 DataController2 4
DataController3 DataController3 4
DataController4 DataController4 4
DataController5 DataController5 4
DataController6 DataController6 4
DataController7 DataController7 4
DataController8 DataController8 4
DataController9 DataController9 4
DataControllerSet DataControllerSet 4
EmployeeFullName employee_full_name,EmployeeFullName 2
EmployeeInternalID EmployeeInternalID 1
FullName FullName 2
HCMEmployeeName HCMEmployeeName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 8
Name EmployeeName,Name 3
PersonFullName CreatedByUserFullName,EmployeeFullName 5
PersonWorkAgreement EmploymentInternalID 1
SystemUser SystemUser 1
UserID BusinessUser 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _EMPLOYEE (
    EMPLOYEE,
    HCMORGANIZATIONALUNIT,
    HCMPERSONNELNUMBER,
    HCMPOSITION,
    PERSONNELNUMBER,
    _BUSINESSPARTNER,
    AUTHORIZATIONGROUP,
    BPIDENTIFICATIONNUMBER,
    BUSINESSPARTNER,
    BUSINESSUSER,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    EMPLOYEEFULLNAME,
    EMPLOYEEINTERNALID,
    FULLNAME,
    HCMEMPLOYEENAME,
    ISBUSINESSPURPOSECOMPLETED,
    NAME,
    PERSONFULLNAME,
    PERSONWORKAGREEMENT,
    SYSTEMUSER,
    USERID,
    PRIMARY KEY (EMPLOYEE, HCMORGANIZATIONALUNIT, HCMPERSONNELNUMBER, HCMPOSITION, PERSONNELNUMBER)
);

Learn More