I_JP_HCM_ESSFamMbrSupplement

DDL: I_JP_HCM_ESSFAMMBRSUPPLEMENT Type: view_entity COMPOSITE
72 Fields 1 Data Sources

My Fam Mmbrs JP Addtl Data

I_JP_HCM_ESSFamMbrSupplement is a Composite CDS View that provides data about "My Fam Mmbrs JP Addtl Data" in SAP S/4HANA. It reads from 1 data source (I_JP_HCMFamilyMemberSupplement) and exposes 72 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

SourceAliasJoin Type
I_JP_HCMFamilyMemberSupplement I_JP_HCMFamilyMemberSupplement from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label My Fam Mmbrs JP Addtl Data view
Metadata.ignorePropagatedAnnotations false view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber HCMPersonnelNumber Personnel No.
KEY HCMSubtype HCMSubtype Subtype
KEY HCMObjectIdentification HCMObjectIdentification Object ID
KEY HCMRecordIsLocked HCMRecordIsLocked Lock indicator
KEY EndDate EndDate Term to
KEY StartDate StartDate Valid From
KEY HCMSequentialNumber HCMSequentialNumber IT record no.
LastChangedDate LastChangedDate Created On
LastChangedByUser LastChangedByUser User Name
HCMInfoTypeRecordIsHistorical HCMInfoTypeRecordIsHistorical Historical rec.
HCMInfoTypeRecordHasText HCMInfoTypeRecordHasText Text exists
HCMInfoTypeRecordHasRefField HCMInfoTypeRecordHasRefField Ref. exists
HCMInfoTypeRecordHasConfField HCMInfoTypeRecordHasConfField Conf.fields ex.
HCMInfoTypeRecordScreenCtrl HCMInfoTypeRecordScreenCtrl Screen control
HCMMasterDataChangeReason HCMMasterDataChangeReason Change Reason
HCMInfoTypeRecordRsrvdFld1 HCMInfoTypeRecordRsrvdFld1 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld2 HCMInfoTypeRecordRsrvdFld2 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld3 HCMInfoTypeRecordRsrvdFld3 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld4 HCMInfoTypeRecordRsrvdFld4 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld1Len2 HCMInfoTypeRecordRsrvdFld1Len2 Reserved Field/Unused Field of Length 2
HCMInfoTypeRecordRsrvdFld2Len2 HCMInfoTypeRecordRsrvdFld2Len2 Reserved Field/Unused Field of Length 2
HCMGrpgValForPersAssignments HCMGrpgValForPersAssignments Grouping Value
HCMFamilyMemberTypeCode HCMFamilyMemberTypeCode Family Member
HCMFamilyMemberBirthDate HCMFamilyMemberBirthDate Date of Birth
HCMFamilyMemberCntryOfBrthCode HCMFamilyMemberCntryOfBrthCode C/R Birth
HCMFamilyMemberNationalityCode HCMFamilyMemberNationalityCode Nationality
HCMFamilyMemberGenderCode HCMFamilyMemberGenderCode Gender
HCMFamilyMemberKanjiFirstName HCMFamilyMemberKanjiFirstName First Name
HCMFamilyMemberKanjiLastName HCMFamilyMemberKanjiLastName Last Name
HCMFamilyMemberStateOfBrthCode HCMFamilyMemberStateOfBrthCode State
HCMFamilyMemberPlaceOfBrthName HCMFamilyMemberPlaceOfBrthName Birthplace
HCMFamilyMemberNameFormatCode HCMFamilyMemberNameFormatCode Name Format
HCMFamilyMemberChildTypeCode HCMFamilyMemberChildTypeCode Child Type
HCMFamMbrKatakanaFirstName HCMFamMbrKatakanaFirstName 1st name Katakana
HCMFamMbrKatakanaLastName HCMFamMbrKatakanaLastName Last name (Katakana)
HCMFamMbrRelationshipCode HCMFamMbrRelationshipCode Relationship
HCMFamMbrDeptDeductionCode HCMFamMbrDeptDeductionCode Dependent
HCMFamMbrAgeGroupDeductionCode HCMFamMbrAgeGroupDeductionCode Ded.for age grp. FM
HCMFamMbrDisabledDeductionCode HCMFamMbrDisabledDeductionCode Ded.for disab. FM
HCMFamMbrLiveWithDeduction HCMFamMbrLiveWithDeduction Ded.for live with
HCMFamMbrDepdntHlthInsur HCMFamMbrDepdntHlthInsur Health ins. ind.
HCMFamMbrFamilyAllowance HCMFamMbrFamilyAllowance Family all.
HCMFamMbrDepdntForYearEndAdjmt HCMFamMbrDepdntForYearEndAdjmt Ind (dep.for YEA)
HCMFamilyMemberIsDeceased HCMFamilyMemberIsDeceased Deceased
HCMFamMbrNonResidentCode HCMFamMbrNonResidentCode Non-resident
HCMFamMbrDepdntNurseInsur HCMFamMbrDepdntNurseInsur Nursin ins. ind.
HCMFamMbrCASubtype HCMFamMbrCASubtype Subtype
HCMFamMbrCAObjId HCMFamMbrCAObjId Object ID
HCMFamMbrCAEndDate HCMFamMbrCAEndDate End Date
HCMFamCASeqNumber HCMFamCASeqNumber IT record no.
HCMFamMbrSubtype HCMFamMbrSubtype Subtype
HCMFamMbrObjId HCMFamMbrObjId Object ID
HCMFamMbrChangeReasonText HCMFamMbrChangeReasonText Change Reason
HCMFamMbrDisabilityDescText HCMFamMbrDisabilityDescText Disability Content
HCMFamMbrDisabilityReasonText HCMFamMbrDisabilityReasonText Disability Reason
HCMFamMbrOccupationText HCMFamMbrOccupationText Occupation
HCMFamMbrDepdntTotIncAmount HCMFamMbrDepdntTotIncAmount Income of Depend
Currency Currency Valuation Crcy
HCMFamMbrPensionNumber HCMFamMbrPensionNumber Insurance no
HCMFamMbrKanjiMiddleName HCMFamMbrKanjiMiddleName Mdl name (Kanji)
HCMFamMbrKatakanaMiddleName HCMFamMbrKatakanaMiddleName Mdl name (Kana)
HCMFamMbrRomajiMiddleName HCMFamMbrRomajiMiddleName Middle name
HCMFamMbrPhoneTypeCode HCMFamMbrPhoneTypeCode Tel Type
HCMFamMbrPhoneNumber HCMFamMbrPhoneNumber Telephone No.
HCMFamMbrAdjustDeductTarget HCMFamMbrAdjustDeductTarget TRUE
HCMFamMbrDepEstTotIncAmount HCMFamMbrDepEstTotIncAmount Income of Depend
HCMFamMbrFactLiveHoodText HCMFamMbrFactLiveHoodText Live with Indicator
HCMFamMbrTaxIsConfirmed HCMFamMbrTaxIsConfirmed Checkbox
HCMFamMbrInsConfirmFlag HCMFamMbrInsConfirmFlag SI Stat for Rp.
HCMFamMbrOverseaExceptionCode HCMFamMbrOverseaExceptionCode Except.
HCMFamMbrChangeReasonCode HCMFamMbrChangeReasonCode Change Reason
HCMFamMbrHasRetireIncomeForRes HCMFamMbrHasRetireIncomeForRes Ret. Income Res.

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_JP_HCM_ESSFamMbrSupplement.
-- 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_JP_HCM_ESSFamMbrSupplement AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordIsHistorical,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordHasRefField,
  HCMInfoTypeRecordHasConfField,
  HCMInfoTypeRecordScreenCtrl,
  HCMMasterDataChangeReason,
  HCMInfoTypeRecordRsrvdFld1,
  HCMInfoTypeRecordRsrvdFld2,
  HCMInfoTypeRecordRsrvdFld3,
  HCMInfoTypeRecordRsrvdFld4,
  HCMInfoTypeRecordRsrvdFld1Len2,
  HCMInfoTypeRecordRsrvdFld2Len2,
  HCMGrpgValForPersAssignments,
  HCMFamilyMemberTypeCode,
  HCMFamilyMemberBirthDate,
  HCMFamilyMemberCntryOfBrthCode,
  HCMFamilyMemberNationalityCode,
  HCMFamilyMemberGenderCode,
  HCMFamilyMemberKanjiFirstName,
  HCMFamilyMemberKanjiLastName,
  HCMFamilyMemberStateOfBrthCode,
  HCMFamilyMemberPlaceOfBrthName,
  HCMFamilyMemberNameFormatCode,
  HCMFamilyMemberChildTypeCode,
  HCMFamMbrKatakanaFirstName,
  HCMFamMbrKatakanaLastName,
  HCMFamMbrRelationshipCode,
  HCMFamMbrDeptDeductionCode,
  HCMFamMbrAgeGroupDeductionCode,
  HCMFamMbrDisabledDeductionCode,
  HCMFamMbrLiveWithDeduction,
  HCMFamMbrDepdntHlthInsur,
  HCMFamMbrFamilyAllowance,
  HCMFamMbrDepdntForYearEndAdjmt,
  HCMFamilyMemberIsDeceased,
  HCMFamMbrNonResidentCode,
  HCMFamMbrDepdntNurseInsur,
  HCMFamMbrCASubtype,
  HCMFamMbrCAObjId,
  HCMFamMbrCAEndDate,
  HCMFamCASeqNumber,
  HCMFamMbrSubtype,
  HCMFamMbrObjId,
  HCMFamMbrChangeReasonText,
  HCMFamMbrDisabilityDescText,
  HCMFamMbrDisabilityReasonText,
  HCMFamMbrOccupationText,
  HCMFamMbrDepdntTotIncAmount,
  Currency,
  HCMFamMbrPensionNumber,
  HCMFamMbrKanjiMiddleName,
  HCMFamMbrKatakanaMiddleName,
  HCMFamMbrRomajiMiddleName,
  HCMFamMbrPhoneTypeCode,
  HCMFamMbrPhoneNumber,
  HCMFamMbrAdjustDeductTarget,
  HCMFamMbrDepEstTotIncAmount,
  HCMFamMbrFactLiveHoodText,
  HCMFamMbrTaxIsConfirmed,
  HCMFamMbrInsConfirmFlag,
  HCMFamMbrOverseaExceptionCode,
  HCMFamMbrChangeReasonCode,
  HCMFamMbrHasRetireIncomeForRes
FROM I_JP_HCMFamilyMemberSupplement
;

Learn More