I_CN_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_CN_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_CN_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.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,
  _AdditionalData.HCMFamMbrFormOfAddressCode AS HCMFamMbrFormOfAddressCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNameFormatCode AS HCMFamilyMemberNameFormatCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberLastName AS HCMFamilyMemberLastName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberFirstName AS HCMFamilyMemberFirstName,
  _AdditionalData.HCMFamMbrMaritalStatusCode AS HCMFamMbrMaritalStatusCode,
  _AdditionalData.HCMFamMbrMaritalStatusDate AS HCMFamMbrMaritalStatusDate,
  I_HCM_ESSFamilyMember.HCMFamilyMemberBirthDate AS HCMFamilyMemberBirthDate,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNationalityCode AS HCMFamilyMemberNationalityCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberCntryOfBrthCode AS HCMFamilyMemberCntryOfBrthCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberPlaceOfBrthName AS HCMFamilyMemberPlaceOfBrthName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberGenderCode AS HCMFamilyMemberGenderCode,
  _AdditionalData.HCMFamMbrChineseName AS HCMFamMbrChineseName,
  _AdditionalData.HCMFamMbrIsOnlyChild AS HCMFamMbrIsOnlyChild,
  _AdditionalData.HCMFamMbrOnlyChildId AS HCMFamMbrOnlyChildId,
  _AdditionalData.HCMFamMbrOnlyChildCertDate AS HCMFamMbrOnlyChildCertDate,
  _AdditionalData.HCMFamMbrIdTypeCode1 AS HCMFamMbrIdTypeCode1,
  _AdditionalData.HCMFamMbrIdNumber1 AS HCMFamMbrIdNumber1,
  _AdditionalData.HCMFamMbrIdTypeCode2 AS HCMFamMbrIdTypeCode2,
  _AdditionalData.HCMFamMbrIdNumber2 AS HCMFamMbrIdNumber2,
  _AdditionalData.HCMFamMbrIdTypeCode3 AS HCMFamMbrIdTypeCode3,
  _AdditionalData.HCMFamMbrIdNumber3 AS HCMFamMbrIdNumber3,
  _AdditionalData.HCMFamMbrIdTypeCode4 AS HCMFamMbrIdTypeCode4,
  _AdditionalData.HCMFamMbrIdNumber4 AS HCMFamMbrIdNumber4,
  _AdditionalData.HCMFamMbrIdTypeCode5 AS HCMFamMbrIdTypeCode5,
  _AdditionalData.HCMFamMbrIdNumber5 AS HCMFamMbrIdNumber5,
  _AdditionalData.HCMFamMbrTelephoneNumber AS HCMFamMbrTelephoneNumber,
  _AdditionalData.HCMFamMbrCommTypeCode1 AS HCMFamMbrCommTypeCode1,
  _AdditionalData.HCMFamMbrCommNumber1 AS HCMFamMbrCommNumber1,
  _AdditionalData.HCMFamMbrCommTypeCode2 AS HCMFamMbrCommTypeCode2,
  _AdditionalData.HCMFamMbrCommNumber2 AS HCMFamMbrCommNumber2,
  _AdditionalData.HCMFamMbrCommTypeCode3 AS HCMFamMbrCommTypeCode3,
  _AdditionalData.HCMFamMbrCommNumber3 AS HCMFamMbrCommNumber3,
  _AdditionalData.HCMFamMbrCommTypeCode4 AS HCMFamMbrCommTypeCode4,
  _AdditionalData.HCMFamMbrCommNumber4 AS HCMFamMbrCommNumber4,
  _AdditionalData.HCMFamMbrPostalCode AS HCMFamMbrPostalCode,
  _AdditionalData.HCMFamMbrCountryCode AS HCMFamMbrCountryCode,
  _AdditionalData.HCMFamMbrRegionCode AS HCMFamMbrRegionCode,
  _AdditionalData.HCMFamMbrCityText AS HCMFamMbrCityText,
  _AdditionalData.HCMFamMbrDistrictText AS HCMFamMbrDistrictText,
  _AdditionalData.HCMFamMbrStreetText AS HCMFamMbrStreetText,
  I_HCM_ESSFamilyMember.HCMFamilyMemberEmployerCode AS HCMFamilyMemberEmployerCode,
  _AdditionalData.HCMFamMbrOccupationText AS HCMFamMbrOccupationText,
  _AdditionalData.HCMFamMbrJobStatusCode AS HCMFamMbrJobStatusCode,
  _AdditionalData.HCMFamMbrPoliticalStatusCode AS HCMFamMbrPoliticalStatusCode,
  _AdditionalData.HCMFamMbrIsSameCompany AS HCMFamMbrIsSameCompany,
  _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_HCMNationalityText AS _NationalityText ON HCMFamilyMemberNationalityCode = _NationalityText.Country  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryOfBirthText ON HCMFamilyMemberCntryOfBrthCode = _CountryOfBirthText.Country  -- association [0..*]
LEFT OUTER JOIN I_HCMGenderText AS _GenderText ON HCMFamilyMemberGenderCode = _GenderText.HCMGenderCode AND HCMCountryRegionGrouping = _GenderText.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_HCMFormOfAddressText AS _FormOfAddressText ON HCMFamMbrFormOfAddressCode = _FormOfAddressText.HCMFormOfAddressCode AND HCMCountryRegionGrouping = _FormOfAddressText.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON HCMFamMbrCountryCode = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_HCMMaritalStatusVH AS _MaritalStatusText ON HCMFamMbrMaritalStatusCode = _MaritalStatusText.HCMMaritalStatusCode  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON HCMFamMbrCountryCode = _RegionText.Country AND HCMFamMbrRegionCode = _RegionText.Region  -- association [0..*]
LEFT OUTER JOIN I_CN_HCMOccupationText AS _OccupationText ON HCMFamMbrOccupationText = _OccupationText.Occupation  -- association [0..*]
LEFT OUTER JOIN I_CN_HCMJobStatusText AS _JobStatusText ON HCMFamMbrJobStatusCode = _JobStatusText.HCMFamMbrJobStatusCode  -- association [0..*]
LEFT OUTER JOIN I_CN_HCMPoliticalStatusText AS _PoliticalStatusText ON HCMFamMbrPoliticalStatusCode = _PoliticalStatusText.HCMFamMbrPoliticalStatusCode  -- association [0..*]
LEFT OUTER JOIN I_HCMIdentificationTypeText AS _IdentificationTypeText ON HCMCountryRegionGrouping = _IdentificationTypeText.HCMCountryRegionGrouping AND HCMFamMbrIdTypeCode1 = _IdentificationTypeText.HCMIdentificationType  -- 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]
LEFT OUTER JOIN E_SG_HCMFamilyMemberSupplement 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]
;