What is I_QA_HCMFamilyMemberSupplement in SAP S/4HANA?

I_QA_HCMFamilyMemberSupplement is a basic CDS view in SAP S/4HANA. HCM Family Member Supplement QA It contains 84 fields.

Which tables does I_QA_HCMFamilyMemberSupplement read from?

I_QA_HCMFamilyMemberSupplement reads data from: pa3304.

What VDM layer is I_QA_HCMFamilyMemberSupplement?

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

I_QA_HCMFamilyMemberSupplement

DDL: I_QA_HCMFAMILYMEMBERSUPPLEMENT Type: view_entity BASIC

84 Fields 1 Data Sources

HCM Family Member Supplement QA

I_QA_HCMFamilyMemberSupplement is a Basic CDS View that provides data about "HCM Family Member Supplement QA" in SAP S/4HANA. It reads from 1 data source (pa3304) and exposes 84 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

Source	Alias	Join Type
pa3304	pa3304	from

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	HCM Family Member Supplement QA	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (84)

Key	Field	Source Field	Description
KEY	HCMPersonnelNumber	pernr	Personnel no.
KEY	HCMSubtype	subty	Subtype
KEY	HCMObjectIdentification	objps	Object ID
KEY	HCMRecordIsLocked	sprps	Single-Character Flag
KEY	EndDate	endda	Valid To
KEY	StartDate	begda	Valid From
KEY	HCMSequentialNumber	seqnr	Tank ID
	LastChangedDate	aedtm	Changed On
	LastChangedByUser	uname	User Name
	HCMInfoTypeRecordIsHistorical	histo	Historical rec.
	HCMInfoTypeRecordHasText	itxex	Text exists
	HCMInfoTypeRecordHasRefField	refex	Single-Character Flag
	HCMInfoTypeRecordHasConfField	ordex	Single-Character Flag
	HCMInfoTypeRecordScreenCtrl	itbld	Screen control
	HCMMasterDataChangeReason	preas	Change Reason
	HCMInfoTypeRecordRsrvdFld1	flag1	Text field length 1
	HCMInfoTypeRecordRsrvdFld2	flag2	Tr. Evaluation
	HCMInfoTypeRecordRsrvdFld3	flag3	Text field length 1
	HCMInfoTypeRecordRsrvdFld4	flag4	Usage in the OWN Authorization Context
	HCMInfoTypeRecordRsrvdFld1Len2	rese1	Reserved Field/Unused Field of Length 2
	HCMInfoTypeRecordRsrvdFld2Len2	rese2	Reserved Field/Unused Field of Length 2
	HCMGrpgValForPersAssignments	grpvl	Grouping Value
	HCMFamMbrPassportNumber	psprt	Passport Number
	HCMFamMbrPassportIssueDate	psiss	Issue Date
	HCMFamMbrPassportExpiryDate	psexp	Passport Exp.
	HCMFamMbrQAVisaNumber	visan	Visa Number
	HCMFamMbrVisaIssueDate	vsiss	Issue Date
	HCMFamMbrVisaExpiryDate	viexp	Expiry Date
	HCMFamMbrQAIdNumber	idnum	ID Number
	HCMFamMbrIdIssueDate	idiss	ID Issue Date
	HCMFamMbrIdExpiryDate	idexp	ID Expiry Date
	HCMFamMbrDocumentTypeCode1	doct1	Document Type
	HCMFamMbrDocumentNumber1	donr1	Number
	HCMFamMbrDocNmbr1IssueDate	dois1	Document Issue Date
	HCMFamMbrDocNmbr1ExpiryDate	doex1	Document Expiry Date
	HCMFamMbrDocumentTypeCode2	doct2	Document Type
	HCMFamMbrDocumentNumber2	donr2	Number
	HCMFamMbrDocNmbr2IssueDate	dois2	Document Issue Date
	HCMFamMbrDocNmbr2ExpiryDate	doex2	Document Expiry Date
	HCMFamMbrDocumentTypeCode3	doct3	Document Type
	HCMFamMbrDocumentNumber3	donr3	Number
	HCMFamMbrDocNmbr3IssueDate	dois3	Document Issue Date
	HCMFamMbrDocNmbr3ExpiryDate	doex3	Document Expiry Date
	HCMFamMbrDocumentTypeCode4	doct4	Document Type
	HCMFamMbrDocumentNumber4	donr4	Number
	HCMFamMbrDocNmbr4IssueDate	dois4	Document Issue Date
	HCMFamMbrDocNmbr4ExpiryDate	doex4	Document Expiry Date
	HCMFamMbrDocumentTypeCode5	doct5	Document Type
	HCMFamMbrDocumentNumber5	donr5	Number
	HCMFamMbrDocNmbr5IssueDate	dois5	Document Issue Date
	HCMFamMbrDocNmbr5ExpiryDate	doex5	Document Expiry Date
	HCMFamMbrDocumentTypeCode6	doct6	Document Type
	HCMFamMbrDocumentNumber6	donr6	Number
	HCMFamMbrDocNmbr6IssueDate	dois6	Document Issue Date
	HCMFamMbrDocNmbr6ExpiryDate	doex6	Document Expiry Date
	HCMFamMbrDocumentTypeCode7	doct7	Document Type
	HCMFamMbrDocumentNumber7	donr7	Number
	HCMFamMbrDocNmbr7IssueDate	dois7	Document Issue Date
	HCMFamMbrDocNmbr7ExpiryDate	doex7	Document Expiry Date
	HCMFamMbrDocumentTypeCode8	doct8	Document Type
	HCMFamMbrDocumentNumber8	donr8	Number
	HCMFamMbrDocNmbr8IssueDate	dois8	Document Issue Date
	HCMFamMbrDocNmbr8ExpiryDate	doex8	Document Expiry Date
	HCMFamMbrCountryEntranceDate	cyetd	Ctry/Reg. Entrance
	HCMFamMbrIsEmployed	emplm	Employed
	HCMFamMbrEmployerName	emplr	Employer Name
	HCMFamMbrEmploymentDate	empdt	Employment Date
	HCMFamMbrHasAcmdtnEntlmnt	accen	Accom. Entitlement
	HCMFamMbrLegalNomineeCode	legno	Legal Nominee
	HCMFamMbrArabicFirstName	arfnm	First Name
	HCMFamMbrArabicSecondName	arsnm	Second Name
	HCMFamMbrArabicThirdName	artnm	Third Name
	HCMFamMbrArabicLastName	arlnm	Last Name
	HCMFamMbrAcademicDegreeCode	acddg	Academic Degree
	HCMFamMbrSpecialization	specl	Specialization
	HCMFamMbrJobName	jobnm	Job
	HCMFamMbrQAEmployerTypeCode	comty	Employer Type
	HCMFamMbrSpousePersNumber	spoid	Spouse ID
	HCMFamMbrHasUnderDependents	undep	Under Dependents
	HCMFamMbrDependentsCountryCode	dplnd	C/R of Dependent
	HCMFamMbrCurrentSchoolGrade	cgrad	Current School Grade
	HCMFamMbrSchoolIdNumber	schuid	School ID
	HCMFamMbrHasCompanyTransport	cotra	Company Transport
	HCMFamMbrTypeOfChallengeCode	sbart	Challenge type

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_QA_HCMFamilyMemberSupplement.
-- 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_QA_HCMFamilyMemberSupplement AS
SELECT
  pernr AS HCMPersonnelNumber,
  subty AS HCMSubtype,
  objps AS HCMObjectIdentification,
  sprps AS HCMRecordIsLocked,
  endda AS EndDate,
  begda AS StartDate,
  seqnr AS HCMSequentialNumber,
  aedtm AS LastChangedDate,
  uname AS LastChangedByUser,
  histo AS HCMInfoTypeRecordIsHistorical,
  itxex AS HCMInfoTypeRecordHasText,
  refex AS HCMInfoTypeRecordHasRefField,
  ordex AS HCMInfoTypeRecordHasConfField,
  itbld AS HCMInfoTypeRecordScreenCtrl,
  preas AS HCMMasterDataChangeReason,
  flag1 AS HCMInfoTypeRecordRsrvdFld1,
  flag2 AS HCMInfoTypeRecordRsrvdFld2,
  flag3 AS HCMInfoTypeRecordRsrvdFld3,
  flag4 AS HCMInfoTypeRecordRsrvdFld4,
  rese1 AS HCMInfoTypeRecordRsrvdFld1Len2,
  rese2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  grpvl AS HCMGrpgValForPersAssignments,
  psprt AS HCMFamMbrPassportNumber,
  psiss AS HCMFamMbrPassportIssueDate,
  psexp AS HCMFamMbrPassportExpiryDate,
  visan AS HCMFamMbrQAVisaNumber,
  vsiss AS HCMFamMbrVisaIssueDate,
  viexp AS HCMFamMbrVisaExpiryDate,
  idnum AS HCMFamMbrQAIdNumber,
  idiss AS HCMFamMbrIdIssueDate,
  idexp AS HCMFamMbrIdExpiryDate,
  doct1 AS HCMFamMbrDocumentTypeCode1,
  donr1 AS HCMFamMbrDocumentNumber1,
  dois1 AS HCMFamMbrDocNmbr1IssueDate,
  doex1 AS HCMFamMbrDocNmbr1ExpiryDate,
  doct2 AS HCMFamMbrDocumentTypeCode2,
  donr2 AS HCMFamMbrDocumentNumber2,
  dois2 AS HCMFamMbrDocNmbr2IssueDate,
  doex2 AS HCMFamMbrDocNmbr2ExpiryDate,
  doct3 AS HCMFamMbrDocumentTypeCode3,
  donr3 AS HCMFamMbrDocumentNumber3,
  dois3 AS HCMFamMbrDocNmbr3IssueDate,
  doex3 AS HCMFamMbrDocNmbr3ExpiryDate,
  doct4 AS HCMFamMbrDocumentTypeCode4,
  donr4 AS HCMFamMbrDocumentNumber4,
  dois4 AS HCMFamMbrDocNmbr4IssueDate,
  doex4 AS HCMFamMbrDocNmbr4ExpiryDate,
  doct5 AS HCMFamMbrDocumentTypeCode5,
  donr5 AS HCMFamMbrDocumentNumber5,
  dois5 AS HCMFamMbrDocNmbr5IssueDate,
  doex5 AS HCMFamMbrDocNmbr5ExpiryDate,
  doct6 AS HCMFamMbrDocumentTypeCode6,
  donr6 AS HCMFamMbrDocumentNumber6,
  dois6 AS HCMFamMbrDocNmbr6IssueDate,
  doex6 AS HCMFamMbrDocNmbr6ExpiryDate,
  doct7 AS HCMFamMbrDocumentTypeCode7,
  donr7 AS HCMFamMbrDocumentNumber7,
  dois7 AS HCMFamMbrDocNmbr7IssueDate,
  doex7 AS HCMFamMbrDocNmbr7ExpiryDate,
  doct8 AS HCMFamMbrDocumentTypeCode8,
  donr8 AS HCMFamMbrDocumentNumber8,
  dois8 AS HCMFamMbrDocNmbr8IssueDate,
  doex8 AS HCMFamMbrDocNmbr8ExpiryDate,
  cyetd AS HCMFamMbrCountryEntranceDate,
  emplm AS HCMFamMbrIsEmployed,
  emplr AS HCMFamMbrEmployerName,
  empdt AS HCMFamMbrEmploymentDate,
  accen AS HCMFamMbrHasAcmdtnEntlmnt,
  legno AS HCMFamMbrLegalNomineeCode,
  arfnm AS HCMFamMbrArabicFirstName,
  arsnm AS HCMFamMbrArabicSecondName,
  artnm AS HCMFamMbrArabicThirdName,
  arlnm AS HCMFamMbrArabicLastName,
  acddg AS HCMFamMbrAcademicDegreeCode,
  specl AS HCMFamMbrSpecialization,
  jobnm AS HCMFamMbrJobName,
  comty AS HCMFamMbrQAEmployerTypeCode,
  spoid AS HCMFamMbrSpousePersNumber,
  undep AS HCMFamMbrHasUnderDependents,
  dplnd AS HCMFamMbrDependentsCountryCode,
  cgrad AS HCMFamMbrCurrentSchoolGrade,
  schuid AS HCMFamMbrSchoolIdNumber,
  cotra AS HCMFamMbrHasCompanyTransport,
  sbart AS HCMFamMbrTypeOfChallengeCode
FROM pa3304
;

Depth:

I_QA_HCMFamilyMemberSupplement view_entity

pa3304

I_QA_HCM_ESSFamMbrSupplement view_entity