C_HCMProcAffcdObjQuickVw

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 C_HCMProcAffcdObjQuickVw.
-- 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 C_HCMProcAffcdObjQuickVw AS
SELECT
  HCMObjectType,
  HCMProcessAffectedObject,
  cast(HCMProcessAffectedObjectName as abap.char(30)) AS HCMProcessAffectedObjectName,
  cast(case HCMObjectType when 'C' then HCMProcessAffectedObjectName else '' end as stltx) AS HCMJobTitle,
  cast(case HCMObjectType when 'S' then HCMProcessAffectedObjectName else '' end as plstx) AS HCMPositionName,
  cast(case HCMObjectType when 'O' then HCMProcessAffectedObjectName else '' end as orgtx) AS HCMOrganizationalUnitName,
  cast(case HCMObjectType when 'P' then HCMProcessAffectedObjectName else '' end as emnam) AS HCMEmployeeName,
  HCMOrganizationalUnit,
  concat(concat(concat(_HCMOrganizationalUnit._Text[1:Language=$session.system_language].HCMOrganizationalUnitName,' ('),HCMOrganizationalUnit),')') AS OrganizationalUnitName,
  HCMPosition,
  concat(concat(concat(_HCMPosition._Text[1:Language=$session.system_language].HCMPositionName,' ('),HCMPosition),')') AS PositionName,
  HCMEmployeeEmailAddress,
  HCMEmployeeWorkPhoneNumber,
  cast(case HCMObjectType when 'P' then ' ' else 'X' end as boolean) AS UICT_EmployeeIsHidden,
  cast(case HCMObjectType when 'O' then ' ' else 'X' end as boolean) AS UICT_OrgIsHidden,
  cast(case HCMObjectType when 'S' then ' ' else 'X' end as boolean) AS UICT_PositionIsHidden,
  cast(case HCMObjectType when 'C' then ' ' else 'X' end as boolean) AS UICT_JobIsHidden
FROM I_HCMProcessAffectedObject
LEFT OUTER JOIN I_HCMObjectType AS _HCMObjectType ON HCMObjectType = _HCMObjectType.HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMOrganizationalUnit AS _HCMOrganizationalUnit ON HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit  -- association [0..*]
LEFT OUTER JOIN I_HCMPositionVH AS _HCMPosition ON HCMPosition = _HCMPosition.HCMPosition AND _HCMPosition.HCMObjectType = 'S'  -- association [0..1]
;