I_TimeOverviewByWrkAgrmtAndDte

DDL: I_TIMEOVERVIEWBYWRKAGRMTANDDTE SQL: IWRKAGRTMOV Type: view BASIC Package: ODATA_HCM_CATS_REPORTING

Availability of a Person Work Agreement

I_TimeOverviewByWrkAgrmtAndDte is a Basic CDS View (Fact) that provides data about "Availability of a Person Work Agreement" in SAP S/4HANA. It reads from 2 data sources (I_PersonWorkAgrmtStatus, ptimeov1) and exposes 13 fields with key fields PersonWorkAgreement, CalendarDate. Part of development package ODATA_HCM_CATS_REPORTING.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_PersonWorkAgrmtStatus _PersonWorkAgrmtStatus inner
ptimeov1 pTime from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IWRKAGRTMOV view
VDM.viewType #BASIC view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Availability of a Person Work Agreement view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
ObjectModel.sapObjectNodeType.name WorkforceAvailability view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement ptimeov1 employeenumber
KEY CalendarDate ptimeov1 validitydate
Origin ptimeov1 extapplication
PlannedWorkingHours ptimeov1 regularhours
PlannedStartTime ptimeov1 regularbegin
PlannedEndTime ptimeov1 regularend
PublicHolidayClass ptimeov1 holidayclass
IsNonWorkingDay ptimeov1 nonworking
AbsenceInHours ptimeov1 absencehours
AttendanceHours ptimeov1 attendancehours
OvertimeInHours ptimeov1 overtimehours
AvailabilityInHours
PersonWorkAgrmtAuthznGrpg I_PersonWorkAgrmtStatus PersonWorkAgrmtAuthznGrpg 
@AbapCatalog.sqlViewName: 'IWRKAGRTMOV'
@VDM.viewType: #BASIC
@Analytics: { dataCategory: #FACT, dataExtraction: {enabled: true } }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER 
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Availability of a Person Work Agreement'
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.preserveKey:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.sapObjectNodeType.name :'WorkforceAvailability'
define view I_TimeOverviewByWrkAgrmtAndDte
  as select from    ptimeov1        as pTime
  inner join I_PersonWorkAgrmtStatus as _PersonWorkAgrmtStatus on pTime.employeenumber = _PersonWorkAgrmtStatus.PersonWorkAgreement and
                                                                  pTime.validitydate between _PersonWorkAgrmtStatus.StartDate and _PersonWorkAgrmtStatus.EndDate
  
// inner join pa0001 as PA0001 on pTime.employeenumber = pa0001.pernr

//                and pTime.validitydate between pa0001.begda and pa0001.endda

//                and pa0001.sprps <> 'X'

{
  key pTime.employeenumber                  as PersonWorkAgreement,
  key pTime.validitydate                    as CalendarDate,
      pTime.extapplication                  as Origin,
      pTime.regularhours                    as PlannedWorkingHours,
      pTime.regularbegin                    as PlannedStartTime,
      pTime.regularend                      as PlannedEndTime,
      pTime.holidayclass                    as PublicHolidayClass,
      pTime.nonworking                      as IsNonWorkingDay,
      pTime.absencehours                    as AbsenceInHours,
      pTime.attendancehours                 as AttendanceHours,
      pTime.overtimehours                   as OvertimeInHours,
      //pa0001.vdsk1                          as PersonWorkAgrmtAuthznGrpg //for dcl

      ( pTime.regularhours + pTime.overtimehours - pTime.absencehours - pTime.attendancehours ) as AvailabilityInHours,
      _PersonWorkAgrmtStatus.PersonWorkAgrmtAuthznGrpg
}

Learn More