I_TimeSheetWrkLocText

DDL: I_TIMESHEETWRKLOCTEXT SQL: ITSWRKLOCTEXT Type: view BASIC Package: ODATA_HCM_CATS_REPORTING
6 Fields 1 Data Sources 2 Associations

Work Location for Timesheet - Text

I_TimeSheetWrkLocText (Basic)

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

Human Resources

I_TimeSheetWrkLocText is a Basic CDS View that provides data about "Work Location for Timesheet - Text" in SAP S/4HANA. It reads from 1 data source (tcats_ssc_wrklt) and exposes 6 fields with key fields Language, TimeSheetWrkLocCode, TimeSheetWrkLocEndDate. It has 2 associations to related views. Part of development package ODATA_HCM_CATS_REPORTING.

SAP Help Documentation

CategoryCDS Views for Human Resources
StatusReleased
Purpose
This CDS view provides the list of work locations and their description or name in different languages. This CDS view provides the prerequisites for answering the following business questions: What is the description or name for a work location?

Structure
Object types This view is built on the following object types: TimesheetWorkLocation Measures and attributes Some important measures and attributes are: Work Location Code Timesheet Work Location End Date Language Work Location Code Name

View on SAP Help Portal →

SAP API Hub

CategoryBasic
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,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageHuman Resources for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the list of work locations and their description or name in different languages.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What is the description or name for a work location?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tcats_ssc_wrklt tswlt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TimeSheetWrkLoc _TimeSheetWrkLoc $projection.TimeSheetWrkLocCode = _TimeSheetWrkLoc.TimeSheetWrkLocCode and $projection.TimeSheetWrkLocEndDate = _TimeSheetWrkLoc.TimeSheetWrkLocEndDate
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ITSWRKLOCTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 002 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey TimeSheetWrkLocCode view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label Work Location for Timesheet - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language tcats_ssc_wrklt langu Primary lang.
KEY TimeSheetWrkLocCode Time Sheet: Work Location
KEY TimeSheetWrkLocEndDate tcats_ssc_wrklt endda Valid To
TimeSheetWrkLocCodeName Timesheet Work Location Text
_TimeSheetWrkLoc _TimeSheetWrkLoc
_Language _Language

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_TimeSheetWrkLocText.
-- 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: ITSWRKLOCTEXT

CREATE VIEW I_TimeSheetWrkLocText AS
SELECT
  tswlt.langu AS Language,
  cast( tswlt.wrkloc as cats_ssc_wrkloc preserving type ) AS TimeSheetWrkLocCode,
  tswlt.endda AS TimeSheetWrkLocEndDate,
  cast( tswlt.text as cats_ssc_wrkloctext preserving type ) AS TimeSheetWrkLocCodeName
FROM tcats_ssc_wrklt AS tswlt
LEFT OUTER JOIN I_TimeSheetWrkLoc AS _TimeSheetWrkLoc ON TimeSheetWrkLocCode = _TimeSheetWrkLoc.TimeSheetWrkLocCode AND TimeSheetWrkLocEndDate = _TimeSheetWrkLoc.TimeSheetWrkLocEndDate  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More