I_IN_HCM_ESSFamilyMemberTP

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_IN_HCM_ESSFamilyMemberTP.
-- 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_IN_HCM_ESSFamilyMemberTP AS
SELECT
  I_HCM_ESSFamilyMember.HCMPersonnelNumber AS HCMPersonnelNumber,
  I_HCM_ESSFamilyMember.HCMSubtype AS HCMSubtype,
  I_HCM_ESSFamilyMember.HCMObjectIdentification AS HCMObjectIdentification,
  I_HCM_ESSFamilyMember.HCMRecordIsLocked AS HCMRecordIsLocked,
  I_HCM_ESSFamilyMember.EndDate AS EndDate,
  I_HCM_ESSFamilyMember.StartDate AS StartDate,
  I_HCM_ESSFamilyMember.HCMSequentialNumber AS HCMSequentialNumber,
  I_HCM_ESSFamilyMember.HCMDraftSequentialNumber AS HCMDraftSequentialNumber,
  I_HCM_ESSFamilyMember.LastChangedDate AS LastChangedDate,
  I_HCM_ESSFamilyMember.LastChangedByUser AS LastChangedByUser,
  I_HCM_ESSFamilyMember.HCMInfoTypeRecordHasText AS HCMInfoTypeRecordHasText,
  I_HCM_ESSFamilyMember.HCMInfoTypeRecordScreenCtrl AS HCMInfoTypeRecordScreenCtrl,
  I_HCM_ESSFamilyMember.HCMSubtypeText AS HCMSubtypeText,
  I_HCM_ESSFamilyMember.HCMETag AS HCMETag,
  I_HCM_ESSFamilyMember.HCMValidityStartDate AS HCMValidityStartDate,
  I_HCM_ESSFamilyMember.HCMValidityEndDate AS HCMValidityEndDate,
  I_HCM_ESSFamilyMember.HCMDefaultDate AS HCMDefaultDate,
  I_HCM_ESSFamilyMember.HCMRecordIsStoredInDataBase AS HCMRecordIsStoredInDataBase,
  I_HCM_ESSFamilyMember.HCMValidityStartDateFieldCtrl AS HCMValidityStartDateFieldCtrl,
  _FamilyMemberRoot.HCMInfoTypeVersion AS HCMInfoTypeVersion,
  _FamilyMemberRoot.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  I_HCM_ESSFamilyMember.HCMFamilyMemberTypeCode AS HCMFamilyMemberTypeCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberLastName AS HCMFamilyMemberLastName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberBirthName AS HCMFamilyMemberBirthName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberFirstName AS HCMFamilyMemberFirstName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberInitials AS HCMFamilyMemberInitials,
  I_HCM_ESSFamilyMember.HCMFamilyMemberOtherTitleCode AS HCMFamilyMemberOtherTitleCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNamePrefixCode AS HCMFamilyMemberNamePrefixCode,
  I_HCM_ESSFamilyMember.HCMFamMember2ndNamePrefixCode AS HCMFamMember2ndNamePrefixCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberBirthDate AS HCMFamilyMemberBirthDate,
  I_HCM_ESSFamilyMember.HCMFamilyMemberPlaceOfBrthName AS HCMFamilyMemberPlaceOfBrthName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberCntryOfBrthCode AS HCMFamilyMemberCntryOfBrthCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNationalityCode AS HCMFamilyMemberNationalityCode,
  I_HCM_ESSFamilyMember.HCMFamilyMember2ndNatltyCode AS HCMFamilyMember2ndNatltyCode,
  I_HCM_ESSFamilyMember.HCMFamilyMember3rdNatltyCode AS HCMFamilyMember3rdNatltyCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberGenderCode AS HCMFamilyMemberGenderCode,
  I_HCM_ESSFamilyMember.HCMFamMbrAllwncAuthznCode AS HCMFamMbrAllwncAuthznCode,
  I_HCM_ESSFamilyMember.HCMFamMbrChildAllowanceCode AS HCMFamMbrChildAllowanceCode,
  I_HCM_ESSFamilyMember.HCMFamMbrChildAllwncEntlmnt AS HCMFamMbrChildAllwncEntlmnt,
  I_HCM_ESSFamilyMember.HCMInfoTypeRecordIsHistorical AS HCMInfoTypeRecordIsHistorical,
  I_HCM_ESSFamilyMember.HCMFamilyMemberStateOfBrthCode AS HCMFamilyMemberStateOfBrthCode,
  I_HCM_ESSFamilyMember.HCMFamMbrRefPersnWorkAgreement AS HCMFamMbrRefPersnWorkAgreement,
  I_HCM_ESSFamilyMember.HCMFamilyMember2ndName AS HCMFamilyMember2ndName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberCompleteName AS HCMFamilyMemberCompleteName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNameFormatCode AS HCMFamilyMemberNameFormatCode,
  I_HCM_ESSFamilyMember.HCMFamMbrRelshpToChildCode AS HCMFamMbrRelshpToChildCode,
  I_HCM_ESSFamilyMember.HCMFamMbrAddressOfChildCode AS HCMFamMbrAddressOfChildCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberChildTypeCode AS HCMFamilyMemberChildTypeCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberChildBonusCode AS HCMFamilyMemberChildBonusCode,
  I_HCM_ESSFamilyMember.HCMFamMbrSicknessCertAuthzn AS HCMFamMbrSicknessCertAuthzn,
  I_HCM_ESSFamilyMember.HCMFamilyMemberAuthznNmbrCode AS HCMFamilyMemberAuthznNmbrCode,
  I_HCM_ESSFamilyMember.HCMFamMbrSoclInsurNmbr1stPrt AS HCMFamMbrSoclInsurNmbr1stPrt,
  I_HCM_ESSFamilyMember.HCMFamMbrSoclInsurNmbr2ndPrt AS HCMFamMbrSoclInsurNmbr2ndPrt,
  I_HCM_ESSFamilyMember.HCMFamMemberEducationEndDate AS HCMFamMemberEducationEndDate,
  I_HCM_ESSFamilyMember.HCMFamilyMemberSchoolTypeCode AS HCMFamilyMemberSchoolTypeCode,
  I_HCM_ESSFamilyMember.HCMFamMbrEducInstituteName AS HCMFamMbrEducInstituteName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberEmployerCode AS HCMFamilyMemberEmployerCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberTitleCode AS HCMFamilyMemberTitleCode,
  I_HCM_ESSFamilyMember.HCMFamMbrIsEmergencyContact AS HCMFamMbrIsEmergencyContact,
  _SubtypeVisibility.HCMFamMbrSubtype1IsHidden AS HCMFamMbrSubtype1IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype2IsHidden AS HCMFamMbrSubtype2IsHidden,
  I_HCM_ESSFamilyMember._Contract AS _Contract
FROM I_HCM_ESSFamilyMember
LEFT OUTER JOIN I_HCM_ESSFamMbrSubtypeVsblty AS _SubtypeVisibility ON HCMSubtype = _SubtypeVisibility.HCMSubtype  -- association [1]
LEFT OUTER JOIN I_CountryText AS _CountryOfBirthText ON HCMFamilyMemberCntryOfBrthCode = _CountryOfBirthText.Country  -- association [0..*]
LEFT OUTER JOIN I_HCMNationalityText AS _NationalityText ON HCMFamilyMemberNationalityCode = _NationalityText.Country  -- association [0..*]
LEFT OUTER JOIN I_HCMNationalityText AS _SecondNationalityText ON HCMFamilyMember2ndNatltyCode = _SecondNationalityText.Country  -- association [0..*]
LEFT OUTER JOIN I_HCMNationalityText AS _ThirdNationalityText ON HCMFamilyMember3rdNatltyCode = _ThirdNationalityText.Country  -- association [0..*]
LEFT OUTER JOIN I_HCMGenderText AS _GenderText ON HCMFamilyMemberGenderCode = _GenderText.HCMGenderCode AND HCMCountryRegionGrouping = _GenderText.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_HCMFamilyCharacteristicText AS _FamilyCharacteristicText2 ON _FamilyCharacteristicText2.HCMFamilyCharacteristic = '2' AND HCMCountryRegionGrouping = _FamilyCharacteristicText2.HCMCountryRegionGrouping AND HCMFamMbrAllwncAuthznCode = _FamilyCharacteristicText2.HCMFamCharcSpecification  -- association [0..*]
LEFT OUTER JOIN I_HCMFamilyCharacteristicText AS _FamilyCharacteristicText4 ON _FamilyCharacteristicText4.HCMFamilyCharacteristic = '4' AND HCMCountryRegionGrouping = _FamilyCharacteristicText4.HCMCountryRegionGrouping AND HCMFamMbrChildAllwncEntlmnt = _FamilyCharacteristicText4.HCMFamCharcSpecification  -- association [0..*]
LEFT OUTER JOIN I_HCMFamilyCharacteristicText AS _FamilyCharacteristicText5 ON _FamilyCharacteristicText5.HCMFamilyCharacteristic = '5' AND HCMCountryRegionGrouping = _FamilyCharacteristicText5.HCMCountryRegionGrouping AND HCMFamMbrChildAllowanceCode = _FamilyCharacteristicText5.HCMFamCharcSpecification  -- association [0..*]
LEFT OUTER JOIN E_HCMFamilyMember 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]
;