I_DraftUserEditingState

DDL: I_DRAFTUSEREDITINGSTATE Type: view_entity Package: SBOI_RAP_SERVICES_DSP_ADMIN

Draft User Editing State

I_DraftUserEditingState is a CDS View that provides data about "Draft User Editing State" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field DraftUserEditingState. It has 1 association to related views. Part of development package SBOI_RAP_SERVICES_DSP_ADMIN.

Data Sources (1)

SourceAliasJoin Type
dd07l value from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_DraftUserEditingStateText _Text _Text.DraftUserEditingState = $projection.DraftUserEditingState

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Draft User Editing State view
Search.searchable true view
ObjectModel.resultSet.sizeCategory #XS view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DraftUserEditingState
domvalue_h domvalue_h
_Text _Text
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Draft User Editing State'

@Search.searchable:                true
@ObjectModel : { resultSet.sizeCategory: #XS }

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view entity I_DraftUserEditingState

  as select from dd07l as value
  association [0..*] to I_DraftUserEditingStateText as _Text on _Text.DraftUserEditingState = $projection.DraftUserEditingState
{
      @Search.defaultSearchElement: true
      @ObjectModel.text.association: '_Text'
  key cast( substring( value.domvalue_l, 1, 1 ) as sdraft_user_role preserving type ) as DraftUserEditingState,

      @Consumption.hidden:true
      domvalue_h,

      //@Consumption.hidden:true

      _Text 
}
where
      value.domname    = 'SDRAFT_USER_EDITING_STATE'
  and value.domvalue_l is not initial