I_EmploymentManagerCl

DDL: I_EMPLOYMENTMANAGERCL SQL: IEMPLOYMENTMGRCL Type: view BASIC

Employment Manager for Cloud

I_EmploymentManagerCl is a Basic CDS View that provides data about "Employment Manager for Cloud" in SAP S/4HANA. It reads from 4 data sources (I_Employee, I_Employee, hrp1001, P_PDOBJECTRELATION) and exposes 9 fields with key field EmploymentInternalID.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
I_Employee Employee inner
I_Employee Manager inner
hrp1001 ManagerRelation from
P_PDOBJECTRELATION P_PDOBJECTRELATION inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLOYMENTMGRCL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Employment Manager for Cloud view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID hrp1001 objid
PersonnelNumber I_Employee PersonnelNumber
Employee I_Employee Employee
EmployeeFullName I_Employee FullName
ManagerPersonnelNumber I_Employee PersonnelNumber
ManagerEmployee I_Employee Employee
ManagerFullName I_Employee FullName
ValidityStartDate hrp1001 begda
ValidityEndDate hrp1001 endda 
@AbapCatalog.sqlViewName: 'IEMPLOYMENTMGRCL'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Employment Manager for Cloud'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER 
@ObjectModel.usageType.serviceQuality: #C 
@ObjectModel.usageType.sizeCategory: #L

define view I_EmploymentManagerCl 
as select from hrp1001 as ManagerRelation
  
inner join  I_Employee as Manager on ManagerRelation.sobid = Manager.PersonnelNumber
inner join  P_PDOBJECTRELATION(P_ObjectType :'XM',
                               P_RelationShipDirection :'B',
                               P_RelationShip :'330',
                               P_RelatedObjectType : 'XE' )  
                               as EmployeeRelation 
                               on ManagerRelation.objid = EmployeeRelation.ObjectID    
inner join  I_Employee as Employee on EmployeeRelation.RelatedObjectID = Employee.PersonnelNumber                              
{
   key ManagerRelation.objid                       as EmploymentInternalID,     // Employment ID

       Employee.PersonnelNumber,                                                 //Internal Stable Employee ID

       Employee.Employee,                                                       //Extnal ID from HR System

       Employee.FullName                           as EmployeeFullName,
       Manager.PersonnelNumber                     as ManagerPersonnelNumber,  // Internal Stable Employee ID of Manager

       Manager.Employee                            as ManagerEmployee,         // External Manager ID from HR System

       Manager.FullName                            as ManagerFullName,
       ManagerRelation.begda                       as ValidityStartDate,
       ManagerRelation.endda                       as ValidityEndDate                                                               //Association to Employee Instance of Manager

   } where otype = 'XM'  and 
           plvar = '01'  and 
           rsign = 'B'   and
           relat = '331' and 
           sclas = 'XE'                               
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EMPLOYEE",
"P_PDOBJECTRELATION",
"HRP1001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More