P_TIMEREJEMAIL

DDL: P_TIMEREJEMAIL SQL: PTIMEREJMAIL Type: view BASIC Package: ODATA_HCM_CATS_REPORTING
3 Fields 1 Data Sources

Email: Rejected Timesheet Entries

P_TIMEREJEMAIL is a Basic CDS View that provides data about "Email: Rejected Timesheet Entries" in SAP S/4HANA. It reads from 1 data source (hcm_cats_rej_ntf) and exposes 3 fields. Part of development package ODATA_HCM_CATS_REPORTING.

Data Sources (1)

SourceAliasJoin Type
hcm_cats_rej_ntf hcm_cats_rej_ntf from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PTIMEREJMAIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Email: Rejected Timesheet Entries view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
NrOfTimesheetRejectedEntries
EmployeeName
TimesheetURL

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 P_TIMEREJEMAIL.
-- 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: PTIMEREJMAIL

CREATE VIEW P_TIMEREJEMAIL AS
SELECT
  cast('NrOfTimesheetRejectedEntries' as abap.char( 1000 )) AS NrOfTimesheetRejectedEntries,
  cast('EmployeeName' as abap.char( 1000 )) AS EmployeeName,
  cast('TimesheetURL' as abap.char( 1000 )) AS TimesheetURL
FROM hcm_cats_rej_ntf
;

Learn More