C_SrvcDocChangeDocument

DDL: C_SRVCDOCCHANGEDOCUMENT SQL: CSRVCDOCCD Type: view CONSUMPTION

Change Documents For Service

C_SrvcDocChangeDocument is a Consumption CDS View (Dimension) that provides data about "Change Documents For Service" in SAP S/4HANA. It reads from 1 data source (I_SrvcDocChangeDocument) and exposes 18 fields with key fields ChangeDocument, ChangeDocObject, DatabaseTable, ChangeDocTableKey, ChangeDocDatabaseTableField. It has 3 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_SrvcDocChangeDocument I_SrvcDocChangeDocument from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ChangeDocChangeIndT _ChangeInd $projection.ChangeDocChangeType = _ChangeInd.Value and _ChangeInd.Language = $session.system_language
[0..1] I_ChangeDocFieldNamesT _FieldName _FieldName.DatabaseTable = $projection.DatabaseTable and _FieldName.Value = $projection.ChangeDocDatabaseTableField and _FieldName.Language = $session.system_language
[0..1] I_ChangeDocUser _User $projection.CreatedByUser = _User.UserName

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCDOCCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Documents For Service view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocument ChangeDocument
KEY ChangeDocObject ChangeDocObject
KEY DatabaseTable DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocChangeType ChangeDocChangeType
KEY SrvcMgmtObjectStatus SrvcMgmtObjectStatus
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
ServiceDocChangedDateTime ServiceDocChangedDateTime
CreatedByUser CreatedByUser
ChangeDocObjectDescription ChangeDocObjectDescription
ChangeDocObjectClass ChangeDocObjectClass
TableChangeLogTableFieldName _FieldName Text
CreatedByUserName _User NAME_TEXTC
ChangeDocChangeTypeText _ChangeInd Text
_ChangeInd _ChangeInd
_FieldName _FieldName 
@AbapCatalog.sqlViewName: 'CSRVCDOCCD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Change Documents For Service'
@UI.presentationVariant: [{requestAtLeast: ['ChangeDocObjectClass','SrvcMgmtObjectStatus','TableChangeLogTableFieldName']}]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM: {
  viewType: #CONSUMPTION
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@Analytics.internalName:#LOCAL
@Metadata.allowExtensions:true
define view C_SrvcDocChangeDocument
  as select from I_SrvcDocChangeDocument
  association [0..1] to I_ChangeDocChangeIndT  as _ChangeInd on  $projection.ChangeDocChangeType = _ChangeInd.Value
                                                             and _ChangeInd.Language             = $session.system_language
  association [0..1] to I_ChangeDocFieldNamesT as _FieldName on  _FieldName.DatabaseTable = $projection.DatabaseTable
                                                             and _FieldName.Value         = $projection.ChangeDocDatabaseTableField
                                                             and _FieldName.Language      = $session.system_language
  association [0..1] to I_ChangeDocUser        as _User      on  $projection.CreatedByUser = _User.UserName

{
  key ChangeDocument,
  key ChangeDocObject,
  key DatabaseTable,
  key ChangeDocTableKey,
      @ObjectModel.text.element: ['TableChangeLogTableFieldName']
      //@ObjectModel.filter.enabled : false

  key ChangeDocDatabaseTableField,

      //@ObjectModel.text.association: '_ChangeInd'

      @ObjectModel.text.element: ['ChangeDocChangeTypeText']
  key ChangeDocChangeType,

  key SrvcMgmtObjectStatus,


      ChangeDocNewFieldValue,


      ChangeDocPreviousFieldValue,


      ServiceDocChangedDateTime,

      @ObjectModel.text.element: ['CreatedByUserName']
      CreatedByUser,


      @ObjectModel.filter.enabled : false
      ChangeDocObjectDescription,

      @ObjectModel.filter.enabled : false
      ChangeDocObjectClass,

      _FieldName.Text  as TableChangeLogTableFieldName,

      _User.NAME_TEXTC as CreatedByUserName,

      _ChangeInd.Text  as ChangeDocChangeTypeText,

      _ChangeInd,
      _FieldName

}

Learn More