P_TimeShtEntriesForApprvl

DDL: P_TIMESHTENTRIESFORAPPRVL SQL: PTIMESHTAPPRVL Type: view COMPOSITE

P_TimeShtEntriesForApprvl is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_TimeSheetRecord) and exposes 27 fields with key field TimeSheetRecord.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_TimeSheetRecord Cats from

Parameters (1)

NameTypeDefault
P_WorkflowTaskInternalID sww_wiid

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PTIMESHTAPPRVL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY TimeSheetRecord I_TimeSheetRecord TimeSheetRecord
PersonWorkAgreement I_TimeSheetRecord PersonWorkAgreement
TimeSheetDate I_TimeSheetRecord TimeSheetDate
WBSElementInternalID I_TimeSheetRecord WBSElementInternalID
ActivityType I_TimeSheetRecord ActivityType
WorkItem I_TimeSheetRecord WorkItem
RecordedHours I_TimeSheetRecord RecordedHours
HoursUnitOfMeasure I_TimeSheetRecord HoursUnitOfMeasure
PurchaseOrder I_TimeSheetRecord PurchaseOrder
PurchaseOrderItem I_TimeSheetRecord PurchaseOrderItem
UnitOfMeasure I_TimeSheetRecord UnitOfMeasure
ReceiverCostCenter I_TimeSheetRecord ReceiverCostCenter
InternalOrder I_TimeSheetRecord InternalOrder
ControllingArea I_TimeSheetRecord ControllingArea
TimeSheetTaskType I_TimeSheetRecord TimeSheetTaskType
TimeSheetNote I_TimeSheetRecord TimeSheetNote
TimeSheetPredecessorRecord I_TimeSheetRecord TimeSheetPredecessorRecord
TimeSheetLastChangedDate I_TimeSheetRecord TimeSheetLastChangedDate
AccountingIndicatorCode I_TimeSheetRecord AccountingIndicatorCode
TimeSheetWrkLocCode I_TimeSheetRecord TimeSheetWrkLocCode
TimeSheetOvertimeCategory I_TimeSheetRecord TimeSheetOvertimeCategory
WorkflowTaskInternalID I_TimeSheetRecord WorkflowTaskInternalID
TimeSheetStatus I_TimeSheetRecord TimeSheetStatus
_TimeSheetOvertimeCatText I_TimeSheetRecord _TimeSheetOvertimeCatText
_TimeSheetRecordLongText I_TimeSheetRecord _TimeSheetRecordLongText
_TimeSheetTaskTypeText I_TimeSheetRecord _TimeSheetTaskTypeText
_TimeSheetWrkLoc I_TimeSheetRecord _TimeSheetWrkLoc 
@AbapCatalog.sqlViewName: 'PTIMESHTAPPRVL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Timesheet Records for Approval by Manager'

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_TimeShtEntriesForApprvl
  with parameters
    P_WorkflowTaskInternalID : sww_wiid
  as select from I_TimeSheetRecord as Cats
{
  key Cats.TimeSheetRecord,
      Cats.PersonWorkAgreement,
      Cats.TimeSheetDate,
      Cats.WBSElementInternalID,
      Cats.ActivityType,
      Cats.WorkItem,
      Cats.RecordedHours,
      Cats.HoursUnitOfMeasure,
      Cats.PurchaseOrder,
      Cats.PurchaseOrderItem,
      Cats.UnitOfMeasure,
      Cats.ReceiverCostCenter,
      Cats.InternalOrder,
      Cats.ControllingArea,
      Cats.TimeSheetTaskType,
      Cats.TimeSheetNote,
      Cats.TimeSheetPredecessorRecord,
      Cats.TimeSheetLastChangedDate,
      Cats.AccountingIndicatorCode,
      Cats.TimeSheetWrkLocCode,
      Cats.TimeSheetOvertimeCategory,
      Cats.WorkflowTaskInternalID,
      Cats.TimeSheetStatus,

      Cats._TimeSheetOvertimeCatText,
      Cats._TimeSheetRecordLongText,
      Cats._TimeSheetTaskTypeText,
      Cats._TimeSheetWrkLoc
}
where
      Cats.WorkflowTaskInternalID = $parameters.P_WorkflowTaskInternalID
  and Cats.TimeSheetStatus        = '20'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TIMESHEETRECORD"
],
"ASSOCIATED":
[
"I_TIMESHEETOVERTIMECATTEXT",
"I_TIMESHEETRECORDLONGTEXT",
"I_TIMESHEETTASKTYPETEXT",
"I_TIMESHEETWRKLOC"
],
"BASE":
[
"I_TIMESHEETRECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More