P_TimeSheetRejectedHours

DDL: P_TIMESHEETREJECTEDHOURS SQL: PTMESHTRJCTHRS Type: view COMPOSITE

P_TimeSheetRejectedHours is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_TimeSheetRecord) and exposes 10 fields.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_TimeSheetRecord Cats from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PTMESHTRJCTHRS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
PersonWorkAgreement I_TimeSheetRecord PersonWorkAgreement
WBSElementInternalID I_TimeSheetRecord WBSElementInternalID
WorkItem I_TimeSheetRecord WorkItem
ActivityType I_TimeSheetRecord ActivityType
PurchaseOrder I_TimeSheetRecord PurchaseOrder
AccountingIndicatorCode I_TimeSheetRecord AccountingIndicatorCode
TimeSheetTaskType I_TimeSheetRecord TimeSheetTaskType
ReceiverCostCenter I_TimeSheetRecord ReceiverCostCenter
InternalOrder I_TimeSheetRecord InternalOrder
RejectedHours 
@AbapCatalog.sqlViewName: 'PTMESHTRJCTHRS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@EndUserText.label: 'Total Rejected Hours'


define view P_TimeSheetRejectedHours
  as select from I_TimeSheetRecord as Cats
{
  Cats.PersonWorkAgreement,
  Cats.WBSElementInternalID,
  Cats.WorkItem,
  Cats.ActivityType,
  Cats.PurchaseOrder,
  Cats.AccountingIndicatorCode,
  Cats.TimeSheetTaskType,
  Cats.ReceiverCostCenter,
  Cats.InternalOrder,
  sum(Cats.RecordedHours) as RejectedHours
}
where
       Cats.TimeSheetStatus      = '40'
group by
  Cats.PersonWorkAgreement,
  Cats.WBSElementInternalID,
  Cats.WorkItem,
  Cats.ActivityType,
  Cats.PurchaseOrder,
  Cats.AccountingIndicatorCode,
  Cats.TimeSheetTaskType,
  Cats.ReceiverCostCenter,
  Cats.InternalOrder

Learn More