EMPLOYEE

21 Fields

EMPLOYEE is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY UserID UserID 1
AuthorizationGroup AuthorizationGroup 2
DataController1 DataController1 2
DataController10 DataController10 2
DataController2 DataController2 2
DataController3 DataController3 2
DataController4 DataController4 2
DataController5 DataController5 2
DataController6 DataController6 2
DataController7 DataController7 2
DataController8 DataController8 2
DataController9 DataController9 2
DataControllerSet DataControllerSet 2
FirstName FirstName 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
LastName FamilyName,LastName 2
Person Person 1
PersonExternalID Employee 1
PersonFullName FullName,PersonFullName 2
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EMPLOYEE (
    USERID,
    AUTHORIZATIONGROUP,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    PERSON,
    PERSONEXTERNALID,
    PERSONFULLNAME,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (USERID)
);

Learn More