I_HCMCurrentPersonalData

DDL: I_HCMCURRENTPERSONALDATA Type: view_entity COMPOSITE
49 Fields 1 Data Sources

HCM Current Personnel Data

I_HCMCurrentPersonalData is a Composite CDS View that provides data about "HCM Current Personnel Data" in SAP S/4HANA. It reads from 1 data source (I_HCMPersonalData) and exposes 49 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

SourceAliasJoin Type
I_HCMPersonalData I_HCMPersonalData from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label HCM Current Personnel Data view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #COMPOSITE view

Fields (49)

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.
LastChangedDate LastChangedDate Created On
LastChangedByUser LastChangedByUser User Name
HCMInfoTypeRecordIsHistorical HCMInfoTypeRecordIsHistorical Historical rec.
HCMInfoTypeRecordHasText HCMInfoTypeRecordHasText Text exists
HCMInfoTypeRecordHasRefField HCMInfoTypeRecordHasRefField Ref. exists
HCMInfoTypeRecordHasConfField HCMInfoTypeRecordHasConfField Conf.fields ex.
HCMInfoTypeRecordScreenCtrl HCMInfoTypeRecordScreenCtrl Screen control
HCMMasterDataChangeReason HCMMasterDataChangeReason Change Reason
HCMInfoTypeRecordRsrvdFld1 HCMInfoTypeRecordRsrvdFld1 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld2 HCMInfoTypeRecordRsrvdFld2 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld3 HCMInfoTypeRecordRsrvdFld3 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld4 HCMInfoTypeRecordRsrvdFld4 Reserved Field/Unused Field
HCMInfoTypeRecordRsrvdFld1Len2 HCMInfoTypeRecordRsrvdFld1Len2 Reserved Field/Unused Field of Length 2
HCMInfoTypeRecordRsrvdFld2Len2 HCMInfoTypeRecordRsrvdFld2Len2 Reserved Field/Unused Field of Length 2
HCMGrpgValForPersAssignments HCMGrpgValForPersAssignments Grouping Value
HCMEmployeeInitials HCMEmployeeInitials Initials
HCMEmployeeLastName HCMEmployeeLastName Last Name
HCMEmployeeBirthName HCMEmployeeBirthName Name at Birth
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
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

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_HCMCurrentPersonalData.
-- 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_HCMCurrentPersonalData AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordIsHistorical,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordHasRefField,
  HCMInfoTypeRecordHasConfField,
  HCMInfoTypeRecordScreenCtrl,
  HCMMasterDataChangeReason,
  HCMInfoTypeRecordRsrvdFld1,
  HCMInfoTypeRecordRsrvdFld2,
  HCMInfoTypeRecordRsrvdFld3,
  HCMInfoTypeRecordRsrvdFld4,
  HCMInfoTypeRecordRsrvdFld1Len2,
  HCMInfoTypeRecordRsrvdFld2Len2,
  HCMGrpgValForPersAssignments,
  HCMEmployeeInitials,
  HCMEmployeeLastName,
  HCMEmployeeBirthName,
  HCMEmployeeSecondName,
  HCMEmployeeFirstName,
  HCMEmployeeCompleteName,
  HCMEmployeeTitleCode,
  HCMEmployeeSecondTitleCode,
  HCMEmployeeOtherTitleCode,
  HCMEmployeeNamePrefix,
  HCMEmployeeSecondNamePrefix,
  HCMEmployeeNickName,
  HCMEmployeeMiddleName,
  HCMEmployeeNameFormat,
  HCMEmployeeFormOfAddressKey,
  HCMEmployeeGender,
  HCMEmployeeBirthDate,
  HCMEmployeeCountryOfBirth,
  HCMEmployeeStateOfBirth,
  HCMEmployeePlaceOfBirth,
  HCMEmployeeNationality,
  HCMEmployeeSecondNationality,
  HCMEmployeeThirdNationality,
  HCMEmployeeCommLanguage,
  HCMEmplReligiousDenomination,
  HCMEmployeeMaritalStatus,
  HCMEmplCurMaritalStsValdFrmDte
FROM I_HCMPersonalData
;

Learn More