I_WorkView

DDL: I_WORKVIEW Type: view BASIC

Work Perspective

I_WorkView is a Basic CDS View that provides data about "Work Perspective" in SAP S/4HANA. It reads from 1 data source (ehfndd_wv) and exposes 14 fields with key fields WorkView, WorkViewUUID. It has 6 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_wv ehfndd_wv from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_WorkViewText _WorkViewText $projection.WorkViewUUID = _WorkViewText.WorkViewUUID
[1..*] I_WorkViewGroup _WorkViewGroup $projection.WorkViewUUID = _WorkViewGroup.WorkViewUUID
[0..*] I_WorkViewScopeText _WorkViewScope $projection.WorkViewScope = _WorkViewScope.WorkViewScope
[0..*] I_WorkViewStatusText _WorkViewStaus $projection.WorkViewStatus = _WorkViewStaus.WorkViewStatus
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWORKVIEW 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
ObjectModel.representativeKey WorkViewUUID view
EndUserText.label Work Perspective view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkView workview
KEY WorkViewUUID workviewuuid
CreationDateTime creationdatetime
CreatedByUser createdbyuser
LastChangeDateTime lastchangedatetime
LastChangedByUser lastchangedbyuser
WorkViewScope scope
WorkViewStatus status
_WorkViewText _WorkViewText
_WorkViewGroup _WorkViewGroup
_WorkViewScope _WorkViewScope
_WorkViewStaus _WorkViewStaus
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog: {
  sqlViewName: 'IWORKVIEW',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl: { 
    authorizationCheck: #CHECK,
    privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

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

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

define view I_WorkView
  as select from ehfndd_wv

  // to child

  association [1..*] to I_WorkViewText       as _WorkViewText       on $projection.WorkViewUUID = _WorkViewText.WorkViewUUID

  association [1..*] to I_WorkViewGroup      as _WorkViewGroup      on $projection.WorkViewUUID = _WorkViewGroup.WorkViewUUID

  association [0..*] to I_WorkViewScopeText  as _WorkViewScope      on $projection.WorkViewScope = _WorkViewScope.WorkViewScope

  association [0..*] to I_WorkViewStatusText as _WorkViewStaus      on $projection.WorkViewStatus = _WorkViewStaus.WorkViewStatus
  
  association [0..1] to I_User               as _CreatedByUser      on  $projection.CreatedByUser           = _CreatedByUser.UserID
  association [0..1] to I_User               as _LastChangedByUser  on  $projection.LastChangedByUser       = _LastChangedByUser.UserID
 
{
  key    workview           as WorkView,
  key    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,

         scope              as WorkViewScope,
         status             as WorkViewStatus,

         /**** Associations ****/
         _WorkViewText,
         _WorkViewGroup,
         _WorkViewScope,
         _WorkViewStaus,
         _CreatedByUser,
         _LastChangedByUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDD_WV"
],
"ASSOCIATED":
[
"I_USER",
"I_WORKVIEWGROUP",
"I_WORKVIEWSCOPETEXT",
"I_WORKVIEWSTATUSTEXT",
"I_WORKVIEWTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More