R_QA_HCM_ESSFamMbrDraft

DDL: R_QA_HCM_ESSFAMMBRDRAFT Type: view_entity BASIC
143 Fields 1 Data Sources

My Family Members QA - Draft

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

Data Sources (1)

SourceAliasJoin Type
hrfio_d_fmqa_d FamilyMemberDraft from

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label My Family Members QA - 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 (143)

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
HCMFamilyMemberBirthDate hcmfamilymemberbirthdate Date of Birth
HCMFamilyMemberCntryOfBrthCode hcmfamilymembercntryofbrthcode C/R Birth
HCMFamilyMemberNationalityCode hcmfamilymembernationalitycode Nationality
HCMFamilyMemberGenderCode hcmfamilymembergendercode Gender
HCMFamilyMemberFirstName hcmfamilymemberfirstname First Name
HCMFamilyMemberLastName hcmfamilymemberlastname Name at Birth
HCMFamilyMemberPlaceOfBrthName hcmfamilymemberplaceofbrthname Birthplace
HCMFamilyMemberStateOfBrthCode hcmfamilymemberstateofbrthcode State
HCMFamMbrRefPersnWorkAgreement hcmfammbrrefpersnworkagreement Ref.Pers.No.
HCMFamilyMemberBirthName hcmfamilymemberbirthname Partner Name
HCMFamilyMember2ndName hcmfamilymember2ndname Second name
HCMFamilyMemberCompleteName hcmfamilymembercompletename Full Name
HCMInfoType hcminfotype Prefix
HCMNameEditingFormatCode hcmnameeditingformatcode Format
HCMFamilyMemberNameFormatCode hcmfamilymembernameformatcode Name Format
HCMFamilyMemberInitials hcmfamilymemberinitials Initials
HCMFamilyMemberNamePrefixCode hcmfamilymembernameprefixcode Name prefix
HCMFamMember2ndNamePrefixCode hcmfammember2ndnameprefixcode Name prefix
HCMFamilyMemberOtherTitleCode hcmfamilymemberothertitlecode Other title
HCMFamMbrRelshpToChildCode hcmfammbrrelshptochildcode Rel/Child
HCMFamMbrAllwncAuthznCode hcmfammbrallwncauthzncode Authoriztn
HCMFamMbrAddressOfChildCode hcmfammbraddressofchildcode Child's Address
HCMFamMbrChildAllwncEntlmnt hcmfammbrchildallwncentlmnt CA Entitle.
HCMFamilyMemberChildTypeCode hcmfamilymemberchildtypecode Child Type
HCMFamilyMemberChildBonusCode hcmfamilymemberchildbonuscode Child Bonuses
HCMFamMbrChildAllowanceCode hcmfammbrchildallowancecode Child Allowance
HCMFamMbrSicknessCertAuthzn hcmfammbrsicknesscertauthzn Sick.Cert.Auth.
HCMFamilyMemberAuthznNmbrCode hcmfamilymemberauthznnmbrcode Authority No.
HCMFamMbrSoclInsurNmbr1stPrt hcmfammbrsoclinsurnmbr1stprt SI Number
HCMFamMbrSoclInsurNmbr2ndPrt hcmfammbrsoclinsurnmbr2ndprt SI Number
HCMFamMemberEducationEndDate hcmfammembereducationenddate Confirm. to
HCMFamilyMemberSchoolTypeCode hcmfamilymemberschooltypecode Educ/Training
HCMFamMbrEducInstituteName hcmfammbreducinstitutename Institute
HCMFamilyMemberEmployerCode hcmfamilymemberemployercode ER Address
HCMFamilyMember2ndNatltyCode hcmfamilymember2ndnatltycode Other nat.
HCMFamilyMember3rdNatltyCode hcmfamilymember3rdnatltycode 2nd/3rd nat.
HCMFamilyMemberTitleCode hcmfamilymembertitlecode Title
HCMFamMbrIsEmergencyContact hcmfammbrisemergencycontact Emergency Contact
HCMFamMbrPassportNumber hcmfammbrpassportnumber Passport Number
HCMFamMbrPassportIssueDate hcmfammbrpassportissuedate Issue Date
HCMFamMbrPassportExpiryDate hcmfammbrpassportexpirydate Pass. Expiry Date
HCMFamMbrQAVisaNumber hcmfammbrQAvisanumber Visa Number
HCMFamMbrVisaIssueDate hcmfammbrvisaissuedate Issue Date
HCMFamMbrVisaExpiryDate hcmfammbrvisaexpirydate Expiry Date
HCMFamMbrQAIdNumber hcmfammbrqaidnumber ID Number
HCMFamMbrIdIssueDate hcmfammbridissuedate ID Issue Date
HCMFamMbrIdExpiryDate hcmfammbridexpirydate ID Expiry Date
HCMFamMbrDocumentTypeCode1 hcmfammbrdocumenttypecode1 Document Type
HCMFamMbrDocumentNumber1 hcmfammbrdocumentnumber1 Number
HCMFamMbrDocNmbr1IssueDate hcmfammbrdocnmbr1issuedate Document Issue Date
HCMFamMbrDocNmbr1ExpiryDate hcmfammbrdocnmbr1expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode2 hcmfammbrdocumenttypecode2 Document Type
HCMFamMbrDocumentNumber2 hcmfammbrdocumentnumber2 Number
HCMFamMbrDocNmbr2IssueDate hcmfammbrdocnmbr2issuedate Document Issue Date
HCMFamMbrDocNmbr2ExpiryDate hcmfammbrdocnmbr2expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode3 hcmfammbrdocumenttypecode3 Document Type
HCMFamMbrDocumentNumber3 hcmfammbrdocumentnumber3 Number
HCMFamMbrDocNmbr3IssueDate hcmfammbrdocnmbr3issuedate Document Issue Date
HCMFamMbrDocNmbr3ExpiryDate hcmfammbrdocnmbr3expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode4 hcmfammbrdocumenttypecode4 Document Type
HCMFamMbrDocumentNumber4 hcmfammbrdocumentnumber4 Number
HCMFamMbrDocNmbr4IssueDate hcmfammbrdocnmbr4issuedate Document Issue Date
HCMFamMbrDocNmbr4ExpiryDate hcmfammbrdocnmbr4expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode5 hcmfammbrdocumenttypecode5 Document Type
HCMFamMbrDocumentNumber5 hcmfammbrdocumentnumber5 Number
HCMFamMbrDocNmbr5IssueDate hcmfammbrdocnmbr5issuedate Document Issue Date
HCMFamMbrDocNmbr5ExpiryDate hcmfammbrdocnmbr5expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode6 hcmfammbrdocumenttypecode6 Document Type
HCMFamMbrDocumentNumber6 hcmfammbrdocumentnumber6 Number
HCMFamMbrDocNmbr6IssueDate hcmfammbrdocnmbr6issuedate Document Issue Date
HCMFamMbrDocNmbr6ExpiryDate hcmfammbrdocnmbr6expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode7 hcmfammbrdocumenttypecode7 Document Type
HCMFamMbrDocumentNumber7 hcmfammbrdocumentnumber7 Number
HCMFamMbrDocNmbr7IssueDate hcmfammbrdocnmbr7issuedate Document Issue Date
HCMFamMbrDocNmbr7ExpiryDate hcmfammbrdocnmbr7expirydate Document Expiry Date
HCMFamMbrDocumentTypeCode8 hcmfammbrdocumenttypecode8 Document Type
HCMFamMbrDocumentNumber8 hcmfammbrdocumentnumber8 Number
HCMFamMbrDocNmbr8IssueDate hcmfammbrdocnmbr8issuedate Document Issue Date
HCMFamMbrDocNmbr8ExpiryDate hcmfammbrdocnmbr8expirydate Document Expiry Date
HCMFamMbrCountryEntranceDate hcmfammbrcountryentrancedate Ctry/Reg. Entrance
HCMFamMbrIsEmployed hcmfammbrisemployed Employed
HCMFamMbrEmployerName hcmfammbremployername ER Fmly. Mmbr.
HCMFamMbrEmploymentDate hcmfammbremploymentdate Employment Date
HCMFamMbrHasAcmdtnEntlmnt hcmfammbrhasacmdtnentlmnt Accom. Entitlement
HCMFamMbrLegalNomineeCode hcmfammbrlegalnomineecode Legal Nominee
HCMFamMbrArabicFirstName hcmfammbrarabicfirstname First Name
HCMFamMbrArabicSecondName hcmfammbrarabicsecondname Second Name
HCMFamMbrArabicThirdName hcmfammbrarabicthirdname Third Name
HCMFamMbrArabicLastName hcmfammbrarabiclastname Last Name
HCMFamMbrAcademicDegreeCode hcmfammbracademicdegreecode Academic Degree
HCMFamMbrSpecialization hcmfammbrspecialization Specialization
HCMFamMbrJobName hcmfammbrjobname Job
HCMFamMbrQAEmployerTypeCode hcmfammbrqaemployertypecode Employer Type
HCMFamMbrSpousePersNumber hcmfammbrspousepersnumber Spouse ID
HCMFamMbrHasUnderDependents hcmfammbrhasunderdependents Under Dependents
HCMFamMbrDependentsCountryCode hcmfammbrdependentscountrycode C/R of Dependent
HCMFamMbrCurrentSchoolGrade hcmfammbrcurrentschoolgrade Current School Grade
HCMFamMbrSchoolIdNumber hcmfammbrschoolidnumber School ID
HCMFamMbrHasCompanyTransport hcmfammbrhascompanytransport Company Transport
HCMFamMbrTypeOfChallengeCode hcmfammbrtypeofchallengecode Challenge type
HCMFamMbrSubtype10IsHidden hcmfammbrsubtype10ishidden Truth Value
HCMFamMbrSubtype11IsHidden hcmfammbrsubtype11ishidden Truth Value
HCMFamMbrSubtype12IsHidden hcmfammbrsubtype12ishidden Truth Value
HCMFamMbrSubtype13IsHidden hcmfammbrsubtype13ishidden Truth Value
HCMFamMbrSubtype14IsHidden hcmfammbrsubtype14ishidden Truth Value
HCMFamMbrSubtype15IsHidden hcmfammbrsubtype15ishidden Truth Value
HCMFamMbrSubtype2IsHidden hcmfammbrsubtype2ishidden Truth Value
HCMFamMbrSubtype3IsHidden hcmfammbrsubtype3ishidden Truth Value
HCMFamMbrSubtype4IsHidden hcmfammbrsubtype4ishidden Truth Value
HCMFamMbrSubtype5IsHidden hcmfammbrsubtype5ishidden Truth Value
HCMFamMbrSubtype6IsHidden hcmfammbrsubtype6ishidden Truth Value
HCMFamMbrSubtype7IsHidden hcmfammbrsubtype7ishidden Truth Value
HCMFamMbrSubtype8IsHidden hcmfammbrsubtype8ishidden Truth Value
HCMFamMbrSubtypeQA01IsHidden hcmfammbrsubtypeqa01ishidden Truth Value
HCMFamMbrSubtypeQA02IsHidden hcmfammbrsubtypeqa02ishidden 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_QA_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_QA_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,
  HCMFamilyMemberBirthDate,
  HCMFamilyMemberCntryOfBrthCode,
  HCMFamilyMemberNationalityCode,
  HCMFamilyMemberGenderCode,
  HCMFamilyMemberFirstName,
  HCMFamilyMemberLastName,
  HCMFamilyMemberPlaceOfBrthName,
  HCMFamilyMemberStateOfBrthCode,
  HCMFamMbrRefPersnWorkAgreement,
  HCMFamilyMemberBirthName,
  HCMFamilyMember2ndName,
  HCMFamilyMemberCompleteName,
  HCMInfoType,
  HCMNameEditingFormatCode,
  HCMFamilyMemberNameFormatCode,
  HCMFamilyMemberInitials,
  HCMFamilyMemberNamePrefixCode,
  HCMFamMember2ndNamePrefixCode,
  HCMFamilyMemberOtherTitleCode,
  HCMFamMbrRelshpToChildCode,
  HCMFamMbrAllwncAuthznCode,
  HCMFamMbrAddressOfChildCode,
  HCMFamMbrChildAllwncEntlmnt,
  HCMFamilyMemberChildTypeCode,
  HCMFamilyMemberChildBonusCode,
  HCMFamMbrChildAllowanceCode,
  HCMFamMbrSicknessCertAuthzn,
  HCMFamilyMemberAuthznNmbrCode,
  HCMFamMbrSoclInsurNmbr1stPrt,
  HCMFamMbrSoclInsurNmbr2ndPrt,
  HCMFamMemberEducationEndDate,
  HCMFamilyMemberSchoolTypeCode,
  HCMFamMbrEducInstituteName,
  HCMFamilyMemberEmployerCode,
  HCMFamilyMember2ndNatltyCode,
  HCMFamilyMember3rdNatltyCode,
  HCMFamilyMemberTitleCode,
  HCMFamMbrIsEmergencyContact,
  HCMFamMbrPassportNumber,
  HCMFamMbrPassportIssueDate,
  HCMFamMbrPassportExpiryDate,
  HCMFamMbrQAVisaNumber,
  HCMFamMbrVisaIssueDate,
  HCMFamMbrVisaExpiryDate,
  HCMFamMbrQAIdNumber,
  HCMFamMbrIdIssueDate,
  HCMFamMbrIdExpiryDate,
  HCMFamMbrDocumentTypeCode1,
  HCMFamMbrDocumentNumber1,
  HCMFamMbrDocNmbr1IssueDate,
  HCMFamMbrDocNmbr1ExpiryDate,
  HCMFamMbrDocumentTypeCode2,
  HCMFamMbrDocumentNumber2,
  HCMFamMbrDocNmbr2IssueDate,
  HCMFamMbrDocNmbr2ExpiryDate,
  HCMFamMbrDocumentTypeCode3,
  HCMFamMbrDocumentNumber3,
  HCMFamMbrDocNmbr3IssueDate,
  HCMFamMbrDocNmbr3ExpiryDate,
  HCMFamMbrDocumentTypeCode4,
  HCMFamMbrDocumentNumber4,
  HCMFamMbrDocNmbr4IssueDate,
  HCMFamMbrDocNmbr4ExpiryDate,
  HCMFamMbrDocumentTypeCode5,
  HCMFamMbrDocumentNumber5,
  HCMFamMbrDocNmbr5IssueDate,
  HCMFamMbrDocNmbr5ExpiryDate,
  HCMFamMbrDocumentTypeCode6,
  HCMFamMbrDocumentNumber6,
  HCMFamMbrDocNmbr6IssueDate,
  HCMFamMbrDocNmbr6ExpiryDate,
  HCMFamMbrDocumentTypeCode7,
  HCMFamMbrDocumentNumber7,
  HCMFamMbrDocNmbr7IssueDate,
  HCMFamMbrDocNmbr7ExpiryDate,
  HCMFamMbrDocumentTypeCode8,
  HCMFamMbrDocumentNumber8,
  HCMFamMbrDocNmbr8IssueDate,
  HCMFamMbrDocNmbr8ExpiryDate,
  HCMFamMbrCountryEntranceDate,
  HCMFamMbrIsEmployed,
  HCMFamMbrEmployerName,
  HCMFamMbrEmploymentDate,
  HCMFamMbrHasAcmdtnEntlmnt,
  HCMFamMbrLegalNomineeCode,
  HCMFamMbrArabicFirstName,
  HCMFamMbrArabicSecondName,
  HCMFamMbrArabicThirdName,
  HCMFamMbrArabicLastName,
  HCMFamMbrAcademicDegreeCode,
  HCMFamMbrSpecialization,
  HCMFamMbrJobName,
  HCMFamMbrQAEmployerTypeCode,
  HCMFamMbrSpousePersNumber,
  HCMFamMbrHasUnderDependents,
  HCMFamMbrDependentsCountryCode,
  HCMFamMbrCurrentSchoolGrade,
  HCMFamMbrSchoolIdNumber,
  HCMFamMbrHasCompanyTransport,
  HCMFamMbrTypeOfChallengeCode,
  HCMFamMbrSubtype10IsHidden,
  HCMFamMbrSubtype11IsHidden,
  HCMFamMbrSubtype12IsHidden,
  HCMFamMbrSubtype13IsHidden,
  HCMFamMbrSubtype14IsHidden,
  HCMFamMbrSubtype15IsHidden,
  HCMFamMbrSubtype2IsHidden,
  HCMFamMbrSubtype3IsHidden,
  HCMFamMbrSubtype4IsHidden,
  HCMFamMbrSubtype5IsHidden,
  HCMFamMbrSubtype6IsHidden,
  HCMFamMbrSubtype7IsHidden,
  HCMFamMbrSubtype8IsHidden,
  HCMFamMbrSubtypeQA01IsHidden,
  HCMFamMbrSubtypeQA02IsHidden,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM hrfio_d_fmqa_d AS FamilyMemberDraft
;

Learn More