What is R_QA_HCM_ESSPerDataDraft in SAP S/4HANA?

R_QA_HCM_ESSPerDataDraft is a basic CDS view in SAP S/4HANA. My Personal Data QA - Draft It contains 106 fields.

Which tables does R_QA_HCM_ESSPerDataDraft read from?

R_QA_HCM_ESSPerDataDraft reads data from: hrfio_d_pdqa_d.

What VDM layer is R_QA_HCM_ESSPerDataDraft?

R_QA_HCM_ESSPerDataDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_QA_HCM_ESSPerDataDraft

DDL: R_QA_HCM_ESSPERDATADRAFT Type: view_entity BASIC

106 Fields 1 Data Sources

My Personal Data QA - Draft

R_QA_HCM_ESSPerDataDraft is a Basic CDS View that provides data about "My Personal Data QA - Draft" in SAP S/4HANA. It reads from 1 data source (hrfio_d_pdqa_d) and exposes 106 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

Source	Alias	Join Type
hrfio_d_pdqa_d	PersonalDataDraft	from

Annotations (14)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	My Personal Data 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	2876	view
Feature	SW:H4S4_SFWS_SC_01	view

Fields (106)

Key	Field	Source Field	Description
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
	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.
	HCMEmployeeInitials	hcmemployeeinitials	Initials
	HCMEmployeeLastName	hcmemployeelastname	Last Name
	HCMEmployeeSecondName	hcmemployeesecondname	Second name
	HCMEmployeeFirstName	hcmemployeefirstname	First Name
	HCMEmployeeCompleteName	hcmemployeecompletename	Full Name
	HCMEmployeeTitleCode	hcmemployeetitlecode	Title
	HCMEmployeeSecondTitleCode	hcmemployeesecondtitlecode	Second title
	HCMEmployeeOtherTitleCode	hcmemployeeothertitlecode	Other title
	HCMEmployeeNamePrefix	hcmemployeenameprefix	Name prefix
	HCMEmployeeSecondNamePrefix	hcmemployeesecondnameprefix	N.prefix 2
	HCMEmployeeNickName	hcmemployeenickname	Nickname
	HCMEmployeeMiddleName	hcmemployeemiddlename	Middle name
	HCMInfoType	hcminfotype	Prefix
	HCMNameEditingFormatCode	hcmnameeditingformatcode	Format
	HCMEmployeeNameFormat	hcmemployeenameformat	Name Format
	HCMEmployeeFormOfAddressKey	hcmemployeeformofaddresskey	Form of Address
	HCMEmployeeGender	hcmemployeegender	Gender
	HCMEmployeeBirthDate	hcmemployeebirthdate	Date of birth
	HCMEmployeeCountryOfBirth	hcmemployeecountryofbirth	C/R Birth
	HCMEmployeeStateOfBirth	hcmemployeestateofbirth	State
	HCMEmployeePlaceOfBirth	hcmemployeeplaceofbirth	Birthplace
	HCMEmployeeNationality	hcmemployeenationality	Nationality
	HCMEmployeeSecondNationality	hcmemployeesecondnationality	Other nat.
	HCMEmployeeThirdNationality	hcmemployeethirdnationality	2nd/3rd nat.
	HCMEmployeeCommLanguage	hcmemployeecommlanguage	Communication L
	HCMEmplReligiousDenomination	hcmemplreligiousdenomination	Religion
	HCMEmployeeMaritalStatus	hcmemployeemaritalstatus	Marital stat.
	HCMEmplCurMaritalStsValdFrmDte	hcmemplcurmaritalstsvaldfrmdte	Since
	HCMEmployeeNumberOfChildren	hcmemployeenumberofchildren	No.of children
	HCMEmployeeHasNameConnection	hcmemployeehasnameconnection	Name connection
	HCMEmplPersIdentifierModifier	hcmemplpersidentifiermodifier	Pers.ID mod.
	HCMEmployeePersonnelIDNumber	hcmemployeepersonnelidnumber	ID number
	HCMEmployeePassportBirthDate	hcmemployeepassportbirthdate	Birth date
	HCMEmployeeKatakanaFirstName	hcmemployeekatakanafirstname	1st name Katakana
	HCMEmployeeKatakanaLastName	hcmemployeekatakanalastname	Last name (Katakana)
	HCMEmployeeRomajiFirstName	hcmemployeeromajifirstname	1st Name Romaji
	HCMEmployeeRomajiLastName	hcmemployeeromajilastname	Last Name Romaji
	HCMEmployeeKatakanaBirthName	hcmemployeekatakanabirthname	Name of Birth (Katk)
	HCMEmployeeRomajiBirthName	hcmemployeeromajibirthname	Name of Birth (Rom.)
	HCMEmployeeKatakanaNickName	hcmemployeekatakananickname	Koseki Katakana
	HCMEmployeeRomajiNickName	hcmemployeeromajinickname	Koseki Romaji
	HCMEmployeeYearOfBirth	hcmemployeeyearofbirth	Year of birth
	HCMEmployeeMonthOfBirth	hcmemployeemonthofbirth	Month of Birth
	HCMEmployeeDayOfBirth	hcmemployeedayofbirth	Date of birth
	HCMEmployeeSearchLastName	hcmemployeesearchlastname	Last Name
	HCMEmployeeSearchFirstName	hcmemployeesearchfirstname	First Name
	HCMEmployeeBirthNameAffixCode	hcmemployeebirthnameaffixcode	Title 2
	HCMPersDataArabicFirstName	hcmpersdataarabicfirstname	First Name
	HCMPersDataArabicSecondName	hcmpersdataarabicsecondname	Second Name
	HCMPersDataArabicThirdName	hcmpersdataarabicthirdname	Third Name
	HCMPersDataArabicLastName	hcmpersdataarabiclastname	Last Name
	HCMPersDataKnownAsTxt	hcmpersdataknownastxt	Known As
	HCMPersDataEnglishFirstName	hcmpersdataenglishfirstname	First Name
	HCMPersDataSecondEnglishName	hcmpersdatasecondenglishname	Second Name
	HCMPersDataThirdEnglishName	hcmpersdatathirdenglishname	Third Name
	HCMPersDataLastEnglishName	hcmpersdatalastenglishname	Last name (Katakana)
	HCMPersDataGenderCode	hcmpersdatagendercode	Gender
	HCMPersDataBloodGroup	hcmpersdatabloodgroup	Blood Group
	HCMPersDataSponsorId	hcmpersdatasponsorid	Sponsor ID
	HCMPersDataSponsorshipNumber	hcmpersdatasponsorshipnumber	Sponsorship Number
	HCMPersDataProfessionCode	hcmpersdataprofessioncode	Profession LR
	HCMPersDataPassportProfession	hcmpersdatapassportprofession	Passport Profession
	HCMPersDataJobOnResidentPermit	hcmpersdatajobonresidentpermit	Job Resident Permit
	HCMPersDataActualJobTxt	hcmpersdataactualjobtxt	Actual Job
	HCMPersDataLegalReportingProf	hcmpersdatalegalreportingprof	Profession LR
	HCMPersDataPassportProfCode	hcmpersdatapassportprofcode	Passport Profession
	HCMPersDataQAHomeAirportCode	hcmpersdataqahomeairportcode	Home Airport
	HCMPersDataCountryEntranceDate	hcmpersdatacountryentrancedate	Ctry/Reg. Entrance
	HCMPersDataPortOfEntryText	hcmpersdataportofentrytext	Port of Entry
	HCMPersDataIsFamilyResidesInQA	hcmpersdataisfamilyresidesinqa	Family in QA
	HCMPersDataIsExcludeLegalRpt	hcmpersdataisexcludelegalrpt	Exclude from Rep.
	HCMPersDataEntryDate	hcmpersdataentrydate	Date of Entry
	HCMPersDataHasNoCompanyHousing	hcmpersdatahasnocompanyhousing	No Com. Housing
	HCMPersDataBirthCertNumber	hcmpersdatabirthcertnumber	Birth Certificate
	HCMPersDataAcademicDegreeCode	hcmpersdataacademicdegreecode	Academic Degree
	HCMPersDataProfileClassCode	hcmpersdataprofileclasscode	Profile Cl.
	HCMPersDataSpecializationText	hcmpersdataspecializationtext	Specialization
	HCMPersDataEduLevelLegalRptTxt	hcmpersdataedulevellegalrpttxt	Education Level
	HCMPersDataHiringTestScoreVal	hcmpersdatahiringtestscoreval	Hiring Test Score
	HCMPersDataCoAccommodation	hcmpersdatacoaccommodation	Company Accomm
	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_ESSPerDataDraft.
-- 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_ESSPerDataDraft AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  HCMDraftSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordScreenCtrl,
  HCMETag,
  HCMValidityStartDate,
  HCMValidityEndDate,
  HCMDefaultDate,
  HCMRecordIsStoredInDataBase,
  HCMValidityStartDateFieldCtrl,
  HCMInfoTypeVersion,
  HCMCountryRegionGrouping,
  HCMEmployeeInitials,
  HCMEmployeeLastName,
  HCMEmployeeSecondName,
  HCMEmployeeFirstName,
  HCMEmployeeCompleteName,
  HCMEmployeeTitleCode,
  HCMEmployeeSecondTitleCode,
  HCMEmployeeOtherTitleCode,
  HCMEmployeeNamePrefix,
  HCMEmployeeSecondNamePrefix,
  HCMEmployeeNickName,
  HCMEmployeeMiddleName,
  HCMInfoType,
  HCMNameEditingFormatCode,
  HCMEmployeeNameFormat,
  HCMEmployeeFormOfAddressKey,
  HCMEmployeeGender,
  HCMEmployeeBirthDate,
  HCMEmployeeCountryOfBirth,
  HCMEmployeeStateOfBirth,
  HCMEmployeePlaceOfBirth,
  HCMEmployeeNationality,
  HCMEmployeeSecondNationality,
  HCMEmployeeThirdNationality,
  HCMEmployeeCommLanguage,
  HCMEmplReligiousDenomination,
  HCMEmployeeMaritalStatus,
  HCMEmplCurMaritalStsValdFrmDte,
  HCMEmployeeNumberOfChildren,
  HCMEmployeeHasNameConnection,
  HCMEmplPersIdentifierModifier,
  HCMEmployeePersonnelIDNumber,
  HCMEmployeePassportBirthDate,
  HCMEmployeeKatakanaFirstName,
  HCMEmployeeKatakanaLastName,
  HCMEmployeeRomajiFirstName,
  HCMEmployeeRomajiLastName,
  HCMEmployeeKatakanaBirthName,
  HCMEmployeeRomajiBirthName,
  HCMEmployeeKatakanaNickName,
  HCMEmployeeRomajiNickName,
  HCMEmployeeYearOfBirth,
  HCMEmployeeMonthOfBirth,
  HCMEmployeeDayOfBirth,
  HCMEmployeeSearchLastName,
  HCMEmployeeSearchFirstName,
  HCMEmployeeBirthNameAffixCode,
  HCMPersDataArabicFirstName,
  HCMPersDataArabicSecondName,
  HCMPersDataArabicThirdName,
  HCMPersDataArabicLastName,
  HCMPersDataKnownAsTxt,
  HCMPersDataEnglishFirstName,
  HCMPersDataSecondEnglishName,
  HCMPersDataThirdEnglishName,
  HCMPersDataLastEnglishName,
  HCMPersDataGenderCode,
  HCMPersDataBloodGroup,
  HCMPersDataSponsorId,
  HCMPersDataSponsorshipNumber,
  HCMPersDataProfessionCode,
  HCMPersDataPassportProfession,
  HCMPersDataJobOnResidentPermit,
  HCMPersDataActualJobTxt,
  HCMPersDataLegalReportingProf,
  HCMPersDataPassportProfCode,
  HCMPersDataQAHomeAirportCode,
  HCMPersDataCountryEntranceDate,
  HCMPersDataPortOfEntryText,
  HCMPersDataIsFamilyResidesInQA,
  HCMPersDataIsExcludeLegalRpt,
  HCMPersDataEntryDate,
  HCMPersDataHasNoCompanyHousing,
  HCMPersDataBirthCertNumber,
  HCMPersDataAcademicDegreeCode,
  HCMPersDataProfileClassCode,
  HCMPersDataSpecializationText,
  HCMPersDataEduLevelLegalRptTxt,
  HCMPersDataHiringTestScoreVal,
  HCMPersDataCoAccommodation,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM hrfio_d_pdqa_d AS PersonalDataDraft
;

Depth:

R_QA_HCM_ESSPerDataDraft view_entity

hrfio_d_pdqa_d