I_HCMFamilyMember

DDL: I_HCMFAMILYMEMBER Type: view_entity BASIC
61 Fields 1 Data Sources

HCM Family Members

I_HCMFamilyMember is a Basic CDS View that provides data about "HCM Family Members" in SAP S/4HANA. It reads from 1 data source (pa0021) and exposes 61 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

SourceAliasJoin Type
pa0021 pa0021 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label HCM Family Members view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber pernr Personnel no.
KEY HCMSubtype subty Subtype
KEY HCMObjectIdentification objps Object ID
KEY HCMRecordIsLocked sprps Single-Character Flag
KEY EndDate endda Valid To
KEY StartDate begda Valid From
KEY HCMSequentialNumber seqnr Tank ID
LastChangedDate aedtm Changed On
LastChangedByUser uname User Name
HCMInfoTypeRecordIsHistorical histo Historical rec.
HCMInfoTypeRecordHasText itxex Text exists
HCMInfoTypeRecordHasRefField refex Single-Character Flag
HCMInfoTypeRecordHasConfField ordex Single-Character Flag
HCMInfoTypeRecordScreenCtrl itbld Screen control
HCMMasterDataChangeReason preas Change Reason
HCMInfoTypeRecordRsrvdFld1 flag1 Text field length 1
HCMInfoTypeRecordRsrvdFld2 flag2 Tr. Evaluation
HCMInfoTypeRecordRsrvdFld3 flag3 Text field length 1
HCMInfoTypeRecordRsrvdFld4 flag4 Usage in the OWN Authorization Context
HCMInfoTypeRecordRsrvdFld1Len2 rese1 Reserved Field/Unused Field of Length 2
HCMInfoTypeRecordRsrvdFld2Len2 rese2 Reserved Field/Unused Field of Length 2
HCMGrpgValForPersAssignments grpvl Grouping Value
HCMFamilyMemberTypeCode famsa Family Member
HCMFamilyMemberBirthDate Birth date
HCMFamilyMemberCntryOfBrthCode fgbld C/R Birth
HCMFamilyMemberNationalityCode fanat Nationality
HCMFamilyMemberGenderCode fasex Gender
HCMFamilyMemberFirstName favor First Name
HCMFamilyMemberLastName fanam Last Name
HCMFamilyMemberPlaceOfBrthName fgbot Birthplace
HCMFamilyMemberStateOfBrthCode fgdep State
HCMFamMbrRefPersnWorkAgreement erbnr Ref.Pers.No.
HCMFamilyMemberBirthName fgbna Name at Birth
HCMFamilyMember2ndName fnac2 Second name
HCMFamilyMemberCompleteName fcnam Full Name
HCMFamilyMemberNameFormatCode fknzn Name Format
HCMFamilyMemberInitials finit Initials
HCMFamilyMemberNamePrefixCode fvrsw Name prefix
HCMFamMember2ndNamePrefixCode fvrs2 Name prefix
HCMFamilyMemberOtherTitleCode fnmzu Other title
HCMFamilyMemberInsuranceNumber AHV Number
HCMFamMbrRelshpToChildCode kdsvh Rel/Child
HCMFamMbrAllwncAuthznCode kdbsl Authoriztn
HCMFamMbrAddressOfChildCode kdutb Child's Address
HCMFamMbrChildAllwncEntlmnt kdgbr CA Entitle.
HCMFamilyMemberChildTypeCode kdart Child Type
HCMFamilyMemberChildBonusCode kdzug Child Bonuses
HCMFamMbrChildAllowanceCode kdzul Child Allowance
HCMFamMbrSicknessCertAuthzn kdvbe Sick.Cert.Auth.
HCMFamilyMemberAuthznNmbrCode ermnr Authority No.
HCMFamMbrSoclInsurNmbr1stPrt ausvl SI Number
HCMFamMbrSoclInsurNmbr2ndPrt ausvg SI Number
HCMFamMemberEducationEndDate fasdt Confirm. to
HCMFamilyMemberSchoolTypeCode fasar Educ/Training
HCMFamMbrEducInstituteName fasin Institute
HCMFamilyMemberEmployerCode egaga ER Address
HCMFamilyMember2ndNatltyCode fana2 Other nat.
HCMFamilyMember3rdNatltyCode fana3 2nd/3rd nat.
HCMFamilyMemberTitleCode titel Title
HCMFamMbrIsEmergencyContact emrgn Emergency Contact
HCMFamilyMember2ndTitleCode titl2 Second title

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_HCMFamilyMember.
-- 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_HCMFamilyMember AS
SELECT
  pernr AS HCMPersonnelNumber,
  subty AS HCMSubtype,
  objps AS HCMObjectIdentification,
  sprps AS HCMRecordIsLocked,
  endda AS EndDate,
  begda AS StartDate,
  seqnr AS HCMSequentialNumber,
  aedtm AS LastChangedDate,
  uname AS LastChangedByUser,
  histo AS HCMInfoTypeRecordIsHistorical,
  itxex AS HCMInfoTypeRecordHasText,
  refex AS HCMInfoTypeRecordHasRefField,
  ordex AS HCMInfoTypeRecordHasConfField,
  itbld AS HCMInfoTypeRecordScreenCtrl,
  preas AS HCMMasterDataChangeReason,
  flag1 AS HCMInfoTypeRecordRsrvdFld1,
  flag2 AS HCMInfoTypeRecordRsrvdFld2,
  flag3 AS HCMInfoTypeRecordRsrvdFld3,
  flag4 AS HCMInfoTypeRecordRsrvdFld4,
  rese1 AS HCMInfoTypeRecordRsrvdFld1Len2,
  rese2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  grpvl AS HCMGrpgValForPersAssignments,
  famsa AS HCMFamilyMemberTypeCode,
  cast ( fgbdt as fgbdt preserving type ) AS HCMFamilyMemberBirthDate,
  fgbld AS HCMFamilyMemberCntryOfBrthCode,
  fanat AS HCMFamilyMemberNationalityCode,
  fasex AS HCMFamilyMemberGenderCode,
  favor AS HCMFamilyMemberFirstName,
  fanam AS HCMFamilyMemberLastName,
  fgbot AS HCMFamilyMemberPlaceOfBrthName,
  fgdep AS HCMFamilyMemberStateOfBrthCode,
  erbnr AS HCMFamMbrRefPersnWorkAgreement,
  fgbna AS HCMFamilyMemberBirthName,
  fnac2 AS HCMFamilyMember2ndName,
  fcnam AS HCMFamilyMemberCompleteName,
  fknzn AS HCMFamilyMemberNameFormatCode,
  finit AS HCMFamilyMemberInitials,
  fvrsw AS HCMFamilyMemberNamePrefixCode,
  fvrs2 AS HCMFamMember2ndNamePrefixCode,
  fnmzu AS HCMFamilyMemberOtherTitleCode,
  cast (ahvnr as abap.char( 11 ) ) AS HCMFamilyMemberInsuranceNumber,
  kdsvh AS HCMFamMbrRelshpToChildCode,
  kdbsl AS HCMFamMbrAllwncAuthznCode,
  kdutb AS HCMFamMbrAddressOfChildCode,
  kdgbr AS HCMFamMbrChildAllwncEntlmnt,
  kdart AS HCMFamilyMemberChildTypeCode,
  kdzug AS HCMFamilyMemberChildBonusCode,
  kdzul AS HCMFamMbrChildAllowanceCode,
  kdvbe AS HCMFamMbrSicknessCertAuthzn,
  ermnr AS HCMFamilyMemberAuthznNmbrCode,
  ausvl AS HCMFamMbrSoclInsurNmbr1stPrt,
  ausvg AS HCMFamMbrSoclInsurNmbr2ndPrt,
  fasdt AS HCMFamMemberEducationEndDate,
  fasar AS HCMFamilyMemberSchoolTypeCode,
  fasin AS HCMFamMbrEducInstituteName,
  egaga AS HCMFamilyMemberEmployerCode,
  fana2 AS HCMFamilyMember2ndNatltyCode,
  fana3 AS HCMFamilyMember3rdNatltyCode,
  titel AS HCMFamilyMemberTitleCode,
  emrgn AS HCMFamMbrIsEmergencyContact,
  titl2 AS HCMFamilyMember2ndTitleCode
FROM pa0021
;

Learn More