C_SrvcDocUserStatus

DDL: C_SRVCDOCUSERSTATUS Type: view CONSUMPTION

Service Transaction User Status

C_SrvcDocUserStatus is a Consumption CDS View that provides data about "Service Transaction User Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectUUIDStatus) and exposes 8 fields with key fields UserStatus, StatusObjectUUID. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectUUIDStatus I_StatusObjectUUIDStatus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StatusCode _StatusCode $projection.UserStatus = _StatusCode.StatusCode and $projection.StatusProfile = _StatusCode.StatusProfile
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (13)

NameValueLevelField
EndUserText.label Service Transaction User Status view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey UserStatus view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CSERVUSRSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UserStatus StatusCode
KEY StatusObjectUUID StatusObjectUUID
StatusProfile StatusProfile
UserStatusName
StatusProfileName
_StatusCode _StatusCode
_StatusProfile _StatusProfile
_StatusObjectUUID _StatusObjectUUID 
@EndUserText.label: 'Service Transaction User Status'
@VDM: {
  viewType: #CONSUMPTION
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ObjectModel: {
  representativeKey: 'UserStatus',
  usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #CUSTOMIZING}
}
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
  sqlViewName: 'CSERVUSRSTS',
  compiler.compareFilter: true,
  preserveKey: true
}

define view C_SrvcDocUserStatus
  as select from I_StatusObjectUUIDStatus
  association [0..1] to I_StatusCode    as _StatusCode    on  $projection.UserStatus    = _StatusCode.StatusCode
                                                          and $projection.StatusProfile = _StatusCode.StatusProfile
  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile
{
      @ObjectModel.text.element: ['UserStatusName']
  key StatusCode                                                                       as UserStatus,
      @ObjectModel.foreignKey.association: '_StatusObjectUUID'
  key StatusObjectUUID,
      @ObjectModel.text.element: ['StatusProfileName']
      StatusProfile,
      @Semantics.text: true
      _StatusCode._StatusCodeText[ 1: Language = $session.system_language ].StatusName as UserStatusName,
      @Semantics.text: true
      _StatusProfile._StatusProfileText[ 1: Language = $session.system_language ].StatusProfileName,

      /* Associations */
      _StatusCode,
      _StatusProfile,
      _StatusObjectUUID
}
where
      IsUserStatus   = 'X'
  and StatusIsActive = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSCODE",
"I_STATUSCODETEXT",
"I_STATUSOBJECTUUIDSTATUS",
"I_STATUSPROFILE",
"I_STATUSPROFILETEXT"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECTUUID",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTUUIDSTATUS"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More