R_SetlMgmtSchedgWlRunItemTP

DDL: R_SETLMGMTSCHEDGWLRUNITEMTP Type: view_entity TRANSACTIONAL
14 Fields 1 Data Sources 4 Associations

Scheduling Worklist Run Item - TP

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

Data Sources (1)

SourceAliasJoin Type
R_SetlMgmtSchedgWlRunItem R_SetlMgmtSchedgWlRunItem from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_SetlMgmtSchedgWlTP _Worklist $projection.SettlmtMgmtSchedgWlUUID = _Worklist.SettlmtMgmtSchedgWlUUID
[0..1] R_SetlMgmtSchedgWlItemTP _Item $projection.SettlmtMgmtSchedgWlUUID = _Item.SettlmtMgmtSchedgWlUUID and $projection.SettlmtMgmtSchedgWlItem = _Item.SettlmtMgmtSchedgWlItem
[0..1] I_SetlMgmtSchedgWlItemStatus _WorklistItemStatus $projection.SetlMgmtSchedgWlRunItemStatus = _WorklistItemStatus.SettlmtMgmtSchedgWlItemStatus
[0..1] I_SettlmtDateCat _SettlmtDateCat $projection.SettlmtDateCat = _SettlmtDateCat.SettlmtDateCat

Annotations (8)

NameValueLevelField
EndUserText.label Scheduling Worklist Run Item - 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 (14)

KeyFieldSource TableSource FieldDescription
KEY SetlMgmtSchedgWlRunItmUUID R_SetlMgmtSchedgWlRunItem SetlMgmtSchedgWlRunItmUUID Scheduling Worklist Run Item UUID
SetlMgmtSchedgWlRunUUID R_SetlMgmtSchedgWlRunItem SetlMgmtSchedgWlRunUUID Scheduling Worklist Run UUID
SettlmtMgmtSchedgWlUUID R_SetlMgmtSchedgWlRunItem SettlmtMgmtSchedgWlUUID Scheduling Worklist UUID
SettlmtMgmtSchedgWlItem R_SetlMgmtSchedgWlRunItem SettlmtMgmtSchedgWlItem Scheduling Worklist Item
SettlmtMgmtDoc R_SetlMgmtSchedgWlRunItem SettlmtMgmtDoc Document Number
ConditionContract R_SetlMgmtSchedgWlRunItem ConditionContract Condition Contract
SettlmtDate R_SetlMgmtSchedgWlRunItem SettlmtDate Settlement Date
SettlmtDateCat R_SetlMgmtSchedgWlRunItem SettlmtDateCat Settlement Date Type
SetlMgmtSchedgWlRunItemStatus R_SetlMgmtSchedgWlRunItem SetlMgmtSchedgWlRunItemStatus Scheduling Worklist Item Status
_Run _Run
_Worklist _Worklist
_Item _Item
_WorklistItemStatus _WorklistItemStatus
_SettlmtDateCat _SettlmtDateCat

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_SetlMgmtSchedgWlRunItemTP.
-- 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_SetlMgmtSchedgWlRunItemTP AS
SELECT
  R_SetlMgmtSchedgWlRunItem.SetlMgmtSchedgWlRunItmUUID AS SetlMgmtSchedgWlRunItmUUID,
  R_SetlMgmtSchedgWlRunItem.SetlMgmtSchedgWlRunUUID AS SetlMgmtSchedgWlRunUUID,
  R_SetlMgmtSchedgWlRunItem.SettlmtMgmtSchedgWlUUID AS SettlmtMgmtSchedgWlUUID,
  R_SetlMgmtSchedgWlRunItem.SettlmtMgmtSchedgWlItem AS SettlmtMgmtSchedgWlItem,
  R_SetlMgmtSchedgWlRunItem.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  R_SetlMgmtSchedgWlRunItem.ConditionContract AS ConditionContract,
  R_SetlMgmtSchedgWlRunItem.SettlmtDate AS SettlmtDate,
  R_SetlMgmtSchedgWlRunItem.SettlmtDateCat AS SettlmtDateCat,
  R_SetlMgmtSchedgWlRunItem.SetlMgmtSchedgWlRunItemStatus AS SetlMgmtSchedgWlRunItemStatus
FROM R_SetlMgmtSchedgWlRunItem
LEFT OUTER JOIN R_SetlMgmtSchedgWlTP AS _Worklist ON SettlmtMgmtSchedgWlUUID = _Worklist.SettlmtMgmtSchedgWlUUID  -- association [1..1]
LEFT OUTER JOIN R_SetlMgmtSchedgWlItemTP AS _Item ON SettlmtMgmtSchedgWlUUID = _Item.SettlmtMgmtSchedgWlUUID AND SettlmtMgmtSchedgWlItem = _Item.SettlmtMgmtSchedgWlItem  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlItemStatus AS _WorklistItemStatus ON SetlMgmtSchedgWlRunItemStatus = _WorklistItemStatus.SettlmtMgmtSchedgWlItemStatus  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDateCat AS _SettlmtDateCat ON SettlmtDateCat = _SettlmtDateCat.SettlmtDateCat  -- association [0..1]
;

Learn More