I_AE_HCM_ESSFamMbrSupplement

DDL: I_AE_HCM_ESSFAMMBRSUPPLEMENT Type: view_entity COMPOSITE
73 Fields 1 Data Sources

My Fam Mmbrs AE Addtl Data

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

Data Sources (1)

SourceAliasJoin Type
I_AE_HCMFAMILYMEMBERSUPPLEMENT I_AE_HCMFAMILYMEMBERSUPPLEMENT from

Annotations (7)

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

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
HCMFamMbrPassportNumber HCMFamMbrPassportNumber Passport Number
HCMFamMbrPassportIssueDate HCMFamMbrPassportIssueDate Issue Date
HCMFamMbrPassportExpiryDate HCMFamMbrPassportExpiryDate Pass. Expiry Date
HCMFamMbrAEVisaNumber HCMFamMbrAEVisaNumber Visa Number
HCMFamMbrVisaIssueDate HCMFamMbrVisaIssueDate Issue Date
HCMFamMbrVisaExpiryDate HCMFamMbrVisaExpiryDate Expiry Date
HCMFamMbrDocumentTypeCode HCMFamMbrDocumentTypeCode Document Type
HCMFamMbrDocumentNumber1 HCMFamMbrDocumentNumber1 Number
HCMFamMbrDocumentIssueDate HCMFamMbrDocumentIssueDate Document Issue Date
HCMFamMbrDocumentExpiryDate HCMFamMbrDocumentExpiryDate Document Expiry Date
HCMFamMbr2ndDocumentTypeCode HCMFamMbr2ndDocumentTypeCode Document Type
HCMFamMbr2ndDocumentNumber HCMFamMbr2ndDocumentNumber Number
HCMFamMbr2ndDocumentIssueDate HCMFamMbr2ndDocumentIssueDate Document Issue Date
HCMFamMbr2ndDocumentExpiryDate HCMFamMbr2ndDocumentExpiryDate Document Expiry Date
HCMFamMbr3rdDocumentTypeCode HCMFamMbr3rdDocumentTypeCode Document Type
HCMFamMbr3rdDocumentNumber HCMFamMbr3rdDocumentNumber Number
HCMFamMbr3rdDocumentIssueDate HCMFamMbr3rdDocumentIssueDate Document Issue Date
HCMFamMbr3rdDocumentExpiryDate HCMFamMbr3rdDocumentExpiryDate Document Expiry Date
HCMFamMbrIsEmployed HCMFamMbrIsEmployed Employed
HCMFamMbrEmployerName HCMFamMbrEmployerName ER Fmly. Mmbr.
HCMFamMbrEmploymentDate HCMFamMbrEmploymentDate Employment Date
HCMFamMbrHasAcmdtnEntlmnt HCMFamMbrHasAcmdtnEntlmnt Accom. Entitlement
HCMFamMbrIsLvePassageApplbl HCMFamMbrIsLvePassageApplbl Leave Passage
HCMFamMbrLegalNomineeCode HCMFamMbrLegalNomineeCode Legal Nominee
HCMFamMbrArabicFirstName HCMFamMbrArabicFirstName First Name
HCMFamMbrArabicSecondName HCMFamMbrArabicSecondName Second Name
HCMFamMbrArabicThirdName HCMFamMbrArabicThirdName Third Name
HCMFamMbrArabicLastName HCMFamMbrArabicLastName Last Name
HCMFamMbrAcademicDegree HCMFamMbrAcademicDegree Academic Degree
HCMFamMbrSpecialization HCMFamMbrSpecialization Specialization
HCMFamMbrSpousePersNoInSameCo HCMFamMbrSpousePersNoInSameCo Spouse ID
HCMFamMbr4thDocumentTypeCode HCMFamMbr4thDocumentTypeCode Document Type
HCMFamMbr4thDocumentNumber HCMFamMbr4thDocumentNumber Number
HCMFamMbr4thDocumentIssueDate HCMFamMbr4thDocumentIssueDate Document Issue Date
HCMFamMbr4thDocumentExpiryDate HCMFamMbr4thDocumentExpiryDate Document Expiry Date
HCMFamMbr5thDocumentTypeCode HCMFamMbr5thDocumentTypeCode Document Type
HCMFamMbr5thDocumentNumber HCMFamMbr5thDocumentNumber Number
HCMFamMbr5thDocumentIssueDate HCMFamMbr5thDocumentIssueDate Document Issue Date
HCMFamMbr5thDocumentExpiryDate HCMFamMbr5thDocumentExpiryDate Document Expiry Date
HCMFamMbr6thDocumentTypeCode HCMFamMbr6thDocumentTypeCode Document Type
HCMFamMbr6thDocumentNumber HCMFamMbr6thDocumentNumber Number
HCMFamMbr6thDocumentIssueDate HCMFamMbr6thDocumentIssueDate Document Issue Date
HCMFamMbr6thDocumentExpiryDate HCMFamMbr6thDocumentExpiryDate Document Expiry Date
HCMFamMbr7thDocumentTypeCode HCMFamMbr7thDocumentTypeCode Document Type
HCMFamMbr7thDocumentNumber HCMFamMbr7thDocumentNumber Number
HCMFamMbr7thDocumentIssueDate HCMFamMbr7thDocumentIssueDate Document Issue Date
HCMFamMbr7thDocumentExpiryDate HCMFamMbr7thDocumentExpiryDate Document Expiry Date
HCMFamMbr8thDocumentTypeCode HCMFamMbr8thDocumentTypeCode Document Type
HCMFamMbr8thDocumentNumber HCMFamMbr8thDocumentNumber Number
HCMFamMbr8thDocumentIssueDate HCMFamMbr8thDocumentIssueDate Document Issue Date
HCMFamMbr8thDocumentExpiryDate HCMFamMbr8thDocumentExpiryDate Document Expiry Date

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_AE_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_AE_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,
  HCMFamMbrPassportNumber,
  HCMFamMbrPassportIssueDate,
  HCMFamMbrPassportExpiryDate,
  HCMFamMbrAEVisaNumber,
  HCMFamMbrVisaIssueDate,
  HCMFamMbrVisaExpiryDate,
  HCMFamMbrDocumentTypeCode,
  HCMFamMbrDocumentNumber1,
  HCMFamMbrDocumentIssueDate,
  HCMFamMbrDocumentExpiryDate,
  HCMFamMbr2ndDocumentTypeCode,
  HCMFamMbr2ndDocumentNumber,
  HCMFamMbr2ndDocumentIssueDate,
  HCMFamMbr2ndDocumentExpiryDate,
  HCMFamMbr3rdDocumentTypeCode,
  HCMFamMbr3rdDocumentNumber,
  HCMFamMbr3rdDocumentIssueDate,
  HCMFamMbr3rdDocumentExpiryDate,
  HCMFamMbrIsEmployed,
  HCMFamMbrEmployerName,
  HCMFamMbrEmploymentDate,
  HCMFamMbrHasAcmdtnEntlmnt,
  HCMFamMbrIsLvePassageApplbl,
  HCMFamMbrLegalNomineeCode,
  HCMFamMbrArabicFirstName,
  HCMFamMbrArabicSecondName,
  HCMFamMbrArabicThirdName,
  HCMFamMbrArabicLastName,
  HCMFamMbrAcademicDegree,
  HCMFamMbrSpecialization,
  HCMFamMbrSpousePersNoInSameCo,
  HCMFamMbr4thDocumentTypeCode,
  HCMFamMbr4thDocumentNumber,
  HCMFamMbr4thDocumentIssueDate,
  HCMFamMbr4thDocumentExpiryDate,
  HCMFamMbr5thDocumentTypeCode,
  HCMFamMbr5thDocumentNumber,
  HCMFamMbr5thDocumentIssueDate,
  HCMFamMbr5thDocumentExpiryDate,
  HCMFamMbr6thDocumentTypeCode,
  HCMFamMbr6thDocumentNumber,
  HCMFamMbr6thDocumentIssueDate,
  HCMFamMbr6thDocumentExpiryDate,
  HCMFamMbr7thDocumentTypeCode,
  HCMFamMbr7thDocumentNumber,
  HCMFamMbr7thDocumentIssueDate,
  HCMFamMbr7thDocumentExpiryDate,
  HCMFamMbr8thDocumentTypeCode,
  HCMFamMbr8thDocumentNumber,
  HCMFamMbr8thDocumentIssueDate,
  HCMFamMbr8thDocumentExpiryDate
FROM I_AE_HCMFAMILYMEMBERSUPPLEMENT
;

Learn More