C_WorkView

DDL: C_WORKVIEW Type: view_entity CONSUMPTION
16 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Projection Perspective Work

C_WorkView is a Consumption CDS View that provides data about "Projection Perspective Work" in SAP S/4HANA. It reads from 1 data source (I_WorkViewTP) and exposes 16 fields with key fields WorkView, WorkViewUUID. It is exposed through 1 OData service (UI_WORKVIEW_MANAGE). It is used in 1 Fiori application: Manage Work Views.

Data Sources (1)

SourceAliasJoin Type
I_WorkViewTP I_WorkViewTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Projection Perspective Work view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_WORKVIEW_MANAGE UI_WORKVIEW_MANAGE_O2 V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5798 Manage Work Views Transactional

Manage Work Views

Business Role: Product Stewardship Specialist - Product Compliance

With this feature, you can define and provide standard work views for all users. For easy data maintenance, you can organize different basic data and compliance assessments within a work view. These views are maintained centrally and can only be changed by privileged users.

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkView WorkView Work View ID
KEY WorkViewUUID WorkViewUUID Work View
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedByUser UserDescription Full Name
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName _LastChangedByUser UserDescription Full Name
WorkViewName WorkViewName Work View Name
WorkViewScope WorkViewScope
WorkViewScopeText _WorkViewScope WorkViewScopeText
WorkViewStatus WorkViewStatus
WorkViewStatusText _WorkViewStaus WorkViewStatusText
WorkViewStsCriticality WorkViewStsCriticality
WorkViewNameInCurLanguage WorkViewNameInCurLanguage
WorkViewNameInEnglish WorkViewNameInEnglish
_WorkViewScope _WorkViewScope
_WorkViewStaus _WorkViewStaus

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_WorkView.
-- 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_WorkView AS
SELECT
  WorkView,
  WorkViewUUID,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  WorkViewName,
  WorkViewScope,
  _WorkViewScope.WorkViewScopeText AS WorkViewScopeText,
  WorkViewStatus,
  _WorkViewStaus.WorkViewStatusText AS WorkViewStatusText,
  WorkViewStsCriticality,
  WorkViewNameInCurLanguage,
  WorkViewNameInEnglish
FROM I_WorkViewTP
;

Learn More