I_HCM_ESSPersonalData

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_HCM_ESSPersonalData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_HCMInfoTypeVersion : itvers

CREATE VIEW I_HCM_ESSPersonalData AS
SELECT
  _PersonalData.HCMPersonnelNumber AS HCMPersonnelNumber,
  _PersonalData.HCMSubtype AS HCMSubtype,
  _PersonalData.HCMObjectIdentification AS HCMObjectIdentification,
  _PersonalData.HCMRecordIsLocked AS HCMRecordIsLocked,
  _PersonalData.EndDate AS EndDate,
  _PersonalData.StartDate AS StartDate,
  _PersonalData.HCMSequentialNumber AS HCMSequentialNumber,
  cast( '000' as hrfio_per_draft_seq_number preserving type ) AS HCMDraftSequentialNumber,
  cast( '0002' as infty ) AS HCMInfoType,
  _PersonalData.LastChangedDate AS LastChangedDate,
  _PersonalData.LastChangedByUser AS LastChangedByUser,
  _PersonalData.HCMInfoTypeRecordIsHistorical AS HCMInfoTypeRecordIsHistorical,
  _PersonalData.HCMInfoTypeRecordHasText AS HCMInfoTypeRecordHasText,
  _PersonalData.HCMInfoTypeRecordHasRefField AS HCMInfoTypeRecordHasRefField,
  _PersonalData.HCMInfoTypeRecordHasConfField AS HCMInfoTypeRecordHasConfField,
  _PersonalData.HCMInfoTypeRecordScreenCtrl AS HCMInfoTypeRecordScreenCtrl,
  _PersonalData.HCMMasterDataChangeReason AS HCMMasterDataChangeReason,
  _PersonalData.HCMInfoTypeRecordRsrvdFld1 AS HCMInfoTypeRecordRsrvdFld1,
  _PersonalData.HCMInfoTypeRecordRsrvdFld2 AS HCMInfoTypeRecordRsrvdFld2,
  _PersonalData.HCMInfoTypeRecordRsrvdFld3 AS HCMInfoTypeRecordRsrvdFld3,
  _PersonalData.HCMInfoTypeRecordRsrvdFld4 AS HCMInfoTypeRecordRsrvdFld4,
  _PersonalData.HCMInfoTypeRecordRsrvdFld1Len2 AS HCMInfoTypeRecordRsrvdFld1Len2,
  _PersonalData.HCMInfoTypeRecordRsrvdFld2Len2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  _PersonalData.HCMGrpgValForPersAssignments AS HCMGrpgValForPersAssignments,
  _Customizing.StartDate AS HCMDefaultDate,
  cast(_PersonalData.StartDate as hrfio_per_valid_from preserving type ) AS HCMValidityStartDate,
  cast(_PersonalData.EndDate as hrfio_per_valid_to preserving type ) AS HCMValidityEndDate,
  cast( 'X' as abap_boolean preserving type ) AS HCMRecordIsStoredInDataBase,
  cast( '1' as int1 ) AS HCMValidityStartDateFieldCtrl,
  $parameters.P_HCMInfoTypeVersion AS HCMInfoTypeVersion,
  _PersonalData.HCMEmployeeInitials AS HCMEmployeeInitials,
  _PersonalData.HCMEmployeeLastName AS HCMEmployeeLastName,
  _PersonalData.HCMEmployeeBirthName AS HCMEmployeeBirthName,
  _PersonalData.HCMEmployeeSecondName AS HCMEmployeeSecondName,
  _PersonalData.HCMEmployeeFirstName AS HCMEmployeeFirstName,
  _PersonalData.HCMEmployeeCompleteName AS HCMEmployeeCompleteName,
  _PersonalData.HCMEmployeeTitleCode AS HCMEmployeeTitleCode,
  _PersonalData.HCMEmployeeSecondTitleCode AS HCMEmployeeSecondTitleCode,
  _PersonalData.HCMEmployeeOtherTitleCode AS HCMEmployeeOtherTitleCode,
  _PersonalData.HCMEmployeeNamePrefix AS HCMEmployeeNamePrefix,
  _PersonalData.HCMEmployeeSecondNamePrefix AS HCMEmployeeSecondNamePrefix,
  _PersonalData.HCMEmployeeNickName AS HCMEmployeeNickName,
  _PersonalData.HCMEmployeeMiddleName AS HCMEmployeeMiddleName,
  _PersonalData.HCMEmployeeNameFormat AS HCMEmployeeNameFormat,
  cast(_PersonalData.HCMEmployeeFormOfAddressKey as hrfio_formofaddress_id preserving type ) AS HCMEmployeeFormOfAddressKey,
  _PersonalData.HCMEmployeeGender AS HCMEmployeeGender,
  _PersonalData.HCMEmployeeBirthDate AS HCMEmployeeBirthDate,
  cast(_PersonalData.HCMEmployeeCountryOfBirth as hrfio_country_of_birth_id preserving type ) AS HCMEmployeeCountryOfBirth,
  _PersonalData.HCMEmployeeStateOfBirth AS HCMEmployeeStateOfBirth,
  _PersonalData.HCMEmployeePlaceOfBirth AS HCMEmployeePlaceOfBirth,
  _PersonalData.HCMEmployeeNationality AS HCMEmployeeNationality,
  cast(_PersonalData.HCMEmployeeSecondNationality as hrfio_secondnationality_id preserving type ) AS HCMEmployeeSecondNationality,
  cast(_PersonalData.HCMEmployeeThirdNationality as hrfio_thirdnationality_id preserving type ) AS HCMEmployeeThirdNationality,
  _PersonalData.HCMEmployeeCommLanguage AS HCMEmployeeCommLanguage,
  _PersonalData.HCMEmplReligiousDenomination AS HCMEmplReligiousDenomination,
  _PersonalData.HCMEmployeeMaritalStatus AS HCMEmployeeMaritalStatus,
  _PersonalData.HCMEmplCurMaritalStsValdFrmDte AS HCMEmplCurMaritalStsValdFrmDte,
  _PersonalData.HCMEmployeeNumberOfChildren AS HCMEmployeeNumberOfChildren,
  _PersonalData.HCMEmployeeHasNameConnection AS HCMEmployeeHasNameConnection,
  _PersonalData.HCMEmplPersIdentifierModifier AS HCMEmplPersIdentifierModifier,
  _PersonalData.HCMEmployeePersonnelIDNumber AS HCMEmployeePersonnelIDNumber,
  _PersonalData.HCMEmployeePassportBirthDate AS HCMEmployeePassportBirthDate,
  _PersonalData.HCMEmployeeKatakanaFirstName AS HCMEmployeeKatakanaFirstName,
  _PersonalData.HCMEmployeeKatakanaLastName AS HCMEmployeeKatakanaLastName,
  _PersonalData.HCMEmployeeRomajiFirstName AS HCMEmployeeRomajiFirstName,
  _PersonalData.HCMEmployeeRomajiLastName AS HCMEmployeeRomajiLastName,
  _PersonalData.HCMEmployeeKatakanaBirthName AS HCMEmployeeKatakanaBirthName,
  _PersonalData.HCMEmployeeRomajiBirthName AS HCMEmployeeRomajiBirthName,
  _PersonalData.HCMEmployeeKatakanaNickName AS HCMEmployeeKatakanaNickName,
  _PersonalData.HCMEmployeeRomajiNickName AS HCMEmployeeRomajiNickName,
  _PersonalData.HCMEmployeeYearOfBirth AS HCMEmployeeYearOfBirth,
  _PersonalData.HCMEmployeeMonthOfBirth AS HCMEmployeeMonthOfBirth,
  _PersonalData.HCMEmployeeDayOfBirth AS HCMEmployeeDayOfBirth,
  _PersonalData.HCMEmployeeSearchLastName AS HCMEmployeeSearchLastName,
  _PersonalData.HCMEmployeeSearchFirstName AS HCMEmployeeSearchFirstName,
  _PersonalData.HCMEmployeeBirthNameAffixCode AS HCMEmployeeBirthNameAffixCode,
  _PersonalData.HCMEmplGenderSelfIdentified AS HCMEmplGenderSelfIdentified
FROM I_HCMPersonalData AS _PersonalData
LEFT OUTER JOIN I_HCMPersonalInfoPersNumbers AS _Contract ON HCMPersonnelNumber = _Contract.HCMPersonnelNumber  -- association [1..1]
;