I_HCM_ESSFamilyMember

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_ESSFamilyMember.
-- 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_ESSFamilyMember AS
SELECT
  _FamilyMember.HCMPersonnelNumber AS HCMPersonnelNumber,
  _FamilyMember.HCMSubtype AS HCMSubtype,
  _FamilyMember.HCMObjectIdentification AS HCMObjectIdentification,
  _FamilyMember.HCMRecordIsLocked AS HCMRecordIsLocked,
  _FamilyMember.EndDate AS EndDate,
  _FamilyMember.StartDate AS StartDate,
  _FamilyMember.HCMSequentialNumber AS HCMSequentialNumber,
  cast( '000' as hrfio_per_draft_seq_number preserving type ) AS HCMDraftSequentialNumber,
  cast( '0021' as infty ) AS HCMInfoType,
  _FamilyMember.LastChangedDate AS LastChangedDate,
  _FamilyMember.LastChangedByUser AS LastChangedByUser,
  _FamilyMember.HCMInfoTypeRecordIsHistorical AS HCMInfoTypeRecordIsHistorical,
  _FamilyMember.HCMInfoTypeRecordHasText AS HCMInfoTypeRecordHasText,
  _FamilyMember.HCMInfoTypeRecordHasRefField AS HCMInfoTypeRecordHasRefField,
  _FamilyMember.HCMInfoTypeRecordHasConfField AS HCMInfoTypeRecordHasConfField,
  _FamilyMember.HCMInfoTypeRecordScreenCtrl AS HCMInfoTypeRecordScreenCtrl,
  _FamilyMember.HCMMasterDataChangeReason AS HCMMasterDataChangeReason,
  _FamilyMember.HCMInfoTypeRecordRsrvdFld1 AS HCMInfoTypeRecordRsrvdFld1,
  _FamilyMember.HCMInfoTypeRecordRsrvdFld2 AS HCMInfoTypeRecordRsrvdFld2,
  _FamilyMember.HCMInfoTypeRecordRsrvdFld3 AS HCMInfoTypeRecordRsrvdFld3,
  _FamilyMember.HCMInfoTypeRecordRsrvdFld4 AS HCMInfoTypeRecordRsrvdFld4,
  _FamilyMember.HCMInfoTypeRecordRsrvdFld1Len2 AS HCMInfoTypeRecordRsrvdFld1Len2,
  _FamilyMember.HCMInfoTypeRecordRsrvdFld2Len2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  _FamilyMember.HCMGrpgValForPersAssignments AS HCMGrpgValForPersAssignments,
  _SubtypeText.HCMSubtypeText AS HCMSubtypeText,
  _Customizing.StartDate AS HCMDefaultDate,
  cast(_FamilyMember.StartDate as hrfio_per_valid_from preserving type ) AS HCMValidityStartDate,
  cast(_FamilyMember.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,
  _FamilyMember.HCMFamilyMemberTypeCode AS HCMFamilyMemberTypeCode,
  _FamilyMember.HCMFamilyMemberBirthDate AS HCMFamilyMemberBirthDate,
  cast(_FamilyMember.HCMFamilyMemberCntryOfBrthCode as hrfio_country_of_birth_id preserving type ) AS HCMFamilyMemberCntryOfBrthCode,
  _FamilyMember.HCMFamilyMemberNationalityCode AS HCMFamilyMemberNationalityCode,
  _FamilyMember.HCMFamilyMemberGenderCode AS HCMFamilyMemberGenderCode,
  _FamilyMember.HCMFamilyMemberFirstName AS HCMFamilyMemberFirstName,
  _FamilyMember.HCMFamilyMemberLastName AS HCMFamilyMemberLastName,
  _FamilyMember.HCMFamilyMemberPlaceOfBrthName AS HCMFamilyMemberPlaceOfBrthName,
  _FamilyMember.HCMFamilyMemberStateOfBrthCode AS HCMFamilyMemberStateOfBrthCode,
  _FamilyMember.HCMFamMbrRefPersnWorkAgreement AS HCMFamMbrRefPersnWorkAgreement,
  _FamilyMember.HCMFamilyMemberBirthName AS HCMFamilyMemberBirthName,
  _FamilyMember.HCMFamilyMember2ndName AS HCMFamilyMember2ndName,
  _FamilyMember.HCMFamilyMemberCompleteName AS HCMFamilyMemberCompleteName,
  _FamilyMember.HCMFamilyMemberNameFormatCode AS HCMFamilyMemberNameFormatCode,
  _FamilyMember.HCMFamilyMemberInitials AS HCMFamilyMemberInitials,
  _FamilyMember.HCMFamilyMemberNamePrefixCode AS HCMFamilyMemberNamePrefixCode,
  _FamilyMember.HCMFamMember2ndNamePrefixCode AS HCMFamMember2ndNamePrefixCode,
  _FamilyMember.HCMFamilyMemberOtherTitleCode AS HCMFamilyMemberOtherTitleCode,
  _FamilyMember.HCMFamilyMemberInsuranceNumber AS HCMFamilyMemberInsuranceNumber,
  _FamilyMember.HCMFamMbrRelshpToChildCode AS HCMFamMbrRelshpToChildCode,
  _FamilyMember.HCMFamMbrAllwncAuthznCode AS HCMFamMbrAllwncAuthznCode,
  _FamilyMember.HCMFamMbrAddressOfChildCode AS HCMFamMbrAddressOfChildCode,
  _FamilyMember.HCMFamMbrChildAllwncEntlmnt AS HCMFamMbrChildAllwncEntlmnt,
  _FamilyMember.HCMFamilyMemberChildTypeCode AS HCMFamilyMemberChildTypeCode,
  _FamilyMember.HCMFamilyMemberChildBonusCode AS HCMFamilyMemberChildBonusCode,
  _FamilyMember.HCMFamMbrChildAllowanceCode AS HCMFamMbrChildAllowanceCode,
  _FamilyMember.HCMFamMbrSicknessCertAuthzn AS HCMFamMbrSicknessCertAuthzn,
  _FamilyMember.HCMFamilyMemberAuthznNmbrCode AS HCMFamilyMemberAuthznNmbrCode,
  _FamilyMember.HCMFamMbrSoclInsurNmbr1stPrt AS HCMFamMbrSoclInsurNmbr1stPrt,
  _FamilyMember.HCMFamMbrSoclInsurNmbr2ndPrt AS HCMFamMbrSoclInsurNmbr2ndPrt,
  _FamilyMember.HCMFamMemberEducationEndDate AS HCMFamMemberEducationEndDate,
  _FamilyMember.HCMFamilyMemberSchoolTypeCode AS HCMFamilyMemberSchoolTypeCode,
  _FamilyMember.HCMFamMbrEducInstituteName AS HCMFamMbrEducInstituteName,
  _FamilyMember.HCMFamilyMemberEmployerCode AS HCMFamilyMemberEmployerCode,
  _FamilyMember.HCMFamilyMember2ndNatltyCode AS HCMFamilyMember2ndNatltyCode,
  _FamilyMember.HCMFamilyMember3rdNatltyCode AS HCMFamilyMember3rdNatltyCode,
  _FamilyMember.HCMFamilyMemberTitleCode AS HCMFamilyMemberTitleCode,
  _FamilyMember.HCMFamMbrIsEmergencyContact AS HCMFamMbrIsEmergencyContact,
  _FamilyMember.HCMFamilyMember2ndTitleCode AS HCMFamilyMember2ndTitleCode
FROM I_HCMFamilyMember AS _FamilyMember
LEFT OUTER JOIN I_HCMPersonalInfoPersNumbers AS _Contract ON HCMPersonnelNumber = _Contract.HCMPersonnelNumber  -- association [1..1]
;