What is I_OM_HCM_ESSFamilyMemberTP in SAP S/4HANA?

I_OM_HCM_ESSFamilyMemberTP is a transactional CDS view in SAP S/4HANA. My Family Members OM - TP It contains 126 fields.

Which tables does I_OM_HCM_ESSFamilyMemberTP read from?

I_OM_HCM_ESSFamilyMemberTP reads data from: I_HCM_ESSFamilyMember.

What VDM layer is I_OM_HCM_ESSFamilyMemberTP?

I_OM_HCM_ESSFamilyMemberTP is classified as a Transactional view that supports create, update, and delete operations.

I_OM_HCM_ESSFamilyMemberTP

DDL: I_OM_HCM_ESSFAMILYMEMBERTP Type: view_entity TRANSACTIONAL

126 Fields 1 Data Sources 14 Associations

My Family Members OM - TP

I_OM_HCM_ESSFamilyMemberTP is a Transactional CDS View that provides data about "My Family Members OM - TP" in SAP S/4HANA. It reads from 1 data source (I_HCM_ESSFamilyMember) and exposes 126 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate. It has 14 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_HCM_ESSFamilyMember	I_HCM_ESSFamilyMember	from

Associations (14)

Cardinality	Target	Alias	Condition
[1]	I_HCM_ESSFamMbrSubtypeVsblty	_SubtypeVisibility	`$projection.HCMSubtype = _SubtypeVisibility.HCMSubtype`
[0..*]	I_CountryText	_CountryOfBirthText	`$projection.HCMFamilyMemberCntryOfBrthCode = _CountryOfBirthText.Country`
[0..*]	I_HCMNationalityText	_NationalityText	`$projection.HCMFamilyMemberNationalityCode = _NationalityText.Country`
[0..*]	I_HCMGenderText	_GenderText	`$projection.HCMFamilyMemberGenderCode = _GenderText.HCMGenderCode and $projection.HCMCountryRegionGrouping = _GenderText.HCMCountryRegionGrouping`
[0..*]	I_HCMNationalityText	_SecondNationalityText	`$projection.HCMFamilyMember2ndNatltyCode = _SecondNationalityText.Country`
[0..*]	I_HCMNationalityText	_ThirdNationalityText	`$projection.HCMFamilyMember3rdNatltyCode = _ThirdNationalityText.Country`
[1]	E_HCMFamilyMember	_Extension	`$projection.HCMPersonnelNumber = _Extension.HCMPersonnelNumber and $projection.HCMSubtype = _Extension.HCMSubtype and $projection.HCMObjectIdentification = _Extension.HCMObjectIdentification and $projection.HCMRecordIsLocked = _Extension.HCMRecordIsLocked and $projection.EndDate = _Extension.EndDate and $projection.StartDate = _Extension.StartDate and $projection.HCMSequentialNumber = _Extension.HCMSequentialNumber`
[0..*]	I_OM_HCMFamMbrDocumentTypeText	_DocumentTypeText1	`$projection.HCMFamMbrDocumentTypeCode1 = _DocumentTypeText1.HCMFamMbrDocumentTypeCode and $projection.HCMCountryRegionGrouping = _DocumentTypeText1.HCMCountryRegionGrouping`
[0..*]	I_OM_HCMFamMbrDocumentTypeText	_DocumentTypeText2	`$projection.HCMFamMbrDocumentTypeCode2 = _DocumentTypeText2.HCMFamMbrDocumentTypeCode and $projection.HCMCountryRegionGrouping = _DocumentTypeText2.HCMCountryRegionGrouping`
[0..*]	I_OM_HCMFamMbrDocumentTypeText	_DocumentTypeText3	`$projection.HCMFamMbrDocumentTypeCode3 = _DocumentTypeText3.HCMFamMbrDocumentTypeCode and $projection.HCMCountryRegionGrouping = _DocumentTypeText3.HCMCountryRegionGrouping`
[0..*]	I_OM_HCMFamMbrDocumentTypeText	_DocumentTypeText4	`$projection.HCMFamMbrDocumentTypeCode4 = _DocumentTypeText4.HCMFamMbrDocumentTypeCode and $projection.HCMCountryRegionGrouping = _DocumentTypeText4.HCMCountryRegionGrouping`
[0..*]	I_OM_HCMFamMbrDocumentTypeText	_DocumentTypeText5	`$projection.HCMFamMbrDocumentTypeCode5 = _DocumentTypeText5.HCMFamMbrDocumentTypeCode and $projection.HCMCountryRegionGrouping = _DocumentTypeText5.HCMCountryRegionGrouping`
[0..*]	I_OM_HCMFamMbrDocumentTypeText	_DocumentTypeText6	`$projection.HCMFamMbrDocumentTypeCode6 = _DocumentTypeText6.HCMFamMbrDocumentTypeCode and $projection.HCMCountryRegionGrouping = _DocumentTypeText6.HCMCountryRegionGrouping`
[0..*]	I_OM_HCMFamMbrHlthInsPaidText	_HealthInsuranceText	`$projection.HCMFamMbrHlthInsPrimPaidByCode = _HealthInsuranceText.DomainValueLow`

Annotations (16)

Name	Value	Level
EndUserText.label	My Family Members OM - TP	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	false	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.modelingPattern	#NONE	view
AbapCatalog.extensibility.extensible	true	view
AbapCatalog.extensibility.elementSuffix	PAD	view
AbapCatalog.extensibility.allowNewDatasources	false	view
AbapCatalog.extensibility.quota.maximumFields	100	view
AbapCatalog.extensibility.quota.maximumBytes	3704	view
Feature	SW:H4S4_SFWS_SC_01	view

Fields (126)

Key	Field	Source Table	Source Field	Description
KEY	HCMPersonnelNumber	I_HCM_ESSFamilyMember	HCMPersonnelNumber	Personnel No.
KEY	HCMSubtype	I_HCM_ESSFamilyMember	HCMSubtype	Subtype
KEY	HCMObjectIdentification	I_HCM_ESSFamilyMember	HCMObjectIdentification	Object ID
KEY	HCMRecordIsLocked	I_HCM_ESSFamilyMember	HCMRecordIsLocked	Lock indicator
KEY	EndDate	I_HCM_ESSFamilyMember	EndDate	Term to
KEY	StartDate	I_HCM_ESSFamilyMember	StartDate	Valid From
KEY	HCMSequentialNumber	I_HCM_ESSFamilyMember	HCMSequentialNumber	IT record no.
KEY	HCMDraftSequentialNumber	I_HCM_ESSFamilyMember	HCMDraftSequentialNumber
	LastChangedDate	I_HCM_ESSFamilyMember	LastChangedDate	Created On
	LastChangedByUser	I_HCM_ESSFamilyMember	LastChangedByUser	User Name
	HCMInfoTypeRecordHasText	I_HCM_ESSFamilyMember	HCMInfoTypeRecordHasText	Text exists
	HCMInfoTypeRecordScreenCtrl	I_HCM_ESSFamilyMember	HCMInfoTypeRecordScreenCtrl	Screen control
	HCMSubtypeText	I_HCM_ESSFamilyMember	HCMSubtypeText	Name
	HCMValidityStartDate	I_HCM_ESSFamilyMember	HCMValidityStartDate	Start Date
	HCMValidityEndDate	I_HCM_ESSFamilyMember	HCMValidityEndDate	End Date
	HCMDefaultDate	I_HCM_ESSFamilyMember	HCMDefaultDate	Current Date
	HCMRecordIsStoredInDataBase	I_HCM_ESSFamilyMember	HCMRecordIsStoredInDataBase	Truth Value
	HCMValidityStartDateFieldCtrl	I_HCM_ESSFamilyMember	HCMValidityStartDateFieldCtrl	INT1
	HCMInfoTypeVersion	_FamilyMemberRoot	HCMInfoTypeVersion	Infotype Vers.
	HCMCountryRegionGrouping	_FamilyMemberRoot	HCMCountryRegionGrouping	HCM Local.
	HCMFamilyMemberTypeCode	I_HCM_ESSFamilyMember	HCMFamilyMemberTypeCode	Family Member
	HCMFamilyMemberBirthDate	I_HCM_ESSFamilyMember	HCMFamilyMemberBirthDate	Date of Birth
	HCMFamilyMemberCntryOfBrthCode	I_HCM_ESSFamilyMember	HCMFamilyMemberCntryOfBrthCode	C/R Birth
	HCMFamilyMemberNationalityCode	I_HCM_ESSFamilyMember	HCMFamilyMemberNationalityCode	Nationality
	HCMFamilyMemberGenderCode	I_HCM_ESSFamilyMember	HCMFamilyMemberGenderCode	Gender
	HCMFamilyMemberFirstName	I_HCM_ESSFamilyMember	HCMFamilyMemberFirstName	First Name
	HCMFamilyMemberLastName	I_HCM_ESSFamilyMember	HCMFamilyMemberLastName	Name at Birth
	HCMFamilyMemberPlaceOfBrthName	I_HCM_ESSFamilyMember	HCMFamilyMemberPlaceOfBrthName	Birthplace
	HCMFamilyMemberStateOfBrthCode	I_HCM_ESSFamilyMember	HCMFamilyMemberStateOfBrthCode	State
	HCMFamMbrRefPersnWorkAgreement	I_HCM_ESSFamilyMember	HCMFamMbrRefPersnWorkAgreement	Ref.Pers.No.
	HCMFamilyMemberBirthName	I_HCM_ESSFamilyMember	HCMFamilyMemberBirthName	Partner Name
	HCMFamilyMember2ndName	I_HCM_ESSFamilyMember	HCMFamilyMember2ndName	Second name
	HCMFamilyMemberCompleteName	I_HCM_ESSFamilyMember	HCMFamilyMemberCompleteName	Full Name
	HCMInfoType
	HCMNameEditingFormatCode
	HCMFamilyMemberNameFormatCode	I_HCM_ESSFamilyMember	HCMFamilyMemberNameFormatCode	Name Format
	HCMFamilyMemberInitials	I_HCM_ESSFamilyMember	HCMFamilyMemberInitials	Initials
	HCMFamilyMemberNamePrefixCode	I_HCM_ESSFamilyMember	HCMFamilyMemberNamePrefixCode	Name prefix
	HCMFamMember2ndNamePrefixCode	I_HCM_ESSFamilyMember	HCMFamMember2ndNamePrefixCode	Name prefix
	HCMFamilyMemberOtherTitleCode	I_HCM_ESSFamilyMember	HCMFamilyMemberOtherTitleCode	Other title
	HCMFamMbrRelshpToChildCode	I_HCM_ESSFamilyMember	HCMFamMbrRelshpToChildCode	Rel/Child
	HCMFamMbrAllwncAuthznCode	I_HCM_ESSFamilyMember	HCMFamMbrAllwncAuthznCode	Authoriztn
	HCMFamMbrAddressOfChildCode	I_HCM_ESSFamilyMember	HCMFamMbrAddressOfChildCode	Child's Address
	HCMFamMbrChildAllwncEntlmnt	I_HCM_ESSFamilyMember	HCMFamMbrChildAllwncEntlmnt	CA Entitle.
	HCMFamilyMemberChildTypeCode	I_HCM_ESSFamilyMember	HCMFamilyMemberChildTypeCode	Child Type
	HCMFamilyMemberChildBonusCode	I_HCM_ESSFamilyMember	HCMFamilyMemberChildBonusCode	Child Bonuses
	HCMFamMbrChildAllowanceCode	I_HCM_ESSFamilyMember	HCMFamMbrChildAllowanceCode	Child Allowance
	HCMFamMbrSicknessCertAuthzn	I_HCM_ESSFamilyMember	HCMFamMbrSicknessCertAuthzn	Sick.Cert.Auth.
	HCMFamilyMemberAuthznNmbrCode	I_HCM_ESSFamilyMember	HCMFamilyMemberAuthznNmbrCode	Authority No.
	HCMFamMbrSoclInsurNmbr1stPrt	I_HCM_ESSFamilyMember	HCMFamMbrSoclInsurNmbr1stPrt	SI Number
	HCMFamMbrSoclInsurNmbr2ndPrt	I_HCM_ESSFamilyMember	HCMFamMbrSoclInsurNmbr2ndPrt	SI Number
	HCMFamMemberEducationEndDate	I_HCM_ESSFamilyMember	HCMFamMemberEducationEndDate	Confirm. to
	HCMFamilyMemberSchoolTypeCode	I_HCM_ESSFamilyMember	HCMFamilyMemberSchoolTypeCode	Educ/Training
	HCMFamMbrEducInstituteName	I_HCM_ESSFamilyMember	HCMFamMbrEducInstituteName	Institute
	HCMFamilyMemberEmployerCode	I_HCM_ESSFamilyMember	HCMFamilyMemberEmployerCode	ER Address
	HCMFamilyMember2ndNatltyCode	I_HCM_ESSFamilyMember	HCMFamilyMember2ndNatltyCode	Other nat.
	HCMFamilyMember3rdNatltyCode	I_HCM_ESSFamilyMember	HCMFamilyMember3rdNatltyCode	2nd/3rd nat.
	HCMFamilyMemberTitleCode	I_HCM_ESSFamilyMember	HCMFamilyMemberTitleCode	Title
	HCMFamMbrIsEmergencyContact	I_HCM_ESSFamilyMember	HCMFamMbrIsEmergencyContact	Emergency Contact
	HCMFamMbrPassportNumber	_AdditionalData	HCMFamMbrPassportNumber	Passport Number
	HCMFamMbrPassportIssueDate	_AdditionalData	HCMFamMbrPassportIssueDate	Issue Date
	HCMFamMbrPassportExpiryDate	_AdditionalData	HCMFamMbrPassportExpiryDate	Pass. Expiry Date
	HCMFamMbrOMVisaNumber	_AdditionalData	HCMFamMbrOMVisaNumber	Visa Number
	HCMFamMbrVisaIssueDate	_AdditionalData	HCMFamMbrVisaIssueDate	Issue Date
	HCMFamMbrVisaExpiryDate	_AdditionalData	HCMFamMbrVisaExpiryDate	Expiry Date
	HCMFamMbrDocumentTypeCode1	_AdditionalData	HCMFamMbrDocumentTypeCode1	Document Type
	HCMFamMbrDocumentNumber1	_AdditionalData	HCMFamMbrDocumentNumber1	Number
	HCMFamMbrDocNmbr1IssueDate	_AdditionalData	HCMFamMbrDocNmbr1IssueDate	Document Issue Date
	HCMFamMbrDocNmbr1ExpiryDate	_AdditionalData	HCMFamMbrDocNmbr1ExpiryDate	Document Expiry Date
	HCMFamMbrDocumentTypeCode2	_AdditionalData	HCMFamMbrDocumentTypeCode2	Document Type
	HCMFamMbrDocumentNumber2	_AdditionalData	HCMFamMbrDocumentNumber2	Number
	HCMFamMbrDocNmbr2IssueDate	_AdditionalData	HCMFamMbrDocNmbr2IssueDate	Document Issue Date
	HCMFamMbrDocNmbr2ExpiryDate	_AdditionalData	HCMFamMbrDocNmbr2ExpiryDate	Document Expiry Date
	HCMFamMbrDocumentTypeCode3	_AdditionalData	HCMFamMbrDocumentTypeCode3	Document Type
	HCMFamMbrDocumentNumber3	_AdditionalData	HCMFamMbrDocumentNumber3	Number
	HCMFamMbrDocNmbr3IssueDate	_AdditionalData	HCMFamMbrDocNmbr3IssueDate	Document Issue Date
	HCMFamMbrDocNmbr3ExpiryDate	_AdditionalData	HCMFamMbrDocNmbr3ExpiryDate	Document Expiry Date
	HCMFamMbrDocumentTypeCode4	_AdditionalData	HCMFamMbrDocumentTypeCode4	Document Type
	HCMFamMbrDocumentNumber4	_AdditionalData	HCMFamMbrDocumentNumber4	Number
	HCMFamMbrDocNmbr4IssueDate	_AdditionalData	HCMFamMbrDocNmbr4IssueDate	Document Issue Date
	HCMFamMbrDocNmbr4ExpiryDate	_AdditionalData	HCMFamMbrDocNmbr4ExpiryDate	Document Expiry Date
	HCMFamMbrDocumentTypeCode5	_AdditionalData	HCMFamMbrDocumentTypeCode5	Document Type
	HCMFamMbrDocumentNumber5	_AdditionalData	HCMFamMbrDocumentNumber5	Number
	HCMFamMbrDocNmbr5IssueDate	_AdditionalData	HCMFamMbrDocNmbr5IssueDate	Document Issue Date
	HCMFamMbrDocNmbr5ExpiryDate	_AdditionalData	HCMFamMbrDocNmbr5ExpiryDate	Document Expiry Date
	HCMFamMbrDocumentTypeCode6	_AdditionalData	HCMFamMbrDocumentTypeCode6	Document Type
	HCMFamMbrDocumentNumber6	_AdditionalData	HCMFamMbrDocumentNumber6	Number
	HCMFamMbrDocNmbr6IssueDate	_AdditionalData	HCMFamMbrDocNmbr6IssueDate	Document Issue Date
	HCMFamMbrDocNmbr6ExpiryDate	_AdditionalData	HCMFamMbrDocNmbr6ExpiryDate	Document Expiry Date
	HCMFamMbrArabicFirstName	_AdditionalData	HCMFamMbrArabicFirstName	First Name
	HCMFamMbrArabicSecondName	_AdditionalData	HCMFamMbrArabicSecondName	Second Name
	HCMFamMbrArabicThirdName	_AdditionalData	HCMFamMbrArabicThirdName	Third Name
	HCMFamMbrArabicLastName	_AdditionalData	HCMFamMbrArabicLastName	Last Name
	HCMFamMbrIsElgblForHlthIns	_AdditionalData	HCMFamMbrIsElgblForHlthIns	Health Ins Cont
	HCMFamMbrHlthInsPrimPaidByCode	_AdditionalData	HCMFamMbrHlthInsPrimPaidByCode	Health Ins paid by
	HCMFamMbrSubtype10IsHidden	_SubtypeVisibility	HCMFamMbrSubtype10IsHidden	Truth Value
	HCMFamMbrSubtype11IsHidden	_SubtypeVisibility	HCMFamMbrSubtype11IsHidden	Truth Value
	HCMFamMbrSubtype12IsHidden	_SubtypeVisibility	HCMFamMbrSubtype12IsHidden	Truth Value
	HCMFamMbrSubtype13IsHidden	_SubtypeVisibility	HCMFamMbrSubtype13IsHidden	Truth Value
	HCMFamMbrSubtype14IsHidden	_SubtypeVisibility	HCMFamMbrSubtype14IsHidden	Truth Value
	HCMFamMbrSubtype15IsHidden	_SubtypeVisibility	HCMFamMbrSubtype15IsHidden	Truth Value
	HCMFamMbrSubtype2IsHidden	_SubtypeVisibility	HCMFamMbrSubtype2IsHidden	Truth Value
	HCMFamMbrSubtype3IsHidden	_SubtypeVisibility	HCMFamMbrSubtype3IsHidden	Truth Value
	HCMFamMbrSubtype4IsHidden	_SubtypeVisibility	HCMFamMbrSubtype4IsHidden	Truth Value
	HCMFamMbrSubtype5IsHidden	_SubtypeVisibility	HCMFamMbrSubtype5IsHidden	Truth Value
	HCMFamMbrSubtype6IsHidden	_SubtypeVisibility	HCMFamMbrSubtype6IsHidden	Truth Value
	HCMFamMbrSubtype7IsHidden	_SubtypeVisibility	HCMFamMbrSubtype7IsHidden	Truth Value
	HCMFamMbrSubtype8IsHidden	_SubtypeVisibility	HCMFamMbrSubtype8IsHidden	Truth Value
	HCMFamMbrSubtypeOM01IsHidden	_SubtypeVisibility	HCMFamMbrSubtypeOM01IsHidden	Truth Value
	HCMFamMbrSubtypeOM02IsHidden	_SubtypeVisibility	HCMFamMbrSubtypeOM02IsHidden	Truth Value
	_Contract	I_HCM_ESSFamilyMember	_Contract
	_SubtypeVisibility		_SubtypeVisibility
	_CountryOfBirthText		_CountryOfBirthText
	_NationalityText		_NationalityText
	_GenderText		_GenderText
	_SecondNationalityText		_SecondNationalityText
	_ThirdNationalityText		_ThirdNationalityText
	_AdditionalData		_AdditionalData
	_FamilyMemberRoot		_FamilyMemberRoot
	_DocumentTypeText1		_DocumentTypeText1
	_DocumentTypeText2		_DocumentTypeText2
	_DocumentTypeText3		_DocumentTypeText3
	_DocumentTypeText4		_DocumentTypeText4
	_DocumentTypeText5		_DocumentTypeText5
	_DocumentTypeText6		_DocumentTypeText6
	_HealthInsuranceText		_HealthInsuranceText

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_OM_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_OM_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,
  I_HCM_ESSFamilyMember.HCMFamilyMemberBirthDate AS HCMFamilyMemberBirthDate,
  I_HCM_ESSFamilyMember.HCMFamilyMemberCntryOfBrthCode AS HCMFamilyMemberCntryOfBrthCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNationalityCode AS HCMFamilyMemberNationalityCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberGenderCode AS HCMFamilyMemberGenderCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberFirstName AS HCMFamilyMemberFirstName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberLastName AS HCMFamilyMemberLastName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberPlaceOfBrthName AS HCMFamilyMemberPlaceOfBrthName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberStateOfBrthCode AS HCMFamilyMemberStateOfBrthCode,
  I_HCM_ESSFamilyMember.HCMFamMbrRefPersnWorkAgreement AS HCMFamMbrRefPersnWorkAgreement,
  I_HCM_ESSFamilyMember.HCMFamilyMemberBirthName AS HCMFamilyMemberBirthName,
  I_HCM_ESSFamilyMember.HCMFamilyMember2ndName AS HCMFamilyMember2ndName,
  I_HCM_ESSFamilyMember.HCMFamilyMemberCompleteName AS HCMFamilyMemberCompleteName,
  cast ('0021' as infotyp ) AS HCMInfoType,
  cast ('01' as pnafo preserving type ) AS HCMNameEditingFormatCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNameFormatCode AS HCMFamilyMemberNameFormatCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberInitials AS HCMFamilyMemberInitials,
  I_HCM_ESSFamilyMember.HCMFamilyMemberNamePrefixCode AS HCMFamilyMemberNamePrefixCode,
  I_HCM_ESSFamilyMember.HCMFamMember2ndNamePrefixCode AS HCMFamMember2ndNamePrefixCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberOtherTitleCode AS HCMFamilyMemberOtherTitleCode,
  I_HCM_ESSFamilyMember.HCMFamMbrRelshpToChildCode AS HCMFamMbrRelshpToChildCode,
  I_HCM_ESSFamilyMember.HCMFamMbrAllwncAuthznCode AS HCMFamMbrAllwncAuthznCode,
  I_HCM_ESSFamilyMember.HCMFamMbrAddressOfChildCode AS HCMFamMbrAddressOfChildCode,
  I_HCM_ESSFamilyMember.HCMFamMbrChildAllwncEntlmnt AS HCMFamMbrChildAllwncEntlmnt,
  I_HCM_ESSFamilyMember.HCMFamilyMemberChildTypeCode AS HCMFamilyMemberChildTypeCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberChildBonusCode AS HCMFamilyMemberChildBonusCode,
  I_HCM_ESSFamilyMember.HCMFamMbrChildAllowanceCode AS HCMFamMbrChildAllowanceCode,
  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.HCMFamilyMember2ndNatltyCode AS HCMFamilyMember2ndNatltyCode,
  I_HCM_ESSFamilyMember.HCMFamilyMember3rdNatltyCode AS HCMFamilyMember3rdNatltyCode,
  I_HCM_ESSFamilyMember.HCMFamilyMemberTitleCode AS HCMFamilyMemberTitleCode,
  I_HCM_ESSFamilyMember.HCMFamMbrIsEmergencyContact AS HCMFamMbrIsEmergencyContact,
  _AdditionalData.HCMFamMbrPassportNumber AS HCMFamMbrPassportNumber,
  _AdditionalData.HCMFamMbrPassportIssueDate AS HCMFamMbrPassportIssueDate,
  _AdditionalData.HCMFamMbrPassportExpiryDate AS HCMFamMbrPassportExpiryDate,
  _AdditionalData.HCMFamMbrOMVisaNumber AS HCMFamMbrOMVisaNumber,
  _AdditionalData.HCMFamMbrVisaIssueDate AS HCMFamMbrVisaIssueDate,
  _AdditionalData.HCMFamMbrVisaExpiryDate AS HCMFamMbrVisaExpiryDate,
  _AdditionalData.HCMFamMbrDocumentTypeCode1 AS HCMFamMbrDocumentTypeCode1,
  _AdditionalData.HCMFamMbrDocumentNumber1 AS HCMFamMbrDocumentNumber1,
  _AdditionalData.HCMFamMbrDocNmbr1IssueDate AS HCMFamMbrDocNmbr1IssueDate,
  _AdditionalData.HCMFamMbrDocNmbr1ExpiryDate AS HCMFamMbrDocNmbr1ExpiryDate,
  _AdditionalData.HCMFamMbrDocumentTypeCode2 AS HCMFamMbrDocumentTypeCode2,
  _AdditionalData.HCMFamMbrDocumentNumber2 AS HCMFamMbrDocumentNumber2,
  _AdditionalData.HCMFamMbrDocNmbr2IssueDate AS HCMFamMbrDocNmbr2IssueDate,
  _AdditionalData.HCMFamMbrDocNmbr2ExpiryDate AS HCMFamMbrDocNmbr2ExpiryDate,
  _AdditionalData.HCMFamMbrDocumentTypeCode3 AS HCMFamMbrDocumentTypeCode3,
  _AdditionalData.HCMFamMbrDocumentNumber3 AS HCMFamMbrDocumentNumber3,
  _AdditionalData.HCMFamMbrDocNmbr3IssueDate AS HCMFamMbrDocNmbr3IssueDate,
  _AdditionalData.HCMFamMbrDocNmbr3ExpiryDate AS HCMFamMbrDocNmbr3ExpiryDate,
  _AdditionalData.HCMFamMbrDocumentTypeCode4 AS HCMFamMbrDocumentTypeCode4,
  _AdditionalData.HCMFamMbrDocumentNumber4 AS HCMFamMbrDocumentNumber4,
  _AdditionalData.HCMFamMbrDocNmbr4IssueDate AS HCMFamMbrDocNmbr4IssueDate,
  _AdditionalData.HCMFamMbrDocNmbr4ExpiryDate AS HCMFamMbrDocNmbr4ExpiryDate,
  _AdditionalData.HCMFamMbrDocumentTypeCode5 AS HCMFamMbrDocumentTypeCode5,
  _AdditionalData.HCMFamMbrDocumentNumber5 AS HCMFamMbrDocumentNumber5,
  _AdditionalData.HCMFamMbrDocNmbr5IssueDate AS HCMFamMbrDocNmbr5IssueDate,
  _AdditionalData.HCMFamMbrDocNmbr5ExpiryDate AS HCMFamMbrDocNmbr5ExpiryDate,
  _AdditionalData.HCMFamMbrDocumentTypeCode6 AS HCMFamMbrDocumentTypeCode6,
  _AdditionalData.HCMFamMbrDocumentNumber6 AS HCMFamMbrDocumentNumber6,
  _AdditionalData.HCMFamMbrDocNmbr6IssueDate AS HCMFamMbrDocNmbr6IssueDate,
  _AdditionalData.HCMFamMbrDocNmbr6ExpiryDate AS HCMFamMbrDocNmbr6ExpiryDate,
  _AdditionalData.HCMFamMbrArabicFirstName AS HCMFamMbrArabicFirstName,
  _AdditionalData.HCMFamMbrArabicSecondName AS HCMFamMbrArabicSecondName,
  _AdditionalData.HCMFamMbrArabicThirdName AS HCMFamMbrArabicThirdName,
  _AdditionalData.HCMFamMbrArabicLastName AS HCMFamMbrArabicLastName,
  _AdditionalData.HCMFamMbrIsElgblForHlthIns AS HCMFamMbrIsElgblForHlthIns,
  _AdditionalData.HCMFamMbrHlthInsPrimPaidByCode AS HCMFamMbrHlthInsPrimPaidByCode,
  _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.HCMFamMbrSubtypeOM01IsHidden AS HCMFamMbrSubtypeOM01IsHidden,
  _SubtypeVisibility.HCMFamMbrSubtypeOM02IsHidden AS HCMFamMbrSubtypeOM02IsHidden,
  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_HCMGenderText AS _GenderText ON HCMFamilyMemberGenderCode = _GenderText.HCMGenderCode AND HCMCountryRegionGrouping = _GenderText.HCMCountryRegionGrouping  -- 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 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 I_OM_HCMFamMbrDocumentTypeText AS _DocumentTypeText1 ON HCMFamMbrDocumentTypeCode1 = _DocumentTypeText1.HCMFamMbrDocumentTypeCode AND HCMCountryRegionGrouping = _DocumentTypeText1.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_OM_HCMFamMbrDocumentTypeText AS _DocumentTypeText2 ON HCMFamMbrDocumentTypeCode2 = _DocumentTypeText2.HCMFamMbrDocumentTypeCode AND HCMCountryRegionGrouping = _DocumentTypeText2.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_OM_HCMFamMbrDocumentTypeText AS _DocumentTypeText3 ON HCMFamMbrDocumentTypeCode3 = _DocumentTypeText3.HCMFamMbrDocumentTypeCode AND HCMCountryRegionGrouping = _DocumentTypeText3.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_OM_HCMFamMbrDocumentTypeText AS _DocumentTypeText4 ON HCMFamMbrDocumentTypeCode4 = _DocumentTypeText4.HCMFamMbrDocumentTypeCode AND HCMCountryRegionGrouping = _DocumentTypeText4.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_OM_HCMFamMbrDocumentTypeText AS _DocumentTypeText5 ON HCMFamMbrDocumentTypeCode5 = _DocumentTypeText5.HCMFamMbrDocumentTypeCode AND HCMCountryRegionGrouping = _DocumentTypeText5.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_OM_HCMFamMbrDocumentTypeText AS _DocumentTypeText6 ON HCMFamMbrDocumentTypeCode6 = _DocumentTypeText6.HCMFamMbrDocumentTypeCode AND HCMCountryRegionGrouping = _DocumentTypeText6.HCMCountryRegionGrouping  -- association [0..*]
LEFT OUTER JOIN I_OM_HCMFamMbrHlthInsPaidText AS _HealthInsuranceText ON HCMFamMbrHlthInsPrimPaidByCode = _HealthInsuranceText.DomainValueLow  -- association [0..*]
;

Depth:

I_OM_HCM_ESSFamilyMemberTP view_entity

I_HCM_ESSFamilyMember view_entity

C_OM_HCM_ESSFamilyMemberTP view_entity