C_SetlMgmtSchedgWlItem_F5856

DDL: C_SETLMGMTSCHEDGWLITEM_F5856 Type: view_entity CONSUMPTION
13 Fields 1 Data Sources

Manage Scheduling Worklist Item

C_SetlMgmtSchedgWlItem_F5856 is a Consumption CDS View that provides data about "Manage Scheduling Worklist Item" in SAP S/4HANA. It reads from 1 data source (R_SetlMgmtSchedgWlItemTP) and exposes 13 fields with key fields SettlmtMgmtSchedgWlUUID, SettlmtMgmtSchedgWlItem.

Data Sources (1)

SourceAliasJoin Type
R_SetlMgmtSchedgWlItemTP R_SetlMgmtSchedgWlItemTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Manage Scheduling Worklist Item view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SettlmtMgmtSchedgWlUUID SettlmtMgmtSchedgWlUUID
KEY SettlmtMgmtSchedgWlItem SettlmtMgmtSchedgWlItem
SettlmtMgmtSchedgWl SettlmtMgmtSchedgWl
SettlmtMgmtDoc SettlmtMgmtDoc Document Number
ConditionContract ConditionContract Condition Contract
SettlmtDate SettlmtDate Settlement Date
SettlmtDateCat SettlmtDateCat Settlement Date Type
SettlmtDateCatNamelocalized
SettlmtMgmtSchedgWlItemStatus SettlmtMgmtSchedgWlItemStatus
SetlMgmtSchedgWlLastRunItmSts SetlMgmtSchedgWlLastRunItmSts
SettlmtMgmtSchedgWlItemStsNamelocalized
CreatedByUser CreatedByUser User Name
CreationUTCDateTime CreationUTCDateTime Time Stamp

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 C_SetlMgmtSchedgWlItem_F5856.
-- 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 C_SetlMgmtSchedgWlItem_F5856 AS
SELECT
  SettlmtMgmtSchedgWlUUID,
  SettlmtMgmtSchedgWlItem,
  SettlmtMgmtSchedgWl,
  SettlmtMgmtDoc,
  ConditionContract,
  SettlmtDate,
  SettlmtDateCat,
  _SettlmtDateCat._Text.SettlmtDateCatName : localized AS SettlmtDateCatNamelocalized,
  SettlmtMgmtSchedgWlItemStatus,
  SetlMgmtSchedgWlLastRunItmSts,
  _WorklistItemStatus._Text.SettlmtMgmtSchedgWlItemStsName : localized AS SettlmtMgmtSchedgWlItemStsNamelocalized,
  CreatedByUser,
  CreationUTCDateTime
FROM R_SetlMgmtSchedgWlItemTP
;

Learn More