C_EmploymentSearchOp

DDL: C_EMPLOYMENTSEARCHOP SQL: CEMPLYMNTSRCHOP Type: view CONSUMPTION
23 Fields 1 Data Sources

Employees

C_EmploymentSearchOp is a Consumption CDS View that provides data about "Employees" in SAP S/4HANA. It reads from 1 data source (I_EmploymentSearchOp) and exposes 23 fields with key field EmploymentInternalID.

Data Sources (1)

SourceAliasJoin Type
I_EmploymentSearchOp I_EmploymentSearchOp from

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName CEMPLYMNTSRCHOP view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Employees view
Search.searchable true view
EnterpriseSearch.enabled true view
Consumption.semanticObject Employee view
ObjectModel.sapObjectNodeType.name WorkAssignmentDetails view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
UI.headerInfo.imageUrl EmployeeImageURL view
UI.headerInfo.typeName Employee view
UI.headerInfo.typeNamePlural Employees view
UI.headerInfo.title.label Employees view
UI.headerInfo.title.value EmployeeName view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
PersonnelNumber EmploymentInternalID Personnel Number
Employee Employee Employee ID
EmployeeName EmployeeName EmployeeName
EmployeeImageURL EmployeeImageURL
CompanyCodeName Company Code
CostCenterName Cost Center
OrganizationalUnitName Organizational Unit
JobName Job
EmployeeSkillTagName EmployeeSkillTagName Tags
LastChangeDate LastChangeDate Last Changed Date
LastChangedByUser LastChangedByUser Last Changed By
Job Job JobCode
OrganizationalUnit OrganizationalUnit OrganizationalUnitCode
CostCenter CostCenter CostCenterID
CompanyCode CompanyCode CompanyCodeID
FamilyName FamilyName Last Name
GivenName GivenName First Name
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel Preferred Name
AuthorizationGroup AuthorizationGroup AuthorizGroup
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg Org.key
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
WorkforceModelFeatureInUse WorkforceModelFeatureInUse Synch Switch

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_EmploymentSearchOp.
-- 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.
-- SQL view name: CEMPLYMNTSRCHOP

CREATE VIEW C_EmploymentSearchOp AS
SELECT
  EmploymentInternalID,
  EmploymentInternalID AS PersonnelNumber,
  Employee,
  EmployeeName,
  EmployeeImageURL,
  concat_with_space(concat_with_space(CompanyCode, '-', 2), CompanyCodeName, 2) AS CompanyCodeName,
  concat_with_space (concat_with_space(CostCenter, '-', 2), CostCenterName, 2) AS CostCenterName,
  concat_with_space (concat_with_space(OrganizationalUnit, '-', 2), I_EmploymentSearchOp.OrganizationalUnitName, 2) AS OrganizationalUnitName,
  concat_with_space(concat_with_space(Job, '-', 2), JobName, 2) AS JobName,
  EmployeeSkillTagName,
  LastChangeDate,
  LastChangedByUser,
  Job,
  OrganizationalUnit,
  CostCenter,
  CompanyCode,
  FamilyName,
  GivenName,
  BusinessPartnerNicknameLabel,
  AuthorizationGroup,
  PersonWorkAgrmtAuthznGrpg,
  IsBusinessPurposeCompleted,
  WorkforceModelFeatureInUse
FROM I_EmploymentSearchOp
;

Learn More