R_SetlMgmtSchedgWlRunTP

DDL: R_SETLMGMTSCHEDGWLRUNTP Type: view_entity TRANSACTIONAL
17 Fields 1 Data Sources 4 Associations

Scheduling Worklist Run - TP

R_SetlMgmtSchedgWlRunTP is a Transactional CDS View that provides data about "Scheduling Worklist Run - TP" in SAP S/4HANA. It reads from 1 data source (R_SetlMgmtSchedgWlRun) and exposes 17 fields with key field SetlMgmtSchedgWlRunUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SetlMgmtSchedgWlRun R_SetlMgmtSchedgWlRun from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SetlMgmtSchedgWlRunStatus _RunStatus $projection.SetlMgmtSchedgWlRunStatus = _RunStatus.SetlMgmtSchedgWlRunStatus
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..*] R_SetlMgmtSchedgWlRunItemTP _RunItem

Annotations (8)

NameValueLevelField
EndUserText.label Scheduling Worklist Run - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SetlMgmtSchedgWlRunUUID R_SetlMgmtSchedgWlRun SetlMgmtSchedgWlRunUUID Scheduling Worklist Run UUID
SettlmtMgmtSchedgWlUUID R_SetlMgmtSchedgWlRun SettlmtMgmtSchedgWlUUID Scheduling Worklist UUID
ApplicationJobName R_SetlMgmtSchedgWlRun ApplicationJobName Job Name
ApplicationJob R_SetlMgmtSchedgWlRun ApplicationJob Job No.
SetlMgmtSchedgWlRunStartDteTme R_SetlMgmtSchedgWlRun SetlMgmtSchedgWlRunStartDteTme Job Execution Start Date and Time
SetlMgmtSchedgWlRunEndDateTime R_SetlMgmtSchedgWlRun SetlMgmtSchedgWlRunEndDateTime Job Execution End Date and Time
SetlMgmtSchedgWlRunStatus R_SetlMgmtSchedgWlRun SetlMgmtSchedgWlRunStatus Scheduling Worklist Run Status
CreatedByUser R_SetlMgmtSchedgWlRun CreatedByUser User Name
CreationUTCDateTime R_SetlMgmtSchedgWlRun CreationUTCDateTime Time Stamp
LastChangedByUser R_SetlMgmtSchedgWlRun LastChangedByUser User Name
LastChangeUTCDateTime R_SetlMgmtSchedgWlRun LastChangeUTCDateTime Time Stamp
ApplicationLogHandle R_SetlMgmtSchedgWlRun ApplicationLogHandle Log Handle
_RunItem _RunItem
_Worklist _Worklist
_RunStatus _RunStatus
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 R_SetlMgmtSchedgWlRunTP.
-- 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.

CREATE VIEW R_SetlMgmtSchedgWlRunTP AS
SELECT
  R_SetlMgmtSchedgWlRun.SetlMgmtSchedgWlRunUUID AS SetlMgmtSchedgWlRunUUID,
  R_SetlMgmtSchedgWlRun.SettlmtMgmtSchedgWlUUID AS SettlmtMgmtSchedgWlUUID,
  R_SetlMgmtSchedgWlRun.ApplicationJobName AS ApplicationJobName,
  R_SetlMgmtSchedgWlRun.ApplicationJob AS ApplicationJob,
  R_SetlMgmtSchedgWlRun.SetlMgmtSchedgWlRunStartDteTme AS SetlMgmtSchedgWlRunStartDteTme,
  R_SetlMgmtSchedgWlRun.SetlMgmtSchedgWlRunEndDateTime AS SetlMgmtSchedgWlRunEndDateTime,
  R_SetlMgmtSchedgWlRun.SetlMgmtSchedgWlRunStatus AS SetlMgmtSchedgWlRunStatus,
  R_SetlMgmtSchedgWlRun.CreatedByUser AS CreatedByUser,
  R_SetlMgmtSchedgWlRun.CreationUTCDateTime AS CreationUTCDateTime,
  R_SetlMgmtSchedgWlRun.LastChangedByUser AS LastChangedByUser,
  R_SetlMgmtSchedgWlRun.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  R_SetlMgmtSchedgWlRun.ApplicationLogHandle AS ApplicationLogHandle
FROM R_SetlMgmtSchedgWlRun
LEFT OUTER JOIN I_SetlMgmtSchedgWlRunStatus AS _RunStatus ON SetlMgmtSchedgWlRunStatus = _RunStatus.SetlMgmtSchedgWlRunStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN R_SetlMgmtSchedgWlRunItemTP AS _RunItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More