_ESSPERSONALDATA

9 Fields

_ESSPERSONALDATA is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
HCMEmplCurMaritalStsValdFrmDte HCMEmplCurMaritalStsValdFrmDte 1
HCMEmployeeBirthDate HCMEmployeeBirthDate 1
HCMEmployeeCommLanguage HCMEmployeeCommLanguage 1
HCMEmployeeFirstName HCMEmployeeFirstName 1
HCMEmployeeFormOfAddressKey HCMEmployeeFormOfAddressKey 1
HCMEmployeeLastName HCMEmployeeLastName 1
HCMEmployeeMaritalStatus HCMEmployeeMaritalStatus 1
HCMEmployeeNationality HCMEmployeeNationality 1
HCMEmployeeNumberOfChildren HCMEmployeeNumberOfChildren 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 _ESSPERSONALDATA (
    HCMEMPLCURMARITALSTSVALDFRMDTE,
    HCMEMPLOYEEBIRTHDATE,
    HCMEMPLOYEECOMMLANGUAGE,
    HCMEMPLOYEEFIRSTNAME,
    HCMEMPLOYEEFORMOFADDRESSKEY,
    HCMEMPLOYEELASTNAME,
    HCMEMPLOYEEMARITALSTATUS,
    HCMEMPLOYEENATIONALITY,
    HCMEMPLOYEENUMBEROFCHILDREN
);

Learn More