I_WorkViewText

DDL: I_WORKVIEWTEXT Type: view_entity BASIC
8 Fields 1 Data Sources

Work Perspective - Text

I_WorkViewText is a Basic CDS View that provides data about "Work Perspective - Text" in SAP S/4HANA. It reads from 1 data source (ehfndd_wv_text) and exposes 8 fields with key fields WorkView, WorkViewUUID, Language.

Data Sources (1)

SourceAliasJoin Type
ehfndd_wv_text ehfndd_wv_text from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
EndUserText.label Work Perspective - Text view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkView workview Work View ID
KEY WorkViewUUID workviewuuid Work View
KEY Language language Report Text Language
WorkViewName workviewname Work View Name
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name

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 I_WorkViewText.
-- 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 I_WorkViewText AS
SELECT
  WorkView,
  WorkViewUUID,
  Language,
  WorkViewName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM ehfndd_wv_text
;

Learn More