I_EmploymtsofEE

DDL: I_EMPLOYMTSOFEE SQL: IEMPLOYMTSOFEE Type: view COMPOSITE Package: VDM_SHCM_EMPLOYEE
7 Fields

Employments of Employee

I_EmploymtsofEE is a Composite CDS View that provides data about "Employments of Employee" in SAP S/4HANA. Part of development package VDM_SHCM_EMPLOYEE.

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLOYMTSOFEE view
VDM.viewType #COMPOSITE view
EndUserText.label Employments of Employee view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber Empl PersonnelNumber Personnel No.
KEY EmploymentInternalID
KEY StartDate
EndDate
Employee Empl Employee Object ID
AuthorizationGroup Empl AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted Empl IsBusinessPurposeCompleted Purpose Completed

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_EmploymtsofEE.
-- 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: IEMPLOYMTSOFEE

CREATE VIEW I_EmploymtsofEE AS
SELECT
  Empl.PersonnelNumber AS PersonnelNumber,
  Empl._Employment.EmploymentInternalID AS EmploymentInternalID,
  Empl._Employment.StartDate AS StartDate,
  Empl._Employment.EndDate AS EndDate,
  Empl.Employee AS Employee,
  Empl.AuthorizationGroup AS AuthorizationGroup,
  Empl.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
;

Learn More