I_WORKVIEWASSGMT

CDS View

Work Perspective Assignment

I_WORKVIEWASSGMT is a CDS View in S/4HANA. Work Perspective Assignment. It contains 13 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 13 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_ChmlCmplncInfoAssmtCmbnd view inner CONSUMPTION CCI assignments combined
P_ChmlCmplncInfoCmpstnCmbnd view inner CONSUMPTION CCI Composition Combined
P_WorkViewAssgmtPrptyRootType view from CONSUMPTION Work perspective assignment property root type

Fields (13)

KeyField CDS FieldsUsed in Views
KEY WorkView WorkView 3
KEY WorkViewAssgmtUUID WorkViewAssgmtUUID 1
ComplianceRequirement ComplianceRequirement 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ProdCmplncLegalArea ProdCmplncLegalArea 1
WorkViewComposition ChmlCompositionType,WorkViewComposition 1
WorkViewDataType WorkViewDataType 1
WorkViewGroupUUID WorkViewGroupUUID 1
WorkViewProperty WorkViewProperty 1
WorkViewUUID WorkViewUUID 3 
@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
}

Learn More