P_EAMUserStatusSequence

DDL: P_EAMUSERSTATUSSEQUENCE SQL: PEAMUSRSTATSEQ Type: view BASIC Package: EAM_OVRL_STS

EAM User Status Sequence

P_EAMUserStatusSequence is a Basic CDS View that provides data about "EAM User Status Sequence" in SAP S/4HANA. It reads from 2 data sources (tj30, tj30) and exposes 3 fields with key fields StatusProfile, UserStatus, FollowOnUserStatus. Part of development package EAM_OVRL_STS.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
tj30 _next left_outer
tj30 _this from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PEAMUSRSTATSEQ view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY StatusProfile tj30 stsma
KEY UserStatus tj30 estat
KEY FollowOnUserStatus tj30 estat 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PEAMUSRSTATSEQ'
define view P_EAMUserStatusSequence
  as select from tj30 as _this
  left outer join tj30 as _next on _next.stsma = _this.stsma
                                and _next.stonr <> _this.stonr
                                and _next.stonr <= _this.hsonr
                                and _next.stonr >= _this.nsonr
{
  key _this.stsma as StatusProfile,
  key _this.estat as UserStatus,
  key _next.estat as FollowOnUserStatus
}

Learn More