I_WorkViewGroup

DDL: I_WORKVIEWGROUP Type: view BASIC

Work Perspective group

I_WorkViewGroup is a Basic CDS View that provides data about "Work Perspective group" in SAP S/4HANA. It reads from 1 data source (ehfndd_wv_group) and exposes 11 fields with key fields WorkView, WorkViewGroupUUID. It has 4 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_wv_group ehfndd_wv_group from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_WorkView _WorkView $projection.WorkViewUUID = _WorkView.WorkViewUUID
[0..1] I_WorkViewGroupText _WorkViewGroupText $projection.WorkViewGroupUUID = _WorkViewGroupText.WorkViewGroupUUID and $projection.WorkView = _WorkViewGroupText.WorkView and _WorkViewGroupText.Language = $session.system_language
[0..1] I_WorkViewGroupText _WorkViewGroupEnglishText $projection.WorkViewGroupUUID = _WorkViewGroupEnglishText.WorkViewGroupUUID and $projection.WorkView = _WorkViewGroupEnglishText.WorkView and _WorkViewGroupEnglishText.Language = 'E'
[1..*] I_WorkViewAssgmt _WorkViewAssgmt $projection.WorkViewGroupUUID = _WorkViewAssgmt.WorkViewGroupUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWORKVIEWGROUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
EndUserText.label Work Perspective group view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY WorkView workview
KEY WorkViewGroupUUID workviewgroupuuid
WorkViewUUID workviewuuid
CreationDateTime creationdatetime
CreatedByUser createdbyuser
LastChangeDateTime lastchangedatetime
LastChangedByUser lastchangedbyuser
PCPrptySequence pcprptysequence
_WorkView _WorkView
_WorkViewGroupText _WorkViewGroupText
_WorkViewAssgmt _WorkViewAssgmt 
@AbapCatalog: {
  sqlViewName: 'IWORKVIEWGROUP',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    sizeCategory: #S,
    serviceQuality: #B
  }
}
  
@EndUserText.label: 'Work Perspective group'

define view I_WorkViewGroup
  as select from ehfndd_wv_group
  // to parent / to root

  association [0..*] to I_WorkView          as _WorkView                 on  $projection.WorkViewUUID = _WorkView.WorkViewUUID
  //To child

  association [0..1] to I_WorkViewGroupText as _WorkViewGroupText        on  $projection.WorkViewGroupUUID = _WorkViewGroupText.WorkViewGroupUUID
                                                                         and $projection.WorkView = _WorkViewGroupText.WorkView
                                                                         and _WorkViewGroupText.Language   = $session.system_language

  association [0..1] to I_WorkViewGroupText as _WorkViewGroupEnglishText on  $projection.WorkViewGroupUUID      = _WorkViewGroupEnglishText.WorkViewGroupUUID
                                                                         and $projection.WorkView = _WorkViewGroupEnglishText.WorkView
                                                                         and _WorkViewGroupEnglishText.Language = 'E'

  association [1..*] to I_WorkViewAssgmt    as _WorkViewAssgmt           on  $projection.WorkViewGroupUUID = _WorkViewAssgmt.WorkViewGroupUUID

{
  key          workview                                as WorkView,
  key          workviewgroupuuid                       as WorkViewGroupUUID,

               workviewuuid                            as WorkViewUUID,

               /**** Admin Fields ****/
               @Semantics.systemDateTime.createdAt: true
               creationdatetime                        as CreationDateTime,
               @Semantics.user.createdBy: true
               createdbyuser                           as CreatedByUser,
               @Semantics.systemDateTime.lastChangedAt: true
               lastchangedatetime                      as LastChangeDateTime,
               @Semantics.user.lastChangedBy: true
               lastchangedbyuser                       as LastChangedByUser,
               //            @Semantics.user.lastChangedBy: true

               pcprptysequence                         as PCPrptySequence,

               @Semantics.text: true
               cast (
                 case
                   when _WorkViewGroupText.WorkViewGroupName is not null
                     then _WorkViewGroupText.WorkViewGroupName
                   when  _WorkViewGroupText.WorkViewGroupName is null
                   and _WorkViewGroupEnglishText.WorkViewGroupName is not null
                     then _WorkViewGroupEnglishText.WorkViewGroupName
                 end
               as ehfnd_wv_group_name preserving type) as WorkViewGroupName,


               /**** Associations ****/
               _WorkView,
               _WorkViewGroupText,
               _WorkViewAssgmt
}

Learn More