P_IHBAccountChangeDocument

DDL: P_IHBACCOUNTCHANGEDOCUMENT Type: view_entity COMPOSITE Package: IHB_ACCOUNT

IHB Account Change Document Private View

P_IHBAccountChangeDocument is a Composite CDS View that provides data about "IHB Account Change Document Private View" in SAP S/4HANA. It reads from 3 data sources (I_ChangeDocument, I_ChangeDocumentItem, I_IHBAccount) and exposes 13 fields with key fields IHBAccountUUID, ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable. Part of development package IHB_ACCOUNT.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_ChangeDocument _ChangeDocument from
I_ChangeDocumentItem _ChangeDocumentItem inner
I_IHBAccount _IHBAccount inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY IHBAccountUUID I_IHBAccount IHBAccountUUID
KEY ChangeDocObject I_ChangeDocument ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocument ChangeDocument
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType
CreatedByUser I_ChangeDocument CreatedByUser
CreationDate I_ChangeDocument CreationDate
CreationTime I_ChangeDocument CreationTime
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_IHBAccountChangeDocument
  as select from I_ChangeDocument     as _ChangeDocument
    inner join   I_IHBAccount         as _IHBAccount         on _ChangeDocument.ChangeDocObject = bintohex(
      _IHBAccount.IHBAccountUUID
    )
    inner join   I_ChangeDocumentItem as _ChangeDocumentItem on  _ChangeDocumentItem.ChangeDocObject      = _ChangeDocument.ChangeDocObject
                                                             and _ChangeDocumentItem.ChangeDocObjectClass = _ChangeDocument.ChangeDocObjectClass
                                                             and _ChangeDocumentItem.ChangeDocument       = _ChangeDocument.ChangeDocument
{
  key _IHBAccount.IHBAccountUUID as IHBAccountUUID,
  key _ChangeDocument.ChangeDocObject,
  key _ChangeDocument.ChangeDocObjectClass,
  key _ChangeDocument.ChangeDocument,
  key _ChangeDocumentItem.DatabaseTable,
  key _ChangeDocumentItem.ChangeDocTableKey,
  key _ChangeDocumentItem.ChangeDocDatabaseTableField,
  key _ChangeDocumentItem.ChangeDocItemChangeType,

      _ChangeDocument.CreatedByUser,
      _ChangeDocument.CreationDate,
      _ChangeDocument.CreationTime,

      _ChangeDocumentItem.ChangeDocPreviousFieldValue,
      _ChangeDocumentItem.ChangeDocNewFieldValue

}
where
       _ChangeDocument.ChangeDocObjectClass            =  '/PF1/IHBACCOUNT'
  and(
       _ChangeDocumentItem.ChangeDocItemChangeType     <> 'D'
    or _ChangeDocumentItem.ChangeDocItemChangeType     <> 'I'
  )
  and  _ChangeDocumentItem.ChangeDocDatabaseTableField is not initial
  and  _ChangeDocumentItem.ChangeDocDatabaseTableField <> 'KEY'

Learn More