I_ChangeDocument

DDL: I_CHANGEDOCUMENT SQL: ICHANGEDOC Type: view BASIC

Change document header

I_ChangeDocument is a Basic CDS View that provides data about "Change document header" in SAP S/4HANA. It reads from 1 data source (cdhdr) and exposes 11 fields with key fields ChangeDocObjectClass, ChangeDocObject, ChangeDocument. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
cdhdr cdhdr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ChangeDocumentItem _ChangeDocumentItem $projection.ChangeDocObjectClass = _ChangeDocumentItem.ChangeDocObjectClass and $projection.ChangeDocObject = _ChangeDocumentItem.ChangeDocObject and $projection.ChangeDocument = _ChangeDocumentItem.ChangeDocument
[0..1] I_Language _ChangeDocLanguage $projection.ChangeDocLanguage = _ChangeDocLanguage.Language

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName ICHANGEDOC view
EndUserText.label Change document header view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass cdhdr objectclas
KEY ChangeDocObject cdhdr objectid
KEY ChangeDocument cdhdr changenr
CreatedByUser cdhdr username
CreationDate cdhdr udate
CreationTime cdhdr utime
ChangeTransactionCode cdhdr tcode
ChangeDocChangeType cdhdr change_ind
ChangeDocLanguage cdhdr langu
_ChangeDocumentItem _ChangeDocumentItem
_ChangeDocLanguage _ChangeDocLanguage 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'ICHANGEDOC'
@EndUserText.label: 'Change document header'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@VDM.viewType: #BASIC

define view I_ChangeDocument
  as select from cdhdr

  association [0..*] to I_ChangeDocumentItem as _ChangeDocumentItem 
                     on  $projection.ChangeDocObjectClass = _ChangeDocumentItem.ChangeDocObjectClass
                     and $projection.ChangeDocObject      = _ChangeDocumentItem.ChangeDocObject
                     and $projection.ChangeDocument       = _ChangeDocumentItem.ChangeDocument

  association [0..1] to I_Language as _ChangeDocLanguage  
                     on  $projection.ChangeDocLanguage = _ChangeDocLanguage.Language
{
  key cdhdr.objectclas as ChangeDocObjectClass,
  key cdhdr.objectid   as ChangeDocObject,
  key cdhdr.changenr   as ChangeDocument,

      cdhdr.username   as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      cdhdr.udate      as CreationDate,
      @Semantics.systemTime.createdAt: true
      cdhdr.utime      as CreationTime,
      cdhdr.tcode      as ChangeTransactionCode,
      cdhdr.change_ind as ChangeDocChangeType,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_ChangeDocLanguage'
      cdhdr.langu      as ChangeDocLanguage,
      _ChangeDocumentItem,
      _ChangeDocLanguage
}    
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CDHDR"
],
"ASSOCIATED":
[
"I_CHANGEDOCUMENTITEM",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More