EMPLOYMENT

24 Fields

EMPLOYMENT is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 2
KEY PersonWorkAgreement EmploymentInternalID,PersonWorkAgreement 6
KEY WorkAssignment WorkAssignment 1
_BusinessPartner _BusinessPartner 1
_WorkforcePerson _WorkforcePerson 1
AuthorizationGroup AuthorizationGroup 1
DataController1 DataController1 1
DataController10 DataController10 1
DataController2 DataController2 1
DataController3 DataController3 1
DataController4 DataController4 1
DataController5 DataController5 1
DataController6 DataController6 1
DataController7 DataController7 1
DataController8 DataController8 1
DataController9 DataController9 1
DataControllerSet DataControllerSet 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
IsMainEmployment IsMainEmployment 3
Person Person 5
PersonFullName PersonFullName 1
PersonnelNumber PersonnelNumber 5
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 1
WorkforcePersonExternalID WorkforcePersonExternalID 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 EMPLOYMENT (
    EMPLOYMENTINTERNALID,
    PERSONWORKAGREEMENT,
    WORKASSIGNMENT,
    _BUSINESSPARTNER,
    _WORKFORCEPERSON,
    AUTHORIZATIONGROUP,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    ISBUSINESSPURPOSECOMPLETED,
    ISMAINEMPLOYMENT,
    PERSON,
    PERSONFULLNAME,
    PERSONNELNUMBER,
    PERSONWORKAGRMTAUTHZNGRPG,
    WORKFORCEPERSONEXTERNALID,
    PRIMARY KEY (EMPLOYMENTINTERNALID, PERSONWORKAGREEMENT, WORKASSIGNMENT)
);

Learn More