SAP Knowledge Base Article - Public

3138813 - TimesheetNote field only displays 40 characters of the Note in CDS view I_TIMESHEETRECORD

Symptom

Field TimesheetNote from I_TIMESHEETRECORD only has 40 characters so the data entered for the timesheet entry is truncated.

Environment

Source: portal
Type: Productive System
System ID/Name: MJ9 / my301532.s4hana.ondemand.com
Product version: SAP S/4HANA Cloud 2111
System managed by: SAP Cloud Tenant
Install base item: my301532.s4hana.ondemand.com
Sold product: S/4HANA

Cause

I_TIMESHEETRECORD has a limitation of 40 characters in the note.

Resolution

Currently the timesheet note field from I_TIMESHEETRECORD only stores 40 characters. If the note goes beyond that it will be stored in a text table.

This text table can be accessible through I_TimeSheetRecordLongText which would contains all of the message entered in the timesheet note.

You may find if a timesheet entry has a long text in field TimeSheetHasLongText of I_TIMESHEETRECORD.

NOTE: Please note that Long Text is currently not supported in Custom Analytical Queries.

Keywords

KBA , CA-TS-S4 , Cross Application Timesheet in S/4HANA , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions