I_PT_HCMFamilyMemberSupplement

DDL: I_PT_HCMFAMILYMEMBERSUPPLEMENT Type: view_entity BASIC
45 Fields 1 Data Sources

HCM Family Member Supplement PT

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

Data Sources (1)

SourceAliasJoin Type
pa0335 pa0335 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label HCM Family Member Supplement PT 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 (45)

KeyFieldSource TableSource FieldDescription
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
HCMFamilyMemberFullName fulna Full name
HCMFamMbrTaxId finum Tax no.
PT_HCMFamMbrSSNumber ssnum SS no.
PT_HCMFamMbrSSInstitutionCode ssins SS institution
HCMFamMbrCoRelationshipText relco Rel.with company
HCMFamMbrDeathDate dadea Date of death
HCMFamMbrHasFamilyAllowance famal Family allow.
HCMFamMbrHasChallengeBonus disbo Challenge bonus
HCMFamMbrHasRegnSubmission spcer Registr.subm.
HCMFamMbrHasLivingAllowance llmbn Month.living all.
HCMFamMbrHasNursingAllowance ssa3p Entitl.nurs.all.
PT_HCMFamMbrADSEBnfcyNumber benef ADSE beneficiary
HCMFamMbrRegnValidityYearDate certa Registr.valid to
HCMFamMbrHasScholarshipBenefit spben Scholarship
PT_HCMFamMbrADSECardValdtyDate vadse ADSE card validity
HCMFamMbrSocialServicesNumber nsers Social services no.
HCMFamMbrDsbltyPctgRate pcdef Disability %
HCMFamMbrRegnSubmissionDate cerdt Reg.subm.date
HCMFamMbrAllowanceTypeCode bfa_alwtp Allowance type
HCMFamMbrEducationLevelCode bfa_grade Education level
HCMFamMbrSchoolCertValdtyDate bfa_valdt Valid.school certif.
HCMFamMbrHasParentalRespy bfa_pares Parental resp.
HCMFamMbrHasForcePayment bfa_fpaym Force payment

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_PT_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_PT_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,
  fulna AS HCMFamilyMemberFullName,
  finum AS HCMFamMbrTaxId,
  ssnum AS PT_HCMFamMbrSSNumber,
  ssins AS PT_HCMFamMbrSSInstitutionCode,
  relco AS HCMFamMbrCoRelationshipText,
  dadea AS HCMFamMbrDeathDate,
  famal AS HCMFamMbrHasFamilyAllowance,
  disbo AS HCMFamMbrHasChallengeBonus,
  spcer AS HCMFamMbrHasRegnSubmission,
  llmbn AS HCMFamMbrHasLivingAllowance,
  ssa3p AS HCMFamMbrHasNursingAllowance,
  benef AS PT_HCMFamMbrADSEBnfcyNumber,
  certa AS HCMFamMbrRegnValidityYearDate,
  spben AS HCMFamMbrHasScholarshipBenefit,
  vadse AS PT_HCMFamMbrADSECardValdtyDate,
  nsers AS HCMFamMbrSocialServicesNumber,
  pcdef AS HCMFamMbrDsbltyPctgRate,
  cerdt AS HCMFamMbrRegnSubmissionDate,
  bfa_alwtp AS HCMFamMbrAllowanceTypeCode,
  bfa_grade AS HCMFamMbrEducationLevelCode,
  bfa_valdt AS HCMFamMbrSchoolCertValdtyDate,
  bfa_pares AS HCMFamMbrHasParentalRespy,
  bfa_fpaym AS HCMFamMbrHasForcePayment
FROM pa0335
;

Learn More