R_AE_HCM_ESSFamMbrDraft

DDL: R_AE_HCM_ESSFAMMBRDRAFT Type: view_entity BASIC
98 Fields 1 Data Sources

My Family Members AE - Draft

R_AE_HCM_ESSFamMbrDraft is a Basic CDS View that provides data about "My Family Members AE - Draft" in SAP S/4HANA. It reads from 1 data source (hrfio_d_fmae_d) and exposes 98 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

SourceAliasJoin Type
hrfio_d_fmae_d FamilyMemberDraft from

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label My Family Members AE - Draft view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API 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 (98)

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.
KEY HCMDraftSequentialNumber hcmdraftsequentialnumber
LastChangedDate lastchangeddate Created On
LastChangedByUser lastchangedbyuser User Name
HCMInfoTypeRecordHasText hcminfotyperecordhastext Text exists
HCMInfoTypeRecordScreenCtrl hcminfotyperecordscreenctrl Screen control
HCMSubtypeText hcmsubtypetext Name
HCMETag hcmetag UUID
HCMValidityStartDate hcmvaliditystartdate Start Date
HCMValidityEndDate hcmvalidityenddate End Date
HCMDefaultDate hcmdefaultdate Current Date
HCMRecordIsStoredInDataBase hcmrecordisstoredindatabase Truth Value
HCMValidityStartDateFieldCtrl hcmvaliditystartdatefieldctrl INT1
HCMInfoTypeVersion hcminfotypeversion Infotype Vers.
HCMCountryRegionGrouping hcmcountryregiongrouping HCM Local.
HCMFamilyMemberTypeCode hcmfamilymembertypecode Family Member
HCMFamilyMemberLastName hcmfamilymemberlastname Name at Birth
HCMFamilyMemberBirthName hcmfamilymemberbirthname Partner Name
HCMFamilyMemberFirstName hcmfamilymemberfirstname First Name
HCMFamilyMember2ndName hcmfamilymember2ndname Second name
HCMFamilyMemberInitials hcmfamilymemberinitials Initials
HCMFamilyMemberOtherTitleCode hcmfamilymemberothertitlecode Other title
HCMFamilyMemberNamePrefixCode hcmfamilymembernameprefixcode Name prefix
HCMFamMember2ndNamePrefixCode hcmfammember2ndnameprefixcode Name prefix
HCMFamilyMemberBirthDate hcmfamilymemberbirthdate Date of Birth
HCMFamilyMemberPlaceOfBrthName hcmfamilymemberplaceofbrthname Birthplace
HCMFamilyMemberCntryOfBrthCode hcmfamilymembercntryofbrthcode C/R Birth
HCMFamilyMemberNationalityCode hcmfamilymembernationalitycode Nationality
HCMFamilyMember2ndNatltyCode hcmfamilymember2ndnatltycode Other nat.
HCMFamilyMember3rdNatltyCode hcmfamilymember3rdnatltycode 2nd/3rd nat.
HCMFamilyMemberGenderCode hcmfamilymembergendercode Gender
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
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
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
HCMFamMbrSubtype2IsHidden hcmfammbrsubtype2ishidden Truth Value
HCMFamMbrSubtypeAE01IsHidden hcmfammbrsubtypeae01ishidden Truth Value
HCMFamMbrSubtypeAE02IsHidden hcmfammbrsubtypeae02ishidden Truth Value
HCMFamMbrSubtypeAE04IsHidden hcmfammbrsubtypeae04ishidden Truth Value
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_AE_HCM_ESSFamMbrDraft.
-- 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 R_AE_HCM_ESSFamMbrDraft AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  HCMDraftSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordScreenCtrl,
  HCMSubtypeText,
  HCMETag,
  HCMValidityStartDate,
  HCMValidityEndDate,
  HCMDefaultDate,
  HCMRecordIsStoredInDataBase,
  HCMValidityStartDateFieldCtrl,
  HCMInfoTypeVersion,
  HCMCountryRegionGrouping,
  HCMFamilyMemberTypeCode,
  HCMFamilyMemberLastName,
  HCMFamilyMemberBirthName,
  HCMFamilyMemberFirstName,
  HCMFamilyMember2ndName,
  HCMFamilyMemberInitials,
  HCMFamilyMemberOtherTitleCode,
  HCMFamilyMemberNamePrefixCode,
  HCMFamMember2ndNamePrefixCode,
  HCMFamilyMemberBirthDate,
  HCMFamilyMemberPlaceOfBrthName,
  HCMFamilyMemberCntryOfBrthCode,
  HCMFamilyMemberNationalityCode,
  HCMFamilyMember2ndNatltyCode,
  HCMFamilyMember3rdNatltyCode,
  HCMFamilyMemberGenderCode,
  HCMFamMbrIsEmployed,
  HCMFamMbrEmployerName,
  HCMFamMbrEmploymentDate,
  HCMFamMbrHasAcmdtnEntlmnt,
  HCMFamMbrIsLvePassageApplbl,
  HCMFamMbrLegalNomineeCode,
  HCMFamMbrArabicFirstName,
  HCMFamMbrArabicSecondName,
  HCMFamMbrArabicThirdName,
  HCMFamMbrArabicLastName,
  HCMFamMbrAcademicDegree,
  HCMFamMbrSpecialization,
  HCMFamMbrSpousePersNoInSameCo,
  HCMFamMbrPassportNumber,
  HCMFamMbrPassportIssueDate,
  HCMFamMbrPassportExpiryDate,
  HCMFamMbrAEVisaNumber,
  HCMFamMbrVisaIssueDate,
  HCMFamMbrVisaExpiryDate,
  HCMFamMbrDocumentTypeCode,
  HCMFamMbrDocumentNumber1,
  HCMFamMbrDocumentIssueDate,
  HCMFamMbrDocumentExpiryDate,
  HCMFamMbr2ndDocumentTypeCode,
  HCMFamMbr2ndDocumentNumber,
  HCMFamMbr2ndDocumentIssueDate,
  HCMFamMbr2ndDocumentExpiryDate,
  HCMFamMbr3rdDocumentTypeCode,
  HCMFamMbr3rdDocumentNumber,
  HCMFamMbr3rdDocumentIssueDate,
  HCMFamMbr3rdDocumentExpiryDate,
  HCMFamMbr4thDocumentTypeCode,
  HCMFamMbr4thDocumentNumber,
  HCMFamMbr4thDocumentIssueDate,
  HCMFamMbr4thDocumentExpiryDate,
  HCMFamMbr5thDocumentTypeCode,
  HCMFamMbr5thDocumentNumber,
  HCMFamMbr5thDocumentIssueDate,
  HCMFamMbr5thDocumentExpiryDate,
  HCMFamMbr6thDocumentTypeCode,
  HCMFamMbr6thDocumentNumber,
  HCMFamMbr6thDocumentIssueDate,
  HCMFamMbr6thDocumentExpiryDate,
  HCMFamMbr7thDocumentTypeCode,
  HCMFamMbr7thDocumentNumber,
  HCMFamMbr7thDocumentIssueDate,
  HCMFamMbr7thDocumentExpiryDate,
  HCMFamMbr8thDocumentTypeCode,
  HCMFamMbr8thDocumentNumber,
  HCMFamMbr8thDocumentIssueDate,
  HCMFamMbr8thDocumentExpiryDate,
  HCMFamMbrSubtype2IsHidden,
  HCMFamMbrSubtypeAE01IsHidden,
  HCMFamMbrSubtypeAE02IsHidden,
  HCMFamMbrSubtypeAE04IsHidden,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM hrfio_d_fmae_d AS FamilyMemberDraft
;

Learn More