C_SrvcDocUserStatus

DDL: C_SRVCDOCUSERSTATUS Type: view_entity CONSUMPTION Package: CRMS4_SERV_COMMON

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. It is exposed through 1 OData service (C_BUSSOLUTIONORDER_SRV). Part of development package CRMS4_SERV_COMMON.

1 data source(s) Exposed by 1 service(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 (10)

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
Analytics.technicalName CSERVUSRSTS view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSSOLUTIONORDER_SRV C_BUSSOLUTIONORDER V2 C1 NOT_RELEASED

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}
}
@Analytics.technicalName: 'CSERVUSRSTS'
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}
define view entity 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'

Learn More