C_ChangeRecordStatusProgress

DDL: C_CHANGERECORDSTATUSPROGRESS SQL: CCRSTATPRGS Type: view CONSUMPTION

Change record statuses in Graph

C_ChangeRecordStatusProgress is a Consumption CDS View that provides data about "Change record statuses in Graph" in SAP S/4HANA. It has 1 association to related views.

7 fields

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChgMgmtUserStatusText _ChgMgmtUserStatusText _ChangeRecordStatusProgress.ChangeRecordStatus = _ChgMgmtUserStatusText.ChgMgmtUserStatus and _ChgMgmtUserStatusText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCRSTATPRGS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change record statuses in Graph view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID _ChangeRecordStatusProgress ChangeRecordUUID
KEY ChangeRecordType _ChangeRecordStatusProgress ChangeRecordType
KEY ChangeRecordStatus _ChangeRecordStatusProgress ChangeRecordStatus
ChangeRecordStatusPosition
ChangeRecordStatusAction
ChangeRecordStatusText
ChangeRecordStatusIcon 
@AbapCatalog.sqlViewName: 'CCRSTATPRGS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Change record statuses in Graph'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #S
                        }
define view C_ChangeRecordStatusProgress
  as select distinct from  P_ChangeRecordStatusProgress as _ChangeRecordStatusProgress

    left outer to one join I_ChangeDocumentItem         as _ChangeDocumentItem on  _ChangeDocumentItem.ChangeDocObject             = bintohex(
      _ChangeRecordStatusProgress.ChangeRecordUUID
    )
                                                                               and _ChangeDocumentItem.DatabaseTable               = '/IAM/D_I_ROOT'
                                                                               and _ChangeDocumentItem.ChangeDocDatabaseTableField = 'USER_STATUS_01'
                                                                               and _ChangeDocumentItem.ChangeDocNewFieldValue      = _ChangeRecordStatusProgress.ChangeRecordStatus

  association [1..1] to I_ChgMgmtUserStatusText as _ChgMgmtUserStatusText on  _ChangeRecordStatusProgress.ChangeRecordStatus = _ChgMgmtUserStatusText.ChgMgmtUserStatus
                                                                          and _ChgMgmtUserStatusText.Language                = $session.system_language
{
  key _ChangeRecordStatusProgress.ChangeRecordUUID,
  key _ChangeRecordStatusProgress.ChangeRecordType,
  key _ChangeRecordStatusProgress.ChangeRecordStatus,
      min( _ChangeRecordStatusProgress.ChangeRecordStatusPosition ) as ChangeRecordStatusPosition,
      min( _ChangeRecordStatusProgress.ChangeRecordStatusAction )   as ChangeRecordStatusAction,
      min( _ChgMgmtUserStatusText.ChgMgmtUserStatusText )           as ChangeRecordStatusText,
      min( _ChangeRecordStatusProgress.ChangeRecordStatusIcon )     as ChangeRecordStatusIcon,

      cast( case
                    when _ChangeDocumentItem.ChangeDocNewFieldValue is null then '' else 'X'
                  end as boole_d )                                  as ChangeRecordStatusIsComplete

}
group by
  _ChangeRecordStatusProgress.ChangeRecordUUID,
  _ChangeRecordStatusProgress.ChangeRecordType,
  _ChangeRecordStatusProgress.ChangeRecordStatus,
  _ChangeDocumentItem.ChangeDocNewFieldValue
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM",
"I_CHGMGMTUSERSTATUSTEXT",
"P_CHANGERECORDSTATUSPROGRESS"
],
"ASSOCIATED":
[
"I_CHGMGMTUSERSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More