P_MaintStsNumberedUserStatus

DDL: P_MAINTSTSNUMBEREDUSERSTATUS Type: view_entity COMPOSITE Package: ODATA_EAM_COMMON

Order User Status w/ Sequence Number

P_MaintStsNumberedUserStatus is a Composite CDS View that provides data about "Order User Status w/ Sequence Number" in SAP S/4HANA. It reads from 1 data source (I_StatusObject) and exposes 5 fields with key field StatusObject. It has 2 associations to related views. Part of development package ODATA_EAM_COMMON.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObject I_StatusObject from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserStatus _UserStatus _UserStatus.UserStatus = I_StatusObjectStatusBasic.StatusCode and _UserStatus.StatusProfile = I_StatusObject.StatusProfile
[0..1] I_UserStatusText _UserStatusText _UserStatusText.StatusProfile = I_StatusObject.StatusProfile and _UserStatusText.UserStatus = I_StatusObjectStatusBasic.StatusCode and _UserStatusText.Language = $session.system_language

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObject StatusObject
StatusProfile I_StatusObject StatusProfile
StatusCode I_StatusObjectStatusBasic StatusCode
_UserStatus _UserStatus
_UserStatusText _UserStatusText 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: {
    viewType: #COMPOSITE,
    private: true
}

define view entity P_MaintStsNumberedUserStatus
  as select from  I_StatusObject
    left outer to many join I_StatusObjectStatusBasic on I_StatusObjectStatusBasic.StatusObject = I_StatusObject.StatusObject
  association [0..1] to I_UserStatus     as _UserStatus     on  _UserStatus.UserStatus    = I_StatusObjectStatusBasic.StatusCode
                                                            and _UserStatus.StatusProfile = I_StatusObject.StatusProfile
  association [0..1] to I_UserStatusText as _UserStatusText on  _UserStatusText.StatusProfile = I_StatusObject.StatusProfile
                                                            and _UserStatusText.UserStatus    = I_StatusObjectStatusBasic.StatusCode
                                                            and _UserStatusText.Language      = $session.system_language

{
  key I_StatusObject.StatusObject,

      I_StatusObject.StatusProfile,
      I_StatusObjectStatusBasic.StatusCode,

      _UserStatus,
      _UserStatusText
}
where
      I_StatusObjectStatusBasic.StatusIsInactive =    ''
  and I_StatusObjectStatusBasic.StatusCode       like 'E%'
  and _UserStatus.StatusSequenceNumber           <>   '00'

Learn More