I_TIMESHEETRECORD
Time Recording Data
I_TIMESHEETRECORD is a CDS View in S/4HANA. Time Recording Data. It contains 31 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CATSDATAWITHCATEGORY | view | from | COMPOSITE | |
| P_FuncnlAreaTskTmeRec | view | from | COMPOSITE | WUFAREA Task Time Recording |
| P_FundTskTmeRec | view | from | COMPOSITE | WUFUND Task Time Recording |
| P_GrantTskTmeRec | view | from | COMPOSITE | WUGRANT Task Time Recording |
| P_SDMForCatsTable | view_entity | from | BASIC | |
| P_TimeSheetApprovedHours | view | from | COMPOSITE | |
| P_TimeSheetRejectedHours | view | from | COMPOSITE | |
| P_TimeShtEntriesForApprvl | view | from | COMPOSITE | |
| P_TimeShtHrsAnlysForProjects | view | from | COMPOSITE | |
| P_TmeShtApprvrMail | view | from | BASIC | Email: Timesheet Approver reminder |
Fields (31)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | TimeSheetRecord | TimeSheetRecord | 7 |
| _TimeSheetOvertimeCatText | _TimeSheetOvertimeCatText | 1 | |
| _TimeSheetRecordLongText | _TimeSheetRecordLongText | 1 | |
| _TimeSheetTaskTypeText | _TimeSheetTaskTypeText | 1 | |
| _TimeSheetWrkLoc | _TimeSheetWrkLoc | 1 | |
| AccountingIndicatorCode | AccountingIndicatorCode | 5 | |
| ActivityType | ActivityType,EngagementProjectResource | 8 | |
| ControllingArea | ControllingArea | 1 | |
| HoursUnitOfMeasure | HoursUnitOfMeasure | 2 | |
| InternalOrder | InternalOrder | 3 | |
| PersonWorkAgreement | EmploymentInternalID,PersonWorkAgreement | 6 | |
| PurchaseOrder | PurchaseOrder | 5 | |
| PurchaseOrderItem | PurchaseOrderItem | 3 | |
| ReceiverCostCenter | ReceiverCostCenter | 3 | |
| RecordedHours | RecordedHours | 2 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| TimeSheetDate | CalendarDate,TimeSheetDate | 3 | |
| TimeSheetHasLongText | TimeSheetHasLongText | 1 | |
| TimeSheetLastChangedDate | TimeSheetLastChangedDate | 1 | |
| TimeSheetNote | TimeSheetNote | 2 | |
| TimeSheetOvertimeCategory | TimeSheetOvertimeCategory | 1 | |
| TimeSheetPredecessorRecord | TimeSheetPredecessorRecord | 2 | |
| TimeSheetStatus | Status,TimeSheetStatus | 4 | |
| TimeSheetTaskType | TaskType,TimeSheetTaskType | 4 | |
| TimeSheetWrkLocCode | TimeSheetWrkLocCode | 1 | |
| UnitOfMeasure | UnitOfMeasure | 2 | |
| WBSElementInternalID | WBSElementInternalID | 4 | |
| WorkflowTaskInternalID | WorkflowTaskInternalID | 1 | |
| WorkItem | WorkItem | 5 |
@AbapCatalog.sqlViewName: 'ITIMESHEETRECORD'
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_TimeSheetRecordLongText','_TIMESHEETTASKTYPETEXT']
@Analytics: { dataCategory: #FACT, dataExtraction: {enabled: true , delta.changeDataCapture.automatic: true}}
@ObjectModel.representativeKey: 'TimeSheetRecord'
@ObjectModel.usageType.serviceQuality : #A
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Time Recording Data'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ]
define view I_TimeSheetRecord
as select from catsdb
association [0..1] to I_TimeSheetRejectionReasonText as _TimeSheetRejReasonText on $projection.RejectionReason = _TimeSheetRejReasonText.TimeSheetRejectionReason
and _TimeSheetRejReasonText.Language = $session.system_language
association [0..1] to I_TimeSheetStatusText as _TimeSheetStatusText on $projection.TimeSheetStatus = _TimeSheetStatusText.TimeSheetStatus
and _TimeSheetStatusText.Language = $session.system_language
association [0..1] to I_TimeSheetWrkLoc as _TimeSheetWrkLoc on $projection.TimeSheetWrkLocCode = _TimeSheetWrkLoc.TimeSheetWrkLocCode
and $projection.TimeSheetDate between _TimeSheetWrkLoc.TimeSheetWrkLocStartDate and _TimeSheetWrkLoc.TimeSheetWrkLocEndDate
association [0..1] to I_TimeSheetTaskTypeText as _TimeSheetTaskTypeText on $projection.TimeSheetTaskType = _TimeSheetTaskTypeText.TimeSheetTaskType
and _TimeSheetTaskTypeText.Language = $session.system_language
association [0..1] to I_TimeSheetOvertimeCatText as _TimeSheetOvertimeCatText on $projection.TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory
and _TimeSheetOvertimeCatText.Language = $session.system_language
association [0..1] to I_TimeSheetRecordLongText as _TimeSheetRecordLongText on $projection.TimeSheetRecord = _TimeSheetRecordLongText.TimeSheetRecord
and _TimeSheetRecordLongText.Language is not null
----Extension Association
association [1..1] to E_TimeSheetRecord as _TimeSheetRecordExtention on $projection.TimeSheetRecord = _TimeSheetRecordExtention.TimeSheetRecord
{
key catsdb.counter as TimeSheetRecord,
catsdb.pernr as PersonWorkAgreement,
catsdb.workdate as TimeSheetDate,
cast(catsdb.rproj as ps_s4_pspnr preserving type) as WBSElementInternalID,
catsdb.lstar as ActivityType,
catsdb.work_item_id as WorkItem,
catsdb.catshours as RecordedHours,
catsdb.meinh as HoursUnitOfMeasure,
catsdb.sebeln as PurchaseOrder,
catsdb.sebelp as PurchaseOrderItem,
@Semantics.amount.currencyCode: 'Currency'
catsdb.catsamount as RecordedAmount,
@Semantics.currencyCode: true
catsdb.waers as Currency,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
catsdb.catsquantity as RecordedQuantity,
@Semantics.unitOfMeasure: true
catsdb.unit as UnitOfMeasure,
catsdb.rkostl as ReceiverCostCenter,
catsdb.skostl as SenderCostCenter,
catsdb.raufnr as InternalOrder,
catsdb.service_doc_type as ServiceDocumentType,
catsdb.service_doc_id as ServiceDocument,
catsdb.service_doc_item_id as ServiceDocumentItem,
catsdb.kokrs as ControllingArea,
catsdb.tasktype as TimeSheetTaskType,
catsdb.tasklevel as TimeSheetTaskLevel,
catsdb.taskcomponent as TimeSheetTaskComponent,
catsdb.bukrs as CompanyCode,
catsdb.ltxa1 as TimeSheetNote,
catsdb.status as TimeSheetStatus,
catsdb.reason as RejectionReason,
catsdb.refcounter as TimeSheetPredecessorRecord,
catsdb.ersda as TimeSheetCreationDate,
catsdb.erstm as TimeSheetEntryTime,
catsdb.ernam as CreatedByUser,
catsdb.aenam as LastChangedByUser,
catsdb.apnam as TimeSheetApprovedByUser,
catsdb.apdat as TimeSheetApprovedDate,
catsdb.laeda as TimeSheetLastChangedDate,
catsdb.laetm as TimeSheetLastChangedTime,
catsdb.bemot as AccountingIndicatorCode,
catsdb.workitemid as WorkflowTaskInternalID,
catsdb.wtart as TimeSheetWrkLocCode,
catsdb.overtimecat as TimeSheetOvertimeCategory,
catsdb.longtext as TimeSheetHasLongText,
catsdb.belnr as TimeSheetAccountingDocument, // added in CE2002
catsdb.s_fund as SenderPubSecFund, //added in CE2111
catsdb.s_func_area as SendingPubSecFunctionalArea, //added in CE2111
catsdb.s_grant_nbr as SenderPubSecGrant, //added in CE2111
catsdb.sbudget_pd as SenderPubSecBudgetPeriod, //added in CE2111
catsdb.fund as ReceiverPubSecFund, //added in CE2111
catsdb.func_area as ReceiverPubSecFuncnlArea, //added in CE2111
catsdb.grant_nbr as ReceiverPubSecGrant, //added in CE2111
catsdb.budget_pd as ReceiverPubSecBudgetPeriod, //added in CE2111
_TimeSheetRejReasonText,
_TimeSheetStatusText,
_TimeSheetWrkLoc,
_TimeSheetTaskTypeText,
_TimeSheetOvertimeCatText,
_TimeSheetRecordLongText
}