P_EmployeeValidity

DDL: P_EMPLOYEEVALIDITY Type: view_entity COMPOSITE Package: VDM_SHCM_EMPLOYEE

Employee Validity

P_EmployeeValidity is a Composite CDS View that provides data about "Employee Validity" in SAP S/4HANA. It reads from 1 data source (I_WorkAssignmentKeyMapping) and exposes 3 fields with key field BusinessPartner. Part of development package VDM_SHCM_EMPLOYEE.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkAssignmentKeyMapping I_WorkAssignmentKeyMapping from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
StartDate
EndDate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType:#COMPOSITE
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity P_EmployeeValidity as select from I_WorkAssignmentKeyMapping  
{
  key BusinessPartner as BusinessPartner, //BusinessPartner,

      min(WorkAssignmentStartDate) as StartDate,
      max(WorkAssignmentEndDate) as EndDate
}
group by BusinessPartner

Learn More