P_MaintStsNumberedUserStatus

DDL: P_MAINTSTSNUMBEREDUSERSTATUS SQL: PMNTSTSNUMUSTS Type: view COMPOSITE

P_MaintStsNumberedUserStatus is a Composite CDS View 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.

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 (8)

NameValueLevelField
AbapCatalog.sqlViewName PMNTSTSNUMUSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObject StatusObject
StatusProfile I_StatusObject StatusProfile
StatusCode I_StatusObjectStatusBasic StatusCode
_UserStatus _UserStatus
_UserStatusText _UserStatusText 
@AbapCatalog.sqlViewName: 'PMNTSTSNUMUSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

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

@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}

//@EndUserText.label: 'Maint. Object with numbered User Status'


define view 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUSBASIC",
"I_USERSTATUS"
],
"ASSOCIATED":
[
"I_USERSTATUS",
"I_USERSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More