I_WorkViewAssgmt

DDL: I_WORKVIEWASSGMT Type: view BASIC

Work Perspective Assignment

I_WorkViewAssgmt is a Basic CDS View that provides data about "Work Perspective Assignment" in SAP S/4HANA. It reads from 1 data source (ehfndd_wv_assgmt) and exposes 15 fields with key fields WorkView, WorkViewAssgmtUUID. It has 2 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_wv_assgmt ehfndd_wv_assgmt from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_WorkViewGroup _WorkViewGroup $projection.WorkViewGroupUUID = _WorkViewGroup.WorkViewGroupUUID
[0..*] I_WorkView _WorkView $projection.WorkViewUUID = _WorkView.WorkViewUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWORKVIEWASSGMT 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 Assignment view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkView workview
KEY WorkViewAssgmtUUID workviewassgmtuuid
WorkViewUUID workviewuuid
ComplianceRequirement compliancerequirement
WorkViewComposition workviewcomposition
WorkViewProperty workviewproperty
WorkViewDataType workviewdatatype
WorkViewGroupUUID workviewgroupuuid
ProdCmplncLegalArea prodcmplnclegalarea
CreationDateTime creationdatetime
CreatedByUser createdbyuser
LastChangeDateTime lastchangedatetime
LastChangedByUser lastchangedbyuser
_WorkView _WorkView
_WorkViewGroup _WorkViewGroup 
@AbapCatalog: {
  sqlViewName: 'IWORKVIEWASSGMT',
  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 Assignment'
define view I_WorkViewAssgmt
  as select from ehfndd_wv_assgmt
  // to parent

  association [0..*] to I_WorkViewGroup as _WorkViewGroup on $projection.WorkViewGroupUUID = _WorkViewGroup.WorkViewGroupUUID
  // to root

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

{
         @Consumption.filter.hidden: true
  key    workview              as WorkView,
  key    workviewassgmtuuid    as WorkViewAssgmtUUID,

         workviewuuid          as WorkViewUUID,
         compliancerequirement as ComplianceRequirement,
         workviewcomposition   as WorkViewComposition,
         workviewproperty      as WorkViewProperty,
         workviewdatatype      as WorkViewDataType,
         workviewgroupuuid     as WorkViewGroupUUID,
         prodcmplnclegalarea   as ProdCmplncLegalArea,
         

         /**** 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,

         //      region                as Region,


         /**** Associations ****/
         _WorkView,
         _WorkViewGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDD_WV_ASSGMT"
],
"ASSOCIATED":
[
"I_WORKVIEW",
"I_WORKVIEWGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More