C_QA_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 C_QA_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 C_QA_HCM_ESSFamilyMemberTP AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  HCMDraftSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordScreenCtrl,
  HCMSubtypeText,
  HCMETag,
  HCMValidityStartDate,
  HCMValidityEndDate,
  HCMDefaultDate,
  HCMRecordIsStoredInDataBase,
  HCMValidityStartDateFieldCtrl,
  HCMInfoTypeVersion,
  HCMCountryRegionGrouping,
  HCMFamilyMemberTypeCode,
  HCMFamilyMemberBirthDate,
  HCMFamilyMemberCntryOfBrthCode,
  HCMFamilyMemberNationalityCode,
  HCMFamilyMemberGenderCode,
  _GenderText.HCMGenderText : localized AS HCMGenderTextlocalized,
  HCMFamilyMemberFirstName,
  HCMFamilyMemberLastName,
  HCMFamilyMemberPlaceOfBrthName,
  HCMFamilyMemberStateOfBrthCode,
  HCMFamMbrRefPersnWorkAgreement,
  HCMFamilyMemberBirthName,
  HCMFamilyMember2ndName,
  HCMFamilyMemberCompleteName,
  HCMInfoType,
  HCMFamilyMemberNameFormatCode,
  HCMFamilyMemberInitials,
  HCMFamilyMemberNamePrefixCode,
  HCMFamMember2ndNamePrefixCode,
  HCMFamilyMemberOtherTitleCode,
  HCMFamMbrRelshpToChildCode,
  HCMFamMbrAllwncAuthznCode,
  HCMFamMbrAddressOfChildCode,
  HCMFamMbrChildAllwncEntlmnt,
  HCMFamilyMemberChildTypeCode,
  HCMFamilyMemberChildBonusCode,
  HCMFamMbrChildAllowanceCode,
  HCMFamMbrSicknessCertAuthzn,
  HCMFamilyMemberAuthznNmbrCode,
  HCMFamMbrSoclInsurNmbr1stPrt,
  HCMFamMbrSoclInsurNmbr2ndPrt,
  HCMFamMemberEducationEndDate,
  HCMFamilyMemberSchoolTypeCode,
  HCMFamMbrEducInstituteName,
  HCMFamilyMemberEmployerCode,
  HCMFamilyMember2ndNatltyCode,
  HCMFamilyMember3rdNatltyCode,
  HCMFamilyMemberTitleCode,
  HCMFamMbrIsEmergencyContact,
  HCMFamMbrPassportNumber,
  HCMFamMbrPassportIssueDate,
  HCMFamMbrPassportExpiryDate,
  HCMFamMbrQAVisaNumber,
  HCMFamMbrVisaIssueDate,
  HCMFamMbrVisaExpiryDate,
  HCMFamMbrQAIdNumber,
  HCMFamMbrIdIssueDate,
  HCMFamMbrIdExpiryDate,
  HCMFamMbrDocumentTypeCode1,
  HCMFamMbrDocumentNumber1,
  HCMFamMbrDocNmbr1IssueDate,
  HCMFamMbrDocNmbr1ExpiryDate,
  HCMFamMbrDocumentTypeCode2,
  HCMFamMbrDocumentNumber2,
  HCMFamMbrDocNmbr2IssueDate,
  HCMFamMbrDocNmbr2ExpiryDate,
  HCMFamMbrDocumentTypeCode3,
  HCMFamMbrDocumentNumber3,
  HCMFamMbrDocNmbr3IssueDate,
  HCMFamMbrDocNmbr3ExpiryDate,
  HCMFamMbrDocumentTypeCode4,
  HCMFamMbrDocumentNumber4,
  HCMFamMbrDocNmbr4IssueDate,
  HCMFamMbrDocNmbr4ExpiryDate,
  HCMFamMbrDocumentTypeCode5,
  HCMFamMbrDocumentNumber5,
  HCMFamMbrDocNmbr5IssueDate,
  HCMFamMbrDocNmbr5ExpiryDate,
  HCMFamMbrDocumentTypeCode6,
  HCMFamMbrDocumentNumber6,
  HCMFamMbrDocNmbr6IssueDate,
  HCMFamMbrDocNmbr6ExpiryDate,
  HCMFamMbrDocumentTypeCode7,
  HCMFamMbrDocumentNumber7,
  HCMFamMbrDocNmbr7IssueDate,
  HCMFamMbrDocNmbr7ExpiryDate,
  HCMFamMbrDocumentTypeCode8,
  HCMFamMbrDocumentNumber8,
  HCMFamMbrDocNmbr8IssueDate,
  HCMFamMbrDocNmbr8ExpiryDate,
  HCMFamMbrCountryEntranceDate,
  HCMFamMbrIsEmployed,
  HCMFamMbrEmployerName,
  HCMFamMbrEmploymentDate,
  HCMFamMbrHasAcmdtnEntlmnt,
  HCMFamMbrLegalNomineeCode,
  HCMFamMbrArabicFirstName,
  HCMFamMbrArabicSecondName,
  HCMFamMbrArabicThirdName,
  HCMFamMbrArabicLastName,
  HCMFamMbrAcademicDegreeCode,
  HCMFamMbrSpecialization,
  HCMFamMbrJobName,
  HCMFamMbrQAEmployerTypeCode,
  HCMFamMbrSpousePersNumber,
  _EmployeeName.HCMEmployeeName AS HCMEmployeeName,
  HCMFamMbrHasUnderDependents,
  HCMFamMbrDependentsCountryCode,
  HCMFamMbrCurrentSchoolGrade,
  HCMFamMbrSchoolIdNumber,
  HCMFamMbrHasCompanyTransport,
  HCMFamMbrTypeOfChallengeCode,
  _SubtypeVisibility.HCMFamMbrSubtype10IsHidden AS HCMFamMbrSubtype10IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype11IsHidden AS HCMFamMbrSubtype11IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype12IsHidden AS HCMFamMbrSubtype12IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype13IsHidden AS HCMFamMbrSubtype13IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype14IsHidden AS HCMFamMbrSubtype14IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype15IsHidden AS HCMFamMbrSubtype15IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype2IsHidden AS HCMFamMbrSubtype2IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype3IsHidden AS HCMFamMbrSubtype3IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype4IsHidden AS HCMFamMbrSubtype4IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype5IsHidden AS HCMFamMbrSubtype5IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype6IsHidden AS HCMFamMbrSubtype6IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype7IsHidden AS HCMFamMbrSubtype7IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtype8IsHidden AS HCMFamMbrSubtype8IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtypeQA01IsHidden AS HCMFamMbrSubtypeQA01IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtypeQA02IsHidden AS HCMFamMbrSubtypeQA02IsHidden
FROM I_QA_HCM_ESSFamilyMemberTP
;