I_JP_HCM_ESSPersonalDataTP

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_JP_HCM_ESSPersonalDataTP.
-- 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.

CREATE VIEW I_JP_HCM_ESSPersonalDataTP AS
SELECT
  I_HCM_ESSPersonalData.HCMPersonnelNumber AS HCMPersonnelNumber,
  I_HCM_ESSPersonalData.HCMSubtype AS HCMSubtype,
  I_HCM_ESSPersonalData.HCMObjectIdentification AS HCMObjectIdentification,
  I_HCM_ESSPersonalData.HCMRecordIsLocked AS HCMRecordIsLocked,
  I_HCM_ESSPersonalData.EndDate AS EndDate,
  I_HCM_ESSPersonalData.StartDate AS StartDate,
  I_HCM_ESSPersonalData.HCMSequentialNumber AS HCMSequentialNumber,
  I_HCM_ESSPersonalData.HCMDraftSequentialNumber AS HCMDraftSequentialNumber,
  I_HCM_ESSPersonalData.LastChangedDate AS LastChangedDate,
  I_HCM_ESSPersonalData.LastChangedByUser AS LastChangedByUser,
  I_HCM_ESSPersonalData.HCMInfoTypeRecordHasText AS HCMInfoTypeRecordHasText,
  I_HCM_ESSPersonalData.HCMInfoTypeRecordScreenCtrl AS HCMInfoTypeRecordScreenCtrl,
  I_HCM_ESSPersonalData.HCMValidityStartDate AS HCMValidityStartDate,
  I_HCM_ESSPersonalData.HCMValidityEndDate AS HCMValidityEndDate,
  I_HCM_ESSPersonalData.HCMDefaultDate AS HCMDefaultDate,
  I_HCM_ESSPersonalData.HCMRecordIsStoredInDataBase AS HCMRecordIsStoredInDataBase,
  I_HCM_ESSPersonalData.HCMValidityStartDateFieldCtrl AS HCMValidityStartDateFieldCtrl,
  _PersonalDataRoot.HCMInfoTypeVersion AS HCMInfoTypeVersion,
  _PersonalDataRoot.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  I_HCM_ESSPersonalData.HCMEmployeeLastName AS HCMEmployeeLastName,
  I_HCM_ESSPersonalData.HCMEmployeeFirstName AS HCMEmployeeFirstName,
  I_HCM_ESSPersonalData.HCMEmployeeKatakanaLastName AS HCMEmployeeKatakanaLastName,
  I_HCM_ESSPersonalData.HCMEmployeeKatakanaFirstName AS HCMEmployeeKatakanaFirstName,
  I_HCM_ESSPersonalData.HCMEmployeeRomajiLastName AS HCMEmployeeRomajiLastName,
  I_HCM_ESSPersonalData.HCMEmployeeRomajiFirstName AS HCMEmployeeRomajiFirstName,
  I_HCM_ESSPersonalData.HCMEmployeeBirthName AS HCMEmployeeBirthName,
  I_HCM_ESSPersonalData.HCMEmployeeKatakanaBirthName AS HCMEmployeeKatakanaBirthName,
  I_HCM_ESSPersonalData.HCMEmployeeRomajiBirthName AS HCMEmployeeRomajiBirthName,
  I_HCM_ESSPersonalData.HCMEmployeeNickName AS HCMEmployeeNickName,
  I_HCM_ESSPersonalData.HCMEmployeeKatakanaNickName AS HCMEmployeeKatakanaNickName,
  I_HCM_ESSPersonalData.HCMEmployeeRomajiNickName AS HCMEmployeeRomajiNickName,
  cast ('0002' as fprfx ) AS HCMInfoType,
  I_HCM_ESSPersonalData.HCMEmployeeNameFormat AS HCMEmployeeNameFormat,
  I_HCM_ESSPersonalData.HCMEmployeeMaritalStatus AS HCMEmployeeMaritalStatus,
  I_HCM_ESSPersonalData.HCMEmplCurMaritalStsValdFrmDte AS HCMEmplCurMaritalStsValdFrmDte,
  I_HCM_ESSPersonalData.HCMEmployeeGender AS HCMEmployeeGender,
  I_HCM_ESSPersonalData.HCMEmployeeBirthDate AS HCMEmployeeBirthDate,
  I_HCM_ESSPersonalData.HCMEmployeeNationality AS HCMEmployeeNationality,
  I_HCM_ESSPersonalData.HCMEmployeeCountryOfBirth AS HCMEmployeeCountryOfBirth,
  I_HCM_ESSPersonalData.HCMEmployeeStateOfBirth AS HCMEmployeeStateOfBirth,
  I_HCM_ESSPersonalData.HCMEmployeePlaceOfBirth AS HCMEmployeePlaceOfBirth,
  I_HCM_ESSPersonalData.HCMEmployeeCommLanguage AS HCMEmployeeCommLanguage,
  I_HCM_ESSPersonalData.HCMEmployeeTitleCode AS HCMEmployeeTitleCode,
  I_HCM_ESSPersonalData.HCMEmployeeSecondTitleCode AS HCMEmployeeSecondTitleCode,
  I_HCM_ESSPersonalData.HCMEmployeeFormOfAddressKey AS HCMEmployeeFormOfAddressKey,
  I_HCM_ESSPersonalData.HCMEmployeeMiddleName AS HCMEmployeeMiddleName,
  _AdditionalData.HCMFamMbrMiddleNameKanji AS HCMFamMbrMiddleNameKanji,
  _AdditionalData.HCMFamMbrMiddleNameKatakana AS HCMFamMbrMiddleNameKatakana,
  _AdditionalData.HCMFamMbrOfclFirstNameKanji AS HCMFamMbrOfclFirstNameKanji,
  _AdditionalData.HCMFamMbrOfclFirstNameKatakana AS HCMFamMbrOfclFirstNameKatakana,
  _AdditionalData.HCMFamMbrOfclFirstNameRomaji AS HCMFamMbrOfclFirstNameRomaji,
  _AdditionalData.HCMFamMbrKosekiLastNameKanji AS HCMFamMbrKosekiLastNameKanji,
  I_HCM_ESSPersonalData._Contract AS _Contract
FROM I_HCM_ESSPersonalData
LEFT OUTER JOIN I_HCMMaritalStatusVH AS _MaritalStatusText ON HCMEmployeeMaritalStatus = _MaritalStatusText.HCMMaritalStatusCode  -- association [0..*]
LEFT OUTER JOIN I_HCMGenderText AS _GenderText ON HCMEmployeeGender = _GenderText.HCMGenderCode AND HCMCountryRegionGrouping = _GenderText.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_HCMNationalityText AS _NationalityText ON HCMEmployeeNationality = _NationalityText.Country  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryOfBirthText ON HCMEmployeeCountryOfBirth = _CountryOfBirthText.Country  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionOfBirthText ON HCMEmployeeCountryOfBirth = _RegionOfBirthText.Country AND HCMEmployeeStateOfBirth = _RegionOfBirthText.Region  -- association [0..*]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON HCMEmployeeCommLanguage = _LanguageText.Language  -- association [0..*]
LEFT OUTER JOIN I_HCMFormOfAddressText AS _FormOfAddressText ON HCMEmployeeFormOfAddressKey = _FormOfAddressText.HCMFormOfAddressCode AND HCMCountryRegionGrouping = _FormOfAddressText.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN E_HCMPersonalData AS _Extension ON HCMPersonnelNumber = _Extension.HCMPersonnelNumber AND HCMSubtype = _Extension.HCMSubtype AND HCMObjectIdentification = _Extension.HCMObjectIdentification AND HCMRecordIsLocked = _Extension.HCMRecordIsLocked AND EndDate = _Extension.EndDate AND StartDate = _Extension.StartDate AND HCMSequentialNumber = _Extension.HCMSequentialNumber  -- association [1]
LEFT OUTER JOIN E_JP_HCMPersonalDataSupplement AS _SupplementExtension ON HCMPersonnelNumber = _SupplementExtension.HCMPersonnelNumber AND HCMSubtype = _SupplementExtension.HCMSubtype AND HCMObjectIdentification = _SupplementExtension.HCMObjectIdentification AND HCMRecordIsLocked = _SupplementExtension.HCMRecordIsLocked AND EndDate = _SupplementExtension.EndDate AND StartDate = _SupplementExtension.StartDate AND HCMSequentialNumber = _SupplementExtension.HCMSequentialNumber  -- association [1]
;