I_HCMContractElement

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

HCM Contract Element

I_HCMContractElement is a Basic CDS View that provides data about "HCM Contract Element" in SAP S/4HANA. It reads from 1 data source (pa0016) and exposes 45 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

SourceAliasJoin Type
pa0016 pa0016 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label HCM Contract Element view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #BASIC 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
HCMEmplHasSidelineJobAllowance nbtgk Sideline Job
HCMEmplHasCompetitionClause wttkl Competition Clause
HCMContinuedPayDuration lfzfr Continued Pay
HCMContinuedPayDurationUnit lfzzh Continued Pay
HCMContinuedPaySpecialRuleCode lfzso Special Rule
HCMSickPaySupplementDuration kgzfr Sick Pay
HCMSickPaySuplmntDurationUnit kgzzh Sick Pay Supplement Period (Unit)
HCMProbationPeriodDuration prbzt Prob.Period
HCMProbationPeriodDurationUnit prbeh Probationary Period (Unit)
HCMNoticePeriodForEmployerCode kdgfr ER Notice Period
HCMNoticePeriodForEmployeeCode kdgf2 EE Notice Period
HCMWorkPermitExpirationDate arber Work Permit
HCMEntryDate eindt Initial Entry
HCMCorporationEntryDate kondt Entry into Group
HCMCorporationCode konsl Group Key
HCMContractType cttyp Contract Type
HCMContractStartDate ctbeg Contribution Start
HCMContractEndDate ctedt Valid Until
HCMEmployeeGroup persg EE group
HCMEmployeeSubgroup persk EE subgroup
HCMWorkplaceLocationName wrkpl Wrk Locat.
HCMContractNumber ctnum Contract no
HCMContractAdditionalNumber objnb Object Number

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_HCMContractElement.
-- 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_HCMContractElement 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,
  nbtgk AS HCMEmplHasSidelineJobAllowance,
  wttkl AS HCMEmplHasCompetitionClause,
  lfzfr AS HCMContinuedPayDuration,
  lfzzh AS HCMContinuedPayDurationUnit,
  lfzso AS HCMContinuedPaySpecialRuleCode,
  kgzfr AS HCMSickPaySupplementDuration,
  kgzzh AS HCMSickPaySuplmntDurationUnit,
  prbzt AS HCMProbationPeriodDuration,
  prbeh AS HCMProbationPeriodDurationUnit,
  kdgfr AS HCMNoticePeriodForEmployerCode,
  kdgf2 AS HCMNoticePeriodForEmployeeCode,
  arber AS HCMWorkPermitExpirationDate,
  eindt AS HCMEntryDate,
  kondt AS HCMCorporationEntryDate,
  konsl AS HCMCorporationCode,
  cttyp AS HCMContractType,
  ctbeg AS HCMContractStartDate,
  ctedt AS HCMContractEndDate,
  persg AS HCMEmployeeGroup,
  persk AS HCMEmployeeSubgroup,
  wrkpl AS HCMWorkplaceLocationName,
  ctnum AS HCMContractNumber,
  objnb AS HCMContractAdditionalNumber
FROM pa0016
;

Learn More