I_SrvcTransMstrAgrmtUserStatus

DDL: I_SRVCTRANSMSTRAGRMTUSERSTATUS Type: view_entity COMPOSITE

Master Agreement User Status

I_SrvcTransMstrAgrmtUserStatus is a Composite CDS View that provides data about "Master Agreement User Status" in SAP S/4HANA. It reads from 3 data sources (I_SrvcTransMasterAgreement, I_SrvcMgmtObjectStatus, P_StatusObjectWithGUID) and exposes 6 fields with key fields SrvcTransMstrAgrmtID, UserStatus. It has 3 associations to related views.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_SrvcTransMasterAgreement MasterAgreement inner
I_SrvcMgmtObjectStatus MasterAgreementStatus from
P_StatusObjectWithGUID StatusObject inner

Associations (3)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Master Agreement User Status view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SrvcTransMstrAgrmtID I_SrvcTransMasterAgreement SrvcTransMstrAgrmtID
KEY UserStatus I_SrvcMgmtObjectStatus SrvcMgmtObjectStatus
StatusProfile P_StatusObjectWithGUID StatusProfile
_StatusCode _StatusCode
_StatusProfile _StatusProfile
_MasterAgreement _MasterAgreement 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

@EndUserText.label: 'Master Agreement User Status'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity I_SrvcTransMstrAgrmtUserStatus
  as select from I_SrvcMgmtObjectStatus     as MasterAgreementStatus
    inner join   P_StatusObjectWithGUID     as StatusObject    on MasterAgreementStatus.SrvcMgmtObjectUUID = StatusObject.StatusObjectUUID
    inner join   I_SrvcTransMasterAgreement as MasterAgreement on  MasterAgreementStatus.SrvcMgmtObjectUUID             =    MasterAgreement.SrvcTransMstrAgrmtUUID
                                                               and MasterAgreement.SrvcTransMstrAgrmtType               =    'BUS2000267'
                                                               and MasterAgreementStatus.SrvcMgmtObjectStatus           like 'E%'
                                                               and MasterAgreementStatus.SrvcMgmtObjectStatusIsInactive =    ' '

  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
  association [1..1] to I_SrvcTransMasterAgreement as _MasterAgreement on  $projection.SrvcTransMstrAgrmtID = _MasterAgreement.SrvcTransMstrAgrmtID

{
  key MasterAgreement.SrvcTransMstrAgrmtID       as SrvcTransMstrAgrmtID,
      @ObjectModel.foreignKey.association: '_StatusCode'
  key MasterAgreementStatus.SrvcMgmtObjectStatus as UserStatus,
      @ObjectModel.foreignKey.association: '_StatusProfile'
      StatusObject.StatusProfile                 as StatusProfile,

      // Associations

      _StatusCode,
      _StatusProfile,
      _MasterAgreement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SRVCMGMTOBJECTSTATUS",
"I_SRVCTRANSMASTERAGREEMENT",
"P_STATUSOBJECTWITHGUID"
],
"ASSOCIATED":
[
"I_SRVCTRANSMASTERAGREEMENT",
"I_STATUSCODE",
"I_STATUSPROFILE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More