I_TimeSheetRejectionReasonText

DDL: I_TIMESHEETREJECTIONREASONTEXT SQL: ITSTREJECTTXT Type: view BASIC

Rejection Reason for Timesheet - Text

I_TimeSheetRejectionReasonText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Human Resources

I_TimeSheetRejectionReasonText is a Basic CDS View that provides data about "Rejection Reason for Timesheet - Text" in SAP S/4HANA. It reads from 1 data source (tcatsdt) and exposes 3 fields with key fields Language, TimeSheetRejectionReason.

SAP Help Documentation

CategoryCDS Views for Human Resources
StatusReleased
Purpose
This CDS view provides the access to the different timesheet rejection reasons and their description in different languages. This CDS view provides the prerequisites for answering the following business questions: How many timesheet rejection reasons along with the descriptions are defined in different languages?

Structure
Object types This view is built on the following object types: Timesheet Rejection Reason Timesheet Rejection Reason Text Measures and attributes Some important measures and attributes are: Timesheet Rejection Reason Timesheet Rejection Reason Text Language

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessHuman Resources
Application ComponentCA-TS-S4
CapabilitiesLanguage-Dependent Text, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageHuman Resources for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tcatsdt tcatsdt from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITSTREJECTTXT view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TimeSheetRejectionReason view
EndUserText.label Rejection Reason for Timesheet - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language langu Primary lang.
KEY TimeSheetRejectionReason reason Reason for rejection
TimeSheetRejectionReasonText Timesheet Rejection Reason Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TimeSheetRejectionReasonText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ITSTREJECTTXT

CREATE VIEW I_TimeSheetRejectionReasonText AS
SELECT
  langu AS Language,
  reason AS TimeSheetRejectionReason,
  cast(text as catsrejetext preserving type ) AS TimeSheetRejectionReasonText
FROM tcatsdt
;