SUIM_USER_VALID_STATE

CDS View

SUIM | Get User Valid Status

SUIM_USER_VALID_STATE is a CDS View in S/4HANA. SUIM | Get User Valid Status. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_USER_ALL_VALID_F4 view_entity from SUIM Value Help for all Valid Users
I_USER_F4 view_entity from SUIM Simple Value Help for Dialog Users

Fields (2)

KeyField CDS FieldsUsed in Views
KEY bname bname 2
class Class 2 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SUIM | Get User Valid Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
//----------------------------------------------------------------------

// SUIM helper view to get status flags regarding user valid status

// - used in public helper view I_USER_F4

// - ask the owner before reuse

//----------------------------------------------------------------------

define view entity SUIM_USER_VALID_STATE
  as select from usr02 as usr02
{
  key usr02.bname as bname,
      usr02.class as class,
      case when ( usr02.gltgv  <= $session.system_date and usr02.gltgb >= $session.system_date ) then 'X'
           else ''
      end   as time_intv_valid,

      case usr02.uflag
        when 0   then 'X'
        when 128 then 'X'  // Locked Due To Incorrect Logons (Limited Term) ... SSO is possible

        else ''
      end   as user_unlocked,

      case when usr02.zbvmaster = 'X' then ' '  // zbvmaster user ... no logon possible

           when usr02.ustyp     = 'L' then ' '  // reference user ... no logon possible

           when usr02.ustyp     = 'B' then 'T'  // system user ... background user (technical)

           when usr02.ustyp     = 'C' then 'T'  // communication user ... technical purpose

           else                            'X'  // local dialog and service user ... can be used in applications

      end   as user_dia_type
}

Learn More