I_US_HCM_ESSFamMbrSupplement

DDL: I_US_HCM_ESSFAMMBRSUPPLEMENT Type: view_entity COMPOSITE
56 Fields 1 Data Sources

My Fam Mmbrs US Addtl Data

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

Data Sources (1)

SourceAliasJoin Type
I_US_HCMFamilyMemberSupplement I_US_HCMFamilyMemberSupplement from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label My Fam Mmbrs US 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 (56)

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
HCMFamMbrNationalId HCMFamMbrNationalId ID number
HCMFamMbrIsStudent HCMFamMbrIsStudent Student Indic.
HCMFamMbrIsSmoker HCMFamMbrIsSmoker Smoker
HCMFamMbrStreet HCMFamMbrStreet Street/House
HCMFamMbrHouseNumber HCMFamMbrHouseNumber Street/House
HCMFamMbrCityName HCMFamMbrCityName City
HCMFamMbrRegionCode HCMFamMbrRegionCode Region
HCMFamMbrPostalCode HCMFamMbrPostalCode Postal Code
HCMFamMbrCountryCode Country/Reg.
HCMFamMbrPhoneNumber HCMFamMbrPhoneNumber Telephone No.
HCMFamMbrLglSeparationDate HCMFamMbrLglSeparationDate Separation Date
HCMFamMbrBnftPhysicianName HCMFamMbrBnftPhysicianName Physician Name
HCMFamMbrBnftPhysicianId HCMFamMbrBnftPhysicianId Physician ID
HCMFamMbr2ndBnftPhysnName HCMFamMbr2ndBnftPhysnName Physician Name
HCMFamMbr2ndBnftPhysnId HCMFamMbr2ndBnftPhysnId Physician ID
HCMFamMbrHasDisability HCMFamMbrHasDisability Disability
HCMFamMbrDsbltyDetnDate HCMFamMbrDsbltyDetnDate Disability Date
HCMFamMbrEmployerDsbltyDte HCMFamMbrEmployerDsbltyDte Date Learned
HCMFamMbrHasBnftMedicare HCMFamMbrHasBnftMedicare Medicare
HCMFamMbrHasBnftSmoker HCMFamMbrHasBnftSmoker Truth Value
HCMFamMbrMaritalStatusCode HCMFamMbrMaritalStatusCode Married
HCMFamMbrBnftPrvdrIdnNmbr HCMFamMbrBnftPrvdrIdnNmbr Provider number
HCMFamMbrBnftPolicyNumber HCMFamMbrBnftPolicyNumber Policy no.
HCMFamMbrTaxId HCMFamMbrTaxId Tax no.
HCMFamMbrResidencyTypeCode HCMFamMbrResidencyTypeCode Residency typ
HCMFamMbrEthnicOriginCode HCMFamMbrEthnicOriginCode Ethnic origin
HCMFamMbrSpouseEmplStsCode HCMFamMbrSpouseEmplStsCode Spouse employed
HCMFamMbrHasBnftMilitary HCMFamMbrHasBnftMilitary Military Serv.
HCMFamMbrHasBnftFinIndep HCMFamMbrHasBnftFinIndep Fin. Indep.
HCMFamMbrHasBnftNonTaxable HCMFamMbrHasBnftNonTaxable Non-taxable
HCMFamMbrMedlAbsncProofDte HCMFamMbrMedlAbsncProofDte Proof of Med Abs Dt
HCMFamMbrHasProofLegalDep HCMFamMbrHasProofLegalDep Proof submission Ind
HCMFamMbrProofLegalDepDate HCMFamMbrProofLegalDepDate Proof submission Dat
HCMFamMbrBenefitId HCMFamMbrBenefitId Person ID

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_US_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_US_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,
  HCMFamMbrNationalId,
  HCMFamMbrIsStudent,
  HCMFamMbrIsSmoker,
  HCMFamMbrStreet,
  HCMFamMbrHouseNumber,
  HCMFamMbrCityName,
  HCMFamMbrRegionCode,
  HCMFamMbrPostalCode,
  cast(HCMFamMbrCountryCode as hrfio_countryid preserving type ) AS HCMFamMbrCountryCode,
  HCMFamMbrPhoneNumber,
  HCMFamMbrLglSeparationDate,
  HCMFamMbrBnftPhysicianName,
  HCMFamMbrBnftPhysicianId,
  HCMFamMbr2ndBnftPhysnName,
  HCMFamMbr2ndBnftPhysnId,
  HCMFamMbrHasDisability,
  HCMFamMbrDsbltyDetnDate,
  HCMFamMbrEmployerDsbltyDte,
  HCMFamMbrHasBnftMedicare,
  HCMFamMbrHasBnftSmoker,
  HCMFamMbrMaritalStatusCode,
  HCMFamMbrBnftPrvdrIdnNmbr,
  HCMFamMbrBnftPolicyNumber,
  HCMFamMbrTaxId,
  HCMFamMbrResidencyTypeCode,
  HCMFamMbrEthnicOriginCode,
  HCMFamMbrSpouseEmplStsCode,
  HCMFamMbrHasBnftMilitary,
  HCMFamMbrHasBnftFinIndep,
  HCMFamMbrHasBnftNonTaxable,
  HCMFamMbrMedlAbsncProofDte,
  HCMFamMbrHasProofLegalDep,
  HCMFamMbrProofLegalDepDate,
  HCMFamMbrBenefitId
FROM I_US_HCMFamilyMemberSupplement
;

Learn More