I_HCMContractElementEnhanced

DDL: I_HCMCONTRACTELEMENTENHANCED Type: view_entity COMPOSITE
49 Fields 1 Data Sources 4 Associations

HCM Contract Element enhanced

I_HCMContractElementEnhanced is a Composite CDS View that provides data about "HCM Contract Element enhanced" in SAP S/4HANA. It reads from 1 data source (I_HCMContractElement) and exposes 49 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_HCMContractElement I_HCMContractElement from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_HCMContractType _ContractType _ContractType.HCMContractType = $projection.HCMContractType
[0..*] I_HCMNoticePeriod _NoticePeriodEmployee _NoticePeriodEmployee.HCMNoticePeriodCode = $projection.HCMNoticePeriodForEmployeeCode
[0..*] I_HCMNoticePeriod _NoticePeriodEmployer _NoticePeriodEmployer.HCMNoticePeriodCode = $projection.HCMNoticePeriodForEmployerCode
[0..1] I_HCMUnitOfMeasure _UnitOfMeasureProbPeriodUnit _UnitOfMeasureProbPeriodUnit.HCMUnitOfMeasure = $projection.HCMProbationPeriodDurationUnit

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label HCM Contract Element enhanced view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A 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
HCMEmplHasSidelineJobAllowance HCMEmplHasSidelineJobAllowance Sideline Job
HCMEmplHasCompetitionClause HCMEmplHasCompetitionClause Competition Clause
HCMContinuedPayDuration HCMContinuedPayDuration Continued Pay
HCMContinuedPayDurationUnit HCMContinuedPayDurationUnit Continued Pay
HCMContinuedPaySpecialRuleCode HCMContinuedPaySpecialRuleCode Special Rule
HCMSickPaySupplementDuration HCMSickPaySupplementDuration Sick Pay
HCMSickPaySuplmntDurationUnit HCMSickPaySuplmntDurationUnit Sick Pay Supplement Period (Unit)
HCMProbationPeriodDuration HCMProbationPeriodDuration Prob.Period
HCMProbationPeriodDurationUnit HCMProbationPeriodDurationUnit Probationary Period (Unit)
HCMNoticePeriodForEmployerCode HCMNoticePeriodForEmployerCode ER Notice Period
HCMNoticePeriodForEmployeeCode HCMNoticePeriodForEmployeeCode EE Notice Period
HCMWorkPermitExpirationDate HCMWorkPermitExpirationDate Work Permit
HCMEntryDate HCMEntryDate Initial Entry
HCMCorporationEntryDate HCMCorporationEntryDate Entry into Group
HCMCorporationCode HCMCorporationCode Group Key
HCMContractType HCMContractType Contract Type
HCMContractStartDate HCMContractStartDate Contribution Start
HCMContractEndDate HCMContractEndDate Valid Until
HCMEmployeeGroup HCMEmployeeGroup EE group
HCMEmployeeSubgroup HCMEmployeeSubgroup EE subgroup
HCMWorkplaceLocationName HCMWorkplaceLocationName Wrk Locat.
HCMContractNumber HCMContractNumber Contract no
HCMContractAdditionalNumber HCMContractAdditionalNumber Object Number
_ContractType _ContractType
_NoticePeriodEmployee _NoticePeriodEmployee
_NoticePeriodEmployer _NoticePeriodEmployer
_UnitOfMeasureProbPeriodUnit _UnitOfMeasureProbPeriodUnit

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_HCMContractElementEnhanced.
-- 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_HCMContractElementEnhanced AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordIsHistorical,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordHasRefField,
  HCMInfoTypeRecordHasConfField,
  HCMInfoTypeRecordScreenCtrl,
  HCMMasterDataChangeReason,
  HCMInfoTypeRecordRsrvdFld1,
  HCMInfoTypeRecordRsrvdFld2,
  HCMInfoTypeRecordRsrvdFld3,
  HCMInfoTypeRecordRsrvdFld4,
  HCMInfoTypeRecordRsrvdFld1Len2,
  HCMInfoTypeRecordRsrvdFld2Len2,
  HCMGrpgValForPersAssignments,
  HCMEmplHasSidelineJobAllowance,
  HCMEmplHasCompetitionClause,
  HCMContinuedPayDuration,
  HCMContinuedPayDurationUnit,
  HCMContinuedPaySpecialRuleCode,
  HCMSickPaySupplementDuration,
  HCMSickPaySuplmntDurationUnit,
  HCMProbationPeriodDuration,
  HCMProbationPeriodDurationUnit,
  HCMNoticePeriodForEmployerCode,
  HCMNoticePeriodForEmployeeCode,
  HCMWorkPermitExpirationDate,
  HCMEntryDate,
  HCMCorporationEntryDate,
  HCMCorporationCode,
  HCMContractType,
  HCMContractStartDate,
  HCMContractEndDate,
  HCMEmployeeGroup,
  HCMEmployeeSubgroup,
  HCMWorkplaceLocationName,
  HCMContractNumber,
  HCMContractAdditionalNumber
FROM I_HCMContractElement
LEFT OUTER JOIN I_HCMContractType AS _ContractType ON _ContractType.HCMContractType = HCMContractType  -- association [0..1]
LEFT OUTER JOIN I_HCMNoticePeriod AS _NoticePeriodEmployee ON _NoticePeriodEmployee.HCMNoticePeriodCode = HCMNoticePeriodForEmployeeCode  -- association [0..*]
LEFT OUTER JOIN I_HCMNoticePeriod AS _NoticePeriodEmployer ON _NoticePeriodEmployer.HCMNoticePeriodCode = HCMNoticePeriodForEmployerCode  -- association [0..*]
LEFT OUTER JOIN I_HCMUnitOfMeasure AS _UnitOfMeasureProbPeriodUnit ON _UnitOfMeasureProbPeriodUnit.HCMUnitOfMeasure = HCMProbationPeriodDurationUnit  -- association [0..1]
;

Learn More