I_HCMProcessAffectedObject

DDL: I_HCMPROCESSAFFECTEDOBJECT Type: view COMPOSITE
35 Fields 4 Data Sources 1 Associations

HCM Process Affected Object

I_HCMProcessAffectedObject is a Composite CDS View that provides data about "HCM Process Affected Object" in SAP S/4HANA. It reads from 4 data sources (I_HCMEmployee, I_HCMJob, I_HCMOrganizationalUnit, I_HCMPosition) and exposes 35 fields with key fields HCMObjectType, HCMProcessAffectedObject, EndDate, HCMProcessAffectedObject, EndDate. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_HCMEmployee I_HCMEmployee union_all
I_HCMJob I_HCMJob from
I_HCMOrganizationalUnit I_HCMOrganizationalUnit union_all
I_HCMPosition I_HCMPosition union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_HCMObjectType _HCMObjectType $projection.HCMObjectType = _HCMObjectType.HCMObjectType

Annotations (14)

NameValueLevelField
EndUserText.label HCM Process Affected Object view
AbapCatalog.sqlViewName IHCMPROCAFFCDOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.filter.businessDate.at true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey HCMProcessAffectedObject view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view
VDM.viewType #COMPOSITE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY HCMObjectType
KEY HCMProcessAffectedObject
KEY EndDate I_HCMJob EndDate Term to
StartDate I_HCMJob StartDate Valid From
HCMProcessAffectedObjectName
HCMOrganizationalUnit Org. Unit
HCMPosition Position
HCMEmployeeEmailAddress Email Address
HCMEmployeeWorkPhoneNumber Work Phone Number
HCMObjectType
KEY HCMProcessAffectedObject
KEY EndDate I_HCMPosition EndDate Term to
StartDate I_HCMPosition StartDate Valid From
HCMProcessAffectedObjectName
HCMOrganizationalUnit Org. Unit
HCMPosition Position
HCMEmployeeEmailAddress Email Address
HCMEmployeeWorkPhoneNumber Work Phone Number
KEY HCMProcessAffectedObject
KEY EndDate I_HCMOrganizationalUnit EndDate Term to
StartDate I_HCMOrganizationalUnit StartDate Valid From
HCMProcessAffectedObjectName
HCMOrganizationalUnit Org. Unit
HCMPosition Position
HCMEmployeeEmailAddress Email Address
HCMEmployeeWorkPhoneNumber Work Phone Number
KEY HCMProcessAffectedObject
KEY EndDate Term to
StartDate Valid From
HCMProcessAffectedObjectName
HCMOrganizationalUnit HCMOrganizationalUnit Org. Unit
HCMPosition HCMPosition Position
HCMEmployeeEmailAddress _WorkEmailAddress HCMEmployeeWorkEmailAddress Email Address
HCMEmployeeWorkPhoneNumber _WorkPhoneNumber HCMEmployeeWorkPhoneNumber Work Phone Number
_HCMObjectType _HCMObjectType

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_HCMProcessAffectedObject.
-- 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_HCMProcessAffectedObject AS
SELECT
  cast('C' as asr_otype) AS HCMObjectType,
  cast(I_HCMJob.HCMJob as asr_object_key) AS HCMProcessAffectedObject,
  I_HCMJob.EndDate AS EndDate,
  I_HCMJob.StartDate AS StartDate,
  cast(I_HCMJobText.HCMJobTitle as stext) AS HCMProcessAffectedObjectName,
  cast('' as orgeh) AS HCMOrganizationalUnit,
  cast('' as plans) AS HCMPosition,
  cast('' as comm_id_long) AS HCMEmployeeEmailAddress,
  cast('' as comm_id_long) AS HCMEmployeeWorkPhoneNumber
FROM I_HCMJob
LEFT OUTER JOIN I_HCMObjectType AS _HCMObjectType ON HCMObjectType = _HCMObjectType.HCMObjectType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_HCMPosition, I_HCMOrganizationalUnit, I_HCMEmployee
;

Learn More