I_WorkViewGroupTP

DDL: I_WORKVIEWGROUPTP Type: view_entity TRANSACTIONAL Package: EHFND_RAP_WORK_VIEW
14 Fields 1 Data Sources 4 Associations

Work Perspective Group - TP

I_WorkViewGroupTP is a Transactional CDS View that provides data about "Work Perspective Group - TP" in SAP S/4HANA. It reads from 1 data source (I_WorkViewGroup) and exposes 14 fields with key fields WorkView, WorkViewGroupUUID. It has 4 associations to related views. Part of development package EHFND_RAP_WORK_VIEW.

Data Sources (1)

SourceAliasJoin Type
I_WorkViewGroup I_WorkViewGroup from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_WorkViewGroupTextTP _GroupTextInCurLang $projection.WorkViewGroupUUID = _GroupTextInCurLang.WorkViewGroupUUID and _GroupTextInCurLang.LanguageForEdit = $session.system_language
[0..1] I_WorkViewGroupTextTP _GroupTextInEnglish $projection.WorkViewGroupUUID = _GroupTextInEnglish.WorkViewGroupUUID and _GroupTextInEnglish.LanguageForEdit = 'E'
[1..*] I_WorkViewGroupTextTP _GroupText
[1..*] I_WorkViewAssgmtTP _Assgmt

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Perspective Group - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkView WorkView Work View ID
KEY WorkViewGroupUUID WorkViewGroupUUID Work View Group
WorkViewUUID WorkViewUUID Work View
PCPrptySequence PCPrptySequence Sequence
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
WorkViewGroupNameendasWorkViewGroupName
_GroupText _GroupText
_Assgmt _Assgmt
_WorkView _WorkView
_GroupTextInCurLang _GroupTextInCurLang
_GroupTextInEnglish _GroupTextInEnglish

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_WorkViewGroupTP.
-- 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_WorkViewGroupTP AS
SELECT
  WorkView,
  WorkViewGroupUUID,
  WorkViewUUID,
  PCPrptySequence,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  case when _GroupTextInCurLang.WorkViewGroupName is not null then _GroupTextInCurLang.WorkViewGroupName else _GroupTextInEnglish.WorkViewGroupName end as WorkViewGroupName AS WorkViewGroupNameendasWorkViewGroupName
FROM I_WorkViewGroup
LEFT OUTER JOIN I_WorkViewGroupTextTP AS _GroupTextInCurLang ON WorkViewGroupUUID = _GroupTextInCurLang.WorkViewGroupUUID AND _GroupTextInCurLang.LanguageForEdit = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkViewGroupTextTP AS _GroupTextInEnglish ON WorkViewGroupUUID = _GroupTextInEnglish.WorkViewGroupUUID AND _GroupTextInEnglish.LanguageForEdit = 'E'  -- association [0..1]
LEFT OUTER JOIN I_WorkViewGroupTextTP AS _GroupText ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_WorkViewAssgmtTP AS _Assgmt ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More