I_SUBSCRPNCONTRUSERSTATUS

CDS View

Contract User Status

I_SUBSCRPNCONTRUSERSTATUS is a CDS View in S/4HANA. Contract User Status. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SubscrpnContrUserStatusTP view_entity from TRANSACTIONAL Contract User Status - TP 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Contract User Status'

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity I_SubscrpnContrUserStatus
  as select from I_SrvcMgmtObjectStatus as SubscrpnContrSts
    inner join   P_StatusObjectWithGUID as StatusObject  on SubscrpnContrSts.SrvcMgmtObjectUUID = StatusObject.StatusObjectUUID
    inner join   I_SubscriptionContract  as SubscriptionContract on  SubscrpnContrSts.SrvcMgmtObjectUUID = SubscriptionContract.SubscriptionContractUUID
                                                                 and SubscrpnContrSts.SrvcMgmtObjectStatus           like 'E%'
                                                                 and SubscrpnContrSts.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
{
  key SubscriptionContract.SubscriptionContract,
      @ObjectModel.foreignKey.association: '_StatusCode'
  key SubscrpnContrSts.SrvcMgmtObjectStatus as UserStatus,

      @ObjectModel.foreignKey.association: '_StatusProfile'
      StatusObject.StatusProfile               as StatusProfile,

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

Learn More